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

Re: [libreoffice-documentation] Calc Multiple Operations tool


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: documentation+unsubscribe@global.libreoffice.org
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

Follow-Ups:
Re[2]: [libreoffice-documentation] Calc Multiple Operations tool"Steve Fanning" <stevemfanning@yahoo.co.uk>
References:
[libreoffice-documentation] Calc Multiple Operations tool"Steve Fanning" <stevemfanning@yahoo.co.uk>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.