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
Attachment:
signature.asc
Description: PGP signature