Crash when select the left most cell and press ctrl and left.

[crosslife]

Specified argument was out of the range of valid values.

   at Syncfusion.XlsIO.Implementation.RangeImpl.CheckRange(Int32 row, Int32 column)

   at Syncfusion.XlsIO.Implementation.RangeImpl.get_Item(Int32 row, Int32 column)

   at Syncfusion.UI.Xaml.Spreadsheet.SpreadsheetGrid.GetCellValue(Int32 rowIndex, Int32 colIndex)

   at Syncfusion.UI.Xaml.CellGrid.GridCurrentCell.HandleKeyNavigation(KeyEventArgs args)

   at Syncfusion.UI.Xaml.CellGrid.SelectionController.ProcessKeyNavigation(KeyEventArgs args)

   at Syncfusion.UI.Xaml.CellGrid.SelectionController.HandleKeyDown(KeyEventArgs args)

   at Syncfusion.UI.Xaml.CellGrid.SfCellGrid.OnPreviewKeyDown(KeyEventArgs e)

   at Syncfusion.UI.Xaml.Spreadsheet.SpreadsheetGrid.OnPreviewKeyDown(KeyEventArgs e)

   at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)

   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)

   at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)

   at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)

   at System.Windows.Input.InputManager.ProcessStagingArea()

   at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)

   at System.Windows.Interop.HwndKeyboardInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawKeyboardActions actions, Int32 scanCode, Boolean isExtendedKey, Boolean isSystemKey, Int32 virtualKey)

   at System.Windows.Interop.HwndKeyboardInputProvider.ProcessKeyAction(MSG& msg, Boolean& handled)

   at System.Windows.Interop.HwndSource.CriticalTranslateAccelerator(MSG& msg, ModifierKeys modifiers)

   at System.Windows.Interop.HwndSource.OnPreprocessMessage(Object param)

   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)

   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)

[Manikanda Akash Munisamy]

Hi crosslife,

We have checked the reported issue “ArgumentOutOfRangeException when pressing Ctrl and Left from the Left most cell in SfSpreadsheet in WPF” on our end and it is confirmed as a defect. And We have logged a bug. We will fix this issue and include it in our NuGet release Which is scheduled on July 16, 2024.

You can track the status of this report through the following feedback link,

Feedback Link: ArgumentOutOfRangeException when pressing Ctrl and Left from the left most cell in Spreadsheet in WPF | Feedback Portal (syncfusion.com)

Note: The provided feedback link is private, and you need to log in to view this feedback.

We will let you know once it is released. We appreciate your patience until then.

Disclaimer: Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.

Regards,
Manikanda Akash

[Malini Selvarasu]

Hi crosslife,

We would like to let you know that Essential Studio Weekly NuGet packages (v26.1.42) has been published in nuget.org with the fix for the issue “ArgumentOutOfRangeException when pressing Ctrl and Left from the Left most cell in SfSpreadsheet in WPF”. Please let us know if you have any concerns in this.

 

Root Cause Details:
We have checked the previous cell values when pressing CTRL+LEFT to maintain the same behavior as in Excel. In this case, when we have a current cell in the first row and first column of a spreadsheet, we do not have any previous cells. Therefore, when trying to get the cell values for a previous index, the argument exception occurs. We have now considered this case and changed the code for querying the cell values when we have a current cell in the first row and first column.

Regards,

Malini Selvarasu