Bug 103390 - Charts series from comma-labeled sheets in Calc are empty after copying in other LibO app
Summary: Charts series from comma-labeled sheets in Calc are empty after copying in ot...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
4.1.6.2 release
Hardware: All Linux (All)
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: notBibisectable, regression
Depends on:
Blocks: Chart-Data
  Show dependency treegraph
 
Reported: 2016-10-21 16:34 UTC by Francisco
Modified: 2022-05-13 13:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Problematic file (396.51 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-10-21 16:34 UTC, Francisco
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Francisco 2016-10-21 16:34:09 UTC
Created attachment 128130 [details]
Problematic file

I have a chart in an ODS file which has several sheets, some of them have commas in their names.

When copying this chart into a ODT or ODP file, the series from these sheets appear empty, i.e., no data in the data table (but these series remain there).

The chart has several series. The data of the blue and yellow ones is on sheets C6H6 and MePh.
The green and grey ones are from sheets with comma in their names: "1,4-Me2Ph" and "1,3,5-Me3Ph."

Steps:
0) Download and open the attached file.
1) Go to the "C6H6" sheet, and copy the chart present there. 
3) Create an ODT and paste it

Result:
The series with colors grey and green have disappeared. 

4) Activate the chart with double click
5) Open the chart data table
6) The series are actually there, but empty.

Expected:
All the series should be there.


I can reproduce this bug with the file attached using LibO with version 4.1.6.2 up to 5.3.0 alpha1, with the file attached. However, it can't reproduce the bug allways with any file with commas on their sheet names.

Last, I can't reproduce this bug using 3.5.7.
Comment 1 Francisco 2016-10-21 16:36:55 UTC Comment hidden (obsolete)
Comment 2 Joel Madero 2016-10-23 20:51:59 UTC
Version: 5.1.4.2
Build ID: 1:5.1.4-0ubuntu1
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; 
Locale: en-US (en_US.UTF-8)

Confirmed.

Major: Loss of data on copy/paste
High: Default for major bugs.
Comment 3 Joel Madero 2016-10-23 21:13:44 UTC
Unfortunately another bug exists in the range that causes bibisect to be impossible in this range. Adding tag.
Comment 4 QA Administrators 2018-06-15 02:44:54 UTC Comment hidden (obsolete)
Comment 5 Timur 2020-05-03 10:28:23 UTC Comment hidden (obsolete)
Comment 6 Timur 2020-05-11 07:25:12 UTC
Reproduced only in Linux, still in 7.0+. Not in Windows.
Comment 7 QA Administrators 2022-05-12 06:13:07 UTC Comment hidden (obsolete)
Comment 8 Francisco 2022-05-13 12:42:39 UTC
The bug seems solved in Version: 7.2.6.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: es-AR (es_AR.UTF-8); UI: es-ES
Ubuntu package version: 1:7.2.6-0ubuntu0.20.04.1~lo2
Calc: threaded

So, I'm closing this as worksframe