The scale factor is not imported from documents with no information about the selection state.
Hello,
In the spreadsheet control you cannot link/use in a function cells from one work sheet to cell(s) in another work sheet. Would like to have the same behavior and functionality of Excel, which allows you to use data from one sheet in any other sheet in the work book. Need the ability to create a sum of (or any other function available) cells from another worksheet in my current worksheet, within the same workbook.
The used cell range is expanded when styles to all columns are applied and one copies an entire row.
Workaround:
private void RadSpreadsheet_WorkbookChanged(object sender, EventArgs e){
var range = this.radSpreadsheet.Workbook.ActiveWorksheet.UsedCellRange;
this.radSpreadsheet.ActiveWorksheet.Columns[range.ColumnCount + 1, SpreadsheetDefaultValues.ColumnCount - 1].Clear(ClearType.All);
}
When the column width is decreasing below the size of the filter button the size of the button remains the same and overlaps the previous button.
The named ranges are not updated after rows columns are inserted.
This item is migrated to the Telerik Document Processing portal: https://feedback.telerik.com/document-processing/1549293. Please, use the new item for commenting, voting, and subscribing instead of this one.
RadSpreadsheet exposes API enabling the users to control the visibility of the sheet selector:
RadSpreadsheetSheetSelector.SetIsSheetSelectorVisible(radSpreadsheet, isVisible);
When the SetIsSheetSelectorVisible method is invoked with false value for the isVisible parameter, its parent container is still visible in the UI.
Combo chart with datetime axis and line/bar/area as a first series and scatter series as a second one throws InvalidCastException.
This can happen both with opening an xlsx file with such a chart or creating it in code. Such a chart cannot be created with the Insert Chart dialog (combo type is not yet supported via UI).
The outline properties of the chart series are not respected by most charts.
The WorkbookContentChanged event is invoked right after importing a document.
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.'
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.
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.
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.