Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Columns and Rows functions on external referenced ranges return wrong values | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | marco.nicolazzo | ||||
Component: | programming | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Normal | ||||||
Priority: | P3 | CC: | issues, oliver.brinzing, rb.henschel | ||||
Version: | 3.4.0 Beta (OOo) | Keywords: | oooqa | ||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
I see the problem with the attached pair of documents. The wrong result 1 does not only appear with very large number of rows but also with more than 7 columns in the example documents. But I cannot set up a new pair of documents with exact the same error. Trying it with new documents I get the error, that not the number of rows or columns of the reference is returned. But the number of rows and columns depends on the content of the referenced cells. This behavior does not correspond to the ODF definition. The wrong result does only occur, if a range in an external file is referenced, but not when the range is inside the own document. So there is surely something wrong with external references. I have tested it with DEV300m101 on WinXP. (Remove target milestone OOo3.3, because it is released already.) . Grabbing issue. External references need to be treated differently for ROWS() and COLUMNS(). getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used. |
Created attachment 76004 [details] Example spreadsheets The following functions =ROWS('file:///C:/Users/marco/Desktop/TestB.ods'#$Sheet1.$A$1:$Z$1048576) =COLUMNS('file:///C:/Users/marco/Desktop/TestB.ods'#$Sheet1.$A$1:$Z$1048576) return wrong value (i.e. 1) when the range specified is very large and user answer not to refresh referenced data on opening. Example (in TestA.ods) Range Rows Columns A1:C10 10 3 A1:C1000 1000 3 A1:C1000000 1000000 3 A1:C1048576 1048576 3 A1:F1048576 1048576 6 A1:I1048576 1048576 9 A1:L1048576 1048576 12 A1:M1048576 1048576 13 A1:N1048576 1048576 14 A1:O1048578 1 1 wher rows by cols exceed a value arount 14 millions, then both functions return the value 1, if referred data is not refreshed on opening. Implication: vlookup or hlookup functions are unusable when selecting large ranges in external references (for example the entire theoretical sheet, as it's often done), because the wrong number of rows/columns reported cause them to report error 502.