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+unsubscr...@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
