Approved
Last Updated: 27 Sep 2019 16:18 by ADMIN

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.

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

 

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 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: 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: 29 Oct 2018 14:30 by ADMIN
ADMIN
Created by: Martin
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Add an event that indicates when a hyperlink is clicked.
Approved
Last Updated: 29 Oct 2018 09:33 by ADMIN
ADMIN
Created by: Martin
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns. If we want to be consistent with MS Excel we should implement this property. It is useful for many operations of a region such as filtering(selecting one cell and executing the Filter command should apply it to the current region), sorting, selecting all and etc. This document will be useful: https://docs.microsoft.com/en-us/office/vba/api/excel.range.currentregion.
Approved
Last Updated: 28 Sep 2018 11:30 by ADMIN
When the PrintPreview has to show many UIElements at once, the performance is slow.
Approved
Last Updated: 21 Aug 2018 14:29 by ADMIN
The functionality would allow to zoom the print preview and scroll the resulting viewport.

A partial implementation of the zooming functionality can be found in the attached file to provide a starting point for a custom implementation.
Approved
Last Updated: 21 Aug 2018 14:11 by ADMIN
The PrintPreviewControl refreshes its preview content on change in the SheetPageSetup object. This method would allow on-demand update.

At the moment this can be achieved by changing something in the page setup and restoring it. 

bool printGridlines = this.spreadsheet.Workbook.ActiveWorksheet.WorksheetPageSetup.PrintOptions.PrintGridlines;
this.spreadsheet.Workbook.ActiveWorksheet.WorksheetPageSetup.PrintOptions.PrintGridlines = !printGridlines;
this.spreadsheet.Workbook.ActiveWorksheet.WorksheetPageSetup.PrintOptions.PrintGridlines = printGridlines;
Approved
Last Updated: 21 Aug 2018 14:23 by ADMIN
This behavior happens at a specific width of the cell's Column. Using different VerticalAlignment (not Bottom) would workaround this issue.
Approved
Last Updated: 08 Aug 2018 14:24 by Peter
In MS Excel, the users can choose between showing the original size of the page and fit it in the window. Expose a similar option in RadSpreadsheet as well.
1 2 3 4 5 6