Hi Regina
Draft Wiki Page created as work in progress
https://wiki.documentfoundation.org/CalcTableRef
Cheers
Olivier
On 7/31/24 10:57, Regina Henschel wrote:
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
--
Olivier Hallot
LibreOffice Documentation Coordinator
Rio de Janeiro - Brasil - Local Time: UTC-03:00
LibreOffice – free and open source office suite: https://www.libreoffice.org
Respects your privacy, and gives you back control over your data
http://tdf.io/joinus
--
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.