Unplanned
Last Updated: 30 Jul 2020 11:13 by ADMIN
Unplanned
Last Updated: 27 Jul 2020 12:00 by ADMIN

The scroll exceeds the visible area when using the auto-fill.

Steps to reproduce:

- Set the VisibleSize to (10 ,10)

- Drag the autofill icon down

 

Unplanned
Last Updated: 13 Jul 2020 12:21 by ADMIN
According to the Open XML documentation, the possible max value for this attribute is an unsignedInt or 4294967295.
Unplanned
Last Updated: 09 Jul 2020 10:53 by ADMIN
Setting a tab color from API:
this.radSpreadsheet.ActiveWorksheet.ViewState.TabColor = new ThemableColor(Colors.Red);
doesn't fire a UI update.
Completed
Last Updated: 22 Jun 2020 07:28 by ADMIN
Release R2 2020 SP1
When changing only number separators and leave the default currency separators values entered in the cells are displayed with wrong separators.
Completed
Last Updated: 18 Jun 2020 11:56 by ADMIN
Release R2 2020 SP1
When setting Wrap Text to an already merged CellSelection the row height is recalculated according to the cell height instead of keeping the initial height of the row.
Unplanned
Last Updated: 22 May 2020 09:34 by ADMIN
The chart is blinking when the SetValue method is used
Unplanned
Last Updated: 21 May 2020 11:14 by ADMIN
The selected text is not readable when the Worksheet tab is in Edit mode and the applied theme is dark.

Reproducible in NoXaml scenario and for all dark themes except Fluent Dark.
In Development
Last Updated: 21 Apr 2020 16:33 by ADMIN
Completed
Last Updated: 31 Mar 2020 11:10 by ADMIN
Release R2 2020
At the moment the print settings set to the WorksheetPageSetup class are not passed to the Print dialog which leads to bad user experience. If you set the print settings of the RadSpreadsheet like so:

WorksheetPageSetup pageSetup = this.radSpreadsheet.Workbook.ActiveWorksheet.WorksheetPageSetup;
pageSetup.PageOrientation = PageOrientation.Landscape;

and then select Print, the Spreadsheet print menu will show the print preview as landscape. However, when after that you click on Print for the default print dialog to appear and then click Preferences, you will notice that the preference is set to Portrait. The print job will be Landscape, but the incorrect information in the default dialog creates confusion.

This is an example of how to set the preference of the default dialog:

PrintDialog printDialog = new PrintDialog();
var printTicket = printDialog.PrintTicket;
printTicket.PageOrientation = System.Printing.PageOrientation.Landscape;
Unplanned
Last Updated: 04 Mar 2020 09:17 by ADMIN

The current worksheet is not updated if the workbook is set while the control is disabled.

Workaround: 

private void RadButton_Click( object sender, RoutedEventArgs e )
{
    radSpreadsheet.IsEnabled = false;
  
    Workbook spreadsheetWorkbook =
        new XlsxFormatProvider( ).Import( File.ReadAllBytes( @"..\..\Book2.xlsx" ) );
  
    radSpreadsheet.Workbook = new Workbook( );
  
    Dispatcher.InvokeAsync( ( ) => radSpreadsheet.Workbook = spreadsheetWorkbook );
  
    radSpreadsheet.IsEnabled = true;
}

Unplanned
Last Updated: 21 Feb 2020 09:42 by ADMIN
The Outline and Marker properties of the Scatter series are not rendered correctly
Completed
Last Updated: 11 Feb 2020 12:52 by ADMIN
Release LIB 2020.1.217 (02/17/2020)
An ArgumentOutOfRangeException is thrown when importing a spreadsheet with the first sheet hidden: VisibleSheetCount should be greater or equal to 1.
Unplanned
Last Updated: 04 Feb 2020 12:38 by ADMIN

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

Unplanned
Last Updated: 20 Jan 2020 05:47 by ADMIN

To reproduce: 

- Select some cells within the same column using Ctrl+Click

- Use the context menu to copy the cells

This works in Excel when the cells are within the same column. 

Completed
Last Updated: 15 Jan 2020 12:47 by ADMIN
Release R1 2020
The background should be stretched along with the item itself. It is currently with specified width.
Workaround: Modify the style and change the width of the tab item. A sample is attached.
Unplanned
Last Updated: 11 Dec 2019 15:26 by ADMIN

 Exception when exporting document that contains links with an empty address.

Workaround:

private void Button_Click_1(object sender, RoutedEventArgs e)
{
    foreach (SpreadsheetHyperlink item in this.radSpreadsheet.Workbook.ActiveWorksheet.Hyperlinks.ToList())
    {
        if (string.IsNullOrEmpty(item.HyperlinkInfo.Address))
        {
            this.radSpreadsheet.Workbook.ActiveWorksheet.Hyperlinks.Remove(item);

        }
    }
    
}

Unplanned
Last Updated: 05 Dec 2019 11:20 by ADMIN

To reproduce; 

- Set the language to Korean

- Type "r" in one of the cells

- Use the AutoFill functionality

At this point, FatalExecutionEngineError occurs (see attached).  

Unplanned
Last Updated: 21 Nov 2019 12:29 by ADMIN
The style name "+-" is a valid one, but the StyleGallery crashes because it tries to set the name as a value of a cell and it is not a valid cell value.
Completed
Last Updated: 01 Nov 2019 08:11 by ADMIN
Release LIB 2019.3.1104 (10/07/2019)

The issue is a regression introduced in R3 2019. When the cells in a hidden column are with IsWrapped=true, an ArgumentOutOfRangeException is thrown during the text measuring. The behavior is related to SpreadProcessing as well.

Workaround: Remove the wrapping from the hidden cells:

 

var usedCellRange = workbook.ActiveWorksheet.GetUsedCellRange(new IPropertyDefinition[] { CellPropertyDefinitions.IsWrappedProperty});

for (int row = usedCellRange.FromIndex.RowIndex; row <= usedCellRange.ToIndex.RowIndex; row++)
{
    for (int column = usedCellRange.FromIndex.ColumnIndex; column <= usedCellRange.ToIndex.ColumnIndex; column++)
    {
        if (workbook.ActiveWorksheet.Columns[column].GetHidden().Value)
        {
            workbook.ActiveWorksheet.Cells[row, column].SetIsWrapped(false);
        }
    }
}

 

1 2 3 4 5 6