Bug 138833 - Impossible to save a Calc file with a chart with an invalid data range obtained when converting from data table
Summary: Impossible to save a Calc file with a chart with an invalid data range obtain...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart
  Show dependency tree / graph
 
Reported: 2020-12-11 21:42 UTC by Leyan
Modified: 2022-12-12 23:25 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot showing the broken ranges for Name and Y-Value (49.76 KB, image/png)
2021-07-21 20:03 UTC, Leyan 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Leyan 2020-12-11 21:42:47 UTC 
Description:
In a chart with an internal data table copied to Calc, starting the process of replacing the internal data table by data ranges (but without actually configuring the data ranges) can leave the file in a state impossible to be saved.

Steps to Reproduce:
1.Create a chart in Word, copy it to Excel. 
2. Edit the chart and select "Data Ranges".
3. Choose Yes in the confirmation popup, the Data Ranges settings popup appears.
However, the values chosen in the ranges are non-sensical, they do not refer to cells at all ("category" for Categories, etc.)
4. Cancel this popup.


Actual Results:
The invalid ranges chosen by default are kept, the original data is still displayed, and the file becomes impossible to save with the chart in it. A popup appears "Error saving the document" "Write Error" "The file could not be written".

Expected Results:

The default ranges should be valid by default, like when creating a new chart. Even if the data is overwritten by an empty chart, the file stays usable.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.2.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.9; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
7.0.2-2
Calc: threaded
Comment 1 Leyan 2020-12-11 21:44:09 UTC 
Sorry, in the steps to reproduce, it is not Word and Excel, but Writer and Calc of course!
Comment 2 Eleonora Govallo 2021-07-21 11:49:00 UTC 
Hello!
Would you mind describing the step 2 edit the chart and select data ranges - you mean data table in Calc or Write. Could you attach printscreen?
Comment 3 Leyan 2021-07-21 20:03:08 UTC 
Created attachment 173765 [details]
Screenshot showing the broken ranges for Name and Y-Value
Comment 4 Leyan 2021-07-21 20:03:56 UTC 
I mean the data ranges (not data table) in Calc, after copying the chart from Writer.
Comment 5 Eleonora Govallo 2021-07-21 21:27:00 UTC 
Repro in Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: c5ca46e75e28ba4245d8544ca53c71fea87d1bbd
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-07-20_00:22:42
Calc: threaded
Comment 6 Stéphane Guillou (stragu) 2022-12-12 23:25:10 UTC 
I could reproduce in 6.3.6.2, but no error when saving anymore, since at least:

Version: 7.4.3.2 / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded