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

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

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.

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.

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?

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.

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

Workaround(Approved by Admin):

<script>
    // Place/load this script after the ScriptManager
    if (Telerik.Web.UI.RadSpreadsheet) {
        Telerik.Web.UI.RadSpreadsheet.prototype.original_initialize = Telerik.Web.UI.RadSpreadsheet.prototype.initialize;
        Telerik.Web.UI.RadSpreadsheet.prototype.initialize = function () {
            this.original_initialize();
            this.add_parentShown(this.get_element());
        }
        Telerik.Web.UI.RadSpreadsheet.prototype.repaint = function () {
            this.get_kendoWidget().refresh()
        }
    }
</script>

Reproduction: 

<telerik:RadWizard runat="server" ID="RadWizard1">
    <WizardSteps>
        <telerik:RadWizardStep ID="WizardStep1" StepType="Start">
            Step 1
        </telerik:RadWizardStep>
        <telerik:RadWizardStep ID="WizardStep3">
            <telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1"></telerik:RadSpreadsheet>
        </telerik:RadWizardStep>
        <telerik:RadWizardStep ID="WizardStep4" StepType="Finish">
            Finish step
        </telerik:RadWizardStep>
        <telerik:RadWizardStep ID="WizardStep5" StepType="Complete">
            Completed!
        </telerik:RadWizardStep>
    </WizardSteps>
</telerik:RadWizard>

Repro: 

<telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1" />
<telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet2" />

protected void Page_Load(object sender, EventArgs e)
{
    var workbook = new Workbook();
    var sheet1 = workbook.AddSheet();

    AddDateRow(sheet1);

    sheet1.Columns = new List<Column>() { new Column() { Index = 1, Width = 150 } };

    RadSpreadsheet1.Sheets.Add(sheet1);
    RadSpreadsheet2.Sheets.Add(sheet1);

    RadSpreadsheet1.ColumnsCount = 5;
    RadSpreadsheet1.RowsCount = 10;
}

private void AddDateRow(Worksheet sheet1)
{
    var row = new Row() { Index = 0 };
    Cell firstCell = new Cell() { Index = 0, Value = "Select Date:", Bold = true };
    row.AddCell(firstCell);

    Cell secondCell = new Cell() { Index = 1, Value = "", Bold = true, Background = "#fef0cd", Format = "mmmm d, yyyy" };

    secondCell.Validation = new Validation()
    {
        AllowNulls = true,
        DataType = "date",
        ShowButton = true,
        ComparerType = "between",
        From = "DATEVALUE(\"1/1/2000\")",
        To = "DATEVALUE(\"12/31/2020\")",
        Type = "reject",
        TitleTemplate = "Invalid date selected",
        MessageTemplate = "Select a date between year 2000 and 2020."
    };

    row.AddCell(secondCell);
    sheet1.AddRow(row);
}