Consider the attached workbook, and the following code:
ExampleIntersections.zip (10.3 KB)
var workbook = new Aspose.Workbook("ExampleIntersections.xlsx"); // "=EntireRowNamedRange" but should be "=@EntireRowNamedRange" var a5Formula = workbook.GetRangeByAddress("Example!A5").Formula; // "=EntireRowNamedRange" var a6Formula = workbook.GetRangeByAddress("Example!A6").Formula;
I would have expected the “@” sign to appear in the formula, both because it changes the actual rendered output of the workbook (see the difference between rows 5 and 6), but it also has bearing on these Excel compatibility topics:
We would like to see the “@” to help programmatically identify formulas where its presence may be an issue. For example, try editing A4 in the attached workbook to have an @ sign in front the formula, and you’ll get this error message:
image.png (17.3 KB)
Using precedent tracing and some logic of checking named range size, if Aspose were to return the “@” sign in the formula, we would be able to programmatically detect the same situation that popup is warning about.
Would it be possible for Aspose to allow getting/setting the “@” character in cell/range Formulas?