2. Import attached Book21.xlsx file
3. I have first row as frozen pane and columns C, D are hidden
4. Select columns B to E using mouse drag & then right click on selected column , it does not show Unhide option, because on right click it keeps the selection only on column E
It does not work if we keep Freeze Panes.
2. Copy from F3:F15
3. Paste as value (ctrl+shift+v) in H3
4. See it pasted only non-empty cells
Empty cells values should be pasted as well as Excel does.
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!
The formula in cell B3 returns #NA!
The formula in cell B3 should return the correct value
Kendo UI version: 2019.3.1023
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.
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.
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.
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)
Uncaught TypeError: Cannot read property 'row' of undefined
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:
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.
=SUBSTITUTE(A1, "ab", "")
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
I am using kendo spreadsheet binding to a datasource... very similar to the demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource
Is there a way to add a two row header while binding to a data source? For example, my first row would be a merged cell spanning all columns and would contain some text. I can see how to do two row headers and to merge cells.. but it doesn't work when the spreadsheet is bound to a datasource as it starts the data in row 2.... where I want row 2 to be my actual field name headers. I don't see any options to fix that.
If there is no way to do that... is there a way to alter my header style? For example, I want a column header to be
MY FIELD NAME HERE
additional text (smaller font and color)
I know in kendo grid there is headerTemplate... but this doesn't seem to be available in kendo spreadsheet.
2. Click Background or Text Color icon , select custom color
3. See the popup UI , there is boarder and margin issues, boarder is visible on top,left & bottom side but not on right side
When a cell/row is selected, its first cell is focused and the sheet is scrolled to show it. If a long sheet is scrolled down/right to edit cells, this scroll top/left is very annoying and user unfriendly.
In these scenarios Excel focuses the topmost/leftmost currently visible cell, avoiding sheet scrolling.
NOTE: for rows reproduction select cell AX2, then click on the header of row 2 - sheet is scrolled to the left and cell A2 is focused.
Column C is selected, cell C1 is focused and the sheet is scrolled to top.
The used has to scroll down to the bottom row again to edit data at the bottom of the sheet.
Column C is selected. The currently visible topmost cell of column C is focused, without scrolling the sheet. Excel works that way
The current context menu lets you hide a row or column, but then you cannot show it again, so the user can lose data. At present there is no context menu option to unhide it and there is no element indicating the column/row was there in the first place. This should behave like in Excel.
When typing a formula and selecting another cell in Excel we can press F2 to be able to change the formula manually, however when using the spreadsheet when trying to change the formula with the arrow left or right button we select another cell.
In MS Excel when you type a number you can easily go to other cells by using the arrow keys and type in another number, thus allowing for fast editing of the spreadsheet. This does not work in the spreadsheet component. this functionality only needs to work when not creating a formula.
I know that Kendo Spreadsheet works like most popular Spreadsheets (Excel and Google Spreadsheet) where, if you copy or drag and paste values from cells, you will copy also the styles, validations, etc from that cell to the new one (unless you select "paste values only" in a context menu or ctrl + shift + v). It would be awesome if we can set how this works by configuring a property in the Spreadsheet configuration, something like pasteValuesOnly: false/true or even more complex with an object where you can choose if paste values, validations, formulas, styles or whatever. Also you could attach this functionalities to a context menu (as Google Spreadsheet does) and be able to paste everything, values only, format only, formulas or data validation.
Client-side exported Excel workbooks are exported "uncompressed" (as readable text) and their size is much greater than the original document.
Regression since R2 2019 - 2019.2.514