Good Morning
I have the following problem, I hope you can help me:
In generating graphs of area type using Aspose.Cells.Charts have the problem that the first element and the last element you draw me with margin on the left and right.
I think it should be able to configure this range but I can not figure out how.
Thank you
Hi,
Well, if you need to get the upper left row/column and lower right row/column indices, you may do it via using the following attributes, see the sample lines of code for your reference:
e.g
Sample code:
…
int UpperLeftRow = chart.ChartObject.UpperLeftRow;
int UpperLeftColumn = chart.ChartObject.UpperLeftColumn;
int LowerRightRow = chart.ChartObject.LowerRightRow;
int LowerRightColumn = chart.ChartObject.LowerRightColumn;
string area1 = CellsHelper.ColumnIndexToName(UpperLeftColumn) + UpperLeftRow + 1":" +
CellsHelper.ColumnIndexToName(LowerRightColumn) + LowerRightRow +1;
Let us know if you have some different issue or requirements.
Thank you.