https://bugs.freedesktop.org/show_bug.cgi?id=43003
--- Comment #5 from Miguel <mjul...@free.fr> --- Created attachment 101117 --> https://bugs.freedesktop.org/attachment.cgi?id=101117&action=edit Another test case (change yellow cells; blue cells changed only after save+reopen) I make a heavy use of Basic macros and I also have big problems with recalculation: it recalculated what is not needed, and updated values are not always displayed. (I also reported a possibly related bug here: https://bugs.freedesktop.org/show_bug.cgi?id=79770 ) I am using: LibreOffice Version: 4.2.4.2 Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8 On a PC running Linux Ubuntu 32 bits: Linux ... 3.13.0-30-generic #54-Ubuntu SMP Mon Jun 9 22:47:59 UTC 2014 i686 i686 i686 GNU/Linux In the test case: * the yellow cells may contain something or be empty * "Reference" contains a formula that uses the yellow range * "Formula" contains the text of the formula * "Address" contains the address of the yellow range * "reference coordinates" are numbers for getting the location of the yellow range * the blue cells are the matrix result of the macro the uses the coordinates. They indicate the location of the non-empty cells I have displayed the cells on which depends each calculated cell. What should happen: - when I write or delete a cell in the yellow range, the blue cells should change - the macro should be run when I modify a cell in the yellow range, not when I modify an unused cell What happens in the results: - the result is GOOD when I open the file - if I modify the yellow range, the blue cells are not updated - if I save and reopen the file, the blue cells are GOOD What happens with the macro (setting a breakpoint in the Basic code): - whenever I modify a cell (even an used one), the macro is run - at the end of the code, the result is good (updated value) - but the new matrix is not displayed in the spreadsheet -- 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
