Hi Steve,
Steve Fanning schrieb am 21-Jul-19 um 13:00:
All,
I am putting the finishing touches to the updated version of Chapter 9
of the 6.2 Calc Guide and have found an existing sentence which I don't
understand.
The LibreOffice 4.1 Calc Guide contains a note as follows:
"If you export a spreadsheet containing multiple operations to Microsoft
Excel, the
location of the cells containing the formula must be fully defined
relative to the data
range."
Is anybody able to clarify exactly what this means?
Have you tried an export to Excel? The import from a two-dimensional
DataTable generates the correct MULTIPLE.OPERATIONS entries, but resave
by LO does not produce files, which are shown correctly in Excel.
The export to xlsx generates the function "MULTIPLE.OPERATIONS". But
that function is unknown to Excel. The needed formula element with the
attribute t="dataTable" is missing at all. The export to xls generates a
file, which shows the correct entry {TABLE(...)}, if I open it in Excel,
but the second reference is wrong and the template area is broken. But
perhaps, I do something wrong.
The DataTable tool in Excel expects the template formula in the top-left
of an two-dimensional target table-area. So that is at least necessary
in LibreOffice too, if you want an export. I was not able to generate a
one-dimensional target table with one variable in Excel and so could not
test roundtrip for them.
So before wondering about some wording, you should test, whether the
export works at all.
Kind regards
Regina
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy
