Hi,
I’m working with the latest version (#23) of Aspose.Cells & Aspose.Cells.GridJs
After we got the fix for the two tickets we had (Aspose.Cells v22.2 - fails to MergeExcelFileFromJson (GridJsWorkbook) & GridJS - need the option to set the ReCalculateOnOpen)
We are facing an issue now when trying to use custom calculation with GridJs.
When We are trying to show our Excel(s) online, we use the Custom Calculation engine and rather than re-calculate our custom function, we’d like to set their existing “value” to the “calculated value”.
So the code looks like this (this is our implementation for GridAbstractCalculationEngine):
public override void Calculate(GridCalculationData data)
{
_logger.LogInformation($"CustomCalculationEngine.Calculate Formula={data.Formula}, Value={data.Value}, StringValue={data.StringValue}");
data.CalculatedValue = data.Value;
}
Running this code locally (unit testing), works as expected, we set the value and it see it.
But, when this code is running on the server, we get an empty values for data.Value and for data.StringValue we do get value data.Formula.
The log on the server look like that:
CustomCalculationEngine.Calculate Formula==DR.GET(SumOfSales), Value=, StringValue=
The Excel we are trying to edit online is CustomCalcTest.zip (9.2 KB) - the issue occurs on the custom calculation of cell A1
Your support will be much appreciated!
Thanks,
Ori