Hi All,
I have a problem when I modify theYPixel position for a datalabel.
This position is modified but do not contain the expected value…
I am using Aspose.Cells 25.4.0
cf the code below:
var pathWorkbook = @"...\\TestHadrienDataLabel.xlsx";
var pathWorkbookNew = @"...\\OneDrive - FactSet\\Documents\\TestHadrienDataLabelBis.xlsx";
var wbtest = new Workbook(pathWorkbook);
Worksheet sheettest = wbtest.Worksheets[0];
Chart charttest = sheettest.Charts[0];
charttest.Calculate(); // calculate all the datapoints for the NSeries
var lastPointIndex = charttest.NSeries[0].Points.Count - 1;
var dataLabels = charttest.NSeries[0].Points[lastPointIndex].DataLabels;
Console.WriteLine($"DataLabel: {dataLabels.XPixel}, {dataLabels.YPixel}");
dataLabels.XPixel = 200;
dataLabels.YPixel = 200;
Console.WriteLine($"New DataLabel: {dataLabels.XPixel}, {dataLabels.YPixel}");
wbtest.Save(pathWorkbookNew);
Result:
DataLabel: 738, 155
New DataLabel: 200, 389
Do you know why ?
virtual X is obsolet. So I am using now XPixel and YPixel.
Thanks,
TestHadrienDataLabel.zip (24.0 KB)