[Libreoffice-bugs] [Bug 143058] New: FILEOPEN XSLX following SAVE from ODS when Range Names are "large:

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 143058
           Summary: FILEOPEN XSLX following SAVE from ODS when Range Names
                    are "large:
           Product: LibreOffice
           Version: 6.4.7.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: malcolm.d.robbins at gmail.com

Created attachment 173187
  --> https://bugs.documentfoundation.org/attachment.cgi?id=173187&action=edit
Trivial ODS that exhibits the problem when exported to Excel and then loaded

There's a defect saving to Excel and then reloading the Excel sheet (whether
into Calc or Excel) when the sheet has named ranges defined that represent a
"large" column.  i.e. If you create a named range by selecting an entire
column.

Attached sheet illustrates the problem via the following steps (note the sheet
has 2 named ranges A and B defined in it that encompass the column column even
though the table has only 10 rows - to support extendability).

1) Open the provided ODS and select Data/Define Range and note that A and B are
defined ranges.  A is defined as $Sheet1.$A$1:$A$1048576, B similarly

2) Save the sheet as Excel (either format) and close

3) Now open the XLSX document. It *looks* OK but click on the items in the C
column (defined as A+B) and force evaluation with F9 and you'll get #VALUE! 

4) Now go to the range definitions again and you'll see they have been
truncated so a is now defined as $Sheet1.$A$1 and B similarly.  

In larger spreadsheets this causes even more severe problems such as the
spurious "Warning loading document 'blah'. The data could not be loaded
completely because the maximum number of rows per sheet was exceeded".

-- 
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/20210625/5b75f07b/attachment.htm>