Jump to content
Microsoft Windows Bulletin Board

Undo stack shouldn't get cleared after setting rowHidden/columnHidden property through the API


Recommended Posts

Posted

Our accounting-oriented add-in provides a feature that is triggered upon recalculation and hides certain report rows (e.g. financial accounts with no balances or activity) that do not interest the report reader.

Unfortunately, this clears the Undo stack and is a source of one of the most frequent customer complaints.

The following ScriptLab snippet illustrates the problem: Undo stack: rowHidden

Steps to replicate:

  • Attach the ScriptLab snippet (run in the current pane)
  • Type "foo" into cell A1
  • Undo the operation
  • Type "foo" into cell A1 again
  • Click the "Hide/unhide first row" in the side panel. It will hide and unhide row 1.
  • Click "Undo" – nothing happens (or Undo operation is not available, depending on the platform)

Expected result:

Setting rowHidden or columnHidden properties of the range should not clear the Undo stack.

View the full article

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...