Hi,
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
We were able to observe the issue using your code. We will investigate this issue and fix it. Once the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as CELLSNET-41510.
Console Output
Color [A=0, R=255, G=0, B=0]
Color [Empty]
Color [Empty]
Color [A=0, R=255, G=0, B=0]
Color [A=0, R=255, G=0, B=0]
Color [A=0, R=255, G=0, B=0]
Hi Shakeel,
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
We are afraid, there is no update for you at this moment. However, I have logged your comments. Once, we will have some update for you, we will let you know asap.
Hi,
We have to create all empty cell instances to support your need .
But it will slow down the performance if we create too many cell instances, so please try the following methods to get the cell’s style.
And if A1:C3 is merged in MS Excel,you could not visit Cell B1.
C#
public static Style GetCellStyle(Cells cells, int row, int column)
{
ArrayList list = cells.MergedCells;
for (int i = 0; i < list.Count; i++)
{
CellArea ca = (CellArea)list[i];
if (ca.StartRow <= row
&& ca.EndRow >= row
&& ca.StartColumn <= column
&& ca.EndColumn >= column)
{
return cells[ca.StartRow, ca.StartColumn].GetStyle();
}
}
return cells[row, column].GetStyle(); ;
}