Bug 116732

Summary:	Chart Legend does not display concatenated data
Product:	LibreOffice	Reporter:	Ian Eales <ieales>
Component:	Chart	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	ilmari.lauhakangas
Priority:	medium
Version:	6.0.2.1 release
Hardware:	x86-64 (AMD64)
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description Ian Eales 2018-04-01 19:17:16 UTC

Description:
Using 
=CONCATENATE( INDEX(MonNames,1,D3), " to ", INDEX(MonNames,1,D4) )

 or

=INDEX(MonNames,1,D3) & " to " & INDEX(MonNames,1,D4) )

in a cell and referencing that cell for a [scatter] plot results in a blank legend


Steps to Reproduce:
1. create formula to build concatenated text
2. reference above cell for legend text
3. legend shows as expected in Chart Edit Data Ranges dialog, but is blank on chart

Actual Results:  
Blank legend on chart

Expected Results:
Legend displays cell text


Reproducible: Always


User Profile Reset: No



Additional Info:
version is what I'm using, may have always been...

Version: 6.0.2.1 (x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: en-US (en_US); Calc: group

problem exist on other machines, so did not reset user profile. I have a fair bit of customization and don't want to lose it all.

OpenGL test site blocked by windows


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 Edge/16.16299

Comment 1 Buovjaga 2018-04-02 17:23:35 UTC

Please attach example file.

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.

Comment 2 Ian Eales 2018-04-02 19:08:57 UTC

I created a new workbook and the problem was not there.

The original workbook is a few years old. It appears that the legend was not resizing properly when new items like trend and mean lines were added when the formula cell was used. If plain text in a cell was used, the legend showed. I misattributed it to the formula.

I create hundreds of graphs and normally when adding data ranges or trend / mean lines the legend grows to accommodate.