We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Variable Overflow?

Hello,

currently I am building a workbook with two worksheets. In the first worksheet I want to link every cell with the second worksheet using a formula. This works fine for the first 65536 rows (Excel 2010, Aspose.Cells version 7.5.0). But in row 65537 the formula points to the first row, in row 65538 to the second row etc.
When I debug my visual studio project, everything seems ok - the formulas displayed in cell.Formula are correct, but when I open the file with excel, I have the result mentioned above.

Am I doing something wrong? As I said: My code is working for the first 65536 rows:

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets.Add(“Test1”);
Worksheet worksheet2 = workbook.Worksheets.Add(“Test2”);
for (int row = 1; row < 100000; row++)
{
Cell cell = worksheet.Cells[“A” + row];
cell.Formula = “=IF(ISBLANK(’” + worksheet2.Name + “’!” + “A” + (1 + cell.Row) + “),”",’" + worksheet2.Name + “’!” + “A” + (1 + cell.Row) + “)”;
}
workbook.Save(“TestFile.xlsx”, SaveFormat.Xlsx);

Thanks for help.

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please create workbook object in this way and see if it resolves your issue.

C#


Workbook workbook = new Workbook(FileFormatType.Xlsx);

Thank you very much. That worked! :slight_smile: