ArgumentException occurs when using the voice typing feature of Windows (started with the Windows Key + H key combo) to convert speech to text in RadRichTextBox.
Exception stacktrace:
System.ArgumentException: 'Requested distance is outside the content of the associated document.'PresentationFramework.dll!System.Windows.Documents.TextPointer.TextPointer(System.Windows.Documents.TextContainer textContainer, int offset, System.Windows.Documents.LogicalDirection direction) PresentationFramework.dll!System.Windows.Documents.TextContainer.CreatePointerAtOffset(int offset, System.Windows.Documents.LogicalDirection direction) PresentationFramework.dll!System.Windows.Documents.TextParentUndoUnit.Do() PresentationFramework.dll!MS.Internal.Documents.UndoManager.Redo(int count) PresentationFramework.dll!System.Windows.Documents.TextStore.RedoQuietly(int count) PresentationFramework.dll!System.Windows.Documents.TextStore.SetFinalDocumentState(MS.Internal.Documents.UndoManager undoManager, System.Collections.Stack imeChangeStack, int appChangeCount, int imeSelectionAnchorOffset, int imeSelectionMovingOffset, int appSelectionAnchorOffset, int appSelectionMovingOffset) PresentationFramework.dll!System.Windows.Documents.TextStore.HandleCompositionEvents(int previousUndoCount) PresentationFramework.dll!System.Windows.Documents.TextStore.GrantLockWorker(MS.Win32.UnsafeNativeMethods.LockFlags flags) PresentationFramework.dll!System.Windows.Documents.TextStore.RequestLock(MS.Win32.UnsafeNativeMethods.LockFlags flags, out int hrSession)
The label of the field that allows you to set the ScreenTip in the Hyperlink dialog is not vertically centered to the associated textbox visual. This reproduces in the Windows11 theme.
To work this around, get the TextBlock element in the Hyperlink dialog and set its VerticalAlignment property to Center.
private void RadSpreadsheet_Loaded(object sender, RoutedEventArgs e)
{
var hyperlinkDialog = this.spreadsheet.ActiveWorksheetEditor.Dialogs.HyperlinkDialog as HyperlinkDialogContent;
hyperlinkDialog.Loaded += HyperlinkDialog_Loaded;
}
private void HyperlinkDialog_Loaded(object sender, RoutedEventArgs e)
{
var dialog = (HyperlinkDialogContent)sender;
var screenTipLocalizedText = LocalizationManager.Manager.GetStringOverride("Spreadsheet_InsertHyperlinkDialog_ScreenTip");
var screenTipTb = dialog.ChildrenOfType<TextBlock>().FirstOrDefault(x => x.Text == screenTipLocalizedText);
if (screenTipTb != null)
{
screenTipTb.VerticalAlignment = VerticalAlignment.Center;
}
}
Hi Team,
I have backported the Xlsx file to Xls format. When I am trying to import the backported file using the Radspreadsheet UI control, I find that it has lost the color formatting which was existing in the original Xlsx file. Where as when we open the back ported file with Excel application we find that all the data and formatting is maintained.
So the request is that after backporting and while importing the file, it should not loose the minimal xls supported features which Excel is able to support.
Attached is the InitialFile.xlsx and BackPorted.xls file
Note that Xlsx file if imported it maintains the data and formatting information of the workbbok when loaded via UI control.
Let us know in case of any more details or queries.
Exepct this to work
Regards,
Manish.
We have a document in XLS format produced by GemBox. The yellow cells get black once the document is imported and then exported (back to XLS or XLSX) with RadSpreadProcessing.
The SUMIFS function adds all of its arguments that meet multiple criteria. A list of the supported functions is available at http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions This function can be implemented as a custom function. Check the following resources for more details on how to achieve that: - http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions - https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/WPF/CustomFunctions