https://issues.apache.org/ooo/show_bug.cgi?id=124625
Issue ID: 124625
Issue Type: DEFECT
Summary: .xls broken with SUM($Sheet1.A1:A65537)
Product: Calc
Version: 4.1.0-beta
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: save-export
Assignee: [email protected]
Reporter: [email protected]
Please export this spreadsheet as .xls, and read it again.
Sheet1 is empty
Sheet2 contains in A1
=SUM($Sheet1.A1:A65535) --> =SUM($Sheet1.A1:A65535) OK
=SUM($Sheet1.A1:A65536) --> =SUM($Sheet1.A1:A1048576) wrong
=SUM($Sheet1.A1:A65537) --> =SUM($Sheet1.#REF!#REF!:#REF!#REF!) broken
(I am pretty sure that this is a very simple bug, just change somewhere SHORT
to INT).
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.