[Libreoffice-bugs] [Bug 126521] New: Incorrect export to Excel of Calc spreadsheet containing Multiple Operations

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 126521
           Summary: Incorrect export to Excel of Calc spreadsheet
                    containing Multiple Operations
           Product: LibreOffice
           Version: 6.2.0.2 rc
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: stevemfanning.wh at gmail.com

Description:
I have been working within the LO Documentation Team updating Chapter 9 (Data
Analysis) of the LO 6.2 Calc Guide.

I have hit a particular problem with the Multiple Operations tool and 
have been unable to successfully save a LO spreadsheet containing 
multiple operations into an Excel file. (I have tried placing the 
relevant formula in the top left cell!)

By way of an example you can find a suitable Excel spreadsheet on the 
site called www.excel-easy.com, at a download address of 
https://www.excel-easy.com/examples/excel-files/data-tables.xlsx. I 
opened this file in LO 6.2 and all seemed well, so I re-saved it from LO 
as an Excel file. Unfortunately Excel generated errors when opening this 
version of the file and the resulting spreadsheet appeared to just 
contain numeric values rather than a proper Excel Data Table structure.

Steps to Reproduce:
Covered in Summary.

Actual Results:
Multiple Operations not mapped to Excel Data Table.

Expected Results:
Multiple Operations should be mapped to Excel Data Table.


Reproducible: Always


User Profile Reset: No



Additional Info:

The following are emailed thoughts from Eike Rathke:

The original file for cell B13 contains an element

  <f t="dataTable" ref="B13:D17" dt2D="1" dtr="0" r1="D7" r2="C4"/>

which expresses the table "formula" as a dataTable type.

Calc when saving stores TABLE() formulas in the involved cells instead,
which apparently was the correct way to do in the binary .xls format but
not in OOXML .xlsx

-- 
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/20190724/a8ebc509/attachment.html>