I am evaluating the CELLS software as an alternative to using Excel because we are going Office 365. I have downloaded the latest demo and worked all night on creating a proof of concept. I’ve been doing regression testing between the Excel (excel9) API version of my code and CELLS .NET version and noticed an error.
The IF statement in CELLS seems to return the transposed cell value.
I’ve traced the flaw to this particular formula in my spreadsheet.
Supposing B12 is 135 and B13 is 106, then Excel returns the value 135, however CELLS returns 106
This basically makes the rest of my spreadsheet invalid.
Can anyone else verify? What are the support options? The source spreadsheet cannot be changed without a whole lot of expense for recertification.