RadSpreadSheet navigation and data entry

[Rod]

Although the rad spreadsheet behaves similarly to Excel,  There is one common behavior that is missing.

If I tab from cell to cell, I cannot conveniently hit the delete key to clear the value.  This becomes a serious user entry issue when users are dealing with numerical data. 

In excel, <shift>tab + delete key will move to the next or previous cell AND <shift>return + delete key moves to the previous or next row and clears the cell value. 

This behavior cannot be reproduced within the RadSpreadsheet control BUT I can tab into a control (with a value) and start typing and it will overwrite the cell value.

So, my users are now tabbing to the next cell and hitting the space key to clear the cell - But this ha a serious side effect in that it now converts the cell to a "space" (Non numeric value) and if that cell is used in a formula elsewhere, the #VALUE! error pops up in all the formulas!

Any idea when this oversight will be corrected in a version of the control?

[Anna]

Hello,

I am trying to reproduce the issue that you are describing, but so far I am not successful. If I tab through a spreadsheet with values and press delete, the current value is cleared. Can you try to reproduce the behavior in our online demo and let me know what the result is? If you are able to reproduce it, can you elaborate a bit more on the steps you are taking in case there is something I am overlooking?

Regards,
Anna
Telerik

 

 

[Rod]

Anna, thanks for the reply.  I will need to dig into this a bit further as I see the functionality working in your online demo (and I built a very simple app and I see it behaving correctly as well).

I will look into it a bit further on my side as it is not as simple as the demos.

We host the RadSpreadsheet inside a usercontrol that is instanciated and assigned to a content property in code behind.  We are loading the spreadsheet from an xlsx file. 

I will get back to you shortly.

[Rod]

Anna,
    If you load the workbook from a stored xlsx file, then the tab + delete functionality does not work any more.

Rod

[Anna]

Hi Rod,

Unfortunately, I am still having trouble reproducing it. What I do is: I open an xlsx file, which I have stored on my machine, in a sample application or the online demo. Then I go through some of the values using tab and shift + tab and try to delete the one I've reached using the delete button. So far I haven't had trouble doing this.

You mentioned that you built a simple app to test this. If you have reproduced this with this app, would you mind sending me the project file? A sample xlsx file would also be great.

Regards,
Anna
Telerik

 

 

[Rod]

Anna,
   Here is an example that will show this issue (as well as my copy paste issue) that occurs when loading a template.

Run the app - it will start out with a blank radSpreasheet.  enter some data, right click copy paste cells and ranges then tab (or shift tab) + delete and see how everything works properly.
THEN, press the load template button at the top and redo those same steps.

[Anna]

Hi,

Thank you for the sample application and file.

The reason why the delete and the back buttons do not work in this case is that when the sheet is protected, these key bindings are removed altogether, regardless of whether the currently selected cells are unlocked or not. This behavior is indeed different from the one in Excel, so I've included this in our backlog and I'm hoping we will fix it soon. I am updating your Telerik points as a token of our appreciation for pointing this out.

As you've mentioned before that you are unable to download our LIBs, I've tried to find a workaround that you can implement. What you can do is you can add the key bindings for the delete and back buttons yourself with your own command. The following snippet shows an example of how to do this without allowing the protected cells to be deleted.

RadWorksheetEditor editor = this.radSpreadsheet.ActiveWorksheetEditor;

ICommand clearCommand = new DelegateCommand((parameter) =>
{
    if (editor.Worksheet.IsProtected)
    {
        RangePropertyValue<bool> isLocked = editor.Worksheet.Cells[editor.Selection.SelectedRanges].GetIsLocked();
        if(!isLocked.IsIndeterminate && !isLocked.Value)
        {
            editor.Clear(ClearType.Contents);
        }
    }
    else
    {
        editor.Clear(ClearType.Contents);
    }
});

editor.KeyBindings.RegisterCommand(clearCommand, Key.Delete, ModifierKeys.None);
editor.KeyBindings.RegisterCommand(clearCommand, Key.Back, ModifierKeys.None);

I hope this helps.

Regards,
Anna
Telerik