Hello,
I have some problems with setting up correct Cell Validation for my use-case. I want to create a list validation which is going to have a numeric options instead of typical string values.
So in order to achieve that I created a following cell validation:
{
dataType: "list",
showButton: true,
comparerType: "list",
from: '{1,2,3,4,5}',
allowNulls: true,
type: "reject"
}
Everything works fine in the widget, but the problems starts when I want to Export the following spreadsheet to Excel format. I'm getting the following message when trying to open such file:
In the past I had a similar problem with the list validation (but for string values) (https://www.telerik.com/account/support-tickets/view-ticket/1381434)
There you suggested to create a validation using different format for "from" property. So I decided to change it from:
from: '{1,2,3,4,5}',
to
from: '"1,2,3,4,5"',
After that I can freely export the spreadsheet without any problems, but then my list is inserting string values instead of numeric ones, therefore this solution is not suitable for my use-case.
And my question is: Is there a possibility to create a Cell validation where I can put numeric values as a possible options without breaking the export process?
Here's a example spreadsheet, which I used to reproduce this behavior: https://dojo.telerik.com/IfuMIbic
Best regards,
Excel file is corrupted when it is created with the kendo.ooxml.Workbook toDataURL method, using stringified sheet data:
let dataURL = new kendo.ooxml.Workbook(JSON.stringify(data)).toDataURL();
If the data is passed to the Workbook without stringifying it, this causes a circular reference error (check the console).
let dataURL = new kendo.ooxml.Workbook(data).toDataURL();
Dojo example.
The generated Excel file is corrupted
The generated Excel file is not corrupted
Working with numbers like 0.000001056 in a Spreadsheet that is bound to a dataSource, after saving the dataSource, the mentioned number will be converted to an exponential format.
The current feature request is about preventing the format changing after saving decimal numbers.
It will be very useful if we can use the Spreadsheet with dataSource binding but keep the decimal numbers as such, not converting them to exponential expressions.
In the Spreadsheet control for jQuery it is possible to set cells as read-only through the use of the Enable property.
However, on calling saveAsExcel() these cells are editable. This means as a developer it is then necessary to create both the spreadsheet JSON (for Kendo Spreadsheet) as well as another spreadsheet class to export to Excel.
Could you please map the Cell.Enable property to the setting of Excel cells as disabled/read-only. Thanks 👍
Use the Events demo to reproduce, since the events are logged in the console: https://demos.telerik.com/kendo-ui/spreadsheet/events
The Invoice sheet is selected but the selectSheet event does not fire.
The selectSheet event fires
Memory usage is increased if the DevTools is open. Navigation between sheets is also slower.
Memory usage increased and slower sheet change.
Memory usage should not be increased and sheet navigation should not be slow.
When I use this formula
=HYPERLINK("mailto:"&B4&"?subject=“& B5 & “&body=“ & B6,", "test")
in the excel, I am able to click on the link which opens up my mail client with compose new email window and also populates To, Subject and Body of the email from cells B4, B5, B6 respectively.
But currently, HYPERLINK formula does not support "mailto:" functionality in Kendo UI spreadsheet. I would love to see this with kendo UI spreadsheet.
For more details you can see the discussion on the forums here.
The AND
formula, when used as part of an array formula, does not evaluate the whole array.
{=AND(A1:D1="")}
would return TRUE if a value is entered in the range B1:D1 and FALSE only if value is entered in A1
=IF(AND(A1="",B1="",C1="",D1=""),TRUE,FALSE)
would return FALSE if value is entered in any cell in range A1:D1
Ctrl
+Shift
+Enter
to enter as an array formulaArray formula should be evaluated correctly and return FALSE when a value is entered in any cell in range A1:D1.
When using a custom cell editor in the Spreadsheet along with keyboard navigation value selection is not limited to the cell with the custom cell editor
The selected value is applied to cell other then the one using the custom cell editor
The selected value should be applied only to the cell with the custom cell editor
Reproducible in this demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource
The data cleared by the "undo" shortcut is saved and sent to the server
A different behavior is exhibited if the data is pasted over the row header instead of the row's first cell. Follow the same steps, but on step 3. instead of pasting over the first cell, paste the data over the row 79 header. After undo and then clicking "Save", the fields have null values.
No data is sent with the request
Need:
Extract only the values for all Spreadsheet cells. These extracted values can be sent back to server (with minimum size) as server only needs data on each sheet. On other information required like references, formulas, images, colors etc.
Possible Approach:
On click of save or a separate button, which will generate a low size data file (having sheet name, cell index and value), which we can send to server.
It will save network traffic and also no complex parsing needed at server side to fetch data.
Dear Concerned,
1. open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. select row header of row 10, go to Insert tab
3. click insert row below, it inserts row successfully after row 10, it adjust formulas of row 12, and other rows there after which is good.
4. But issue is - it neither keep format of row 10 in new row & nor it add formulas to various columns in new row(e.g. F11, E11)
Please suggest how can we achieve it, it is very common and useful feature which excel have. if you do not have any ready solution then please suggest workaround for the same as it is urgent for my client.
Hi,
I want to highlight spreadsheet on cell hover. But I just want to highlight row and column until cell. Is there any way to do this ?
In example, When my mouse on cell E11.
Best Regards,
Kaan
In Excel it is possible to select several rows and increase/decrease all selected rows height. In the Spreadsheet this works only for the last selected row. The following steps demonstrate the behavior:
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Click on the header of row 6, hold and drag until rows 6, 7, 8, 9 , 10 are selected.
3. Click the handle below row 10's header and drag to increase the height of the rows. The Spreadsheet increases only the last row's height.
Currently, the sheets in the Spreadsheet component can be reordered. It will be a very useful feature if we can configure the component in a way this reordering can be disabled.
Thus the users won't be able to move the sheets' tabs.
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.
Add support for multiple ranges for the Spreadsheet's SUM function, for example:
=SUM(E5:E6:E9:E10)
The select method of the range in the Spreadsheet component throws an error when we have a selected cell in the visible area of the component and try to select a range that is outside of this visible area.
The bug is replicable both when the range is passed as exact cells or row-column pair:
** This is a regression from the R3 2019 release
The following error appears in the browser's console
If you scroll to the top rows of the Spreadsheet there is a visual selection of the cells that are passed in the range
On "Select range" click the "C4:E6" cell range should be selected and the Spreadsheet should be automatically scrolled to this selection.
Here is a working demo: https://dojo.telerik.com/uRERUxOm