> 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? > > If I try: > A1 => 1965 [Enter] > B1:AX1 => array formula(=(A1:AW1)+1) [Control+Shift+Enter] > > B1 is calculated correctly, but the other cells get Err:522 - circular > reference, > which I agree it is in a way, but in Excel this doesn't matter > as the looping through the list is done left to right, so it isn't > really circular. > > This is such basic stuff that it doesn't seem to be documented. > > Dave A common possible method in Calc would be: A1 => 1965 [Enter] B1 => formula(=A1+1) [Enter] B1 => copy C1:AX1 => paste
So, more steps than in Excel; simpler than an array formula. I don't remember whether there is a simple keyboard shortcut to simultaneously insert the same value/formula in multiple cells in Calc. Best Regards, Ady. -- To unsubscribe e-mail to: [email protected] 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
