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;
}
Modified date value from Excel is not correctly updated when pasting in the Spreadsheet.
Regression introduced with 2023 R1
The updated date cell is not pasted in the Spreadsheet
The updated cell's value should be pasted in the Spreadsheet
When the background tool is displayed in the overflow menu of the toolbar and the user tries to change the background color or text color an error: e[this._property] is not a function
is thrown.
An error e[this._property] is not a function
is thrown and the background color is not changed.
There should be no error in the console and the color should be changed accordingly.
Set an indicator same way that grid already does but now in sheet cells when a record is 'dirty'.
Bug report
SpreadSheet does not apply borderBottom correctly for last row
Reproduction of the problem
Dojo - https://dojo.telerik.com/UGABAnoR
Current behavior
Border is applied at the first row for the next column
Expected/desired behavior
The border shall be applied at the bottom at A2000
Environment
Kendo UI version: [all]
Browser: [all ]
When values are pasted in the Spreadsheet if the cell is not empty the previous format is taken into account
The number column is formatted as date - screencast(https://somup.com/cZeoodChyH)
The current format should be applied to the pasted data.
Bug report
The computed range when pasting data into the spreadsheet is incorrect.
Reproduction of the problem
Dojo: https://dojo.telerik.com/eToXOQOL/9
1. Open a Notepad, and create the following structure:
a
b[tab]c[tab]d
e[tab]f[tab]g
Between each element on rows 2 and 3, there is a [tab] character. This will make sure that the data pasted into Spreadsheet will land on different columns.
2. Copy the entire content of the Notepad document and paste it in cell A1. After the paste operation, you will notice under the Spreadsheet component an output with the range that was passed to the change event.
Problem:
The computed range is A1:A3 while the expected value is A1:C3
Expected behaviour
The expected value is A1:C3
Environment
Kendo UI version: 2021.1.224 or newer
Browser: [all]
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
Bug report
Round Function from empty cell shows #VALUE! but in Excel, this shows 0
Reproduction of the problem
Open Dojo: https://dojo.telerik.com/aBOMoCOF
Paste in cell B1 the following formula: =ROUND(A1, 2)
The shown result is #VALUE!
In Excel the same formula returns 0
Expected/desired behavior
The shown value must be 0
Environment
Kendo UI version: [all]
Browser: [all ]
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
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 .
In a Spreadsheet with date cell editor, the fr-CA culture does not work.
The Calendar is empty
The Calendar should display the dates defined in the validation
After pasting values from the Kendo UI Spreadsheet to Excel, making a change in Excel, and pasting the value back to a Kendo UI Spreadsheet, it pastes old information.
The new values are not pasted back to the Kendo UI Spreadsheet.
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.
When an Excel File that contains VLOOKUP and calculated columns is imported in Excel, this results to CIRCULAR value for the cells, although ther are no circular formulas in the file.
The values in the Spreadsheet are imported as '#CIRCULAR' although there are no circular formulas.
When the VLOOKUP in cell L2 is deleted the values are imported as '#VALUE'
The values in the Excel file should be imported correctly.
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?