https://bugs.freedesktop.org/show_bug.cgi?id=79770
Priority: medium Bug ID: 79770 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: Other: The currently selected cell is not recalculated Severity: normal Classification: Unclassified OS: Linux (All) Reporter: mjul...@free.fr Hardware: Other Whiteboard: BSA Status: UNCONFIRMED Version: 4.2.4.2 release Component: Spreadsheet Product: LibreOffice Created attachment 100608 --> https://bugs.freedesktop.org/attachment.cgi?id=100608&action=edit Up: select cell with formula and type Ctrl-Shift-F9 => Err:522 in this cell and "0" and several other cells; down: select empty cell and type Ctrl-Shift-F9 => everything is correct. Problem description: The problem happens in a complex spreadsheet (accounting software), with several macros (in Star Basic) using references to large ranges of cells. Sometimes, the cell or the line which is selected is not correctly recalculated, instead it displays "N/A" or "Err:522" Steps to reproduce: Method 1: 1. Open the file 2. Select another sheet of the file Method 2: 1. Type Ctrl-Shift-F9 for "unconditional recalculate" Method 3: 1. Select a cell (X) in the sheet 2. Go to another sheet of the same file 3. Modify a cell, which has an effect onto X 4. Select back the sheet that contains cell X Current behavior: The cell which is selected contains "Err :522". Other cells in the same sheet my contain "0" or "N/A" instead of their current value. The workaround is to select a cell with no formula and type Ctrl-Shift-F9. Often, the calculation time is also very long when one cell is modified, which may indicate that all cells have been recalculated, not just the cells that depend directly or indirectly on the modified cell. See screenshoots: #1: a cell with a formula was selected when Ctrl-Alt-F9 was typed in. Results: "Err:522" in this cell and "0" in many other cells. This is reproducible. #2: an empty cell was selected when Ctrl-Alt-F9 was typed in. Results: everything is correct. This is reproducible too. I may transmit the whole file if required, but only if this is useful, since it must first be anonymized. Expected behavior: When a cell is modified, all the cells that depend directly or indirectly on it should be recalculated. The other cells should not be recalculated, so the computation time should be short when just one cell is modified. The cells in other sheets should not be recalculated until the sheet is selected or the file is saved, unless they have an indirect effect onto the current sheet. When Ctrl-Shift-F9 is typed in, all the cells should be recalculated. No cell should contain "Err:522", or "0" or "N/A" when this is not the correct value. Operating System: Ubuntu Version: 4.2.4.2 release -- 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