Unplanned
Last Updated: 17 May 2022 14:03 by ADMIN
When replying to someone else`s SpreadsheetComment, the SpreadsheetCommentReply`s author copies the comments author instead of passing the current author`s name.
Completed
Last Updated: 17 May 2022 11:29 by ADMIN
Release R2 2022
ADMIN
Created by: Petya
Comments: 6
Category: Spreadsheet
Type: Feature Request
27
Add support for conditional formatting of cells - allow applying of rules used during visualization of cells to automatically apply formatting depending on their values.
Unplanned
Last Updated: 16 May 2022 07:48 by Michel Cossette
InvalidOperationException thrown by RowColumnHeadingBase.get_NormalFillBrush() with Crystal theme.
Unplanned
Last Updated: 09 May 2022 15:07 by ADMIN

When the Freeze Panes option is enabled and try to insert a new comment into the next cell on the left to the Freeze Panes separator the comment is deleted.

Unplanned
Last Updated: 06 May 2022 08:14 by IGK

Custom style is not applied to empty cells when applying to the entire row.

Workaround: 

Dim usedCellRange As CellRange = mobjValidationResultWs.UsedCellRange
For rowIndex As Integer = usedCellRange.FromIndex.RowIndex To usedCellRange.ToIndex.RowIndex
    For columnIndex As Integer = usedCellRange.FromIndex.ColumnIndex To usedCellRange.ToIndex.ColumnIndex
        Dim cell As CellSelection = mobjValidationResultWs.Cells(rowIndex, columnIndex)
        cell.SetStyleName("Common")

    Next columnIndex
Next rowIndex

Completed
Last Updated: 12 Apr 2022 15:28 by ADMIN
Release LIB 2022.1.418 (18 Apr 2022)
NullReferenceException is thrown when Undo is clicked and Clear Contents of an image is performed.
Completed
Last Updated: 04 Mar 2022 07:47 by ADMIN
Release LIB 2022.1.307 (07 Mar 2021)
Some documents with conditional formatting occasionally throw an ArgumentOutOfRangeException due to an internal issue with dfsx indexing.
Unplanned
Last Updated: 28 Feb 2022 11:32 by JC
The user needs to either double click or hit F2 in order to proceed.
Completed
Last Updated: 14 Feb 2022 08:13 by ADMIN
Release LIB 2022.1.214 (14 Feb 2022)
The MergeAndCenter command binding in the SpreadsheetRibbon causes a NullReferenceException.
Unplanned
Last Updated: 04 Feb 2022 07:33 by ADMIN
Introduce support for row/column reordering via the UI
Unplanned
Last Updated: 01 Feb 2022 10:45 by ADMIN
Created by: Michael
Comments: 3
Category: Spreadsheet
Type: Feature Request
8

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.

Duplicated
Last Updated: 20 Jan 2022 11:48 by ADMIN
Created by: Robby
Comments: 1
Category: Spreadsheet
Type: Bug Report
0

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.

 

Duplicated
Last Updated: 13 Jan 2022 08:33 by ADMIN

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.
Completed
Last Updated: 14 Dec 2021 16:34 by ADMIN
Release LIB 2021.3.1220 (20 Dec 2021)
Created by: EuroEager2008
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

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

Unplanned
Last Updated: 14 Dec 2021 07:43 by ADMIN

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.

Completed
Last Updated: 10 Dec 2021 12:00 by ADMIN
Release LIB 2021.3.1213 (13 Dec 2021)

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.

Completed
Last Updated: 10 Dec 2021 11:17 by ADMIN
Release LIB 2021.3.1213 (13 Dec 2021)

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

Unplanned
Last Updated: 07 Dec 2021 11:27 by ADMIN

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

 

Completed
Last Updated: 01 Nov 2021 09:00 by ADMIN
Release LIB 2021.3.1101
The style gallery is broken in the fluent theme and crashes the control
Completed
Last Updated: 20 Oct 2021 12:22 by ADMIN
Release R3 2021 SP1
The SpreadsheetML format has built-in reserved names. When such a name is defined in the scope of a worksheet, a SpreadsheetNameException is thrown during parsing the document.
1 2 3 4 5 6