Three issues with formulae support

[Sebastian]

Hi again,
after some initial testing, we have found some formulae related issues.

1) first is about "shared" formulae formulae" (ie the ones obtained by dragging one formula over adjacent cells).
I'll attach you two simple xlsx file, both work exactly the same in MS Excel, but one doesn't work fine in Spreadsheet component.

Compare the first section of the two files: the row tagged as "Cumulative" doesn't work in Spreadsheet in the second version, since the "shared" sum formula doesn't work. 

NOTE: the first version is produced with MS Excel, the other with a famous third party commercial XLS library.

2) empty cells are not considered as "0", and give an error when used as parameters in formulae (see second section of any of the attached file, compared to first section) the yellow empty cell gives an error

 

3) SUMPRODUCT doesn't work. It's sufficient to test it on one of your online examples to verify. It throws an error

thanks and regards,
Sebastian

[T. Tsonev]

Hello,

Thanks for reporting these issues.

We'll investigate and get back to you with our assessment and a timeline for potential fixes.

Regards,
T. Tsonev
Telerik

[Mihai]

Hi Sebastian,

We fixed these issues, and the fixes will make it into the next internal build (mid February).  Thanks again for your report.

Regards,
Mihai
Telerik