[Libreoffice-bugs] [Bug 109061] New: xlsx import : large ranges in formula shows error on recalc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=109061

            Bug ID: 109061
           Summary: xlsx import : large ranges in formula shows error on
                    recalc
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dennisfrancis.in at gmail.com

Created attachment 134583
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134583&action=edit
XLSX file with formula containing large range

Steps to reproduce :

1) Open the attached xlsx file
2) Select cell B4 and do "ReCalculate" (Data > Calculate > ReCalculate)
3) B4 now shows error : #NAME? instead of the value 6.


In the attachment the cell B4 has the formula =SUM(A2:BZZ2) and row 2 has
values only upto column C. LO supports only 1024 columns(upto AMJ), but I think
for large ranges in formulas should be truncated by the available columns(ie in
this case, A2:BZZ2 needs to be truncated to A2:AMJ2) while importing from xlsx
rather than reporting an error.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170711/66e6b9d0/attachment-0001.html>