cancel
Showing results for 
Search instead for 
Did you mean: 

Possible Bug: Excel DataSource - Evaluate formulas

Highlighted
Contributor

Possible Bug: Excel DataSource - Evaluate formulas

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

 

2 REPLIES 2
Community Hero

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



If my answer helped please click on the 'Accept as Solution' button.
Highlighted

Thanks Lucian,

 

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

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors