Ability to set a cell with font Strikethrough
I checked out the feature request provisions on your site. Since I'd like to include photos with my description, I'm hoping that it is okay that I send this to you for forwarding on to the appropriate audience. My feature request involves the spreadsheet control in Kendo's JQuery controls The request is for an attribute to be added to a cell of a spreadsheet which can be used by JQuery to associate the HTML dom element with the spreadsheet's javascript model. Here is why: In needing to place things in the cells of spreadsheets (such as images and my own custom controls) as can be seen in my images 1 and 2, it is necessary to know which div.k-spreadsheet-cell corresponds with a kendo javascript spreadsheet cell. As a work around, I have given my custom controls an index number. In the kendo javascript object, I set the cell's background color to the same value as that index. This gave me two benefits: 1) it put a characteristic on the cell's div object that could identify the cell; 2) it rendered the cell even if it had no content--this is particularly important. In my image 4, you can see the background color attribute of a cell div. In image 3, you can see my collection of custom controls. Each of my div.custom-control has a control_index property. I have a routine that runs periodically to reckon the location and size of each control whose background color is set to a value matching one of my cell's control indices. Once located, the controls are laid down onto their respective cells at their appropriate size (or made invisible if the target cell is scrolled off of the container). This work around contains a lot of painful overhead. For instance, when a spreadsheet is first rendered, I have to traverse the div.k-spreadsheet-cell elements to check their background color attributes. If they qualify, a css class must be placed on the cell so that a black cell isn't presented in the time that it takes to reckon and position my custom controls. If there were a 'tag' attribute that could be added to a cell's javascript model and that tag was ascribed to the div.k-spreadsheet-cell element (AND make the element render even if it is otherwise trivial), this operation would be a lot easier. I think that I'm not the only one who would like to take some control over the dom objects of the spreadsheet control. I would be happy to discuss this further with anybody who is interested. Thanks, Doug
Currently, after export to excel and opening the exported file again in Spreadsheet, the row heights for rows with predefined height change. The above could be easily observed on the Index demo:
* initially, the height of the top row is set to 70px;
* export the Spreadsheet to Excel;
* after re-importing the above file, the height of the first row "Invoice #52" becomes 81px without any apparent reason.
1. Open "Sample Kendo UI SpreadSheet Example.html" attached html file in the chrome browser.
2. Click on open button in the Toolbar of the spreadsheet.
3. Select "Sample Excel with Font Colors.xlsx" attached excel file. This excel file contains headers with background color and Rows with ForeColors.
4. Now when the file is loaded, you will observe that B2, B3 and B5 should come up in Red fore color but the fore color of these cell in the kendo spread sheet is Black.
5. Similarly C2 to C5 should come in Green color but the fore color in the spreadsheet is black.
Query: Kindly let me know how can we achieve the fore color present in the excel sheet show show up in the Kendo UI Spreadsheet?
Hi,
When editing a workbook with the Spreadsheet component, if a user switches from a worksheet to another, then moves the scrollbars, when switching back, although the active cell is adequately recovered, the scrollbars are not (the user experience is that they do not react to worksheet switching).
Is this behavior planned to be changed? Is there a workaround?
Best
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Open attached MultipleSheetsRowHeightIssue.xlsx
3. Please notice there are 3 sheets with default row height 20, 30, 40 respectively (you can check in MS Excel)
4. Now Click export, and open the exported file again
5. Now we have an issue here - all sheets set to default row height to 40. (It seems that it is setting the last sheet's default row height to all sheets)
Its severe issue, please share a fix or at least provide some workaround.
When a string, used as old_text for SUBSTITUTE(text, old_text, new_text, [instance_num]) function, is repeated more than once and the new_text is an empty string, one occurrence of the old_text remains not substituted.
ab113abababab11ab
in A1=SUBSTITUTE(A1, "ab", "")
NOTE: substituting ab
with another string, e.g. cd
, replaces all instances of ab
as expected.
113ab11
- when ab is repeated more than once in a row, one of its instances remains unchanged to an empty string
11311
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!
Hi Team,
I would like to request the Kendo UI Spreadsheet to have CSP support.
Thank you for the consideration!
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.
Hi Support Team,
When select multiple cells continuously and right click, it will have more options. But when select multiple cells without continuously and right click, there is only 1 option
Would like to have a feature to have more options when select multiple cells without continuously and right click and also to able to detect which cells are selected if multiple cells are selected without continuously.
Select multiple cells continuously: Select multiple cells without continuously:
When trying to import an Excel document into the Kendo UI Spreadsheet with a missing/corrupt image reference, the file will not show.
The Kendo UI Spreadsheet fails to load the document.
The Kendo UI Spreadsheet should handle the error and load the Spreadsheet data without the image.
When the reference to a cell in a specific Sheet is added in the defineName function, using the name leads to invalid result.
The returned result is '#NAME?'
The returned result should depend on the referenced cell value. In the example above B2 have a value 5, thus the value in the selected cell should be also 5.
The issue also appears when importing an Excel file with defined names in the Spreadsheet. The names in the attached Excel file are created as in the image below:
Hi Support Team,
Would like to have a feature below:
After the 2022 R2 SP1 version. there is a bug in the spreadsheet data source. when dill down the cell, the data source will not be changed. only input text can trigger the change event.
Reproduction steps:
Expected:
Button is enabled
Actual:
Button not enabled
Bug report
YEAR, MONTH and DATE functions do not return the same value on a black cell as in MS Excel
Reproduction of the problem
Apply the Year, Month or Date functions on any blank cell, it returns #VALUE!, where as Excel returns the respective value.
Environment
Kendo UI version: [all]
Browser: [all]