Hi,

There are multiple formats for date and time in kendo and in different cultures the count increases. Is there a function in which i pass spreadsheet cell value and format and it returns that it is a date format or number format. I just want to know the type of format so i can parse the dates on my own from json on server side.

Regards,
Faraz

Bug report

When you enter a value with leading zeros and then use the drag handle at the bottom right corner to change the value of the cells below, the leading zeros are being removed.

Reproduction of the problem

1. Go to the Basic Usage example - https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Enter "SS0012" as value in a random cell.
3. Grab the handle at the bottom right of the cell and drag down.

Current behavior

The value entered for the cells below is SS13, SS14 etc.

Expected/desired behavior

The value entered for the cells should be SS0012, SS0013 etc.

Environment

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

In my application I am using the following. 

kendo.ns="kendo-";

Dojo example: https://dojo.telerik.com/@iankodj/aKIyEwUv 

The spreadsheet component works well with the namespace, however any dialogs that the component opens do not function correctly.

For example, I am using Edge browser. If I copy a cell and they try and past the value via the context menu, a dialog appears telling me to use the keyboard.

The "ok" button of the dialog does not work. Looking at the html source that is added to the DOM, it appears that the button is trying to bind to the click event via a "data-bind" attribute rather than a "data-kendo-bind" attribute as specified via the namespace.

The attached file show the behavior with the Basic demo example having the kendo namespace set.

Thanks,

Darin

Bug report

In Spreadsheet, the cell format is lost when you change its value.

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/@martin.tabakov@progress.com/EWUdUDUp/2
2. Change the value of cell C3 to 5.5678

Current behavior

The new value is not rounded as per the preset format.

Expected/desired behavior

The new value should respect the format set for the cell.

Environment

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

Hi Team,

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

Thank you!

When an Excel file with 'Set precision as displayed' option enabled is imported in the Spreadsheet the calculations are not the same as in the Excel file.

Reproduction:

1. Open the Spreadsheet demo

2. Import the excel file from the zip. in the Excel file the following option is enabled - File->Options->Advanced->When Calculating this workbook-> Set precision as displayed

The value in Excel in C1 column is 399.96, while the value displayed in the Spreadsheet is 400.00

I would like to have support in Spreadsheet for Excel files with 'Set precision as displayed' option enabled.

Hi, I'm using the spreadsheet control and i'm having an issue with date columns.

When I enter a valid date, it works fine.

but when I enter an empty date (clicking delete on date column, or emptying out the contents)

the date gets stored as "new Date(0,0,-1)" ["Sat Dec 30 1899 00:00:00 GMT+1130 (New Zealand Daylight Time)" in my local time]

obviously, this is incorrect, and it should store the value as NULL.

it happens regardless of whether the schema/model has nullable=true.

If I manually modify the dataItem via JS, it stores it correctly as null. 

I have a dojo demo set up which replicates the issue.

https://dojo.telerik.com/oFowivUN

Steps:

1. select the ItemDate column of the first row in the spreadsheet
2. type in a valid date (e.g. 1/1/2020)
3. Click View ItemDate button (It should show the correct date)
   
4. Select the ItemDate column and empty it out (e.g. click delete)
5. Click View ItemDate button. (it should now show the incorrect date!)

Doing some investigation into the kendo code, it seems to be caused by the serialToDate method of the spreadsheet.

Thanks

Currently, in Kendo Spreadsheet multiple rows/columns can not be selected by using Shift + click. For example, in Excel, if the user clicks on the first column header, then press 'Shift' key and click on the fifth column header all five columns will be selected. The same is valid for row selection.

I would like to have the possibility for multiple rows/columns selection by using the Shift key +click In Kendo UI for jQuery Spreadsheet.

When values in the sheet are updated using the batch method the DataSource does not update according to changes.

Dojo: https://dojo.telerik.com/@iankodj/IRUdufOx

1. Run the example

2. Check the console showing "no data" and an empty array.

Expected: https://dojo.telerik.com/@iankodj/EKoziCic 

When there is formatting and decimals are rounded negative numbers that round to zero show a negative sign. In Excel those are shown without the negative sign. 

Dojo example: https://dojo.telerik.com/@iankodj/azEMIRUv/21

Hello,

the spreadsheet component triggers no change event if the width of a column changes. Is it possible to track a change of the width of a column?

Can be reproduced with your event demo of the spreadsheet component (https://demos.telerik.com/kendo-ui/spreadsheet/events)

Hi there,

When a spreadsheet is linked to a datasource, if you leave a gap between previously entered rows and your new data, each cell edit creates a new item in the datasource with only the cell modified.

Here is the record after adding one cell.

and after adding another cell:

This is the state of the spreadsheet:

I managed to replicate this in dojo here: https://dojo.telerik.com/eRiHocar

Bug report

When you copy a formatted cell with value "0", pasting the content in the Spreadsheet results in an incorrect value in the formula input.

Reproduction of the problem

1. Open the attached file in the Spreadsheet.
   CopyPaste-CellFormatIssue.xlsx
2. Open the attached file in Excel.
3. Copy the content from C3 to C5 and paste it in the Spreadsheet.

Current behavior

The value of the cells containing "-" are incorrectly changed to "-" in the formula bar.

Expected/desired behavior

The value of the cells containing "-" should remain "0" in the formula bar.

Environment

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

Hi admin,

I have a problem when I do with the Spreadsheet.

Bug only appear on mobile deice that run iOS operation system. You need prepare a device as iPhone or iPad

** Prerequisite step.

1. Your device must install Japanese keyboard percussion. You can refer to this below link 

https://www.youtube.com/watch?v=2_ImIkZ5Kis&ab_channel=TaraNico

2. You visit to

https://demos.telerik.com/kendo-ui/spreadsheet/index   by your device

** Step to reproduce this bug

Because having may steps to reproduce this bug, I records a video. Please check video attached.

** 

When you switch to Japanese keyboard percussion,  you select a cell and enter a formula excel on  'fx' input

Ex: =sum

** Phenomenon: 

You enter "="  and then continue entering 'u' character. But cells lose focus and can't enter any character.

You must click again on 'fx' input, it focus again. But only enter a character. And then continue losing focus

Please confirm and help me this problem

Bug report

When the Sheetsbar is hidden the horizontal scrollbar is not adjusted to the bottom of the widget

Reproduction of the problem

1. Run this dojo
2. Note the space below the horizontal scrollbar:
   

Expected/desired behavior

The horizontal scrollbar should be adjusted to the bottom of the widget.

As a possible workaround, when hiding the Sheetsbar add the following styling:

<style>
    .k-spreadsheet-sheets-bar {
      padding: 0;
      border-style: none;
    }
</style>

Environment

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

The spreadsheet currently relies on the <v> tag and doesn't accept cell type "inlineStr". Here is an article with more info regarding the inlineStr type:

https://c-rex.net/projects/samples/ooxml/e1/Part4/OOXML_P4_DOCX_c_topic_ID0E1XM4.html 

A cell of type "inlineStr" which is currently not accepted in SpredSheet

<c r="F2" s="4" t="inlineStr">
        <is>
          <t>1005131528</t>
        </is>
      </c>

while the format saved from excel is accepted:

<c r="F2" s="2" t="s">
        <v>12</v>
      </c>

Ticket ID: 1517963

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