Bug 83140 - FILEOPEN: data range names as constant text lost on fileopen
Summary: FILEOPEN: data range names as constant text lost on fileopen
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.6.2 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-08-27 11:33 UTC by Karl Palsson
Modified: 2014-08-27 16:53 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Karl Palsson 2014-08-27 11:33:05 UTC
Problem description: 
If you have data ranges that don't have captions as first rows/columns, and you manually enter a name for a data range as "somename" (with quotes) in the "Range for name" field, then it shows correctly on the graph and causes no errors on save.  When you reload the file, the name is gone, and it returns to "column M" or similar.

Also described here: http://ask.libreoffice.org/en/question/19997/possible-to-set-charts-data-series-name-to-constant/

A workaround is to put the desired constant text in _any_ cell, and pick that cell as the "data range for name"

Steps to reproduce:
1. Create a graph with (multiple?) data ranges
2. edit the "name" property of a data range, in the "name for data range" field
3. enter a fixed string, such as "my range name"
4. ok, verify that chosen text shows on graph.
5. save document
6. close calc
7. open calc
8. open file saved in 5.
9. see that name for range entered in 3 is missing.

Current behavior:
the custom range name is missing when you re-open the file.

Expected behavior:
the custom range name is saved like anything else.
              
Operating System: Fedora
Version: 4.1.6.2 release
Comment 1 Karl Palsson 2014-08-27 11:36:10 UTC
I forgot to note, this is saving in .ods format, so it should be "native"
Comment 2 ign_christian 2014-08-27 14:09:25 UTC
Hi Carl.. You're using unsupported version of LO. 4.1 branch is reached end of life. Bug report should be filed if reproduced in latest stable release.

Assuming that what you meant is legend in XY chart, I can't reproduce with LO 4.2.6.2 under Ubuntu 12.04 x86

Please retest with latest stable release and using fresh user profile. Then please change status to RESOLVED WORKSFORME if it's resolved, otherwise UNCONFIRMED.
Comment 3 Karl Palsson 2014-08-27 16:53:29 UTC
works fine in 4.2.6.2 on fedora 20. (was my fedora 19 machine that had 4.1.x)