Bug 126521 - Incorrect export to Excel of Calc spreadsheet containing Multiple Operations
Summary: Incorrect export to Excel of Calc spreadsheet containing Multiple Operations
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Corrupted
  Show dependency tree / graph
 
Reported: 2019-07-24 09:21 UTC by Steve Fanning
Modified: 2022-09-06 00:14 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Steve Fanning 2019-07-24 09:21:59 UTC 
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