Created attachment 71139 [details] It is a simple table to show you the problem I mentioned before Hallo, It is the first time I am using LO (Writer) and I really start loving this programme. Unfortunately I have a critical problem. When I make a Table with Writer everything looks really nice and easy. But there is a real critical bug: If I cancel or add a new LINE the cells loose their formate. The table corrupts and does not any more sum the amounts correctly. In fact the total sum does not change anymore. Once again: the table corrupts when i add or cancel one or several lines. I thank you very much in advance for your kind help and soonest possible answer. Best Regards Franz
@Fco I cannot read the attachment, it looks like an Outlook .msg file, could you please attach a sample .odt file containing a table? And meanwhile I've created a simple table, inserted values, inserted a SUM formula and then inserted several rows. The total sum remained the same, and when I entered new values to the new cells, formula updated itself immediately. (LO 4.0.0.0 alpha1 28/11 build - OS X 10.7.5) Also that would be great if you could specify which LO version and locale you use. Thanks in advance.
*** Bug 57991 has been marked as a duplicate of this bug. ***
Created attachment 71219 [details] sample file Francisco sent this file to me via e-mail, now I am attaching it. Formula seems here not updating, but when I re-calculated the sum, then added another row, and made another multiplication, it seems the formula updated itself correctly. Can someone else check the file and play with it a bit? Regards,
@ Fco/Franz: > It is the first time I am using LO (Writer) and I really start loving this > programme. Unfortunately I have a critical problem. Which version of LibreOffice do you use? To see the exact version, please start LibreOffice and select “About LibreOffice” (“Über LibreOffice”) from the menu “LibreOffice”; or just locate LibreOffice in the Finder and press Command+I to get the Finder’s information window for the LibreOffice application ... [Greetings from Brackenheim, not far from Heilbronn ;-)]
Set “Version” field according to private mail by reporter -- for him reproducible since 3.6.2, but also in 3.6.4 and 4.0.0, and both on Mac OS X and Windows. Improved Summary a bit. > Can someone else check the file and play with it a bit? I will try to do so soon ...
> > Can someone else check the file and play with it a bit? > I will try to do so soon ... Sorry, I did not find any time to test this issue before Xmas. I hope I will get some time in the coming weeks.
OK, here is a first result of playing around with the sample file: something is definitely wrong with the re-calculation/update of the summmary field. I can get it to work by entering the summary formula again, but then again it fails to update * when I change the counts in column D * when I delete a row In both cases I need to enter the formula again -- i.e., select the cell with the main summary, click into the formula input field at the top of the window, and press enter/OK; then the formula updates. Additionally, when I add another row to the formula, I can get into a state where the tooltip for the formula field still says: =sum(<F1>|<F2>|<F3>|<F4>|<F5>|<F6>|<F7>|<F8>|<F9>|<F10>|<F11>), and the field still displays this value (e.g., "315,00"), but the formula input field at the top of the window displays as formula just says =sum(<F12>) So there is definitely something “out of sync” here. Therefore I set the status of this bug report to NEW. However, before we talk about this bug to the developers, it would be better to do additional tests, which (a) make the steps given above reproducible step by step (I have just “played around” with the file, therefore I can not yet say if this behaviour is 100% reproducible), (b) ideally, re-create the same problem in an even simpler file with instructions how to reprodoce the issue step by step, beginning with an empty Writer document. I will try to do these additional tests and to report the results in the step-by-step format preferred by the developers in the next days/weeks.
Supplement: I did my tests with LibreOffice 3.6.4.3 (Build ID: 2ef5aff) on Mac OS X 10.6.8 (Intel). When I do my more detailed tests, I will check if the same applies to LibO 4.0.0.0, too.
Reproducible for me under Ubuntu 12.04 x86-65 with all LibreOffice version since 3.5.7. Best regards. JBF
i think same problem here with Writer Version 4.0.1.2. under Win 7 pro 64bit: In Writer i have a calculation within a table (for ex. 4 columns), say <C3>*500. The result should display in <D3>. When i update the cell <C3> and move the cursor to cell <D3>, i would expect, that the result updates. Instead nothing happens, untill i hit F2 when the cursor is in cell <D3> to show up the formula editor (where i can see the formular "<C3>*500") and then press enter. Pretty annoying.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.