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: 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: 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
Completed
Last Updated: 30 Nov 2017 10:16 by ADMIN
ADMIN
Created by: Peter Milchev
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
Expected: https://www.screencast.com/t/bvkiEnFk7uhc (as in the Kendo Spreadsheet http://demos.telerik.com/kendo-ui/spreadsheet/index)

Actual: https://www.screencast.com/t/6Vu2f1bR3Oy0 (the tooltip is not visible) https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/overview/defaultcs.aspx

Workaround: 
Add the styles for the tooltip from the Kendo Spreadsheet

html body .RadSpreadsheet .k-tooltip {               

    border-radius: 4px;
    background-image: none, linear-gradient(rgba(255, 255, 255, 0.6) 0px, rgba(255, 255, 255, 0) 100%);
    background-color: rgb(234, 232, 232);
    color: rgb(49, 49, 49);
    box-shadow: rgba(0, 0, 0, 0.3) 0px 4px 6px;
    background-position: 50% 50%;
    border-color: transparent;
    z-index: 12000;
    min-width: 20px;
    text-align: center;
    border-style: solid;
    border-width: 0px;
    padding: 5px 5px 5px 6px;
    background-repeat: repeat-x;
}
Unplanned
Last Updated: 23 Aug 2017 11:57 by ADMIN
related to https://github.com/telerik/kendo-ui-core/issues/3519
workaround for rounding function is using Custom Functions http://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/custom-functions

kendo.spreadsheet.defineFunction("ROUND", function (x) {
    return Math.round(x);
}).args([
    ["x", "number"]
]);

Cell cell = new Cell() { Index = 0, Formula = "=ROUND(1.2)", Bold = true, Background = "#fef0cd", Format = "$0" };
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
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);


Completed
Last Updated: 21 Apr 2017 14:10 by ADMIN
Unplanned
Last Updated: 27 May 2021 08:36 by ADMIN
The SpreadProcessing library gets into account the current server culture and the SpreadsheetDocumentProvider uses different decimal and list separators based on the culture while the RadSpreadsheet control supports only comma as a list separator and dot as a decimal separator. 

The JavaScript error that is thrown when using the "sv-SE" culture is caused by the fact that this culture uses the comma as a decimal separator and semicolon as a list separator. 

One possible workaround is to change the current thread's culture before creating the Spreadsheet's provider and then restore the culture.
Completed
Last Updated: 27 May 2021 15:32 by ADMIN
Created by: Matt
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
The spreadsheet adjusts the width based on how many toolbar items are available.  The width property doesn't help. It would be nice to have the spreadsheet list of tools to collapse if a width is specified that is smaller than the toolbar row at the top.  I don't always want the spreadsheet to be the same width as the tools that are available.
Completed
Last Updated: 24 Jun 2022 13:09 by ADMIN
Unplanned
Last Updated: 09 Nov 2016 14:09 by ADMIN
ADMIN
Created by: Veselin Tsvetanov
Comments: 0
Category: Spreadsheet
Type: Feature Request
0

			
Unplanned
Last Updated: 08 Jan 2021 09:54 by ADMIN
Created by: Matt
Comments: 2
Category: Spreadsheet
Type: Feature Request
1
In support ticket #1058916 I was told I need to use an overriding pageLoad function to focus on the top of my page if I have a Spreadsheet control at the bottom of my page to prevent it from scrolling down to the spreadsheet when somebody navigates to the page.  Was the Spreadsheet control designed to be the only element on the page?  By forcing focus to be in cell A1 on pageLoad, it scrolls to the spreadsheet immediately and bypasses anything I might have above it.

I would rather see a property on the spreadsheet control to focus on A1 on pageLoad that is defaulted to False rather than having to add a script.  When I first navigate to any page without anchor tags in the URL, I expect to see the top of the page, not something that scrolls down to the spreadsheet and ignores anything above it!
Completed
Last Updated: 19 Sep 2016 14:16 by ADMIN
Completed
Last Updated: 06 Jan 2021 09:54 by ADMIN
Created by: Brad
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
It would be helpful if there was a way to print a spreadsheet via the code behind.   As it stands someone must open up a screen with the embedded spreadsheet and export it to PDF, then print from the PDF.  

What we would like is the ability to print the spreadsheet without having to export to PDF first and ideally without even having to show it on screen. The way we are using it you can attach a spreadsheet to any record and there many be one or more attached, plus the user may print more than one parent record at a time. When someone prints the parent records we want to print all of the attached spreadsheets at the same time without the user having to open each one up in their browser first as this can be time consuming when dealing with large amounts of data.

Thank you
Unplanned
Last Updated: 14 Jun 2016 14:39 by Daniel
Allow to set the filename for the radspeadsheet control when a client API SaveAs is performed e.g. MyRadSpreadsheetControl.saveAsExcel("myfilename.xlsx");
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!