I'm having trouble with some formulas that are valid in Excel, which don't seem to work in Aspose. I'm using Aspose.Cells for .NET (just got the latest version 184.108.40.206).
Some Excel formulas allow me to specify a range as the intersection of two ranges. For example, SUM(D:F 8:8) is equivalent to SUM(D8:F8). The first syntax is especially useful when dealing with named ranges; e.g. if Name1 = D:F, then I can use SUM(Name1 8:8).
Aspose does not seem to handle these formulas correctly. Please see the attached Intersections.xls, with formulas in columns B and G. IntersectionsTests.cs has code which shows that these formulas are not correct when the grid is manipulated, although formulas that do not use this syntax (B9 and G9) work correctly. Is it possible to make these formulas work correctly in Aspose?
Additionally, when I save the Intersections.xls as SpreadsheetML format (Intersections.xml) Aspose can't even open the file. This seems to be because the formulas are converted to R1C1 notation, and references to whole rows are written as R. For example, =SUM(C[-3]:C[-1] R). Aspose seems to be unable to process the R. Is there any way this could be made to work as well?