Apache OpenOffice (AOO) Bugzilla – Issue 77785
Formula fields don't calculate properly in a table.
Last modified: 2017-05-20 11:17:30 UTC
FORMULA FIELDS WON'T INSERT, OR CALCULATE PROPERLY IN TABLES. I am using Ubuntu 6.10 (Edgy) with OOo 2.1. To reproduce the problem, open this document: http://members.optuszoo.com.au/~theelectronicco/table.odt It is a sheet of labels kept in format using a table. Change the serial number of the first label, the other labels should change serial number to match, incremented by 1 each label. Notice that the first label in the middle column has the same serial number as the first label in the first column (startsernum) even though it is set to [ startsernum + 11 ], Interestingly if you replace the defective serial number field with standard text, the first label in the right column then calculates incorrectly. You can muck around with replacing the fields, and all looks fine until you try to print, then OOo recalculates the fields, and prints the defective value (that's when I start banging my head on the desk :-) ). Also, I was unable to insert the formula fields directly, I had to insert them outside the table, then cut and paste them into place. To replicate this, go to Insert->Fields->Other->(Variables Tab)-> Select "Insert Formula" in the left hand list, type your preferred formula (try startsernum + 10), click on a position in one of the table cells and click insert. Nothing happens, but if you do the same thing, but instead of clicking inside a cell, click outside the table, then click insert, it works fine. Keep up the good work. I am trying to stop using ms office all together, but I do a lot of label and form printing, and OOo is not quite stable enough yet, but I'm sure it will be soon. Many thanks for your hard work.
Created attachment 45385 [details] This is the document that showed the problem described in the issue.
Reassigned to ES.
@OS: please have a look. reproduced in m207 @mp035: Please file another issue for the impossibility to insert such a field in this document.
move target to 3.x according http://wiki.services.openoffice.org/wiki/Target_3x
There are a number of problems with the sample document, but not the one described in the summary. I have attached a sample document that uses fields to calculate the serial numbers correctly (I think). Since it seems that the intention is for the serial numbers to increment by columns instead of the natural row order, I had to add variables for row and column, then calculate the serial numbers from them. The row/column is calculated and displayed in each cell; it can be hidden by changing the "_rc" character style to Font Effects: Hidden. I also saw the same problem with inserting a formula field in the table, and also had to use the workaround. If the submitter can review this, and agrees with my results, perhaps the summary should be changed, or this should be closed and a new issue opened for the formula insert problem.
Created attachment 49945 [details] Sample document with correct formula calculations
BTW, I'm using 2.3 on Fedora 8
Created attachment 50164 [details] THis documane still displays the problem as of OOo 2.3
jes is right, for some reason the original example document no longer shows the problem, but my local copy still does. I have attached a copy of my local file that still exhibits the calculation problem. To reproduce, open the document table2.odt, all fields should appear to be calculated in order. Go to tools -> update -> update all, and the field at the top of the second column is no longer calculated correctly.
Reset assigne to the default "issues@openoffice.apache.org".