Re: [libreoffice-users] Problem LO Calc not copying formulae LMDE X64

Hi :)
LMDE is "Linux Mint"
http://linuxmint.com/
(i had to look it up as i thought the short form was "Mint" but the official name is LMDE now 
grrr).  The DW page
http://distrowatch.com/table.php?distribution=mint

It seems really wrong that the formula is not being copied as expected.  Have you tried renaming 
the user-profile to see if some weird setting has gone wrong?
http://user.services.openoffice.org/en/forum/viewtopic.php?f=74&t=12426
Regards from
Tom :)


--- On Mon, 31/10/11, Stephan Zietsman <sziets@gmail.com> wrote:

> From: Stephan Zietsman <sziets@gmail.com>
> Subject: Re: [libreoffice-users] Problem LO Calc not copying formulae LMDE X64
> To: users@global.libreoffice.org
> Date: Monday, 31 October, 2011, 7:36 Steve Fisher wrote:
> > Enter "X" in B1, then enter following formula in A1 then copy formula to A2
> > =if(b1="X","AAA","BBB"), it copies the value "AAA" and not the formula
> > =if(b2="X","AAA","BBB").
>
> If I copy the formula from A1 to A2, the formula works as I would
> expect; the formula in A2 is =IF(B2="X","AAA","BBB"). 
> How exactly do
> you copy the formula from A1 to A2?  Do you use:
> - (on Cell A1) Right Click > Copy (and then on Cell A2) Right Click > Paste
> - Select A1, click and drag (down) the bottom left corner of the cell
> - Select A1, Ctrl+C, select A2, Ctrl+V
> - Some other method?
>
> Also, I see you are using LibreOffice version 3.4.3; on
> which
> operating system (Windows, Linux, Mac)?
>
> Regards
> Stephan

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted