Automatic resizing of chart when AutoFitColumns

[VincentB]

Hi

When i call AutoFitColumns below a chart, the LeftColumn of chart change

Example :

Code: Select all

// Chart
var chart = sheet.Charts.Add();
chart.TopRow = sheet.Range["G3"].Row;
chart.LeftColumn = sheet.Range["G3"].Column;
chart.Width = 500;
chart.Height = 225;
// cell below chart
sheet.Range["G20"].Value2 = "long long long value";
sheet.Range["G20"].AutoFitColumns();


I create a chart in G3 and when i AutoFitColumns G20, the chart begin on A3.
Are you reproduce ?

Thanks.

[Betsy.jiang]

Hi VincentB,

Thanks for your inquiry.
I have noticed the issue and posted it to our Dev team. We will inform you once there is any progress.
So sorry for inconvenience.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Hi VincentB,

Thanks for your waiting.
Now the issue get resolved in Spire.XLS Pack Hotfix Version:7.11.13, welcome to test it.

Sincerely,
Betsy
E-iceblue support team