Re: Problem with Calc 6.2 Multiple Operations

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

_______________________________________________
LibreOffice mailing list
LibreOffice@xxxxxxxxxxxxxxxxxxxxx
https://lists.freedesktop.org/mailman/listinfo/libreoffice

[Index of Archives]     [LARTC]     [Bugtraq]     [Yosemite Forum]     [Photo]

  Powered by Linux