Bug report
Some date formats are lost when pasting from Excel and parsed as strings
Reproduction of the problem
Excel provided in Ticket ID: 1658266
copy and paste that into any Kendo Spreadsheet component.
Expected/desired behavior
Dates shall be parsed to dates
Environment
Kendo UI version: [all]
Browser: [all]
1. The top tab section (with the Home, Insert, Data, Undo, Redo) button of the toolbar should be configurable to be hidden, i.e. "single toolbar" configuration should be supported. Since it is possible to configure the toolbar to show custom items, it should also be possible to hide other tabs and the undo/redo button and only have a single toolbar as the configuration.
/* Style hack to hide the "Home/Insert/Data" tabstrip at the top of the spreadsheet. */
.k-spreadsheet-tabstrip.k-tabstrip {
& > ul {
display: none;
}
& .k-content {
border-top: 0px;
}
}
/**
* Style hack to hide the undo/redo buttons in the quick-access toolbar.
*/
.k-tabstrip-wrapper .k-spreadsheet-quick-access-toolbar {
display: none;
}
Set an indicator same way that grid already does but now in sheet cells when a record is 'dirty'.
Hi
Is it possible to only move between "open cells for input. " With fx. using tab or enter.
When you are input finance data. It would be nice, that with a tab, it only moves between open cell. Is this possible.
On all browser, but mainly edge, chrome ,
reg. jakob
Currently, there is a KB that demonstrates how only values can be pasted into the Spreadsheet. However, to achieve pasting values the cells are modified programmatically, which leads to an improper undoRedo stack. In the knowledge base article if the user presses 'Undo' then a single cell will be undone.
We can add the editing of the cell using commands as demonstrated below, but this will require the user to undo the changes cell by cell and not the entire range at once:
spread._workbook.execute({ command: "EditCommand", options: { value: value, operatingRange: range, editRange: range}});
I think that it will be a good improvement if the Spreadsheet can be configured or if it provides a method that will allow paste-only values that will be properly added to the undoRedo stack and without additional customizations.
Regards
Once I showed this control to a few people they loved it and are asking me to make a lot of interfaces with it.
All of these are databound.
They want some validation, like dropdown lists, datapicker, etc. And I found you can put controls in cells.
But what do I do with hundreds of rows? In the rows/cells there is validation and editors that can be setup.
For databound sheets, the columns would be a more logical place for validation and editors.
I did find this today, prepping for this request, https://docs.telerik.com/kendo-ui/controls/spreadsheet/custom-editors
But that is not intuitive.
I'd like for the same validation and editors that are available on rows.cells to be available at sheets.columns when the sheets.dataSource is used.
These would be applied to the columns on the data rows created from the datasource.
Structured references in MS Excel:
Example formulas that should work (Table1 is a named reference of a table):
1. =Table1[Column2] is not working in kendo
2. =Table1[#Header] -- Header, Data, All and all other specifiers.
3. =[@ColX] also not working .
Somtimes you just want to give the User a little Side Calc without a full blown Sheet, just the grid with some cells able to change.
Hi Team,
I would like to request the Kendo UI Spreadsheet to include JSZip 3.x functionality for future releases.
Thank you!
The Spreadsheet supports names that are defined within the global worksheet level (Workbook). However, when uploading a file that contains defined names, which scope is the local worksheet level (for example, Sheet1), the names are not available.
For example, upload the attached file in the Spreadsheet in the following online demo.
https://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export
The name defined in the scope of "Sheet1" is not available:
Please improve the Spreadsheet to support names defined in the scope of the sheet?
Hi Team,
I would like to request the functionality to be able support multiple languages for the Excel file. It would be great if there was a way to make the file content automatically change to a specific language.
For example, if we could use a collection of <English key, French strings> of a selected language e.g. French, and all Excel text strings matching with the English key would convert to the French text.
Thank you!
Hi Team,
I would like to request a way to include commas for the sheets.rows.cells.validation.from values.
For example:
Instead of:
Additionally, it would be nice to be able to use another delimiter instead of commas.
Thank you!
If you copy a cell whose text contains multiple spaces from one Spreadsheet and try to paste it in another, the multiple spaces are lost
The pasted content contains only one spaces instead of three, as in the original cell content
All the spaces should be preserved when pasting in another Spreadsheet.
Related to this ticket View Ticket | Your Account (telerik.com) (id: 1605513)
Basically, when all the rows fit in the viewport, the horizontal scrollbar should be entirely hidden instead of always visible.
I have a column of a string type, but I would like to have a validation list such as ['1', '2', '3', '4', '5']. However, even after setting the format to '@' and the schema column to type: "string", after saving the values, the cells are marked as invalid, as the column is of type string and the values in the validation.from the list are numbers. Thus, the validation marks the values as invalid. Here is a Dojo that demonstrates the issue - in the Dojo after selecting a value in column C and saving the changes the value is marked as invalid
I would like the validation.from option to be improved, to have the possibility to set the type of values in the validation.from a list and have digits in a string column to be considered a valid value. Such improvement could be also helpful in scenarios where boolean true/false values should be considered as strings.