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 treegraph
 
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

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.