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

> 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: 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