E.g. italian culture uses ";" as parameter separator in formulae. Our client will adopt spreadsheet component on a global basis and users need to be able to e.g. copy/paste from excel to spreadsheet component using their culture
Currently if I set column border width large, it has multiple problems: 1. it will overlay on columns next to it; 2. when copy the cell with thick border and paste somewhere else, the thick border get copied as well; 3. when select cell with thick border, the border will block part of editor;
In the scpreadsheet you can use controls like dropdowns & datepicker , but should be helpful if user could to customize the design and behavior. For example, the dropdown and any other control needs be opened since an icon at right that is displayed over the next column, As user i would like to choose how i want to be displayed the control: Open clicking on it, set expand direction, styles, etc.
Allowing custom editors to be inline would be very helpful. In particular, inline editors using other Kendo controls (e.g. masked textbox, numeric textbox) should be possible.
We have clients with large spreadsheets that print out across multiple pages, which can mean losing track of which column refers to what on new pages after a page break, so they want to be able to assign a row of column headers to be printed on new pages above each column to keep track
It should be possible to define cell types (or types that are valid for the entire column) like: - Booleans (which will result in showing check boxes inside the cells)
Presently in Spreadsheet tooltip is not working for filter applied range so tooltip should display for each cell in which the range of filter is applied
The Excel file downloaded from Spreadsheet does not maintain leading spaces. In other words, the internal sharedString.xml should use <t xml:space="preserve"> when necessary.