I have a formula in my spreadsheet:
In Excel this functions as expected, however when I use this in a SoapUI Excel Datasource with 'Evaluate formulas' checked. It often returns 2147483647 (signed int32 max)
Experimenting further I've tried:
which often returns 4294967294 (unsigned int32 max)
I've also noticed that it doesn't like named ranges. I get an error that the named range doesn't exist even though it works fine in Excel.
This doesn't seem like intended behavior. I expect SoapUI to evaluate excel functions the same way that Excel does.
Can anyone confirm that this is an issue?
Windows 10 Pro Build 17134
I didn't experienced bugs with datasource before but you can open a support request ticket and the guys from smartbear will respond asap.
I've opened a support ticket and they're looking into it.