Possible Bug: Excel DataSource - Evaluate formulas

[thePantz]

Hello,

I have a formula in my spreadsheet:

=RANDBETWEEN(0, 9999999999)

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)

Example DataSet:

-2147483647 

-2147483647 

-416343719

-2147483647 

-118279355

Experimenting further I've tried:

=RANDBETWEEN(2147483647, 9999999999)

which often returns 4294967294 (unsigned int32 max)

Example DataSet:

- 3101863848

- 3272373208

- 4294967294 

- 4294967294 

- 4294967294 

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?

ReadyAPI v2.4.0

Excel 2016

Windows 10 Pro Build 17134

[Lucian]

I didn't experienced bugs with datasource before but you can open a support request ticket and the guys from smartbear will respond asap. 

https://support.smartbear.com/message/?prod=ReadyAPI

[thePantz]

Thanks Lucian,

I've opened a support ticket and they're looking into it.