[Bug 153422] Writer Table Formula Evaluation Errors
https://bugs.documentfoundation.org/show_bug.cgi?id=153422 --- Comment #10 from David Alden --- Version: 26.2.3.2 (X86_64) Build ID: 70e089b17412e4cb7773e41413306b17a2328c34 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded The above version of LibreOffice was installed today to test this bug according to the follow-up LibreOffice QA e-msg received yesterday. The good news is that the auto-recalc fault noted in the previous demo document description is no longer apparent and the relevant note has been removed from the description. The bad news is that the anomalous calculations are still present as previously reported. Consequently, the demo document has been updated and re-saved using the above LibreOffice version and submitted for reconsideration. Unfortunately, I am unable to perform the procedures necessary to determine if this bug is a REGRESSION. Thank you for your continued work to resolve the LO Writer table computation evaluation errors. Kind regards, Dave Alden -- You are receiving this mail because: You are the assignee for the bug.
[Bug 153422] Writer Table Formula Evaluation Errors
https://bugs.documentfoundation.org/show_bug.cgi?id=153422 David Alden changed: What|Removed |Added Attachment #186270|0 |1 is obsolete|| --- Comment #9 from David Alden --- Created attachment 207019 --> https://bugs.documentfoundation.org/attachment.cgi?id=207019&action=edit Updated LO Writer bug demo document Updated LO Writer table calculation bug demo document submitted for review. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 153422] Writer Table Formula Evaluation Errors
https://bugs.documentfoundation.org/show_bug.cgi?id=153422 --- Comment #8 from QA Administrators --- Dear David Alden, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Bug 153422] Writer Table Formula Evaluation Errors
https://bugs.documentfoundation.org/show_bug.cgi?id=153422 Dieter changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||0672 --- Comment #7 from Dieter --- I confirm the first problem, you've mentioned with Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-GB Calc: CL threaded Steps: 1. Open attachment 186270 2. In empty cell C3 insert value -1 3. Press tab key => Values C4:9 are recalculated 4. Undo 3x (so that C1 is again empty) -> Tab key Expected result Values C4:9 are recalculated Actual result No change 5. Insert 0 as value and press tab (=> recalculation) 6. Insert 2 as value and press tab (=> recalculation) 7. Undo 2x (so that value C1 is again 0) -> Tab key (=> recalculation) So it's a problem of empty cell. At least related to bug 140672. If empty cell isn't treated as 0, I would expect an error message when opening document. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153422] Writer Table Formula Evaluation Errors
https://bugs.documentfoundation.org/show_bug.cgi?id=153422
David Alden changed:
What|Removed |Added
Ever confirmed|1 |0
Status|NEEDINFO|UNCONFIRMED
--- Comment #6 from David Alden ---
Dear Libre Office Writer QA Administrators,
Thanks for following up with this bug report. I'm sorry the explanatory
material included in the attachment was not sufficiently clear. The attachment
provided (TableDemo1.odt) was derived from an attempt to use the capability of
LO Writer to compute formulas according to US Federal and State income tax
worksheets within tables and fields in an ODF text document. The income tax
worksheets often require conditional computation of values dependent on other
entered or computed values. In an attempt to use the LO Writer table formula
capabilities for this purpose, anomalous results were observed from properly
constructed formulas in all currently available versions of LO. Rows 4-9 in
Table1 of TableDemo1.odt provide examples of both correct and anomalous formula
evaluations each with a brief note as to what the value or
formula is intended to demonstrate ( is editable but are fixed).
The Table1 formulas in and evaluate correctly for all values entered
in , specifically the integers -2, -1, 0, 1, or 2 for demonstration
purposes. These are the simple formula: "=+*" and the
conditional formula "=max((*+)*(g 0)) | (*(leq
0)*3/4)" as shown in the rightmost column at the bottom of the attachment
(TableDemo1.odt) [these active formulas can be verified by hovering the pointer
over the appropriate cells in Table1 ( or )]. The simple formula
is provided just to demonstrate that common algebraic logic (e.g.,
multiplication has computational precedence over addition) is correctly
implemented without the need for parentheses. The conditional formula is
provided to demonstrate that such conditional computation can evaluate
correctly if exhaustive parentheses (i.e., none are left out) are included in
the formula. The formula evaluates correctly to either the same value as
or *3/4 (4258.5) depending on whether cell is greater than (g)
zero or less than or equal to (leq) zero respectively. They are shown in the
rightmost column of lines marked 4. and 5. at the bottom of the attachment
document along with the correct expected values (columns 2-6) these formulas
produce for the above mentioned values of without any highlighted (i.e.,
no anomalies). So far so good. However, the exhaustive parentheses should not
be necessary to correctly evaluate the formula in and when they are
removed, anomalous evaluations of the formula and are observed
(expected results are highlighted in yellow at the bottom of the document in
the row labeled 6.). Note that the "(g 0)" condition has also been removed
for the and formulas along with most of the parentheses included in
the formula to simplify the expression to "=max +* |
*(leq 0)*3/4". For the two negative values of and zero, the left
component of the max function will be either 3210, or 5678 respectively
compared to 4258.5 on the right of the pipe (element separator). But the
formula actually evaluates to 9936.5 instead for all three (note that this
value shouldn't even occur at all). For the two positive values of , the
right hand component of the max function should be zero so only the left hand
component should matter with values 6912 and 8946 respectively but the function
actually evaluates to 5678 instead. The function simply reverses the
order of the left hand arithmetic expression, *+ instead of
+*, and the results are even stranger: 1790.5, 3024.5, 4258.5, 1234
and 2468 instead of the expected 4258.5, , 5678, 6912 and 8946 for -2,
-1, 0, 1 and 2 respectively. {At this point, please accept my apologies for
the confusion resulting from my copy/paste and editing failure error caused by
playing around with the and formulas and neglecting to fix the
results that originally included the (g 0) condition as a part of the left
max component after having removed it from both and formulas. I have
fixed the expected values in the corresponding lines in the replacement
TableDemo1.odt attached below.} In other words, even without parentheses, the
arithmetic, operator and/or function calculations between the list separators
(pipe characters) should be completed first regardless of how many there are
before evaluating the max function or other functions that take lists (all the
LO Writer "statistical functions", e.g. "=product (min 1|2|3) | (mean 2|4) |
(max 1|3|5|7)" should compute 1*3*7=21 but produces 8 instead--weird 😕
[generally, the parentheses would usually be necessary to indicate which list
separator goes with which function when the formula contains multiple separate
lists]). This reasonable expectation is apparently not what
[Libreoffice-bugs] [Bug 153422] Writer Table Formula Evaluation Errors
https://bugs.documentfoundation.org/show_bug.cgi?id=153422 David Alden changed: What|Removed |Added Attachment #185240|0 |1 is obsolete|| --- Comment #5 from David Alden --- Created attachment 186270 --> https://bugs.documentfoundation.org/attachment.cgi?id=186270&action=edit Corrected LO Writer formula evaluation demo document Corrected LO Writer demo document attachment. Sorry for any confusion. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153422] Writer Table Formula Evaluation Errors
https://bugs.documentfoundation.org/show_bug.cgi?id=153422 Buovjaga changed: What|Removed |Added CC||ilmari.lauhakangas@libreoff ||ice.org Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #4 from Buovjaga --- (In reply to Dieter from comment #3) > Steps > 1. Open attachment 185240 [details] > 2. In empty table cell C1 enter a number between -2 and 2 > 3. Click into another cell or outside table > 4. Compare results in column C with expected results at buttom of page > > I can see, that results differ from expected results, but since I'm not > familiar with such formulars I can't asses, which results are correct. David: can you clarify what exactly is expected? Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the information. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153422] Writer Table Formula Evaluation Errors
https://bugs.documentfoundation.org/show_bug.cgi?id=153422 Dieter changed: What|Removed |Added Blocks||122755 CC||[email protected] Version|3.3.0 release |7.4.5.1 release Whiteboard| QA:needsComment| --- Comment #3 from Dieter --- Tested with Version: 7.5.0.3 (X86_64) / LibreOffice Community Build ID: c21113d003cd3efa8c53188764377a8272d9d6de CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-GB Calc: CL threaded Steps 1. Open attachment 185240 2. In empty table cell C1 enter a number between -2 and 2 3. Click into another cell or outside table 4. Compare results in column C with expected results at buttom of page I can see, that results differ from expected results, but since I'm not familiar with such formulars I can't asses, which results are correct. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=122755 [Bug 122755] [META] Formulae in Writer tables bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153422] Writer Table Formula Evaluation Errors
https://bugs.documentfoundation.org/show_bug.cgi?id=153422 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153422] Writer Table Formula Evaluation Errors
https://bugs.documentfoundation.org/show_bug.cgi?id=153422 David Alden changed: What|Removed |Added Attachment #185161|0 |1 is obsolete|| --- Comment #2 from David Alden --- Created attachment 185240 --> https://bugs.documentfoundation.org/attachment.cgi?id=185240&action=edit Table Formula Demo Document Update Updated Document Demonstrating LO Writer table formula evaluation errors and inconsistencies with more detailed commentary. The previous attachment (TableDemo.odt) may be ignored. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153422] Writer Table Formula Evaluation Errors
https://bugs.documentfoundation.org/show_bug.cgi?id=153422 David Alden changed: What|Removed |Added CC||[email protected] --- Comment #1 from David Alden --- Created attachment 185161 --> https://bugs.documentfoundation.org/attachment.cgi?id=185161&action=edit Writer Table Formula Demo Document -- You are receiving this mail because: You are the assignee for the bug.
