Completed
Last Updated: 27 Sep 2018 13:19 by Dimitar
To reproduce:
- Add a spreadsheet and add ribbon bar from the smart tag. 
- Start the application.

Workaround:
protected override void OnShown(EventArgs e)
{
    base.OnShown(e);
    var parameter = 11;
    this.radSpreadsheet1.SpreadsheetElement.CommandDescriptors.SetFontSize.Command.Execute(parameter);

    FontFamilyInfo parameter1 = new FontFamilyInfo(new System.Windows.Media.FontFamily("Calibri"));
    this.radSpreadsheet1.SpreadsheetElement.CommandDescriptors.SetFontFamily.Command.Execute(parameter1);
}
Completed
Last Updated: 17 Aug 2018 10:10 by Dimitar
ADMIN
Created by: Dess | Tech Support Engineer, Sr.
Comments: 0
Category: Spreadsheet
Type: Bug Report
1
To reproduce: please refer to the attached gif file demonstrating how to replicate the problem with the Demo application. Scroll with the mouse wheel and you will notice the the row index disappears until you click a cell. Using the thumb will behave as expected. 

Workaround:
this.radSpreadsheet1.SpreadsheetElement.VerticalScrollBar.ValueChanged+=VerticalScrollBar_ValueChanged;
        private void VerticalScrollBar_ValueChanged(object sender, EventArgs e)
        {
            this.radSpreadsheet1.SpreadsheetElement.InvalidateMeasure(true);
        }
Unplanned
Last Updated: 06 Jul 2018 08:21 by ADMIN
ADMIN
Created by: Dess | Tech Support Engineer, Sr.
Comments: 0
Category: Spreadsheet
Type: Feature Request
2

			
Completed
Last Updated: 21 Jun 2018 14:39 by ADMIN
ADMIN
Created by: Dimitar
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
Set the Print Area as described here: https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/worksheetpagesetup
Completed
Last Updated: 21 Jun 2018 14:42 by ADMIN
RadSpreadsheet must support printing using RadPrintDocument. 
Completed
Last Updated: 18 Apr 2018 08:26 by Dimitar
Ideally we should expose the events in the RadPrintDocument object.

Workaround handling the PrintPreview method:
private void button1_Click(object sender, EventArgs e)
{
    RadPrintDocument printDocument = new RadPrintDocument();
    IPrintable printManager = typeof(RadSpreadsheetElement).GetProperty("PrintManager", BindingFlags.Instance | BindingFlags.NonPublic).GetValue(this.radSpreadsheet1.SpreadsheetElement) as IPrintable;
    printDocument.AssociatedObject = printManager;

    printDocument.BeginPrint += PrintDocument_BeginPrint;
    printDocument.PrintPage += PrintDocument_PrintPage;
    printDocument.EndPrint += PrintDocument_EndPrint;
    printDocument.QueryPageSettings += PrintDocument_QueryPageSettings;
    SpreadsheetPrintPreviewDialog printPreviewDialog = new SpreadsheetPrintPreviewDialog(printDocument);
    printPreviewDialog.ThemeName = this.radSpreadsheet1.ThemeName;
    printPreviewDialog.ShowDialog();
}

private void PrintDocument_QueryPageSettings(object sender, System.Drawing.Printing.QueryPageSettingsEventArgs e)
{
    
}

private void PrintDocument_EndPrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
    
}

private void PrintDocument_BeginPrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
    
}

private void PrintDocument_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
}

Completed
Last Updated: 11 Jun 2018 12:35 by Dimitar
Workaround: create a custom input behavior class and manually handle the navigation when holding the Shift key
public partial class SpreadsheetForm : Telerik.WinControls.UI.RadForm
{
    public SpreadsheetForm()
    {
        InitializeComponent();

        FieldInfo behaviorFi = typeof(RadSpreadsheetElement).GetField("inputHandler", BindingFlags.Instance | BindingFlags.NonPublic);
        behaviorFi.SetValue(this.radSpreadsheet1.SpreadsheetElement, new CustomSpreadsheetInputBehavior(this.radSpreadsheet1.SpreadsheetElement));
    }
}

