Declined
Last Updated: 18 Mar 2019 14:33 by ADMIN
If the lookup_value parameter and lookup_vector parameters refer cells containing text values, the function returns a Not available error ("#N/A").
Approved
Last Updated: 18 Mar 2019 11:29 by ADMIN
For some reason the last letters are dropping from headers and data.

New
Last Updated: 14 Mar 2019 09:54 by ADMIN
Created by: Stephen
Comments: 3
Category: Spreadsheet
Type: Feature Request
0

I have loaded an excel file into the spreadsheet control from our document database. When a user makes changes and clicks the save button I would like to handle a save process back to our document database of the file.

If a save function can be raised I can save to the document database

If a SavAs fucntion can be raised I can prompt the user to create a new version

 

Can the control have these two features added please?

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.
Approved
Last Updated: 01 Mar 2019 14:41 by Tom
If a worksheet spans more than one page, you can print row and column headings or labels (also called print titles) on every page to ensure that the data is properly labeled.
Approved
Last Updated: 03 Feb 2019 12:25 by Ioannis
Created by: Ioannis
Comments: 3
Category: Spreadsheet
Type: Bug Report
1

Hello,

 

So here's what happens. I create a workbook and a worksheet in that wb which I assign as the workbook of a RadSpreadSheet by RadSpreadSheet..Workbook = wb

The first time I assign a name to the first (and only sheet) created in the creation of the wb, the name does appear on that sheet.

Then some code takes this workbook ByVal, creates a new Sheet, makes that sheet the wb's ActiveWorksheet and then changes the ws's name.

You can see in the debugging that the worksheet does have the new name i put there ("2018-05"), but visually this 2nd worksheet has the default name "sheet 2".

Then that wb which is returned by the function is assigned as the RadSpreadSheet's workbook

If I run the code again, so a 3rd sheet is created, then the 3rd sheet will visually have the default name "sheet 3", however in the debugger it says "2018-06" as its name; but most importantly, now sheet 2 has magically changed to what I was seeing its name to be in the debugger ("2018-05").

 

I'm assuming that If I'm changing the sheet names at runtime, I need to call some method on the Workbook element or something like that in order to update the names. I just couldn't find which method to call.

 

Best regards,

Ioannis Mamalikidis.

Completed
Last Updated: 31 Jan 2019 12:12 by ADMIN
Created by: Ioannis
Comments: 12
Category: Spreadsheet
Type: Bug Report
1

Hello,

 

So, I'm testing the Telerik suite, part of which is the RadSpreadSheet. I'm currently using the 30 days trial.

So, when I'm debugging it and I'm instantiating a new form that contains the RadSpreadSheet, the programme will about 50% of the time create an exception of object reference not set to an instance of an object
Now, I've only noticed this with forms that contain a radspreadsheet but it could have nothing to do with it.

What always happens before I get the exception is that the reminder to buy a Telerik License appears (the programme halts until I choose an option) and when the dialogue disappears, the exception happens.

 

Please note that if I just push "F5" again in VS, without changing anything anywhere, so after the crash immediately debug (F5) again, the exception will not occur.

Approved
Last Updated: 02 Jan 2019 15:08 by ADMIN
Created by: Ioannis
Comments: 3
Category: Spreadsheet
Type: Bug Report
1

Hello,

 

I have a RadRibbonForm with a normal ribbon with no items and a spreadsheet control.

 

I iterate over a datatable and fill the spreadsheet's cell values with the datatable's values

we're talking about a very small size, like 33 rows x 35 columns, and not even all the values are filled in.

 

Unfortunately, there's a very noticeable delay in the spreadsheet, from moving the scrollbars to selecting to changing sheets.. the whole thing feels laggy.

Is this just how it is, or am I experiencing a possible bug?

Could it have anything to do with https://feedback.telerik.com/winforms/1380948-exception-at-runtime-trial-bug ?

 

If that is just how it is, is there anything I can do to make it feel snappier? Disable a theme? Disable some behaviour?

Approved
Last Updated: 17 Dec 2018 12:41 by ADMIN
The data validation rule should have values for formula1 and formula2 elements, which define the start and end values for a range to validate between. When such values are missing, a NullReferenceException is thrown on import and the document cannot be imported. As a workaround, the document can be modified by deleting the AlternateContent attribute.
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);
        }
Approved
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:42 by ADMIN
RadSpreadsheet must support printing using RadPrintDocument. 
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:39 by ADMIN
This is possible in WPF
Approved
Last Updated: 21 Jun 2018 14:10 by ADMIN
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;
            }
        }
    }
}
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: 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)
{
}

1 2