|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Array formulas over an entire column evaluate slowly | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | chris | ||||
| Component: | editing | Assignee: | AOO issues mailing list <issues> | ||||
| Status: | UNCONFIRMED --- | QA Contact: | |||||
| Severity: | Normal | ||||||
| Priority: | P3 | ||||||
| Version: | 4.1.1 | ||||||
| Target Milestone: | --- | ||||||
| Hardware: | PC | ||||||
| OS: | Linux 32-bit | ||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
| Developer Difficulty: | --- | ||||||
| Attachments: |
|
||||||
Created attachment 84154 [details] The sheet that uses limited ranges shows perceptably better performance When an array formula is applied to an entire column then it evaluates very slowly. When applied to a limited range it evaluates much more quickly. I believe this is due to the formula being applied to the full range, rather than just the limits of the sheet. I consider this a bug rather than an enhancement as I cannot see a reason for evaluating outside the limits of the sheet (as determined by pressing ctrl-End). Specifying a full column range allows the sheet to grow indefinitely while performance degrades in proportion to the size.