Unplanned
Last Updated: 03 Feb 2020 13:09 by ADMIN
Created by: Telerik Admin
Comments: 0
Category: Spreadsheet
Type: Feature Request
4
The Image and Comments properties should be added to the Cell object in Telerik.Web.Spreadsheet.dll
Unplanned
Last Updated: 29 Apr 2019 06:13 by ADMIN
Created by: Vamsi Krishna
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
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.
Unplanned
Last Updated: 23 Dec 2019 09:36 by ADMIN

Hi,

I have identified a discrepancy in behavior of Telerik Spreadsheet vs Excel in treatment of array formulae (multiplication of arrays)

 

The spreadsheet attached contains two examples on how the difference on how Excel and Kendo spreadsheets handle array formulas is impacting the tool I'm developing.

The first example is a simple multiplication between a one-column range and a two-column range. Since both have the same number of Rows, Excel multiples both columns of Array 2 by the Array 1 and sum them
Kendo instead expects both ranges to have the same dimensions, so the same array formula throws an error when opened on Kendo


The second example is a the sum of a multiplication between two same-sized matrixes, but conditioned to a flag array. If the flag for that row is true, then the multiplication of the elements of that row should be added to the final result. On Excel, it works as expected.
On the other hand, Kendo seems to consider the “Flag” matrix as a 2-column matrix with the second column left blank, so the result is the multiplication of the first column of array 1 by the first column of array two, conditioned by the flag array:

You can check the results uploading the attached spreadsheet to the Demo available online: https://demos.telerik.com/kendo-ui/spreadsheet/index

Please let me know your feedback and when/if we can expect an alignment of Spreadsheet behavior to Excel's

Kind regards
Andrea

Unplanned
Last Updated: 14 Oct 2019 12:15 by ADMIN
Created by: Development
Comments: 1
Category: Spreadsheet
Type: Feature Request
2

Hello,

 I've been reading through the documentation, and I wanted to reach out in case I am missing something.  In all the Kendo Spreadsheet documentation that is available, I've not seen an MVVM example provided.  Is the MVVM method available with use for the Spreadsheet widget?   I was also wondering if just syntactically I might not have the right items configured in order for the data to populate in the spreadsheet.  I can confirm at the viewmodel that my data is populated in that object, but I just can't seem to get the data to appear in the spreadsheet.  Any guidance or additional documentation would be most helpful.

 

I am setting the data-role="spreadsheet", mimicking other examples of mvvm that I've seen.  I've also set the data-bind to my dataSource (data-bind="source:spreadsheetDataSource" while also populating a dataSource object within my data-sheets property.  I wanted to verify that these are in fact supported before I continue down this road.  I would also like to understand which properties are required by default (data-columns, data-rows, data-sheets) etc...and the properties that exist within the arrays (such as data-sheets), since that also doesn't seem to be present in the documentation. 

I'd also like to point out that I am using a windows server 2016, since that option was not listed in the fields below for the ticket.  The .NET Framework is 4.5.2

 

I appreciate all assistance in this matter. 

 

 

Unplanned
Last Updated: 07 Oct 2020 07:44 by ADMIN
The Spreadsheet does not support cell formatting with exponent (scientific) notation.  For example, a cell currently displays a value as 0.0000000177 while the formula bar displays it as 1.77e-8. When working with scientific data the ability to format a cell value using exponent (scientific) notation would be an extremely valuable feature.
Unplanned
Last Updated: 11 Jun 2021 13:11 by ADMIN
Created by: Moishy
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
Create a Telerik.Web.Spreadsheet NuGet package for UI for ASP.NET MVC.
Unplanned
Last Updated: 30 Oct 2020 08:05 by ADMIN
Created by: Rakesh
Comments: 2
Category: Spreadsheet
Type: Feature Request
1

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

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

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.

Unplanned
Last Updated: 06 Nov 2019 11:40 by ADMIN
Created by: Bryan Patrick
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

 

When using the URL feature of the spreadsheet it seems to use "_blank" as the target (opens in a new window).

 

My spreadsheet is in a single page application with some javascript already loaded.

I'd like to have the url be something like "javascript:myfunction('test');" which works well even with an a tag "<a href='javascript...'>"

I do this quite a lot with templates on the Grid control.

Not asking for templates on the spreadsheet, just let us specify the target and/or use local javascript functions in an "a href";

 

Unplanned
Last Updated: 23 Feb 2021 15:45 by ADMIN
Created by: Peter
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
At present, opening csv files directly from the "Open" tool in the Spreadsheet's toolbar is not possible. Only xlsx files are allowed.
Unplanned
Last Updated: 23 May 2022 08:39 by David
Created by: David
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Implement an option to format a range of cells as table using predefined table formats, similar to the Excel's "Format as table" functionality.
Unplanned
Last Updated: 30 Jun 2023 07:01 by star
Currently, the diagonal borders are lost on server importing or exporting a file that has diagonal borders applied to cells.
Unplanned
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

Unplanned
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