public class CustomSpreadsheetInputBehavior : SpreadsheetInputBehavior
{
    public CustomSpreadsheetInputBehavior(RadSpreadsheetElement element)
    : base(element) { }

    public override void ProcessKeyDown(KeyEventArgs e)
    {
        base.ProcessKeyDown(e);

        if (e.Shift)
        {
            switch (e.KeyCode)
            {
                case Keys.Left:
                    this.Spreadsheet.ActiveWorksheetEditor.Commands.UpdateActiveSelectionRangeCommand.Execute(MovementType.MoveToPreviousColumn);
                    break;
                case Keys.Up:
                    this.Spreadsheet.ActiveWorksheetEditor.Commands.UpdateActiveSelectionRangeCommand.Execute(MovementType.MoveToPreviousRow);
                    break;
                case Keys.Right:
                    this.Spreadsheet.ActiveWorksheetEditor.Commands.UpdateActiveSelectionRangeCommand.Execute(MovementType.MoveToNextColumn);
                    break;
                case Keys.Down:
                    this.Spreadsheet.ActiveWorksheetEditor.Commands.UpdateActiveSelectionRangeCommand.Execute(MovementType.MoveToNextRow);
                    break;
            }
        }
    }
}
Completed
Last Updated: 21 Jun 2018 14:39 by ADMIN
This is possible in WPF
Unplanned
Last Updated: 21 Jun 2018 14:10 by ADMIN
Unplanned
Last Updated: 16 Mar 2018 11:14 by ADMIN
Unplanned
Last Updated: 06 Mar 2018 15:02 by ADMIN
Workaround: Handle the MouseWheel event of the control

private void RadSpreadsheet1_MouseWheel(object sender, MouseEventArgs e)
{
    int offset = this.radSpreadsheet1.SpreadsheetElement.VerticalScrollBar.SmallChange * 3;
    int x = e.Delta < 0 ? offset : -offset;
    this.radSpreadsheet1.SpreadsheetElement.VerticalScrollBar.ClampValue = true;
    this.radSpreadsheet1.SpreadsheetElement.VerticalScrollBar.Value += x;

    RadWorksheetEditor editor = this.radSpreadsheet1.SpreadsheetElement.ActiveSheetEditor as RadWorksheetEditor;
    if (editor != null)
    {
        IRadWorksheetEditorPresenter presenter = (IRadWorksheetEditorPresenter)editor.GetType().GetField("activePresenter", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).GetValue(editor);
        presenter.SetVerticalOffset(presenter.VerticalOffset + x);
        editor.InvalidateMeasure(true);
    }
}
Declined
Last Updated: 29 May 2018 11:49 by ADMIN
The control can be resized in the designer.  The resize operation starts with a slight delay and it is necessary to wait for this initial delay. From then on the control can be freely resized. The attached gif file illustrates this.

Workaround:
1. Set the size using the property grid
2. Add a panel and dock the control to fill the panel, then resize the panel
Completed
Last Updated: 12 Feb 2018 10:57 by Dimitar
ADMIN
Created by: Hristo
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
How to reproduce: check the attached project and the remaining memory after disposing the forms.
Completed
Last Updated: 07 Mar 2019 23:39 by ADMIN
ADMIN
Created by: Dimitar
Comments: 0
Category: Spreadsheet
Type: Bug Report
1
To reproduce:
- Open the first look example. 
- Choose Save from the backstage button.
- Currently, the default is PDF, It should be xlsx.
Unplanned
Last Updated: 20 Nov 2017 12:03 by ADMIN
Unplanned
Last Updated: 13 Nov 2017 16:08 by ADMIN
ADMIN
Created by: Hristo
Comments: 0
Category: Spreadsheet
Type: Feature Request
2

			
1 2