https://bugs.freedesktop.org/show_bug.cgi?id=71598
Jeff H <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #90661|0 |1 is obsolete| | --- Comment #11 from Jeff H <[email protected]> --- Created attachment 92120 --> https://bugs.freedesktop.org/attachment.cgi?id=92120&action=edit Better test case which shows the recalc bug This test case has been cut down to the absolute minimum which shows the bug. You open the .ods file, a message tells you that the ending balance formula is correct. You click the Process Disbursement button and a message tells you that the ending balance formula is NOT CORRECT. You can click on the Journal tab to verify for yourself. The ending balance is just a formula which is the difference between 2 cells, but the difference is incorrect. If you type Ctrl-Shift-F9 to recalculate all formulas, it updates and is correct again. The macro that runs when you click the button is very simple. It inserts a row (above the Total disbursements line) and then increases the debit amount by 1000. This leads to the bug every time (in LO 4.1.3.2, and a colleague saw it in 4.1.4 as well). Here are the observations I have made: If I remove the insertion of the row, there is no bug. If I insert the row AFTER the Total disbursements sum line, there is no bug. If the ending balance is calculated directly from the debit amount, no bug. If the Total disbursements is not a sum, but just a number, there is no bug. If the macro makes the Journal sheet active before the operations, no bug. If I move the button to the Journal sheet, there is no bug. If I run the macro from the Journal sheet, there is no bug. If I run the macro from the CashOut sheet, THE BUG DOES SHOW UP. So in summary, I think the bug shows up when a macro makes changes to a non-active sheet so that a sum formula is pushed down by an insert row operation. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
