I would like to highlight recent issues I have been having with Aspose handling of the CEILING function with significance parameter of 0.12.
A client supplied a hugely complex spreadsheet which produced incorrect results when run through Aspose Cells when compared to running directly in Excel. The spreadsheet is client confidential so cannot be supplied.
I would be grateful to receive any feedback on these observations., thank you
The workbook had many worksheets including 720 formula including CEILING function with significance parameter of 0.12,
i.e. =CEILING(F90-IF(Inputs!F$192=“No”,0,‘Pen Deb PRE DOL LR’!F322),0.12)
Results with CEILING(xxx,0.12)
I modified the SS to use CEILING(xxx,0.01) everywhere as an alternative. Results:
I also modified the SS to use MROUND(0.05999 + xxx,0.12) which should be mathematically more or less equivalent. Results:
As you can see the results with CEILING(xxx,0.12) are considerably different to those using MROUND(0.05999 + xxx,0.12) , which are very close to the results obtained when running the original spreadsheet directly in Excel.
(This is tested using Aspose Cells 22.5)