Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
925
Undo issue in the spreadsheet control
posted

We have encountered a new issue in the spreadsheet control when performing the Undo command (reproduced in the attached sample application). We have named references in the workbook which are updated dynamically (static references applied to entire column currently do not work in the spreadsheet control). In order to simplify the update of the reference, we use R1C1 reference style. When undo operation is performed for named reference update, an exception is thrown.

Steps to reproduce:

  1. Start a sample application. During start it updates the named reference and the related Undo item is in the Undo history.
  2. Select some cell in the worksheet.
  3. Press Ctrl + Z.

This issue seems to be independent of whether R1C1 style is enabled in the workbook or not.

Is there any workaround for this issue?

SpreadsheetUndoReferenceIssueSample.zip