Bug 135424 - FILESAFE XLSX The file in the package for the chart has no stable filename
Summary: FILESAFE XLSX The file in the package for the chart has no stable filename
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
 
Reported: 2020-08-03 23:01 UTC by Regina Henschel
Modified: 2024-09-24 10:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet with chart to test saving (21.43 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-08-03 23:01 UTC, Regina Henschel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2020-08-03 23:01:10 UTC
Created attachment 163914 [details]
Spreadsheet with chart to test saving

Open attached document.
Save it in xlsx-format with new name.
Save it a second time with new name.
Open the packages and find the folder /xl/charts.
In one case you will see a file "chart1.xml" in the other case a file "chart2.xml".

So the name depends on whether the file had been saved before. Such behavior hinders unit tests and evaluation of the file by programs.

The reason of this wrong behavior has been discussed in https://lists.freedesktop.org/archives/libreoffice/2020-July/085613.html
Comment 2 Regina Henschel 2020-08-04 13:50:45 UTC
(In reply to Xisco Faulí from comment #1)
> I believe the same happens with these 2 occurrences ...

Yes. That is a result of this bug. But "chart1" and "chart2" should not have been used in that test. Chart2ExportTest has a special version of parseExport, which uses always the first chart in folder 'charts', if called with '/charts/chart', see the other tests in that Chart2ExportTest. This workaround is implemented in local method 'findChartFile'.
Comment 3 QA Administrators 2022-10-07 03:37:55 UTC Comment hidden (obsolete)
Comment 4 Regina Henschel 2022-10-07 12:54:05 UTC
The problem still exists in Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: c3b5eea4304ad6815b491f549fce008a9630c213
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (en_US); UI: en-US
Calc: CL threaded
Comment 5 Sophie Sipasseuth 2024-09-24 09:08:17 UTC
Hello Regina,

Thank you for reporting the bug.

No repro with:

Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7ccfc0277a44d0a9eee943fdbb952e16df36590c
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: en-US
Calc: threaded

When I select the chart, then click on the "format" menu, and then on the "name..." option, I see the name "chart 1" each time.

But, perhaps I didn't understand the steps to reproduce the bug well.

I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 6 Regina Henschel 2024-09-24 10:51:54 UTC
It is indeed OK in Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 976567aee323afd09629b6adf13537908f43d2a8
CPU threads: 32; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: threaded

(In reply to Sophie Sipasseuth from comment #5)
> When I select the chart, then click on the "format" menu, and then on the
> "name..." option, I see the name "chart 1" each time.
The bug report was not about the name in the UI of LibreOffice, but about the file names inside the saved .xlsx files.