Hello, 
we have an Excel export in our software that we solved via Telerik Spreadsheet. 
An exported Excel Table can also contain images. 
These pictures are inserted as shape objects. 
The Placement Property is set to xlMove (xlPlacement Enum) in Excel. 
If you now filter the data in Excel, the images remain and are not hidden. 
We therefore need a way of being able to change this Placement Property to the Value xlMoveAndSize
It would be very desirable if this option were made available in Telerik Spreadsheet as our customers urgently need it.

Hi,

Range name becomes incorrect after removing row in a spreadsheet.

Use case:

- Set range name to 'test' on cell A5

- Remove row 4 (option entire row)

Observed:

- Range name is still located on cell A5

Expected:

- Range name 'test' on cell A4. Similar behavior as in MS Excel

Can be reproduced using the Telerik WPF demo app.

The named ranges are not updated after rows columns are inserted.

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

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.

There are several items that currently cannot be localized:

• Fit Sheet on One page
• Fit All Columns on One page
• Fit All Rows on One page

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.'

Cell Values disappearing when RadWindow is dragged to a second Monitor.

Workaround:

private void MainWindow_Loaded(object sender, RoutedEventArgs e)
{
    this.viewModel.OpenSampleCommand.Execute(null);
    radDocking1.ToolWindowCreated += RadDocking1_ToolWindowCreated;
}

private void RadDocking1_ToolWindowCreated(object sender, Telerik.Windows.Controls.Docking.ElementCreatedEventArgs e)
{
    var window = e.CreatedElement as ToolWindow;
    if (window != null)
    {
        window.WindowStateChanged += Window_WindowStateChanged;

    }
}

private void Window_WindowStateChanged(object sender, EventArgs e)
{
    var window = sender as ToolWindow;

    var spreadsheet = window.ChildrenOfType<RadSpreadsheet>().FirstOrDefault();
    if (spreadsheet != null)
    {
        spreadsheet.InvalidateVisual();
    }
}

The WorkbookContentChanged event is invoked right after importing a document. 

The outline properties of the chart series are not respected by most charts.

The scale factor is not imported from documents with no information about the selection state.

Value of a cell is visualized outside of the cell boundaries, or the value is clipped and partially visible, when the cell is updated (from code-behind), while being in an inactive worksheet, and is referenced by another cell from the active sheet.

Workaround: get a value of some cell in the active sheet and set it again to the same cell.

The issue is reproducible after the official release of Q1 2015.