Approved
Last Updated: 29 Apr 2019 06:13 by ADMIN
Created by: Vamsi Krishna
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
Currently, the cells which are disabled are not protected in the exported XLSX document and can be modified by the users. Implement functionality to protect the data when exporting.
Approved
Last Updated: 26 Jun 2019 13:51 by ADMIN
Created by: Anamika
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Hello,

 

I am looking at possibility to convert Spreadsheet tables to html . I am creating an HTML report with header and footer and would like to merge the spreadsheet table as html between header and footer.

 

Is there a way to convert the spread content to html tables

 

Thanks

 

Anamika 

Pending Review
Last Updated: 27 Aug 2019 06:24 by ADMIN
Created by: Rakesh
Comments: 2
Category: Spreadsheet
Type: Feature Request
0

Hi There,

I am facing one issue in kendo spreadsheet onchange event.

Suppose I have applied formula on one cell A1 and formula is =SUM(B1:B3)

Now one change of values in B1 to B3 on change event gets fired but whenever cell A1 values gets updated i.e. on entering value in B1 to B2, on change event doesn’t get fired.

How can I make onchange event fire for formula cell.

 

Thank you,

Rakesh

Approved
Last Updated: 30 Aug 2019 11:12 by ADMIN
Created by: Vamsi Krishna
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

We are looking to see whether all the cells in the formula are filled or not  for that we need all the cells information in the formula. 

 

Is there any way to get list of cells present in formula cell.

Approved
Last Updated: 16 Sep 2019 15:30 by ADMIN

Bug report

When we want to add a formula in a given cell in the Spreadsheet, we double-click it and enter the "=" in it as an identifier that a formula definition will follow. If we want to include in the formula a cell that is not inside the visible range of the Spreadsheet, we scroll to that cell and select it. In Internet Explorer, if we scroll to a given cell using the arrows of the Spreadsheet's scrollbar the "double-clicked" cell becomes just a selected one and the "=" sign is converted to a string value.

Reproduction of the problem

  1. Open this Dojo example in Internet Explorer 11
  2. Select the A1 cell and enter "=" in it.
  3. Press the "down" direction arrow of the Spreadsheet trying to reach cell A50.
  4. With the first click on the arrow, the A1 cell is no more "double-clicked" and the "=" inside it is converted to a string

Current behavior

When building a formula in a given cell and trying to navigate to a cell using the scrollbar, this usage stops the formula building and converts the "=" into a string.

Expected/desired behavior

When a user creates a formula for a given cell, they should be able to navigate through the Spreadsheet using its scrollbars.

Environment

  • Kendo UI version: 2019.2.619
  • jQuery version: x.y
  • Browser: IE 11.950.17134.0
Approved
Last Updated: 12 Feb 2019 14:50 by ADMIN

Hello,

we have a hard time controlling the cells "Enable" attribute in a data binding scenario, because it really depends on the data, e.g. the complete Row must be read only (Enable = false) when Cell "Completed" is marked with true.

I mark this as "Feature request" because I think there is no such functionality, but I'd need some dynamic expression here, you could reuse the validation expressions, e.g.:

enable: "NOT(ISERROR(FIND(\"true\", B3)))"

 

As an alternative/workaround, maybe we can reuse validation / reject, so instead of making the cell non-editable, leave it editable but reject any kind of change, this is just a thought and I feel like there is no easy way to do it like this either.

 

You might wonder how we apply validation or enabled/disabled cells in data binding scenario; We basically run post processes after data binding, so because I think there is no other way doing it.

Best regards