Declined
Last Updated: 27 Feb 2020 16:07 by ADMIN
Created by: David
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
Right now, a List based validation is strict on case, it'd be nice to have a toggle for when it is appropriate.
Declined
Last Updated: 27 Feb 2020 16:06 by ADMIN
Created by: Robert
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
Add menu item that allows end users to style background and text color based on rules (if cell value > 0 then green)
Declined
Last Updated: 27 Feb 2020 16:05 by ADMIN
Created by: Ganesan
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
Add a watermark in each worksheet.
Declined
Last Updated: 27 Feb 2020 16:04 by ADMIN
Declined
Last Updated: 27 Feb 2020 16:01 by ADMIN
Created by: JackP
Comments: 2
Category: Spreadsheet
Type: Feature Request
2
I know it seems like a small thing, but I work with complex spreadsheets, and supporting coloured sheet tabs would really help 
Love this control.
Declined
Last Updated: 26 Feb 2020 15:53 by ADMIN
Hi Progress - just some quick feedback: 1. Telerik Control Panel updates - it feels like a lot of the time, when the TCP needs updating the user has to manually uninstall the old version and the install the new one using the .exe installer. If the TCP could automatically handle this process, that would be appreciated. 2. The various Telerik Spread Processing libraries (and other document processing libraries) can only be installed as an included component of the Telerik "UI for X" library installations. It would be great if there was an option in the TCP to do a standalone installation of just the Spread Processing libraries. Thanks and kind regards, - Lawrence
Declined
Last Updated: 26 Feb 2020 15:15 by ADMIN
Created by: Paul
Comments: 3
Category: Spreadsheet
Type: Bug Report
0

Bug in js\spreadsheet\numformat.js makeDateFormat

 

You appear to be using the wrong indices inside a nested loop.

if (/^(?:date|time|ampm)$/.test(section.body[i].type)) {

Should be (switch i to j)

if (/^(?:date|time|ampm)$/.test(section.body[j].type)) {

Getting error

Uncaught TypeError: Cannot read property 'type' of undefined
     at Object.<anonymous> (numformat.js:630)

 

Note: Version is actually 2018.3.1114 from npm

Declined
Last Updated: 26 Feb 2020 15:03 by ADMIN
We are using the Kendo UI spreadsheet in a real-world website. We have a design team who are providing a visual design which fits in with our company's corporate standards.

HTML5 aims at separating styling from the layout design, which enables different teams to build the syle, with very little development experience, but more artistic experience.

For some reason, the Spreadsheet control can only be styled via the API (javascript code)! This means our design team needs to write their style in javascript, which is completely unrealistic.

It should be a fairly simple change to allow a range object to have a CSS class associated, and let HTML work like it should.
Declined
Last Updated: 26 Feb 2020 14:54 by ADMIN
Created by: Victor
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
I need the way to get a user the opportunity to set the columns headers. Moreover, the columns headers should be saved separately from the main spreadsheet data.

Of course, the possible variant is to have two spreadsheets: the one – for the data, the second (with one row) – for the headers.

But the better way is to get a user the opportunity to set the spreadsheet columns headers.
It would be ideally if a user could change “A”, “B”, “C” for “ID”, “Product”, “Quantity” …
Not to have a first row for headers, but change the spreadsheet columns headers!
Moreover, we have the context menu on the columns headers and it is possible to add one more item “Edit” in it.
Declined
Last Updated: 26 Feb 2020 14:46 by ADMIN
Created by: Otto Neff
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
Declined
Last Updated: 26 Feb 2020 14:35 by ADMIN
Created by: David
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
The spreadsheet doesn't provide any configuration options for the font size unit; it is always in pixels. I need to be able to specify other CSS units, such as points or ems.
Declined
Last Updated: 26 Feb 2020 14:16 by ADMIN
Please see Demo https://dojo.telerik.com/UNOPUvaB/2

In first data row (Row 3) I create a range of numeric values from a , middle and maximum value.
Validation works perfectly, e.g. when manipulating the Middle value, I cannot go below minimum cell value and not above maximum cell value, until adjusted.

I want to accomplish the same with dates in second data row (Row 4 when I reference another "C4", it looks like validation works as expected, but the Date Picker is broken.
Declined
Last Updated: 26 Feb 2020 14:05 by ADMIN
This will help doing data entry in column for scenarios like entering tax details for different years in columns and also user can keep on entering new year info in rew-row right most column.
Declined
Last Updated: 26 Feb 2020 14:03 by ADMIN
Created by: Otto Neff
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
Declined
Last Updated: 26 Feb 2020 14:01 by ADMIN
Created by: Imported User
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
It would be great if there is a cell (and column) type that lets you choose from a defined list (manually defined list or based on a cell-range). It should be possible to make multple selections and the output should be put into the cell separated with semi-colons.
Declined
Last Updated: 25 Feb 2020 15:56 by ADMIN
Currently if you access cells range programmatically, you can set background color, text color etc.
It would be good to have the way to set classes or to get the DOM of the range.
Another option would be to get DOM or set a class to individual cells (e.g. via range.forEachCell).
Declined
Last Updated: 25 Feb 2020 15:52 by ADMIN
I have altered the kendo code to add row and column references to the k-spreadsheet-cell dom objects. A sample of this is: 
<div style="color: rgb(81, . . .  class="k-spreadsheet-cell r17c1 row-17 col-1"> . . . .
I have items that I wish to place on top of cells in the spreadsheet.
I can use these classes to identify the dom element corresponding to a spreadsheet cell object. I wish that this thing would let me post images. This is working really well. 
Request: It would be nice if the spreadsheet code to do this out of the box. Further, it would be beneficial to add a 'tag' property to a spreadsheet cell that would be indicated in the cell's dom object. If a cell has a tag, it should be rendered even if it doesn't have non-trivial formatting or a value.
Declined
Last Updated: 25 Feb 2020 15:49 by ADMIN
Created by: auto
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
I use data binding data source for spreadsheet
But when I use it, data auto input begins at row 0
I want to insert 2 row (To Write title)
Declined
Last Updated: 25 Feb 2020 15:33 by ADMIN
Created by: Doug
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
Custom editors are great!  But often when you have a custom editor, you want to restrict data entry to only use that editor, and not free-form typing in the cell.  You can prevent free-form typing in the cell by disabling the cell, but then the custom editor button is no longer available.

Suggestion is to still show custom editor button even if cell is disabled, perhaps with an additional setting; so that you could optionally not show the custom editor if the cell is disabled, since often a disabled cell should prevent any kind of modification.
Declined
Last Updated: 25 Feb 2020 15:28 by ADMIN
Can the Spreadsheet widget be updated to initialize a sheet that is bound to a datasource when the datasource is an empty object?  

Generally, when a sheet is bound to a datasource, it is for the purpose of editing data, creating new rows and updating/deleting existing rows.  If a datasource comes back empty, the sheet isn't initialized.  So there are no column headers, which can be confusing to users when they don't know what data to enter in which columns.  The other thing is that the sheet itself is not fully initialize so that even if we assign column headers programmatically, when users start entering data, the UI becomes unresponsive and generates a javascript error: Uncaught TypeError: Cannot read property 'indexOf' of undefined
    at r.set (kendo.all.js:4586)
    at r.set (kendo.all.js:4760)
    at kendo.all.js:127702
1 2