Add ability to enable change tracking
Created originally on Bitbucket by Jacob Floyd
I would like to enable change tracking (revisions) in a generated spreadsheet. I do not need to record or work with those changes, I just need to initialize the revisions section of a workbook.
Looking in a blank spreadsheet with this enabled I see:
xl/revisions/_rels/revisionHeaders.xml.rels
xl/revisions/revisionHeaders.xml
xl/revisions/revisionLog1.xml
xl/revisions/userNames.xml
The only files with any content that would need to be adjusted for the workbook (the others only need the default content):
xl/revisions/revisionHeaders.xml
- guid attribute on headers element and on child header element
- dateTime and userName attr on child header element.
- sheet counts: maxSheetId on header; count on sheetIdMap element (child of header); and sheetId elements (children of sheetIdMap).
xl/_rels/workbook.xml.rels
- Needs references to revisions/userNames.xml and revisions/revisionHeaders.xml