Unplanned
Last Updated: 18 Jun 2020 16:30 by ADMIN
ADMIN
Created by: Peter Milchev
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Currently, the RadSpreadsheet supports only Dollar as currency. 

As a temporary workaround, the Kendo UI Spreadsheet (https://demos.telerik.com/kendo-ui/spreadsheet/index) can be used as demonstrated in this Dojo example: https://dojo.telerik.com/imAWasuJ

- Select a cell with number as value 
- Open the formats dropdown 
- Choose the "More Formats..." option 
- Select "Currency" tab
- Choose a currency from the dropdown
- Choose the desired format.
Completed
Last Updated: 11 Jun 2020 16:18 by ADMIN
Completed
Last Updated: 06 May 2020 15:13 by ADMIN
Release R2 2020

Workaround: Placing the following script under the ScriptManager

<script>
        kendo.spreadsheet.registerEditor('_validation_list', function () {
            var context, list;
            function create() {
                var $list = $("[id$='SpreadsheetListBoxDropDown']").first();
                var element = $list.closest(".rssPopup");

                list = $find($list.attr("id"));
                if (!this._listdropdown) {
                    var dropdown = new kendo.spreadsheet.DropDown(element);
                    this._listdropdown = dropdown;

                    list.add_selectedIndexChanged(function (sender, args) {
                        dropdown.close();
                        var item = list.get_selectedItem();
                        if (item) {
                            context.callback(item.get_value());
                        }
                    });
                }

                this._listdropdown.openFor(context.view.element.find('.k-spreadsheet-editor-button'));
            }
            function open() {
                create();
                var matrix = context.validation.from.value;
                if (matrix) {

                    var items = list.get_items();
                    items.clear();
                    matrix.each(function (el) {
                        var item = new Telerik.Web.UI.RadListBoxItem();
                        item.set_text(el);
                        items.add(item);
                    });
                }
            }
            return {
                edit: function (options) {
                    context = options;
                    open();
                },
                icon: 'p-icon p-i-arrow-60-down'
            };
        });
    </script>

 

Need More Info
Last Updated: 02 May 2020 15:53 by Doug
Created by: Emanuele
Comments: 5
Category: Spreadsheet
Type: Feature Request
1

I think it might be very useful to add to cell comments a html code and be able to do it programmatically.

Thank you

Unplanned
Last Updated: 27 Apr 2020 10:42 by ADMIN
Created by: Jerry
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

The RadSpreadsheet server-side object does not support Named Ranges. 

Workaround:

Nevertheless, you can load them client-side with the code below, by saving a JSON in a hidden field and loading it via the API:

protected void Page_Init(object sender, EventArgs e)
{
    var path = Server.MapPath("~/App_Data/spreadsheet.xlsx");
    var workbook = Workbook.Load(path);
    HiddenField1.Value = workbook.ToJson();
}

<script>    
    function pageLoadHandler() {
        var spreadsheet = $find("<%= RadSpreadsheet1.ClientID %>");
        var hiddenfield = $get("<%= HiddenField1.ClientID %>");
        if (hiddenfield.value) {
            spreadsheet.get_kendoWidget().fromJSON(JSON.parse(hiddenfield.value))
            hiddenfield.value = '';
        }

        // Sys.Application.remove_load(pageLoadHandler);  
    }
    Sys.Application.add_load(pageLoadHandler);
</script>
<telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1"></telerik:RadSpreadsheet>
<asp:HiddenField runat="server" ID="HiddenField1" />

 

Unplanned
Last Updated: 24 Apr 2020 10:02 by ADMIN
There are no issues when the user makes changes to the imported Blank XLSX document.
Unplanned
Last Updated: 23 Mar 2020 16:53 by ADMIN
It would be very handy if we could set the active sheet of the spreadsheet programmatically, either from the client-side or server-side. We'd like to be able to load a spreadsheet and select a certain tab as the initial active sheet without the user having to click on it or having to have that tab be the first in the list. Thank you!
Completed
Last Updated: 19 Feb 2020 12:56 by ADMIN
Release R1 2020 SP1
Created by: MikeK
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Please provide the ability to add Tooltips to specific cells.
Unplanned
Last Updated: 03 Jan 2020 17:11 by ADMIN
Created by: Steve
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
Currently the formatting feature (Bold, Italic and Underline) applies to entire cell content. 

It will be nice to have a partial cell content formatting feature (including subscript and superscript), means only few characters within the cell can be formatted instead of entire cell content (same as in Excel).  

Thanks
Under Review
Last Updated: 11 Nov 2019 10:34 by ADMIN
Scheduled for 2018.R1

In Internet Explorer version 11.418.18362.0, when hovering over the lower-right dot the cursor doesn't change to the expected cross-hair. 

 

To Reproduce:

1. Open IE11

2. Navigate to the ASP.NET Spreadsheet Demo

3. Highlight a few cells

4. Hover the cursor over the lower-right dot

Expected Behavior:

The cursor changes to a thin cross-hair icon but it doesn't change in IE 11.

Completed
Last Updated: 02 Oct 2019 15:01 by ADMIN
Cells in Spreadsheet are automatically underlined on second save or when the file is loaded dynamically.

Code to reproduce:
        string filePath = Server.MapPath("Test.xlsx");
        Telerik.Web.Spreadsheet.Workbook wkb = Telerik.Web.Spreadsheet.Workbook.Load(filePath);
        wkb.Save(filePath);


Unplanned
Last Updated: 24 Sep 2019 13:08 by Issa

Bug report

Reported in ticket № 1429260

Reproduction of the problem

  1. Create a date in a cell in Excel, e.g. 9/9/2019 with format type as "Date";
  2. Shrink the column so that the date is displayed as hash tags ####;
  3. Select the cell and copy it
  4. Paste it in any Kendo UI Spreadsheet cell

Current behavior

The date is pasted as string with value of hash tags.

Expected/desired behavior

The date is pasted as a date

Notes

The e.ClipboardContent.data contains the hash tag string as value, so the issue should be somewhere in the clipboard pasting logic

Completed
Last Updated: 03 Sep 2019 16:06 by ADMIN
Release R3 2019
ADMIN
Created by: Marin Bratanov
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
The current context menu lets you hide a row or column, but then you cannot show it again, so the user can lose data. At present there is no context menu option to unhide it and there is no element indicating the column/row was there in the first place. This should behave like in Excel.

Such a feature must be implemented first in the underlying Kendo Spreadsheet widget, and to this end I encourage you to cast your votes for its implementation here: http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/suggestions/19240072-context-menu-option-to-unhide-row-column
Declined
Last Updated: 06 Aug 2019 09:13 by ADMIN
Created by: JF
Comments: 2
Category: Spreadsheet
Type: Bug Report
0
I have two lines that was set to a certain height,

Each time I save the sheet, those two lines expand by 8 pixels.

Does anyone are reading those bug reports?
Completed
Last Updated: 14 Jun 2019 12:34 by ADMIN
Created by: Marco Piumi
Comments: 2
Category: Spreadsheet
Type: Feature Request
1
Can this control open, edit and save Excel File from Code.
Open a File from code and not in Page_Init event.
Completed
Last Updated: 18 Apr 2019 07:43 by ADMIN
If you put a radspreadsheet inside a radtabstrip with multipage, the controls do not render properly.

In my scenario, I have a tabstrip embedded within a tabstrip, and a grid in the nested tabstrip.  That works fine.  Once you put a spreadsheet control in the multipage, the controls do not render properly. 

However, I was able to reproduce the results with the first scenario above, which is the most simple.
Unplanned
Last Updated: 17 Apr 2019 14:23 by ADMIN
Created by: JF
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
When I load the radspreadsheet from an excel file, the foreground color is not loaded.

A workaround is to use the Kendo Spreadsheet widget directly which imports fore color: https://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export

Repro steps 
    go to https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/import-export/defaultcs.aspx
    add some text with specific fore color
    save the excel file
    import the excel file

Expected: there is no change

Actual: the fore color is not imported. Also, font size changes, but see the related item for that
Unplanned
Last Updated: 17 Apr 2019 14:21 by ADMIN
ADMIN
Created by: Marin Bratanov
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
The default font size on the client is not saved explicitly on the Excel file, so the Excel defaults take over (11px Calibri), so upon subsequent import all cells will have that font.

Steps to repro:

    go to https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/import-export/defaultcs.aspx
    export the file
    import the file

Expected: nothing changes

Actual: all cells are 11px Calibri
Completed
Last Updated: 17 Apr 2019 08:29 by ADMIN
Created by: JF
Comments: 3
Category: Spreadsheet
Type: Bug Report
0
The lines shifts badly after line 10 

You think you are on line 17  but the cursor is on line 16.  Very annoying bug for those using this control.  Please fix and give us an update.

Look the attached file.
Unplanned
Last Updated: 26 Dec 2017 12:14 by ADMIN
A workaround is using directly the Kendo Spreadsheet widget as this will allow you to use its latest version that does not manifest this issue: https://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export

Repro steps

    Go to https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/import-export/defaultcs.aspx
    Go to an empty cell
    type some text
    change its font size (e.g., to 18)
    save the file
    import the file you just saved

Expected: nothing changes

Actual: (some) cells change their height and font size, not just the cell that was edited above
1 2 3