We are using Aspose.Cells v22.214.171.124. One problem we noticed is that some cells with formulas do not have values even after calculating. It appears that this happens when the grid has already been calculated before the formula is added to the grid. So the following code, for example, works when the first CalculateFormula is omitted, but when it is put in, the test cell gives "Cell contains no data." even though the formula is there.
This is a big problem for us. Can you suggest anything?
public void SetSharedFormulaTest()
var workbook = new Workbook();
var grid = workbook.Worksheets;
var cell = grid.Cells[0, 2];
cell.Formula = "=3-2";
cell.SetSharedFormula(cell.Formula, 13, 1);
Assert.AreEqual(grid.Cells[12, 2].FloatValue, 1);