Summary: | FILESAVE XLSX Named range pointing to external file is lost | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | NISZ LibreOffice Team <libreoffice> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | VERIFIED FIXED | ||
Severity: | normal | CC: | miguelangelrv, nemeth, varga.balazs3 |
Priority: | medium | Keywords: | filter:xlsx |
Version: | Inherited From OOo | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=144397 https://bugs.documentfoundation.org/show_bug.cgi?id=137846 https://bugs.documentfoundation.org/show_bug.cgi?id=112566 https://bugs.documentfoundation.org/show_bug.cgi?id=148993 |
||
Whiteboard: | target:7.3.0 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108897 | ||
Attachments: |
attachment 166828 saved with current Calc master
Screenshot of the saved-reopened file in Calc Screenshot of the exported document in Excel after removing an invalid named range |
Description
NISZ LibreOffice Team
2021-09-21 09:53:03 UTC
Created attachment 175160 [details]
Screenshot of the saved-reopened file in Calc
Created attachment 175161 [details]
Screenshot of the exported document in Excel after removing an invalid named range
*** This bug has been marked as a duplicate of bug 137847 *** (In reply to m.a.riosv from comment #3) > > *** This bug has been marked as a duplicate of bug 137847 *** No, this is a different issue. The example file is referenced from bug 137846, but * bug 137846 and bug 137847 are about opening and saving the abomination in cell B3 * while 144397 and this one is about opening and saving the abomination in cell B2 The solution for the latter two are in https://gerrit.libreoffice.org/c/core/+/122026 - Balázs told me this does not solve the issues with external data ranges (or Table names in Excel terminology). Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/12ee423c7549ddd2b86dfc3fc6fed2c617dcca7f tdf#144397 tdf#144636 XLSX: cache external named ranges and their formulas It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Verified in: Version: 7.3.0.0.alpha1+ (x64) / LibreOffice Community Build ID: 73334560b2dd2d60ac58d2cc2b1a5295490b03e1 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded |