Bug 157906 - Named ranged are lost when we convert from ods to xlsx
Summary: Named ranged are lost when we convert from ods to xlsx
Status: RESOLVED DUPLICATE of bug 157318
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-10-24 06:16 UTC by nhatthinh.phan
Modified: 2023-10-25 14:00 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example to test the issue (9.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-10-24 06:17 UTC, nhatthinh.phan
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nhatthinh.phan 2023-10-24 06:16:14 UTC
Description:
Named ranged are lost when we convert from ods to xlsx.
I cannot replicate this issue in LibreOffice Calc version 7.5.7 or earlier.
This issue happens from version 7.6

Steps to Reproduce:
1. Open LibreOffice Calc and create a Named Ranged.
2. Save as *.ods file.
3. Close this file.
4. Open this file and save as *.xlsx e.g. test_named_ranged.xlsx
5. Close all files.
6. Open test_name_ranged.xlsx and check the Named Ranged in step 1 has been lost.

Actual Results:
The Named Ranged has been lost.

Expected Results:
The Named Ranged should be kept.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
I cannot replicate this issue in LibreOffice Calc version 7.5.7 or earlier.
This issue happens from version 7.6
Comment 1 nhatthinh.phan 2023-10-24 06:17:47 UTC
Created attachment 190396 [details]
Example to test the issue
Comment 2 Stéphane Guillou (stragu) 2023-10-24 06:46:08 UTC
This is a sheet-level named range. I believe this should be fixed in version 7.6.3 with the fix for bug 157318. You can test a pre-release to confirm: https://dev-builds.libreoffice.org/pre-releases/

Thank you!

*** This bug has been marked as a duplicate of bug 157318 ***
Comment 3 nhatthinh.phan 2023-10-24 23:15:27 UTC
Thank you for your reply. I will test it when I can download that version. Currently, I cannot find it from the pre-release.

Thinh
Comment 4 Stéphane Guillou (stragu) 2023-10-25 14:00:25 UTC
(In reply to nhatthinh.phan from comment #3)
> Thank you for your reply. I will test it when I can download that version.
> Currently, I cannot find it from the pre-release.
Sorry, I pointed you to the wrong listing. You should find a daily build of 7.6.3 here: https://dev-builds.libreoffice.org/daily/libreoffice-7-6/