Bug 152141 - Data labels range in data series is lost in XLSX and XLS
Summary: Data labels range in data series is lost in XLSX and XLS
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls, filter:xlsx
Depends on:
Blocks: Chart-Labels
  Show dependency treegraph
 
Reported: 2022-11-20 10:57 UTC by Fabio
Modified: 2022-11-28 11:15 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
I show the problem (11.99 MB, video/mp4)
2022-11-21 07:55 UTC, Fabio
Details
file you requested (94.67 KB, image/jpeg)
2022-11-21 10:54 UTC, Fabio
Details
spreadsheet (20.50 KB, application/vnd.ms-excel)
2022-11-22 19:18 UTC, Fabio
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Fabio 2022-11-20 10:57:54 UTC
Description:
when constructing the graphs, LibreOffice does not keep the Category Labels in memory: I save the file with the graph with the captions, I close the file, I reopen the file, and the category labels have disappeared. I have to set them every time, it doesn't keep them in memory.

Steps to Reproduce:
1.set category labels
2.close file
3.reopen file

Actual Results:
nothing

Expected Results:
I hope it stays in memory


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 7.3.2.2 (x86) / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: it-IT (it_IT); UI: it-IT
Calc: threaded
Comment 1 m_a_riosv 2022-11-20 19:30:59 UTC
Could you attach a sample file?
Comment 2 m_a_riosv 2022-11-21 01:26:45 UTC
Attach it here please, not sending a private email. Make it as simple as you can.
Also to mention, a video, it's not of too much help.
Comment 3 Fabio 2022-11-21 07:55:31 UTC
Created attachment 183688 [details]
I show the problem
Comment 4 m_a_riosv 2022-11-21 10:35:03 UTC
Pls attach a real sample file, not a video.
Comment 5 Fabio 2022-11-21 10:54:55 UTC
Created attachment 183696 [details]
file you requested

I attach the file you requested, but the video was much more explanatory.
Comment 6 m_a_riosv 2022-11-21 21:18:42 UTC
You have not attached the requested file, a spreadsheet file. The video or the image can be explanatory, but don't allow recreating the situation.
Comment 7 Fabio 2022-11-22 19:18:34 UTC
Created attachment 183722 [details]
spreadsheet
Comment 8 QA Administrators 2022-11-23 03:44:53 UTC Comment hidden (obsolete)
Comment 9 Fabio 2022-11-23 15:32:55 UTC
Description:
when constructing the graphs, LibreOffice does not keep the Category Labels in memory: I save the file with the graph with the captions, I close the file, I reopen the file, and the category labels have disappeared. I have to set them every time, it doesn't keep them in memory.

Steps to Reproduce:
1.set category labels
2.close file
3.reopen file

Actual Results:
nothing

Expected Results:
I hope it stays in memory
Comment 10 raal 2022-11-23 21:34:41 UTC
I can confirm with Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7b23c53232245a1f61c3e8ddff59d049a49fe975
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

I recommend using .ods format.
Comment 11 raal 2022-11-23 21:37:01 UTC
repro Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 12 Stéphane Guillou (stragu) 2022-11-28 11:15:23 UTC
The range is kept only for ODS, not for XLSX or XLS.