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!!!.

Additional functionality for:
-- Conditional Formatting -- coloring of cells, for example based upon a value and then be able to import from excel, and export back out.
-- Data Validation (dropdowns).  Also be able to import and export back out.

It would be great if you would add accessabbility to the spreadsheet as it seems to be the last control without this feature.

Currently the focus gets trapped inside its grid and the user cannot leave the spreadsheet with the TAB key. At least this should be avoided. It would be also better if only the first cell would be focusable and you then could navigate with the arrow keys, as with thousands of cells it is not very comfortable to use the TAB key.

In Excel I can create a merged cell. For this example, I will merge A1:B1 and name the range MyCell.  Next I name the single cell D5, and call it MyAnswer.  I can enter the following formula into MyAnswer, =MyCell and Excel will return the result.

Using Telerik if I create the same layout I get a #Value or #Spill error because Telerik requires MyAnswer to be the same merge configuration as MyCell which creates a significant disadvantage in usability.

Can you please advise when this issue will be fixed in Telerik.

I have attached a screen recording of this not working in your Dojo named "Telerik merge cell reference not working when not same col.mov".

Thank you so much.

Bug report

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.

Reproduction of the problem

1. Open this Dojo project
2. Cut B3:C3
3. Paste the copied content to A1:B1
4. Copy A1:B2
5. Paste to Excel

Current behavior

In Excel, the first row is duplicated and the pasted content contains 3 rows, while 2 rows are copied

Expected/desired behavior

The pasted in Excel content should contain 2 rows instead of 3

Environment

• Kendo UI version: 2020.3.1021
• jQuery version: x.y
• Browser: [all]

Bug report

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();

Reproduction of the problem

Dojo example.

1. Click the "To Json" button above the Spreadsheet.
2. Try to open the generated file in Excel.

Current behavior

The generated Excel file is corrupted

Expected/desired behavior

The generated Excel file is not corrupted

Environment

• Kendo UI version: 2020.2.617
• jQuery version: x.y
• Browser: [all]

Bug report

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.

Reproduction of the problem

1. Go to Spreadsheet Basic usage demo
2. Add a new sheet
3. Type ab113abababab11ab in A1
4. Enter the following formula in B1 =SUBSTITUTE(A1, "ab", "")

NOTE: substituting ab with another string, e.g. cd, replaces all instances of ab as expected.

Current behavior

113ab11 - when ab is repeated more than once in a row, one of its instances remains unchanged to an empty string

Expected/desired behavior

11311

Environment

• Kendo UI version: 2019.2.514
• Browser: all

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.

Currently the font sizes in the Spreadsheet are in pixels, while in Excel they are in points (pt). The values for the fontSize remains the same upon export / import. As a result, fonts in Excel appear lager than those in Spreadsheet.

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?

Ability to hover over a cell and see a tooltip

Allowing custom editors to be inline would be very helpful. In particular, inline editors using other Kendo controls (e.g. masked textbox, numeric textbox) should be possible.

In the scpreadsheet you can use controls like  dropdowns & datepicker , but should be helpful if user could to customize the design and behavior. 

For example, the dropdown and any other control needs be opened since an icon at right that is displayed over the next column, As user i would like to choose how i want to be displayed the control: Open clicking on it, set expand direction, styles, etc.

type =IF( "a"="A" ; 1 ; 0 ) and =IF( EXACT("a";"A") ; 1 ; 0 )
into Kendo Spreadsheet and Google Spreadsheet and MS Excel.
There is a special EXACT function (which is also available in Kendo) to enforce case-sensitivity. By default it should be off.

Hi Team,

I would like to request the Kendo UI Spreadsheet to include JSZip 3.x functionality for future releases. 

Thank you!

The Excel file downloaded from Spreadsheet does not maintain leading spaces.  In other words, the internal sharedString.xml should use <t xml:space="preserve"> when necessary.

Bug report

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

Reproduction of the problem

1. Go to https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Open the following file in Spreadsheet -
   Workbook Original.xlsx - 26 KB
3. Export the file to Excel

Current behavior

The exported file is 1015 KB in size. The content of the file may be read as plain text

Expected/desired behavior

The exported file is 26 KB or similar size. The content of the file is unreadable binary data

Environment

• Kendo UI version: 2019.2.619
• Browser: all

Bug report

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.

Reproduction of the problem

1. Go to https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Scroll to the bottom row of Spreadsheet's sheet.
3. Click in cell B200 to select it.
4. Click on the header of column C to select the whole column.

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.

Current behavior

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.

Expected/desired behavior

Column C is selected. The currently visible topmost cell of column C is focused, without scrolling the sheet. Excel works that way

Environment

• Kendo UI version: 2019.2.619
• Browser: all

Bug report

The current client-side export functionality does not preserve the number of columns.

Reproduction of the problem

• 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".

Current behavior

Client-side export does not preserve the number of columns greater than "AX".

Expected/desired behavior

Client-side export does not preserve the exact number of columns.

Environment

• Kendo UI version: 2019.2.619
• Browser: [all]

Dear Concerned,

1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index

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