Problem with Calc 6.2 Multiple Operations
erack at redhat.com
Tue Jul 23 16:28:48 UTC 2019
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.
GPG key 0x6A6CD5B765632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 833 bytes
Desc: not available
More information about the LibreOffice