Problem with Calc 6.2 Multiple Operations

[Eike Rathke]

Hi Steve,

On Tuesday, 2019-07-23 13:20:09 +0000, Steve Fanning wrote:

> 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.
> 
> Should this process work or am I doing something stupid?

No to both ;-P

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

Please open a bug for this.

Thanks
  Eike

-- 
GPG key 0x6A6CD5B765632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20190723/450fc86d/attachment.sig>