[Issue 125821] New: Array formulas over an entire column evaluate slowly

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125821

          Issue ID: 125821
        Issue Type: DEFECT
           Summary: Array formulas over an entire column evaluate slowly
           Product: Calc
           Version: 4.1.1
          Hardware: PC
                OS: Linux32
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: chris@chris-barry.org

Created attachment 84154
  --> https://issues.apache.org/ooo/attachment.cgi?id=84154&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.