var layer = ((NormalWorksheetEditorPresenter)radSpreadsheet.ActiveWorksheetEditor.ActivePresenter).UILayers.GetByName(WorksheetPredefinedUILayers.CellInput);
CellInputUILayer cellInputUILayer = (CellInputUILayer)layer;
cellInputUILayer.ApplyChange();
RadSpreadsheet should respect negative time values as MS Excel does it.
Add an event that indicates when a hyperlink is clicked.
Xlsx documents with a global filter defined cannot be imported. Message box "The name that you entered is not valid." is shown and internally SpreadsheetNameException is thrown. MS Excel can import such document and even preserve the filter, but do not respect it and doesn't have UI to clear it. Workaround 1 (includes processing the document with MS Excel): - Open the document in MS Excel - Choose Formulas -> Defined names -> Named Manager - Choose Filter -> Names with errors - Find all Filter defined names and delete them - Save the document
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.
Filter command should be disabled when a single row or cell is selected. Fix available in LIB Version 2018.3.1105.
Customers are reporting an issue when trying to copy content in an application hosted on a remote machine (there are reports using TigerVNC and Citrix). The exception is thrown from the Clipboard class with a message: OpenClipboard failed (Exception from HRESULT: 0x800401D0 (CLIPBRD_E_CANT_OPEN)) It seems like such a behavior could be reproduced when the clipboard is already opened by another application. Here is a discussion on the matter: https://stackoverflow.com/questions/68666/clipbrd-e-cant-open-error-when-setting-the-clipboard-from-net
When the PrintPreview has to show many UIElements at once, the performance is slow.
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.
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;