"Some of the cell formatting may have changed. Maximum number of fonts exceeded.........."

Aspose.Cells Product Family
1

Hi ,

I am getting this error message:

“Some of the cell formatting may have changed. Maximum number of fonts exceeded…”

whenever I open my reports in excel. It is very strange.

I have not used more than one font : “Arial” and that too size 8. It shows up the excel file fine(with just one font) after poping up that error message.

Will appreciate your quick reply,

Thanks

2

Hi,

Aspose.Excel currently does not combine the same fonts that you set to different cells.

For example, if you use the following code:


int styleIndex = excel.Styles.Add();
Style style = excel.Styles[styleIndex];
style.Font.Size = 8;

cells[“A1”].Style = style;

styleIndex = excel.Styles.Add();
Style style = excel.Styles[styleIndex];
style.Font.Size = 8;

cells[“A2”].Style = style;

Two font records will be saved in the result file, not just one.

If the style of two cell is the same, you can directly set a style object to two cells. That will decrease the number of fonts and styles.

int styleIndex = excel.Styles.Add();
Style style = excel.Styles[styleIndex];
style.Font.Size = 8;

cells[“A1”].Style = style;
cells[“A2”].Style = style;