Workbook with data in sheet1 and some dependant charts and formulas on sheet 2,3 ecc.:
When inserting data in sheet1 I note that are updated only the rangeof cells in formulas and charts of the same sheet.
The range of the formulas and charts on other sheets are not updated.
I’m using method:
worksheet.Cells.InsertRows(row, 1); and wrote the data on cells of the new row.
If open file with Microsoft Excel and insert a new row the range specified on charts and formula are updated on all the worksheetts of the file.
I tried with xls and xlsx files but the problem is same.
I’m using Aspose Cells for
Thank you in advance