Bug 159450

Summary: FILEOPEN XLSX Axis title in chart with data table is misplaced
Product: LibreOffice Reporter: Gabor Kelemen (allotropia) <kelemeng>
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: ilmari.lauhakangas, mhillat
Priority: medium Keywords: filter:xlsx, implementationError
Version: 7.5.0.3 release   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=130587
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 75057    
Attachments: Example file from Excel 2016
Screenshot of the example file in Excel 2016 and Calc

Description Gabor Kelemen (allotropia) 2024-01-30 13:25:59 UTC
Created attachment 192256 [details]
Example file from Excel 2016

Attached example document has a chart with the vertical axis title and data table enabled.
In Calc the axis title is incorrectly positioned compared to Excel, a bit to the left and down towards the bottom.

1. Open attached document
-> the Y axis title is misplaced.
Looks like in Excel it is automatically aligned compared to the Y axis only, but in Calc the height of the axis and the data table is also considered.

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

Data table was implemented in 7.5, before this was good.
Comment 1 Gabor Kelemen (allotropia) 2024-01-30 13:26:27 UTC
Created attachment 192257 [details]
Screenshot of the example file in Excel 2016 and Calc
Comment 2 Buovjaga 2024-02-16 14:31:25 UTC
Confirmed.

Arch Linux 64-bit, X11
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 3b04e74503ec6d07dc4befdb756e6abdc3de4e58
CPU threads: 8; OS: Linux 6.7; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 16 February 2024