Unplanned
Last Updated: 26 Feb 2020 14:08 by ADMIN
Created by: Dimitar
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Provide support for zooming the Spreadsheet's cells grid similar to the one provided by Excel.
Unplanned
Last Updated: 26 Feb 2020 14:07 by ADMIN

Hello,

We are using Spreadsheet widget in our system and have following questions to meet the demands of our customers:

  1. How can the filters be limited to valid choices by type of column? For example a numeric column does not need Filter By Condition options by date or by text containing values.
  2. On initial drop down of the filter the Filter by Value section opens, since most of our columns are numeric that isn't useful. How could we collapse the filter by value option on initial opening of the filter?

Currently we use spreadsheet filtering configuration according to this example:

            $("#spreadsheet").kendoSpreadsheet({
                sheets: [
                {
                    name: "OrdersLog",
                    mergedCells: [
                        "A1:G1",
                        "A2:F2"
                    ],
                    filter: {
                        ref: "A3:G49",
                        columns:[]
                    },

Can you please provide us with working examples of configuration (or required code adjustments) that will help us to meet the requrements above?

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.
Duplicated
Last Updated: 26 Feb 2020 13:55 by ADMIN
Spreadsheet import currently handles (keeps) rich text formatting of a cell if the entire cell is formatted, such as a colored row or all bold text in cell. However, if the content of the cell is a mix of plain text and formatted text, the formatting gets dropped on import. If it is possible, it would be nice to keep rich text under this condition.
Duplicated
Last Updated: 26 Feb 2020 13:54 by ADMIN
How to add Superscript, Subscript HTML Entities to Kendo Spreadsheet Cell Data
Duplicated
Last Updated: 26 Feb 2020 13:50 by ADMIN
Text formatting examples are bold, underline, italic. if a react wrapped jquery spreadsheet component cell has two words something like 'Hello World' i want only 'world' to be bold which means in the cell it should show as 'Hello World'. Instead of applying these formatting options to cells apply them to the text in the cell. please make this feature applied to the react spreadsheet as well.

API Reference - https://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range/methods/bold
Under Review
Last Updated: 26 Feb 2020 13:45 by ADMIN
Created by: Imported User
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
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.
Under Review
Last Updated: 26 Feb 2020 13:44 by ADMIN
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
Under Review
Last Updated: 26 Feb 2020 13:44 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
It should be possible to define cell types (or types that are valid for the entire column) like:
- Booleans (which will result in showing check boxes inside the cells)
Under Review
Last Updated: 26 Feb 2020 13:43 by ADMIN
Created by: iTai
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
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.
Under Review
Last Updated: 26 Feb 2020 13:43 by ADMIN
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;
Under Review
Last Updated: 26 Feb 2020 13:43 by ADMIN
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
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).
Unplanned
Last Updated: 25 Feb 2020 15:52 by ADMIN
Created by: Imported User
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
It would be nice to have text orientation support (at least vertical) like in MS Office.
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)
Unplanned
Last Updated: 25 Feb 2020 15:47 by ADMIN
Created by: Prasadh
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
IF any custom validation available for spreadsheet cells, then while exporting the sheet, those validation error messages or formats not getting exported. So here it will be helpful if its exports validations too. So user can see error in both UI and Exported file. 
In the below example, user can see the error messages in ui but cant see on the exported file. 
https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/how-to/validation-to-column
Unplanned
Last Updated: 25 Feb 2020 15:46 by ADMIN

Hi,

When editing a workbook with the Spreadsheet component, if a user switches from a worksheet to another, then moves the scrollbars, when switching back, although the active cell is adequately recovered, the scrollbars are not (the user experience is that they do not react to worksheet switching).

Is this behavior planned to be changed? Is there a workaround?

Best