Windows Server Posted January 23 Posted January 23 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: rowHiddenSteps to replicate:Attach the ScriptLab snippet (run in the current pane)Type "foo" into cell A1Undo the operationType "foo" into cell A1 againClick 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.