In the spreadsheet when referencing other cells, only non-empty cell values are carried over
1. Click into a cell (i.e. A20)
2. Enter a value ( abc ); hit return or tab to another cell
3. Click back into the cell ( A20)
4. In that cell, enter a reference to another cell that is empty ( = A19 ); hit return or tab to another cell
5. The value is not replaced with the 'empty' value from the referenced cell; the original value ( abc ) remains
6. Enter a value in the referenced cell ( enter xyz into A19) - the cell that has the reference ( A20 ) changes its value correctly to the referenced value (xyz from A19)
7. Go back to the referenced cell ( A19 ), delete the value; the cell that has the reference ( A20 ) does not change, it still displays the 'old' value ( xyz )
Essentially, if a referenced cell has a null value, the null value is not carried to the cell reference. We were able to recreate on the demo spreadsheet ( http://demos.telerik.com/kendo-ui/spreadsheet/index ).
Thank you