Hi,
We are currently using our own calculations by using JavaScript and Kendo Grid. Since it is written by us with a lot of validations, it hurts the performance and creates bugs. I found Kendo has Spreadsheet control and I like to give it a try, I have already found some answers but I still have a lot of questions which I cannot find. I wonder if you can help me with those answers.
1. Can we move worksheet bar to the top?
2. Can we set a default worksheet to open up with?
2. Can we lock all features but only open "add row" to the user?
3. Can we add a drop-down list to one column of cells?
4. can it handle different date/time format based on the user culture?
5. can we lock columns so users cannot modify those columns?
6. can we pre-define the formula and users cannot change it?
7. can we change the column header name instead of "A" "B" "C" ...
thanks a lot!
1 Answer, 1 is accepted
I'd like to clarify that it's unlikely that we'll ever be able to make the Spreadsheet look like a Grid.
The closest we can get to your scenario is the DataSource binding demo.
Regarding the specific features in question:
1. Can we move worksheet bar to the top?
No, but that can be done via the activeSheet method.
2. Can we set a default worksheet to open up with?
Yes, via the activeSheet configuration.
2. Can we lock all features but only open "add row" to the user?
Not right now, but we're ready to consider configuration for specific features.
3. Can we add a drop-down list to one column of cells?
Not at the moment. Please vote for this feature.
4. can it handle different date/time format based on the user culture?
No, but it's something that we'd like to have in the future. Please vote for that if you have a minute.
5. can we lock columns so users cannot modify those columns?
Something that we'd like to have in the future. Please vote for that as well.
6. can we pre-define the formula and users cannot change it?
Is that supposed to be only the formula? Locking the entire cell is something we're ready to consider.
7. can we change the column header name instead of "A" "B" "C" ...
No, not right now. Please vote for that as well.
I hope that helps.
Regards,
T. Tsonev
Telerik