I've been reading through the documentation, and I wanted to reach out in case I am missing something. In all the Kendo Spreadsheet documentation that is available, I've not seen an MVVM example provided. Is the MVVM method available with use for the Spreadsheet widget? I was also wondering if just syntactically I might not have the right items configured in order for the data to populate in the spreadsheet. I can confirm at the viewmodel that my data is populated in that object, but I just can't seem to get the data to appear in the spreadsheet. Any guidance or additional documentation would be most helpful.
I am setting the data-role="spreadsheet", mimicking other examples of mvvm that I've seen. I've also set the data-bind to my dataSource (data-bind="source:spreadsheetDataSource" while also populating a dataSource object within my data-sheets property. I wanted to verify that these are in fact supported before I continue down this road. I would also like to understand which properties are required by default (data-columns, data-rows, data-sheets) etc...and the properties that exist within the arrays (such as data-sheets), since that also doesn't seem to be present in the documentation.
I'd also like to point out that I am using a windows server 2016, since that option was not listed in the fields below for the ticket. The .NET Framework is 4.5.2
I appreciate all assistance in this matter.
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.
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.