Issue 125821 - Array formulas over an entire column evaluate slowly
Summary: Array formulas over an entire column evaluate slowly
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.1
Hardware: PC Linux 32-bit
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-11-02 12:17 UTC by chris
Modified: 2014-11-02 12:17 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
The sheet that uses limited ranges shows perceptably better performance (9.18 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-11-02 12:17 UTC, chris 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description chris 2014-11-02 12:17:21 UTC 
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.