Been debugging this issue for a bit and can’t seem to locate an easy to spot cause outside of Aspose. We’re processing a calculator for a set of data, which uses a mixture of macros and formulas to output a set of results; the VB has been externalised and works perfectly and the formulas have been calculating with no issue until now.
The one in question is in the FRACTURE_SUMMARY Worksheet of the attached Workbook, in the cells F28 and F29. F28 is a sum of the cells above it and is working as expected, and F29 MROUNDs the result to the correct factor (10 or 100 depending), and then chooses the lesser value of the output and the value of another cell.
In the case attached, the result in F28 is 1850, which should round to the nearest 100 and output 1900 to F29. This should then be compared to an external value, which is 1850, and the MIN should choose the external value. However, as you can see in the calculator (which is pulled out from the code right before result return) the value in F29 is 1800. However if you re-calculate the spreadsheet I attached you’ll see the value change to the correct output.
Wondering if this is a known issue with MIN or MROUND, or if I’m missing something obvious. Version is 1.19.3 with .NET Framework (unsure of the PROD .NET version but my local is 4.5).
AT-2.zip (321.9 KB)