Default data label positioning of area charts in Excel is vertically centered between the X axis and the data point.
Opening this in Calc the data labels positioning is above the data point.
Steps to Reproduce:
1. Create a simple area chart in Excel
2. Enable data labels, save the file and open it in Calc
The data labels appear above the data points.
The data labels should appear vertically centered between the X axis and the data point.
User Profile Reset: No
Created attachment 157178 [details]
Example file from Calc
Created attachment 157179 [details]
Screenshot of the original document side by side in Excel and Calc
Also reproduced in
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e
Version 126.96.36.199.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Created attachment 157330 [details]
subtypes of area chart (work in progress)
It seems, MSO uses the default (and only) center labelling of area charts for better stacked area charts.
@Tünde: Unfortunately, the work-in-progress patch results regressions here, see the differences. 3D charts don't use exact center positioning. The stacked charts use center positioning inside of the area of the single data sets, not center of the data point-Y axis section.
Tünde Tóth committed a patch related to this issue.
It has been pushed to "master":
tdf#130031 Chart OOXML import: fix area chart data label position
It will be available in 6.5.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.