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.

Reply via email to