We upgraded Aspose.Cells from 25.10 to 26.6 and suddenly we get the following error:
Aspose.Cells.CellsException: Invalid table reference, formula should be in table when specifing no table name.(Based on A1)
It is reproducable and I created a small sample project which you can find here
Since it works with the old version can you please look into this and provide us a newer version.
Regards,
Danny Springer
Hello,
Thank you for reporting this issue to us.
We have successfully reproduced the behavior you described using Aspose.Cells 26.5. Our internal testing confirms that the engine currently fails to parse or set formulas using structured table references (such as [@[Column]]) when the table name is omitted, even when the target cell is located within the defined table boundaries.
It appears there is a regression in how the formula parser handles relative table references in the current version compared to previous releases. We have verified that this specific syntax is valid in Excel but is currently triggering a CellsException in our library.
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-60300
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.