Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Le 01/09/12 17:58, Dave Long a écrit :

Hi Dave,

The file has 4 columns of data: in the first is a date, in the second an item description, in the 
third a number (my example records amounts paid into or taken out of a bank account, so this is a 
sum of money), and the 4th column holds the account balance, so it is the sum of the number above 
and the number entered in column C. The file has a title row then 5 rows of entries as above.

With LO, I insert a new line 4 - that is, between the 2nd and third entries that I 
started with. Into the new row I add for example:
A4                               B4                               C4
31 Aug 2012 <tab> New row/item <tab> 100.00   

Then I drag the "ear" of D3, which contains the formula, =D2+C3, down to cell D7 which still 
holds the formula, =D6+C7, and is returning the balance before the extra line was added. When I 
let go the mouse button, the program quits and the document requires recovery on the next start.
Note that I have a workaround (when I remember): delete the calculations I need to update before 
trying to copy the calculation in D3 down the column. It's a perfectly acceptable workaround, but 
obviously it shouldn't be necessary :)

I have a feeling that this is a known bug, which should be fixed for 3.6.2 :


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.