Namespace DRIT.Spreadsheet.Revisions

Classes

Revision

Represents a single tracked change recorded in a shared workbook's revision log. Excel UI: "Review > Track Changes > Highlight Changes". This is the abstract base for the revision subtypes; the concrete type is exposed via Type.

RevisionAutoFormat

Represents a revision that applies an auto format to a range. Maps to the OOXML CT_RevisionAutoFormatting (element raf).

RevisionCellChange

Represents a revision that changes a cell's value or formatting. Maps to the OOXML CT_RevisionCellChange (element rcc).

RevisionCellComment

Represents a revision that adds, changes, or deletes a cell comment. Maps to the OOXML CT_RevisionComment (element rcmt).

RevisionCellMove

Represents a revision that moves cells by cut-and-paste. Maps to the OOXML CT_RevisionMove (element rm).

RevisionCustomView

Represents a revision that adds or deletes a custom view. Maps to the OOXML CT_RevisionCustomView (element rcv).

RevisionDefinedName

Represents a revision that adds, changes, or deletes a defined name. Maps to the OOXML CT_RevisionDefinedName (element rdn).

RevisionFormat

Represents a revision that changes cell formatting without changing the value. Maps to the OOXML CT_RevisionFormatting (element rfmt).

RevisionInsertDelete

Represents a revision that inserts or deletes rows or columns. Maps to the OOXML CT_RevisionRowColumn (element rrc).

RevisionInsertSheet

Represents a revision that inserts a worksheet. Maps to the OOXML CT_RevisionInsertSheet (element ris).

RevisionLog

Represents a single revision log: a set of changes made by one user in one editing session of a shared workbook. Each log corresponds to one xl/revisions/{N}.xml part and one header entry in xl/revisions/revisionHeaders.xml. Excel UI: "Review > Track Changes > Highlight Changes".

RevisionLogCollection

Represents the collection of RevisionLog objects on a shared workbook. Excel UI: "Review > Share Workbook" and "Review > Track Changes".

RevisionMergeConflict

Represents a revision that records a merge conflict. Maps to the OOXML CT_RevisionConflict (element rcft).

RevisionQueryTable

Represents a revision that refreshes a query table field. Maps to the OOXML CT_RevisionQueryTableField (element rqt).

RevisionRenameSheet

Represents a revision that renames a worksheet. Maps to the OOXML CT_RevisionSheetRename (element rsnm).

SharedWorkbookSettings

Settings for a shared workbook's change history. Maps to the attributes of the OOXML CT_RevisionHeaders element (xl/revisions/revisionHeaders.xml). Excel UI: "Review > Share Workbook" and the "Advanced" tab of the Share Workbook dialog ("Track changes", "Update changes", "Conflicting changes").

Structs

RevisionCollection

A read-only collection of Revision objects within a RevisionLog.