Hi, I’d like to report two behaviours which, in my opinion might be bugs.
- The first sheet contains two ListObjects with column formula referencing other columns of the same table; when inserting rows in that sheet, whether it involves the listObjects or not, some wrong formula appears around depending on the number of inserted rows and on the number of column formula defined per table (see output file for more details);
- The second sheet contains a ListObject where some headers contain carriage return in their text. If those columns are used in formulae, once you save the workbook with Aspose, formulae get broken showing the #REF error code (see Sheet2 of the output file).
- Also using a formula like the following “=SUM(Table3[[#Headers];[#Data];[Column1]:[Column3]])” results in the same (parsing?) error as stated in the above point 2 (see Sheet2 of the output file for the related example).