https://bugs.freedesktop.org/show_bug.cgi?id=71598
--- Comment #7 from Jeff H <[email protected]> --- Created attachment 90661 --> https://bugs.freedesktop.org/attachment.cgi?id=90661&action=edit Test case which shows the recalc bug I'm not sure this is the same bug, but the attachment LORecalcBug.ods clearly demonstrates a recalc bug in LO 4.1.3.2 (but works fine in LO 4.0.5.2). Open the spreadsheet, enable macros, go to the CashOut page (make sure "1" is in the #OUT column of the "1,000" row, and others are blank), click on the Process Disbursement button and you should get a MsgBox that indicates the formula error. Now go to the Journal sheet and the ending balance will be some formula like "=J3+F19-G18", but if you do the math, it won't be right. It should be the same as the bottom of the balance column there. Also if you go to the Balance sheet, you will see the difference there as well. If you type Ctrl-Shit-F9 on any of these sheets, it recalculates successfully and the error goes away. Sorry I didn't strip the code down more. As it is it took me a couple of hours to strip it down this far. Hope this helps find the bug - it's a bad one for us, and prevents us from upgrading to 4.1. -- 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
