Created attachment 192261 [details] Example file from Excel 2016 Attached example file has a data series name that has an empty second line. In Excel this is not rendered in the charts data table, but in Calc it is. 1. Open attached file -> the data table has two line tall headers, but in Excel it is only one line. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d49b0c3654e50ff9b74545140e6f19e008009c33 CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: threaded
Created attachment 192262 [details] Screenshot of the example file in Excel 2016 and Calc
Hello Gabor Kelemen, I have looked at both attachments; excel file and screenshot. There is an additional break in excel which showed in LO calc spreadsheet. I removed the linebreak and it resolved the issue. I did this similarly in both stable and master builds. Is this a simple fix ok for you? Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 8eee7eab8087590aa19bb9989c294e9be767f356 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
(In reply to Dean from comment #2) > Hello Gabor Kelemen, > > I have looked at both attachments; excel file and screenshot. There is an > additional break in excel which showed in LO calc spreadsheet. I removed the > linebreak and it resolved the issue. I did this similarly in both stable and > master builds. > > Is this a simple fix ok for you? The idea is that we shouldn't render the line break in the data table, so we would be visually compatible with Excel. Let's set to NEW.