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);


Approved
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

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: 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.
Approved
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
Approved
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.
Approved
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
Approved
Last Updated: 19 Dec 2017 14:26 by ADMIN
If you type 15 into the font size combo box and click away, a Javascript error is thrown and the font size of the selected cell does not change. If instead you type 16 and click away, the cell changes correctly. 16 is an option in the drop-down but 15 is not.

Error message:

RadSpreadsheetScripts.js:196 Uncaught TypeError: Cannot read property 'get_text' of null


The font size combo box works correctly in the Kendo spreadsheet demo (both with the current and the 2017.1.124 Kendo version ). You can also press enter to commit your typed font size in the Kendo widget, but not in RadSpreadsheet.

Steps to reproduce:
1. Open https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/overview/defaultcs.aspx
2. Click inside the font -size dropdown
3. Type 15 and click outside the SpreadSheet

Result: A JavaScript error is thrown.
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;
}
Pending Review
Last Updated: 27 Nov 2017 12:10 by JF
Created by: JF
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
Problem with simple excel behavior.

In excel when you type a string longer than the cell, text is not clipped and shows over other cells.  Then, if you fill adjacent cell, text is then clipped.

I've been able to mimic this behaviour using this css:

.RadSpreadsheet .rssPane .k-spreadsheet-cell {
    overflow: visible !important;
  }

But then, If you highlite those cells with background color  the text is again clipped.  The background color wipe the text.

Attached is a small png to show the problem.

Please fix this to work as excel.  Users are complaining non stop.

Thanks.
Approved
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" };
Approved
Last Updated: 22 May 2017 11:15 by ADMIN
http://screencast.com/t/FJjlN3yw

The error message reads
'ContextMenus' could not be initialized. Details: Object reference on set to an instance of an object.
Completed
Last Updated: 21 Apr 2017 14:10 by ADMIN
Pending Review
Last Updated: 05 Jan 2017 11:07 by Bo
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.
Approved
Last Updated: 21 Nov 2016 11:20 by Anton
Completed
Last Updated: 19 Sep 2016 14:16 by ADMIN
Approved
Last Updated: 15 Mar 2016 08:52 by ADMIN
ADMIN
Created by: Ivan Danchev
Comments: 0
Category: Spreadsheet
Type: Bug Report
1