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.