Bug 85073

Summary: Chart 'Data Ranges...' grayed out
Product: LibreOffice Reporter: jby601
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED WORKSFORME    
Severity: normal CC: ign_christian
Priority: medium    
Version: 4.2.6.3 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Sample spreadsheet

Description jby601 2014-10-15 22:12:37 UTC
Created attachment 107902 [details]
Sample spreadsheet

Using LO Version: 4.2.6.3 Build ID: 420m0(Build:3) under Linux Mint 17.

Use:  Insert > Object > Chart... to create a simple chart.

Accept the default values in steps 1 and 2.

In step 3, click 'Add'. In the box headed 'Data series' appears the wording:
'Unnamed Series' and in the box headed 'Data ranges' there are two rows (or more in the case of e.g.x-y plots). The top line reads 'Name'. As a beginner, it appears to be possible to change 'Unnamed Series' to a name of your own choosing by entering a value in the text edit box 'Range for Name', e.g. "Foo"

Enter a genuine data range, so that a nice-looking chart appears.

Now, if you save and close the spreadsheet and then re-open it, it is no longer possible to access the 'Data Ranges...' dialog. The option to do so is grayed out in the 'Format' menu, and on the right-click menu on the chart itself the option has been replaced with 'Chart Data Table...' This is now only a copy of the data and not linked to the spreadsheet.

Up until the save and re-open, it is still possible to access 'Data Ranges', and indeed if "Foo" is deleted the spreadsheet may be saved and re-opened without problems.

This is counter-intuitive to me. If 'Range for Name' can only accept properly-defined spreadsheet ranges, then the user should be warned of this, and not have to discover it after saving/re-opening his/her work.

Sample spreadsheet attached.
Comment 1 ign_christian 2014-10-16 03:32:15 UTC
Hi.. New bug report should filed with UNCONFIRMED status, someone else will mark NEW if same issue confirmed.

Saw same behavior with LO 4.2.6.3 portable - Win7 x86. Seems the bug is gone with LO 4.3.2.2 though Bug 83162 exists.

I'll check later with 4.2.7
Comment 2 ign_christian 2014-10-16 07:17:54 UTC
Confirm same behavior with LO 4.2.7.1 - Ubuntu 12.04 x86

But it's not happen with LO 4.3.2.2
Comment 3 raal 2014-10-17 13:11:41 UTC
LO 4.3.2, Win7 - it's fixed
Comment 4 ign_christian 2014-10-20 02:43:15 UTC
Perhaps this report should be closed since we can confirm it works with latest 4.3 release. While 4.2 release is near EOL and we can't expect much for backported fix.
Comment 5 jby601 2014-10-20 14:59:52 UTC
I will await the release of LO 4.3 so I'm happy for this to be closed.