I am looking at possibility to convert Spreadsheet tables to html . I am creating an HTML report with header and footer and would like to merge the spreadsheet table as html between header and footer.
Is there a way to convert the spread content to html tables
I am facing one issue in kendo spreadsheet onchange event.
Suppose I have applied formula on one cell A1 and formula is =SUM(B1:B3)
Now one change of values in B1 to B3 on change event gets fired but whenever cell A1 values gets updated i.e. on entering value in B1 to B2, on change event doesn’t get fired.
How can I make onchange event fire for formula cell.
We are looking to see whether all the cells in the formula are filled or not for that we need all the cells information in the formula.
Is there any way to get list of cells present in formula cell.
When we want to add a formula in a given cell in the Spreadsheet, we double-click it and enter the "=" in it as an identifier that a formula definition will follow. If we want to include in the formula a cell that is not inside the visible range of the Spreadsheet, we scroll to that cell and select it. In Internet Explorer, if we scroll to a given cell using the arrows of the Spreadsheet's scrollbar the "double-clicked" cell becomes just a selected one and the "=" sign is converted to a string value.
When building a formula in a given cell and trying to navigate to a cell using the scrollbar, this usage stops the formula building and converts the "=" into a string.
When a user creates a formula for a given cell, they should be able to navigate through the Spreadsheet using its scrollbars.
we have a hard time controlling the cells "Enable" attribute in a data binding scenario, because it really depends on the data, e.g. the complete Row must be read only (Enable = false) when Cell "Completed" is marked with true.
I mark this as "Feature request" because I think there is no such functionality, but I'd need some dynamic expression here, you could reuse the validation expressions, e.g.:
enable: "NOT(ISERROR(FIND(\"true\", B3)))"
As an alternative/workaround, maybe we can reuse validation / reject, so instead of making the cell non-editable, leave it editable but reject any kind of change, this is just a thought and I feel like there is no easy way to do it like this either.
You might wonder how we apply validation or enabled/disabled cells in data binding scenario; We basically run post processes after data binding, so because I think there is no other way doing it.