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


Mirosław,
Thanks for your interest and advice.

I have created an example file (on a Mac). With LO 3.5.6 no problem. 

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 3.6.1.2, 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 :)

In a separate email I will make this example file available to you, Mirosław (as offered off-list). 

If the bug is confirmed please advise me where I should send a report, so I don't misuse this list 
(and my apologies for having done so on this occasion).

Dave






On 31 Aug 2012, at 23:21, Mirosław Zalewski wrote:

Hi Dave

Sorry to hear about your problems.

This mailing list is not proper place to post bug reports, but it is good 
thing you have posted it nevertheless. It is so, because I could not reproduce 
this issue. I am using LO 3.6.1 on Debian, amd64. I tried following your 
instructions and LO did not crash. It calculated what there was to calculate 
and that's it.

Could you post example document somewhere on the web (this mailing list does 
not allow mail attachments - they are simply stripped) and provide as detailed 
as possible, step-by-step instructions? In bug reporting, it's better to give 
too much details than too little.

If you can't put document on the web, then please write cell address and 
content exactly. Also note any direct formatting you might have applied.

Looking forward for your reply - I hope we can work it out.
-- 
Best regards
Mirosław Zalewski

PS You have provided e-mail address in message, so I am CC-ing you just in 
case.

-- 
For unsubscribe instructions e-mail to: users+help@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


-- 
For unsubscribe instructions e-mail to: users+help@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

Context


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.