https://bugs.freedesktop.org/show_bug.cgi?id=81757
--- Comment #7 from Ryszard <ry...@iname.com> --- What different bug? We are still talking about the same bug, I was just trying to give you more clues about it, so you may trace it better. I was playing with the macros to figure out where is the problem. So the BENDALLOWANCE macro is also changing cell J12, this cell is not used in any other formulas it is only information, but somehow now it is triggering recalculations, so that is why iteration is needed, and the other values are not calculated correctly. I have commented out this line, and everything worked fine. Than I have changed the cell J12 to be calculated as result of macro BENDFACTOR same way the F7 is for BENDALLOWANCE. Everything works fine except, it brought question about extremely strange behavior(and I'm not reporting this as a bug). Is the new version (4.2.5.2 ) of libreoffice caching opened files. When I have saved this spreadsheet using version 4.0, opened file in 4.2 version was still same old bad file, I had to save it under different name using 4.2 version to get it back correctly after reopening in 4.2. The 4.0 version was showing all changes in place. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs