Created attachment 175159 [details]
attachment 166828 [details] saved with current Calc master
This is a followup to bug 144397
When the attachment 166828 [details] is saved in Calc, the resulting file is invalid according to Excel.
Steps to reproduce:
1. Open attachment 166828 [details]
2. Save as XLSX
3. Open that file in Excel
Excel repairs the file, says it has found invalid named range.
Correctly saved named range that is pointing to an external file.
Version: 188.8.131.52.alpha0+ (x64) / LibreOffice Community
Build ID: 770dcb1f717d576facf31efed14bee403e1a7155
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
safe to assume this would be a new feature, not a regression.
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":
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:
Affected users are encouraged to test the fix and report feedback.
Version: 184.108.40.206.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