Re: [libreoffice-users] Calc - avoiding circular references

Hi Dave,

Dave Kimble schrieb:
> Ubuntu 13.04 > LibreOffice > Calc 4.0.2.2
> I'm a veteran Excel-er, but very new to Calc.
> I've had to invent some syntax in the following question - hope you can
> follow it.
>
> In Excel, to set up a row of column headings (years say), you would do:
> A1 => 1965 [Enter]
> B1:AX1 => formula(=A1+1) [Control+Enter]
>
> and B1 would become set to 1966, ... , AX1 would become set to 2013.
> What is the equivalent syntax in Calc?

You need to mark the range B1:AX1 in a way, that B1 is your active cell. 
You can do it by dragging back from AX1 to B1, or while B1 is active 
write the range B1:AX1 into the name field (leftmost from the input 
line) and hit Enter.
Then click into the input line and write  =A1+1 and finalize input with 
ALT+Enter.

For small ranges I use the simple drag copying that was already 
mentioned here. For large ranges, sometimes more than 10000 rows, I use 
the way to mark a range via the name field.

Kind regards
Regina


--
To unsubscribe e-mail to: users+unsubscribe@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