StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSharepoint 2007 with MS Office 2007 footers
text
Body
copied!<p>We had a need for a <strong>document management solution</strong> and were hoping <code>SharePoint 2007</code> would satisfy our needs. We felt our needs were relatively simple. We needed to manage <strong>versioning</strong>, have <strong>searching capabilities</strong>, and having an <strong>approval workflow</strong>.</p> <p><code>SharePoint</code> handled these three aspects great out of the box.</p> <p>However, we also require that the footer on the Office 2007 (Word, Excel, and PowerPoint) documents reflect the document version, last person to modify, and last modification date. These things can be done with office automation, but we have yet to find a complete solution.</p> <p>We first tried to do it on the checking-in and checked-in events and followed this path for a while, however, the complication we ran into was after we made the changes to the document we had to no way of preventing the save from updating the version number. This resulted in something similar to this:</p> <p>Document checked-in – the document version should be v0.1 however it is v0.2 because we save the document after the footer is replaced. If we look in the document history we there are 2 separate versions v0.1 does not have the footer v0.2 has the footer but it says v0.1 as that is the version the document was when it was replaced.</p> <p>This is an unacceptable solution for us as we want the process to be completely handled on the user side so they would have full control to revert back to a version where the footer would be incorrect and not contain the correct data. When we attempted to create a custom approval/check-in workflow we found that the same problem was present. The footer is necessary so that hard-copies can be traced back to their electronic counterpart.</p> <p>Another solution that was proposed to us was to build plugins for office that would handle the replacement of the footer. This is inadequate for our needs as it requires a client side deployment of our plugins which is undesirable by our clients. What we are looking for is a clean solution to this problem.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload