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

        }
    }
    
}

Approved
Last Updated: 11 Dec 2019 07:38 by ADMIN
Created by: n/a
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

Hi,

I think it would be really cool to include a search bar in the filter window, as implemented in Excel (Please find attached a screenshot for demonstration). This is a very useful functionality, as there may be too many options to choose from is the filter is added to subject ID, which could result in thousands IDs.

In Development
Last Updated: 10 Dec 2019 08:03 by ADMIN
ADMIN
Created by: Anna
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
Implement UI for hiding sheet. The sheets can be visible, hidden, or very hidden (could be made visible only from the API).

Note: This is already supported on model level (in RadSpreadProcessing).
Approved
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).  

Completed
Last Updated: 29 Nov 2019 07:11 by ADMIN
Release 2019.3.1202 (12/02/2019)
ADMIN
Created by: Todor
Comments: 2
Category: Spreadsheet
Type: Feature Request
1
Currently it's not possible to disable the fill handle feature. Provide API for disabling it.

Workaround: in the attached project.
Pending Review
Last Updated: 29 Nov 2019 05:41 by Dimitar

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. 

Approved
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.
Approved
Last Updated: 18 Nov 2019 11:03 by ADMIN
Created by: Petar
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Currently, this can be achieved partially by using the FlowDirection property but the result could be unexpected for right-to-left. 
Approved
Last Updated: 11 Nov 2019 12:57 by ADMIN
Right now this functionality is missing and the user is not able to scroll the viewer when the row header is selected and not the cell.
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);
        }
    }
}

 

Completed
Last Updated: 10 Sep 2019 14:17 by ADMIN
Release R3 2019
A resource cannot be found and an exception is thrown for a WPF Net Core project.
Approved
Last Updated: 04 Sep 2019 12:19 by ADMIN
Print Preview's "Fit All Columns on One page" does not fit columns on one page.
Declined
Last Updated: 26 Aug 2019 11:51 by ADMIN
Created by: CB
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

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.  

Completed
Last Updated: 13 Aug 2019 14:00 by ADMIN
Release LIB 2019.2.819 (08/19/2019)
For example, the default namespace prefix for BlipElement is r: if the namespace prefix is different an exception will occur.
Completed
Last Updated: 08 Aug 2019 08:05 by ADMIN
Release LIB 2019.2.812 (08/12/2019)
The scale factor is not imported from documents with no information about the selection state.
Completed
Last Updated: 08 Jul 2019 11:17 by ADMIN
Release LIB 2019.2.708 (07/08/2019)
When there is a document with wrapped cells in it, often the content of the cell is not properly displayed in RadSpreadsheet. This results in the content also being shown over the cell below.
Completed
Last Updated: 26 Jun 2019 06:34 by ADMIN
Release R2 2019 SP1
If a document contains many and complex formulas (with many functions having other functions as arguments) it may take a long time to show in the control.
Approved
Last Updated: 19 Jun 2019 08:16 by ADMIN
Created by: Michal
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
SUBSTITUTE  - replaces text in a given string by matching.
REPLACE - replaces characters specified by location in a given text string with another text string.
Approved
Last Updated: 06 Jun 2019 10:58 by ADMIN
Created by: Randy
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
The PickCellRange dialog should allow using the formula selection to select cell ranges and convert them into text.
Approved
Last Updated: 05 Jun 2019 14:29 by ADMIN
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;
1 2 3 4 5 6