Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Import attached Dummy.xlsx file
3. No data loaded
4. please check
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index in IE 11
2. Start editing cells C3 to C12 and enter value 1234 in each cell as fast as possible
3. 1234 enter, 1234 enter , 1234 enter and so on without waiting for UI rendering completion as UI freezes for few seconds, and then all cells get updated in one go
4. below is the result, few cells are having wrong values
5. Its very serious issue
Note: Excel 365, Excel and GoogleSheet works fine in such cases
Needs:
Load big excel files stored on the server
Possible implementation:
Load on demand data:
First load the file structure (sheets name, column names and number of rows)
Then load data when sheet is selected or scrolled
Need a default cell format, in addition to rowHeight and columnWidth including: - font size, - font-family, - font weight - (see other toolbar options) Default cell format would set the default values for all cells and toolbar options.
Office 365 Comment are shown with a warning:
"[Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
go to demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
import a file from ticket - 1447268
A warning is displayed
No warning is displayed
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Put some text in B2 so that it does not fit in the cell width.
3. Press Wrap Text button
4. Press Wrap Text again
5. The row height is not adjusted back to the original height (Excel does it)
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 .
Reproducible in the demos.
=HYPERLINK("https://google.com")
The link does not work. It does if you specify a "friendly name":
=HYPERLINK("https://google.com", "google")
The link works with and without a "friendly name" specified, as in Excel.
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Open Attached Test.xlsx file
3. Check the value of A2, it is different than Excel
Note: Cell format of A2 is set as below, if I select only $ format then it is working.
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Start editing cells D3 to D11 as fast as possible (like type 45 enter, 45 enter, 45 enter and so on) (refer attached videos)
3. UI freezes for few seconds, and then all cells get updated in one go
4. But Excel 365, Excel and GoogleSheet work fine in such cases
5. Please make similar UI behavior as in Excel.
Check attached Excel Data Entry & Kendo Data Entry video recordings
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Upload the attached sample.xlsx file.
3. Cell B1 getting value from cell A1 using formula "=TEXT(A1, "$#,###")"
4. Delete(Blank) the value of cell A1, see error #VALUE! in cell B1.
5. The same is working fine in Excel.
6. Please suggest any workaround or quick fix.
Check attached Sample.xlsx file in Sample.zip folder
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)
Currently, when the "Custom format" button in the Spreadsheet is clicked, the available predefined formats that can be applied to a cell appear as demonstrated in the below screenshot. These predefined options don't change if you set a specific Kendo UI culture.
It will be a very useful feature to be able to change the predefined custom formats. Also, it will be nice if the custom formats in the Spreadsheet can be set based on the selected Kendo UI culture.
It would be nice to have text orientation support (at least vertical) like in MS Office.
Currently only the global culture is used to parse dates. This behavior differs from Excel as I can enter 1/1/19 to parse to 1/1/2019. I would like the widget to format using the chosen date culture (mm/dd/yyyy), but parse in an optional way, such as mm/dd/yy.
When using the bottom right corner of a cell to batch copy values across a range by dragging the corner, an error popup appears if a disabled cell is found inside the range that was dragged into. It is possible to reproduce this with this demo: https://demos.telerik.com/kendo-ui/spreadsheet/disabled-cells 1. Set the quantity column to disabled. 2. Select B3. 3. Drag the bottom right corner of B3 to D3. 4. See error: "Destination range contains disabled cells." There should be an option to allow that to copy into any enabled cells in that range and ignore the disabled ones.