The formula is not evaluated correctly when the fill right function is used.
To reproduce:
1. Enter the word "A1" in cell A1 and "B1" in cell B1.
2. Enter the formula "=A1&B1" in cell C1. C1 now correctly shows "A1B1"
3. Select C1 to H1 and run the Fill Right command.
Observe that D1, E1, and F1 show the correct result, but G1 and H1 show "0".
Workaround:
Save and reopen the document.
Fill right shortcut (Ctrl + R) does not work
As a workaround, manually register the combination:
public MainWindow()
{
InitializeComponent();
this.radSpreadsheet.ActiveSheetChanged += RadSpreadsheet_ActiveSheetChanged;
this.Loaded += MainWindow_Loaded;
}
private void MainWindow_Loaded(object sender, RoutedEventArgs e)
{
RegisterFillRight();
}
private void RadSpreadsheet_ActiveSheetChanged(object sender, EventArgs e)
{
RegisterFillRight();
}
public void RegisterFillRight()
{
RadWorksheetEditor worksheetEditor = this.radSpreadsheet.ActiveWorksheetEditor;
if (this.radSpreadsheet.ActiveWorksheetEditor != null)
{
worksheetEditor.KeyBindings.RegisterCommand(worksheetEditor.Commands.FillRight, Key.R, ModifierKeys.Control);
}
}
There are several items that currently cannot be localized:
The headers and the description of the items have hardcoded strings.
When importing a document containing a hyperlink formula (e.g. "=HYPERLINK(B2,A2)") an exception is thrown: System.Collections.Generic.KeyNotFoundException: 'The given key was not present in the dictionary.'
The WorkbookContentChanged event is invoked right after importing a document.
The scale factor is not imported from documents with no information about the selection state.
The outline properties of the chart series are not respected by most charts.
Setting up a paper size to A1 and exporting it actually sets the paperSize to 1. Using the same scenario in Excel sets the paperSize to 305.
This leads to inappropriate values when entering the Page Setup options later in Excel.