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+unsubscr...@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
