Thank you for your patience with us.
This is to update you that we have looked further into this matter, and we are able to identify the cause of behaviour difference for formula calculation. Please check the formula at Modell - LOG REG’!D39 which is as follow =IF(C39=0,0,SQRT(MAX(0,IF(C39=“N/A”,0,ROUND(BRTEILJAHRE(C39,TODAY(),1)-0.5,0))))).
You can observe that the formula uses the function BRTEILJAHRE which cannot be parsed and calculated by Excel application in en-US environment and therefore formula results in #NAME? error. Please note, Aspose.Cells APIs can only support the standard function names in en_US environment.
The older versions of Aspose.Cells APIs were able to work for such non-English formula names because of the fact that when encounter functions that cannot be recognized, the Aspose.Cells calculation engine used to ignore the calculation. Instead, the older revisions of the APIs used cell’s original value (which was saved in the template file). However, for most situations, those functions should be calculated as #NAME? like what Excel application does. Therefore we modified the logic for those unknown functions to follow Excel’s standards and guidelines.
In order to avoid such situation while working with recent API revisions, we strongly suggest you to use the English based function names only. For instance, the function BRTEILJAHRE seems to be the locale name in de-DE environment for the standard function YEARFRAC so you can change this function to YEARFRAC, then it will be calculated by Aspose.Cells APIs.