Bug 128103 - FILESAVE: XLS: Chart key names lost
Summary: FILESAVE: XLS: Chart key names lost
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: XLS
  Show dependency treegraph
 
Reported: 2019-10-12 11:05 UTC by Jonny Grant
Modified: 2022-09-21 03:36 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
ODS save as XLS to reproduce (54.56 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-10-12 17:12 UTC, Jonny Grant
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jonny Grant 2019-10-12 11:05:07 UTC
Please reproduce in latest trunk version.

1. Create a spreasheet with 4 columns. Select data that does not include the column headings.
2. Plot a line chart, enter the column names by hand in the chart wizard.
3. Add some more rows to the data.
4. Observe the chart names are lost.

Easy to reproduce every time.

Please avoid asking me to install newer version of Calc to reproduce for you.
Comment 1 Julien Nabet 2019-10-12 11:26:25 UTC
On pc Debian x86-64 with LO Debian package 6.3.2, I don't reproduce this.

Here are the steps I did:
- launch a brand new file on Calc
- create an array on A B from line 2:
1   10
2   20
3   30
4   40
- select the 8 cells and click "Insert Chart"
- Click Next three times
=> dialog shows "Choose Titles, Legend, and Grid Settings"
- in "Title", type "Chart Title"
- in "Sub Title", type "Chart Sub Title"
- in "X axis", type "abscissa"
- in "Y axis", type "ordinate"
- Click "Finish"
=> names appear
- click on a cell which is not in the chart so you leave the chart
- select line 3
- Right click "Insert Rows above"
- add the pair cells "5  50"
- click enter to validate
=> the new values appear on the chart
and all the names are still there

6.0 and 6.1 branches are EOL but I took the time to make the test and describe precisely what I did.
So please, either give a step by step process to reproduce this or upgrade indeed.
Comment 2 Jonny Grant 2019-10-12 17:12:29 UTC
Created attachment 154961 [details]
ODS  save as XLS to reproduce
Comment 3 Jonny Grant 2019-10-12 17:13:46 UTC
(In reply to Julien Nabet from comment #1)
> On pc Debian x86-64 with LO Debian package 6.3.2, I don't reproduce this.
> 
> Here are the steps I did:
> - launch a brand new file on Calc
> - create an array on A B from line 2:
> 1   10
> 2   20
> 3   30
> 4   40
> - select the 8 cells and click "Insert Chart"
> - Click Next three times
> => dialog shows "Choose Titles, Legend, and Grid Settings"
> - in "Title", type "Chart Title"
> - in "Sub Title", type "Chart Sub Title"
> - in "X axis", type "abscissa"
> - in "Y axis", type "ordinate"
> - Click "Finish"
> => names appear
> - click on a cell which is not in the chart so you leave the chart
> - select line 3
> - Right click "Insert Rows above"
> - add the pair cells "5  50"
> - click enter to validate
> => the new values appear on the chart
> and all the names are still there
> 
> 6.0 and 6.1 branches are EOL but I took the time to make the test and
> describe precisely what I did.
> So please, either give a step by step process to reproduce this or upgrade
> indeed.

Julien, Appologies my mistake, there was an extra step to save as XLS. It seems that it is this save as XLS which causes the loss.

Please see attached test.ods, if you save as test.XLS, are the column key names lost for you in latest version?

Jonny
Comment 4 Julien Nabet 2019-10-12 21:38:15 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this with xls format.

Remark: I don't reproduce this if I save as xlsx format.
Comment 5 Xisco Faulí 2019-10-23 14:55:43 UTC
Also reproduced in

Version: 4.4.0.0.alpha0+
Build ID: 9835a5823e0f559aabbc0e15ea126c82229c4bc7
Comment 6 QA Administrators 2022-09-21 03:36:21 UTC
Dear Jonny Grant,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug