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.
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;
Approved
Last Updated: 05 Jun 2019 11:52 by ADMIN
Created by: Pascal
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
This feature allows automatically to group ordered data in the table and calculate the subtotals of the values column in each group of similar items. The subtotals are included just after each grouped items.
Approved
Last Updated: 18 Apr 2019 08:13 by ADMIN
Applying a Number number format in a cell and then entering fractional number values like 1.2/2 results in cell value equal to 37258 if it is formatted as a date it will be 1/2/2002.
Approved
Last Updated: 16 Apr 2019 06:05 by ADMIN
When entering values in the cells fast some of the values are skipped.
Approved
Last Updated: 01 Apr 2019 11:39 by ADMIN
The SheetSelectorTabItem background is not properly applied and the text is not readable. This is easily noticeable in themes with a dark color palette. 
Approved
Last Updated: 19 Mar 2019 14:29 by ADMIN
Currently, when the user is editing a cell and saves the document without leaving the edit mode first, the current value is not preserved in the saved document.
When pressing the File -> Save button in the ribbon, the Save dialog doesn't appear at all.
 
Workaround: Manually commit the change before saving. This workaround will also respect data validation:
var layer = ((NormalWorksheetEditorPresenter)radSpreadsheet.ActiveWorksheetEditor.ActivePresenter).UILayers.GetByName(WorksheetPredefinedUILayers.CellInput);
CellInputUILayer cellInputUILayer = (CellInputUILayer)layer;
cellInputUILayer.ApplyChange();
Approved
Last Updated: 08 Mar 2019 11:15 by ADMIN
When a user setups a page and chooses to customize the Header's Odd and Even pages, the tab headers become clipped.
Approved
Last Updated: 08 Mar 2019 07:43 by ADMIN
Created by: Petar
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
When Esc key is pressed charts dialog should close.
Approved
Last Updated: 14 Feb 2019 10:33 by ADMIN
ADMIN
Created by: Nikolay Demirev
Comments: 4
Category: Spreadsheet
Type: Feature Request
7
Add support for preserving and exporting the macros in a macro-enabled workbook.

Macros are pieces of code written in Visual Basic for Applications (VBA) which are used to automate repetitive tasks in excel. The macros are part of the excel file. When a file contains a macro its extension becomes xlsm.
Spreadsheet should be able to import and export xlsm files and edit the macros in them.
Approved
Last Updated: 08 Jan 2019 19:24 by ADMIN
Some of the RadSpreadsheet child controls do not apply the new theme, but stay with office black applied when theme is set on control level.
Approved
Last Updated: 05 Nov 2018 11:27 by ADMIN
ADMIN
Created by: Martin
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
RadSpreadsheet should respect negative time values as MS Excel does it.
Approved
Last Updated: 31 Oct 2018 13:43 by ADMIN
At the moment when any of the properties are changed, e.g. the frozen panes, the UI is not notified and you have to export and import the file in order for the UI to pick them up. 


Workaround: There are several workarounds:

1. Change the active worksheet and return to the old one

2. Export and import the document

3. Change the workbook of the RadSpreadsheet to a new one, and return the old one after that
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
We should provide an easier API allowing the customers to remove the key bindings or change the commands that they trigger.

Workaround: There is attached a sample showing how all the commands triggered by the key bindings can be disabled.
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
If plain text is pasted in a cell, and the text is automatically recognizable as date, number, percentage, formula or other format, the text is always converted to the recognized number format.

Instead, the cell's current number format should affect the convertion in the following way:
- If the current format is General -> parse the value with the automatically recognized format, and set the value with the automatically recognized format
- If the current format is Text -> set the value as text, and preserve the current format (Text)
- If the current format is any other format -> try parse the value with the current format
  - Successful -> set the parsed value with the current format
  - Unsuccessful -> parse the value with the automatically recognized format, and set the parsed value with the current format.

As a result, strings which are recognizable as dates, for example, are pasted as their numeric representation instead of with their Date formatting. Also it's not possible to paste something as plain text. 

Workaround: for always pasting plain text: Create custom Paste button and executes the following code:
this.radSpreadsheet.ActiveWorksheetEditor.Selection.Cells.SetValueAsText(Clipboard.GetText());
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
When setting the following strings as cell value, they are recognized as dates. In industry standard applications like MS Excel and OpenOffice, they are recognized as strings:
- "12 3456" in bg-BG, fr-FR, ru-RU, sv-FI, en-US
- "12.3456" in de-DE
- "1 23" in en-US
- "2013/5" in en-US
- "3000-03" in en-US
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
When RadSpreadsheet is placed inside a data template and the Workbook property is bound, the binding fails. 

In the Convert() method of the debug converter, the proper value is set. However, an empty workbook is displayed in the view.
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
ADMIN
Created by: Boby
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Currently the following text filters are not supported in the model, filtering popup and Custom Filter dialog:
- begins with
- does not begin with
- ends with
- does not end with
- contains
- does not contain.

All of these are supported in MS Excel.
1 2 3 4 5 6