________________________________
From: Steve Edmonds <[email protected]>
To: [email protected]
Sent: Mon, 13 June, 2011 18:53:36
Subject: Re: [libreoffice-users] copy down, copy and paste in calc.
On 14/06/11 12:20 AM, Tom Davies wrote:
>
>
>
> ----- Original Message ----
>> From: Steve Edmonds<[email protected]>
>> To: [email protected]
>> Sent: Mon, 13 June, 2011 11:31:11
>> Subject: Re: [libreoffice-users] copy down, copy and paste in calc.
>>
>>
>>
>> On 13/06/11 8:59 PM, Stephan Zietsman wrote:
>>> Steve Edmonds wrote:
>>>> When I want to copy the same formula to a range of cells without the
>>>> references indexing this is usefull, but the formula only copies to the
>>>> top cell.
>>>>
>>>> Another usefull thing would be;
>>>> click into a cell with formula and drag the bottom right black square
>>>> down, the formula repeats indexing the references. (does this now).
>>>> click into a cell with formula while holding ctl (cmd) down and drag the
>>>> bottom right black square down, the formula repeats without indexing the
>>>> references, i.e. copies literally as with numbers. (does not do this now).
>>> If you want to copy a formula without "indexing the reference", then
>>> you can take a look at absolute references. It is described in the
>>> LibreOffice wiki
>>>
>>(http://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative).
>>.
>>
>>> A short summary is:
>>> Let's say cell C1 contains the following formula (without the quotes):
>>> "= A1 + B1"
>>> If you copy the formula in cell C1 to cell C2 (by either Copy& Paste,
>>> or by dragging the corner of cell C1) you will get "= A2 + B2" in cell
>>> C2.
>>> If this is not what you wanted, you can change the reference in C1 to
>>> an absolute reference.
>>>
>>> To do this, select the cell C1 and press SHIFT+F4. The formula in
>>> cell C1 will change to "= $A$1 + $B$1". If you copy that to cell C2,
>>> it will stay "= $A$1 + $B$1".
>>>
>>> If you want a more detailed explanation of absolute and relative cell
>>> referencing, read the wiki page or ask in this mailing list for more
>>> info.
>>>
>> Thanks Stephan and Tom.
>> I already understand the use of the absolute referencing. I may not have
>> expressed myself well enough to avoid confusion.
>> 1. Enter say the digit 9 into a cell. Click into the cell, copy. Select
>> 5 cells and paste. 9 pastes into all 5 cells.
>>
>> 2. Now in your email, select a word or number and copy. Select 5 cells
>> and paste. The word only pastes into the top 1 of the 5 cells.
>>
>> It would be nice if the behavior in 2 was the same as in 1.
>>
>> steve
>>
> Hi :)
> That is inconsistent and i hadn't noticed. It happens in LO3.3.2 on Ubuntu
> 10.04 too. can you post a bug-report about it?
> 9
> Regards from
> Tom :)
Is it a bug or an enhancement?
steve
Hi :)
I think either case could be argued. I think probably best to post it as a
bug-report. The link that i gave you has a lot of complicated things to do
that
really are not needed for this report. It just needs a copy&paste of your
email
that ended "It would be nice if the behavior in 2 was the same as in 1".
Short
& sweet should be enough
Regards from
Tom :)
--
Unsubscribe instructions: E-mail to [email protected]
In case of problems unsubscribing, write to [email protected]
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
