Abstract: A method and system provides reversibility of an operation performed by a user of an application program and associated with a modification to an object model of the application program, such as a spreadsheet program or other office productivity application program. The top item of a first undo stack associated with the application program is determined, saved, and copied to a second stack functioning as a replicated undo stack. According to one aspect of the invention, such steps are performed prior to calling an object model method that clears the first undo stack. The top item of the second replicated undo stack is placed back onto the first undo stack.

Abstract: Indirect persistent storage of data in a file that is associated with an application program and is capable of having an embedded OLEObject includes creating the OLEObject by way of a Component Object Model add-in that supplements the application program, and using the OLEObject to store the data in the file. The OLEObject is marked so that it is hidden from a user of the application program. After loading a file that was previously saved and closed, the OLEObject is initialized, and the stored data is retrieved. The add-in may be a reporting add-in that queries a database, such as an OLAP database.