Date: prev next · Thread: first prev next last
2024 Archives by date, by thread · List index


Hi all,

Microsoft has for its "Excel table" a feature "structured references".
https://support.microsoft.com/en-us/office/using-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e

When opening an xlsx-file, the "Excel table" is converted into a "Database range", see section "Data Ranges" in the Help.
https://help.libreoffice.org/25.2/en-US/text/scalc/guide/database_define.html

LibreOffice can use the "structured references" and they are retained if saving to xlsx-Format. They are converted to ordinary range addresses, when saving to ODF. Feature request for ODF is in bug 162088.

But there exist no help on this feature, see bug 162275.

I want to start a Wiki-page for it. For that I need a term for this kind of addressing parts of a database range. Suggestions? I hesitate to name it "structured references" because a "Excel table" is not the same as our "Database Range", there are some slight differences how they work and because I don't know whether we will get trouble with Microsoft, when we name it the same.

Kind regards,
Regina

--
To unsubscribe e-mail to: design+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/design/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


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.