Bug 122985 - VIEWING: Chart column label improvised when label cell is blank
Summary: VIEWING: Chart column label improvised when label cell is blank
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Labels
  Show dependency tree / graph
 
Reported: 2019-01-26 00:49 UTC by Ben Elliston
Modified: 2019-03-23 13:35 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Test case demonstrating the problem. (12.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-26 00:54 UTC, Ben Elliston 		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 Ben Elliston 2019-01-26 00:49:47 UTC 
Description:
In Excel, if "Use first row as column labels" (or "first column as row labels") is selected, then a blank cell in any of those cells produces a blank label the chart legend. In LibreOffice, the blank cell is replaced with "Column X" (for example).

Should LibreOffice aim for consistency with Excel on this? I am happy to be convinced otherwise. Using "Column X" in the legend is fine when column labels are not taken from the spreadsheet, but I don't think LibreOffice should mix up both.

Steps to Reproduce:
Test case attached.

Actual Results:
One series in the chart is labelled "Column D".

Expected Results:
The series should have no label.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Ben Elliston 2019-01-26 00:54:41 UTC 
Created attachment 148667 [details]
Test case demonstrating the problem.
Comment 2 Oliver Brinzing 2019-01-26 15:09:21 UTC 
i can confirm the described behaviour.
already reproducible with AOO 4.15.

but i am not sure if this can be seen as a bug.

workaround: insert a blank into cell D3
Comment 3 Ben Elliston 2019-01-26 22:04:35 UTC 
When you say "insert a blank", I assume you mean "insert a single space character"? That indeed works, but is not an option for me as the affected spreadsheet comes from a third party. I don't want to have to modify it.
Comment 4 Ben Elliston 2019-01-30 11:44:57 UTC 
Having read the documentation more closely, I don't think I can consider this a bug. LO is behaving as documented.
Comment 5 Ben Elliston 2019-01-30 11:45:31 UTC 
Changed to enhancement.