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
