https://bugs.documentfoundation.org/show_bug.cgi?id=106459
Bug ID: 106459
Summary: incorrect results in dragged sum formula spanning
multiple sheets (3d reference)
Product: LibreOffice
Version: 5.2.5.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 131775
--> https://bugs.documentfoundation.org/attachment.cgi?id=131775&action=edit
Minimal example showing the incorrect behaviour
When you have 100 or more contiguous cells in one column containing a sum
formula spanning multiple sheets (in excel, this is called a "3d reference"),
only the data of the first sheet's range is summed up.
How to reproduce:
Use the attached example, or do this:
- create new spreadsheet document
- add one new sheet (so we now have Sheet1 and Sheet2)
- enter the value "1" into Sheet1.B1 and Sheet2.B1
- enter the formula "=SUM(Sheet1.B1:Sheet2.B1)" into Sheet1.A1
- Sheet1.A1 now shows the value "2", as expected
- select Sheet1.A1 and drag the formula down to Sheet1.A100 (without letting
go!)
Expected result:
Sheet1.A1 still shows the value "2"
Observed result:
Sheet1.A1 shows the value "1" instead of "2"
Further Info:
- "Recalculate", "Recalculate Hard", or (save, close, re-open the document)
do not help
- modify any of the formulas on Sheet1 so it does not match the pattern of
the others
(e.g.: in Sheet1.A100, change "B100" to "B101" in either or both of the
cell references),
then "Recalculate Hard", and the problem goes away.
Revert the modification, and it still works ok - until you save, close and
re-open the document.
- if you drag the formula to A99 only, then pick up the drag square again and
drag to A100,
A1 will still show "2" as expected, but will not update if you change the
value on Sheet2.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
