Bug 124015 - FILESAVE XLSX Shapes get the same name
Summary: FILESAVE XLSX Shapes get the same name
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, filter:xlsx
Depends on:
Blocks: XLSX-Shapes
  Show dependency treegraph
 
Reported: 2019-03-12 09:23 UTC by NISZ LibreOffice Team
Modified: 2022-11-23 16:10 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Example ODS file saved by LO 3.5 (8.28 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-03-12 09:49 UTC, NISZ LibreOffice Team
Details
Example XLSX file saved by LO 3.5 (15.88 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-03-12 09:50 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-03-12 09:23:12 UTC
Description:
Shapes in XLSX documents created with LibreOffice Calc 6.3.0.0.alpha0+ get the same name when the document is exported and opened in LibreOffice Calc 6.3.0.0.alpha0+.
This makes it impossible to select one of the shapes by double clicking on the shape name in the Navigator because always the “first” one gets selected.

Shapes in Writer get unique default names (Shape1, Shape2 ...) that are correctly preserved in DOCX.

Steps to Reproduce:
    1. Create a new document in LibreOffice Calc 6.3.0.0.alpha0+.
    2. Insert shapes.
    3. Save the file as XLSX.
    4. Reload the file.
    5. Notice, that shapes get the same name. 


Actual Results:
Shapes get the same name in XLSX documents created and exported in LibreOffice Calc 6.3.0.0.alpha0+.

Expected Results:
Shapes should have individual names when the document is opened in LibreOffice Calc 6.3.0.0.alpha0+.


Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice details:
Version: 6.3.0.0.alpha0+
Build ID: 65438bcda46bab4f2fe6fb555f44aace45e11e5e
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: threaded
Comment 1 NISZ LibreOffice Team 2019-03-12 09:49:43 UTC
Created attachment 149907 [details]
Example ODS file saved by LO 3.5
Comment 2 NISZ LibreOffice Team 2019-03-12 09:50:25 UTC
Created attachment 149908 [details]
Example XLSX file saved by LO 3.5
Comment 3 Durgapriyanka 2019-03-12 17:20:35 UTC
Thank you for reporting the bug. I can confirm the bug in

Version: 6.3.0.0.alpha0+
Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 4 Aron Budea 2019-04-24 06:42:19 UTC
In Writer the following commit introduced unique names, which also enabled them to appear in the Navigator (and bug 122445 was a follow-up fix), might be helpful to know:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=3647626309ef89bf90d8b6a6539d41d8deb6b482
author		Caolán McNamara <caolanm@redhat.com>	2015-09-17 13:55:28 +0100
committer	Caolán McNamara <caolanm@redhat.com>	2015-09-17 14:12:08 +0100

Give drawing objects unique names by default
Comment 5 Aron Budea 2019-04-24 06:44:12 UTC
(In reply to Aron Budea from comment #4)
> them to appear in the Navigator (and bug 122445 was a follow-up fix), might
Oops, I meant bug 122487.
Comment 6 QA Administrators 2022-09-01 03:47:58 UTC Comment hidden (obsolete)
Comment 7 László Németh 2022-11-23 16:09:39 UTC
It seems, it's been already fixed.