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.

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]

Please allow copy of multiple randomly selected cells in Spreadsheet.

Currently, when a column in the Spreadsheet is filtered and you paste a value in the cells of another column, the pasted value will apply for all rows between the filtered rows as well. That is similar to the Transpose paste option in Excel. Kindly change the default behavior so that the pasted values will apply for the filtered rows only, as in Excel. Additionally, implement an Transpose option that could be enabled/disabled.

It would be nice to have custom attributes for rows and cells so that I can track things behind the scenes such as row identifiers that could be used to update a corresponding rows in a the data base. This id would not be editable by the user. There are many more uses I would like this for and that is just one example.

I would rather not have to create a column in the spreadsheet just for this and then hide it. I find that very clunky.

 

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 

Enable Cut/Copy cell values and can Paste it in mutiple selected values

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)

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

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

With Excel when you use a custom number format of #,##0.00 and you enter (10) into the cell it will be displayed as -10.  With the Spreadsheet control the same example yields (10).  How can we get the same behavior as Excel with the Spreadsheet control?

 

  dojo example: https://dojo.telerik.com/@843335b6-427b-4127-af09-fbe9957bfec6/uGaVAVat

 

Thanks,

Ron

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

 

 

We have clients with large spreadsheets that print out across multiple pages, which can mean losing track of which column refers to what on new pages after a page break, so they want to be able to assign a row of column headers to be printed on new pages above each column to keep track

Hi Team,

I have getting warning message when open down loaded excel file . This warning is coming if we apply conditional formatting in kendo spreadsheet .Please 

check the URL

https://dojo.telerik.com/

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.

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.

E.g. italian culture uses ";" as parameter separator in formulae.
Our client will adopt spreadsheet component on a global basis and users need to be able to e.g. copy/paste from excel to spreadsheet component using their culture

Currently if I set column border width large, it has multiple problems:

1. it will overlay on columns next to it;
2. when copy the cell with thick border and paste somewhere else, the thick border get copied as well;
3. when select cell with thick border, the border will block part of editor;