Summary: | If a data range is defined in a document, it is partly translated in formulas into the normal cell range after saving and re-opening the document | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Jürgen Kirsten <dscheikey> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | REOPENED --- | ||
Severity: | enhancement | CC: | buzea.bogdan, miguelangelrv |
Priority: | medium | ||
Version: | 7.0.0.0.alpha0+ | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 109178 | ||
Attachments: | Example document to reproduce the bug |
Description
Jürgen Kirsten
2020-04-06 18:07:17 UTC
Created attachment 159369 [details]
Example document to reproduce the bug
You can save that as ODF it is not defined on it, and not implemented, it's only on xlsx documents for compatibility. https://wiki.documentfoundation.org/ReleaseNotes/5.0#Table_structured_references Sorry "can't save as ODF" So I reopen this and changed into a enhancement. The structured references are currently not saved in ODF format. Please change this. This would also lead to a better acceptance by the old Excel users. The data range is already saved correctly today. Only if I refer to a column 'Database[Row]' this is translated into the cell range when saving in *.ods. In the Release Notes for 5.0 it says that this also happens with *.xls. This is also correct. But with *.xlsx I can save and my structured references are preserved. Do I always have to save my documents in *.xlsx? Sorry, it must of course be called 'Database [column]'. I do not speak English as a native language. https://bugs.documentfoundation.org/show_bug.cgi?id=85063#c27 has a note of dev about this. In any case better open a new bug with a clear title about. I think it is already but I can't found it. |