When the size of the columns is changed using the ColumnSelection.SetWidth(*) method does not update the layout, so subsequent uses of the layout are not calculated correctly. For example BringIntoView method works incorrectly. Workaround: call RadSpreadsheet.UpdateLayout() after setting the width.
At the moment the theme of the RadSpreadsheetRibbon can be set only by setting the theme of the entire application. The individual setting (using telerik:StyleManager.Theme="Windows8") should also be supported.
The exception is thrown in the QuarterAutoFillGenerator TryParse method due to the unexpected length of the value. Workaround: Do not use SetValueAsText method by passing an empty string to it. Use SetValue or ClearValue instead.
An ArgumentNullException is thrown when you try to open a document containing relationship namespace declared in the tag. <sheet name="Management Position View" sheetId="1" d3p1:id="rId1" xmlns:d3p1="http://schemas.openxmlformats.org/officeDocument/2006/relationships" />
When the users click on the More Borders option provided in the ribbon UI, the Format Cells dialog opens but the popup of the dropdown is still kept open.
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.
When the formula bar is empty and alt + enter is pressed in order to insert a new line, NullReferenceException is thrown. The exception might be reproduced with text in the formula bar, but the caret has to be placed in the end of a run/end of the text. Fix available in LIB Version 2018.2.820.
This behavior happens at a specific width of the cell's Column. Using different VerticalAlignment (not Bottom) would workaround this issue.
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;
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.
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
Filter command should be disabled when a single row or cell is selected. Fix available in LIB Version 2018.3.1105.
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
Add an event that indicates when a hyperlink is clicked.
RadSpreadsheet should respect negative time values as MS Excel does it.