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 .
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
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. Open Workbook(1).xlsx (attached)
3. Edit B2, D2, F2 with some new values
4. See the results in B4, D4, F4
Calculations are different 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.
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.
When the INDEX formula is used in combination with LINEST the Spreadsheet displays an empty cell. In case such formula is imported from Excel file '#VALUE' is displayed.
behavior when importing:
The content of the formula cell that includes LINEST and INDEX is empty. When clicking on the cell the formula is displayed in the formula bar. When importing the content in some cases the content is '#VALUE'.
The LINEST should work as expected in combination with the INDEX formula.
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)
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
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.
To reproduce
Steps to reproduce the behavior:
step1: Make a cell become wrap text and text something
step2: Export to pdf file:
Expected behavior
Text display same as on safari
Please fix this problem asap!!!.
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.