Apache OpenOffice (AOO) Bugzilla – Issue 99121
user fields/formulas autonomously change their values
Last modified: 2017-05-20 11:17:35 UTC
I tried to print a sheet of labels with consecutive ranges of numbers. After several attempts to do this in a fancier way (that always failedin even stranger ways), I came up with the following (which nearly worked ;): - I defined 2 fields: s=2021 and n=40 - 1st label contains 2 formulas: "s" and "s+n-1" (=> values: "2021" "2060") - following labels: "s+n*1", "s+(n-1)+(n*1)", "s+n*2", "s+(n-1)+(n*2)" ... When I print the document (and upon several other operations), the 1st label suddenly is displayed and printed as "21" "2061" when I look into the corresponding dialog, it still shows s=2021 and n=40 (so the subject line is not entirely correct: what changes, is only the displayed values)
Created attachment 60094 [details] Sample data
MRU->OS: in the attached document two User field variables are available (s=2021 and n=40). in the first frame, the User field formula just showing value of s will display a wrong value after updating the fields using F9 or printing.
Target changed to 3.x
We're seeing this too in our documents. It only happens in formulas that use userfields which are not referenced in the document. The problem can be circumvented by adding a hidden section at the end of the document that contains direct references (by using Insert->Fields>Other...>Variables>UserField, not in a formula) to all userfields in the document which are used in forumlas. It seems the internal value is only initialized a first use and this is not properly considered when calculating formulas in writer documents.
Reset assigne to the default "issues@openoffice.apache.org".