https://bugs.freedesktop.org/show_bug.cgi?id=71598
Priority: medium
Bug ID: 71598
Assignee: [email protected]
Summary: Other: Cell Not Recalculating
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.2.3 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Cell referencing formula on another sheet does not recalculate. Cell A is a
cell which has a formula with "SUM(range)". Cell B is on another page and
references cell A. When a macro adds a row into the range used in Cell A, Cell
A recalculates automatically, but Cell B does not.
Steps to reproduce:
1. Make a column of numbers and below it make a cell with =SUM(R), where R is a
range of the column of numbers. This SUM cell will be cell A.
2. On another sheet make a cell with = X + Y, where X is some cell on the same
sheet and Y is a reference to cell A created in step 1. This new cell will be
cell B.
3. Make a macro which adds a row into range R and put a number in the column in
that range.
4. Run the macro.
Current behavior: Cell A updates and recalculates. Cell B does not
recalculate.
Expected behavior: Both A and B recalculate.
Operating System: Debian
Version: 4.1.2.3 release
--
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
