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

> > I don't remember whether there is a simple keyboard shortcut to 
> > simultaneously insert the same value/formula in multiple cells in 
> > Calc.
>  
> I'd like to clarify the above paragraph. One thing would be to insert 
> "the same" value/formula simultaneously in multiple cells. A more 
> powerful keyboard shortcut would be to:
>
> 1_ Select a range of cells;
> 2_ Type in a formula;
> 3_ Press a combination of keys that would:
> 3.1_ insert the typed in value/formula in the first cell of the 
> selected range, and then;
> 3.2_ would "extend", or "fill in", or "copy+paste" the first cell to 
> the rest of the cells in the selected range.
>
> If the typed in formula would be "=A1+1" (without quotation marks), 
> then:
> A_ the "same formula" would mean the _exact_ same formula, as if it 
> would be copying the content of the cell (as oppose to copying the 
> first "cell"; or
> B_ copying the first formula while respecting relative references too 
> (e.g. "=A2+1" ; "=A3+1"; ... )
>
> Whether case "B" would also copy the entire first cell (including 
> formatting) into the rest of the selected range would be something to 
> consider if/when such shortcut gets to be considered for development 
> in Calc.
 
And that shortcut is [alt]+[enter], as Regina mentioned (thanks) in a 
prior email in this topic thread.

> From the useful:

[url] 
https://help.libreoffice.org/Calc/Shortcut_Keys_for_Spreadsheets 
[/url]

[quote]
To fill a selected cell range with the formula that you entered on 
the Input line, press Alt+Enter.
[/quote]

So instead of:

A1 => 1965 [Enter]
B1:AX1 => formula(=A1+1) [Control+Enter]

in Calc you do:

A1 => 1965 [Enter]
B1:AX1 => formula(=A1+1) [Alt+Enter]

BTW, there is a _very limited_ document regarding LibreOffice and 
MSOffice (including Calc and Excel):

[url] 
https://wiki.documentfoundation.org/Feature_Comparison:_LibreOffice_-_
Microsoft_Office [/url]

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