Dojo example.
After the initial value change the filter menu no longer shows the current value of the modified cell.
The filter menu should always show the current values of the cells.
Values that are copied from Spreadsheet are duplicated when pasted in Excel if before that the copied cells have been cut and pasted inside the Spreadsheet.
In Excel, the first row is duplicated and the pasted content contains 3 rows, while 2 rows are copied
The pasted in Excel content should contain 2 rows instead of 3
cell connection in Spreadsheet is not working when the sheet contains 1.0 in the name
download the file from ticket - 1500102
open our demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
open the file from the ticket in the Kendo Spreadsheet
cell F17 is not connected with cell B12 from the second sheet
cell F17 is connected with cell B12 from the second sheet
note: if the name of the sheet is changed to something different than 1.00 for example 'A' the cells are connected
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,
When multiple cells are merged in the Spreadsheet the DatePicker is not always rendered at the correct position.
The DatePicker is not always entirely visible (screencast)
DatePicker should be visible
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
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Select Column B11, click wrap text from Home toolbar.
3. Start typing in B11 & see cell editor keeps growing and goes beyond screen.
4. This is not user friendly, it should be same as Excel
5. Any alternative or quick fix would be appreciable
There is no TypeScript definition for defineFunction and no custom functions can be created in TypeScript context using the approach demonstrated in this Custom functions article.
Try defining a new function using:
kendo.spreadsheet.defineFunction("Mask",mask).args(maskArgs)
The following error appears:
Propery "defineFunction" does not exist on type 'typeof spreadsheet'
There shouldn't be any errors
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
Hi,
I encountered a bug when using the spreadsheet control with a remote datasource which I was able to replicate using the datasource binding demo (https://demos.telerik.com/kendo-ui/spreadsheet/datasource).
When entering data on an empty cell in an empty row not adjacent to a non-empty row (e.g. a row that is two rows below the end of the data); then editing a cell in the same row, but adjacent column, this creates two items in the corresponding datasource.
Editing an empty row above this new row will modify one of the records created in this process.
Dear Kendo,
I made research about Kendo Spreadsheet control and I found some of unlogical things in example:
1. When I made changes (kendoSpreadsheetCancelChanges.png) in spreadsheet and click on CANCEL CHANGES button, all of these changes aren't removed.
2. Manually reading spreadsheet datasource, all of these changes aren't removed. For example, when I type in console
$("#spreadsheet").data("kendoSpreadsheet").options.sheets[0].dataSource.read();, datasource is reading, but almost all changes are shown. Why?
Kind Regards,
Marin
The spreadsheet widget has no Polish localization.
Feel free to use those: https://github.com/telerik/kendo-ui-core/pull/5310
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
When using IE 11 and using Ctrl+X to cut, this only works the first time. All subsequent attempts to use cut produce the following dialog:
Error occurred in browser console after select cell with value, pressing cut scissors button on top and press undo shortcut key combination (Ctrl+Z at windows or Cmd+Z at macos)
File:
3f0465a2-412c-4876-ba47-4b12ae46f92e_adam.zip
https://demos.telerik.com/kendo-ui/spreadsheet/index
Errors are encountered. Even if resolving the errors bold styles are not applied as they are part of the font definition and not of the inlineStyles.
The excel is imported as expected.
The current client-side export functionality does not preserve the number of columns.
Load the following file in the Spreadsheet which contains columns up to "BA".
Export the file
Load the file again in the Spreadsheet and notice that the columns are displayed up to "AX" instead of "BA".
Client-side export does not preserve the number of columns greater than "AX".
Client-side export does not preserve the exact number of columns.
Hi Kendo Team,
The exported excel file from spreadsheet can not be opened in Microsoft excel when the spreadsheet has both a comment and a image.
You can reproduce the issue at your demo site https://demos.telerik.com/kendo-ui/spreadsheet/index
First add a comment for cell D3, then add a image, then export as xlsx.
Try open the export excel file, and you will see the error popup says "we found a problem with some content in workbook.xlsx ......"
It works when exporting comment and image separately.
Bug report
Spreadsheet SUMIF function returns #NA when Excel returns the correct result. The issue is observed when the criteria range and sum range have different sizes.
Reproduction of the problem
Run the Spreadsheet demo page
Open the attached file
Formula in cell B3 returns #NA!
Current behavior
The formula in cell B3 returns #NA!
Expected/desired behavior
The formula in cell B3 should return the correct value
Environment
Kendo UI version: 2019.3.1023
Browser: [all]