msofficesvn/msofficesvn

MSOfficeSVN is a Subversion (SVN) client interface for MS Excel, MS Word and MS PowerPoint.

MSOfficeSVN

What is it

MSOfficeSVN is a set of add-ins for Microsoft Office Excel, Word and PowerPoint that assists for document version control through Subversion (SVN).
Thanks to the MSOfficeSVN package, you can now easily version-control your MS Office files right from the MS Office menu!

MSOfficeSVN is based on TortoiseSVN, an established Subversion client for Windows.

Main features:

• Invoke the most frequently used version control commands directly from Microsoft Office: Update, Lock, Commit, Diff, Log, and others
• Allow shortcut keys to trigger SVN commands ; the key mapping is customizable
• Notify the user if the svn:needs-lock property is in use (i.e. trying to edit a read-only file)

edition	screenshot
PowerPoint 2016 (EN)
Word 2007 (EN)
Excel 97 (JA)

How to use

1. MSOfficeSVN is based on TortoiseSVN, that's why you need to have previously installed TortoiseSVN for MSOfficeSVN to work!
2. MSOfficeSVN comes as a package of multiple add-ins. Follow the instructions to install the add-in(s) of your choice:
   a. English Instructions
   b. Japanese Instructions

Compatibility

TortoiseSVN is a Windows-only software, so does MSOfficeSVN.
In other words, MSOfficeSVN is not compatible with Mac OS versions of Microsoft Office.

As of April 29, 2021, we decided to stop supporting MS Office 2003 and older. Already released versions of MSOfficeSVN may fortunately be compatible with those old versions of MS Office.

The latest release 1.4.0 is compatible:

• Up to Microsoft Office 2019 (at least)
• Down to Microsoft Office 97
• With 32bit and 64bit versions of MS Office
• Up to TortoiseSVN 1.14.1 (at least)
• Down to TortoiseSVN 1.7
• With Windows OS (32bit, 64bit) where WSH is installed

Since release 1.3.0, MSOfficeSVN supports TortoiseSVN 1.7 (or later).

Known limitations

The add-ins apply the commands to only the active document or book, so you can't use it when you wish to edit multiple files and commit them at the same time to make a "change set".

How to contribute

If you want to add your contribution to our project feel free to fork the repository, commit your changes and submit a pull-request.
You are encouraged to read the GitHub fork guide.

License(s) to use/share

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

Credits

Koki Yamamoto ([email protected])

We appreciate the valuable contribution of the original authors who created the initial programs and opened their source code to the public:
Mr. Osamu OKANO (http://dkiroku.com/2005-07-01-11.html)
Mr. Kazuyuki NAGAMORI (http://www.nekoconeko.com/~nagamori/wordsvn/)

---

Functional overview

Commands

The add-ins can apply the following commands to the active workbook and document.

• SVN Update
• SVN Get lock
• SVN Commit
• SVN Diff
• SVN Show log
• SVN Repo-browser
• SVN Release lock
• SVN Add
• SVN Delete
• Open Explorer

Regarding Update, Get lock, Commit and Release lock, the active document or book is first closed then reopen after having applied the SVN command in order to refresh the document status.

Open Explorer opens the Windows Explorer and selects the active document or book.

Needs-lock detection (a.k.a. Auto-lock feature)

Binary files stored inside a Subversion repository usually get the svn:needs-lock property. This forces the user to take an exclusive lock on a file before editing it, thus avoiding conflicts of two or more people working on the same file at the same time.
http://svnbook.red-bean.com/en/1.8/svn.advanced.locking.html

As a consequence, TortoiseSVN applies a Read-only file-system flag on each file that has the svn:needs-lock property.
https://tortoisesvn.net/docs/release/TortoiseSVN_en/tsvn-dug-locking.html

In MSOfficeSVN, we detect the svn:needs-lock and offer the possibility to take the lock on the file and make it writable. This is a way to avoid making modifications on a file you won't be able to save in the end.

Ribbon interface and Tool bar support

This set of add-ins supports the ribbon interface of Office 2007 and newer.
For versions where Office 2003 and older is supported (no ribbon), we provide a Tool bar instead.

Shortcut keys

Shortcut keys are assigned by default for the Subversion commands.
You may edit the shortcuts mapping if you want.

Option settings

The following option settings are available.

• Turn on/off displaying a message asking data file saving while performing a command.
• Turn on/off closing and reopening the data file in performing commit command.
• Turn on/off auto closing of the progress dialog box in the end of performing Update, Commit.

Instructions for those settings to be edited are given by the customization documentation page.

Screenshots of the available packages

edition	screenshot
Excel 2016 (EN)
PowerPoint 2016 (EN)
Word 2016 (EN)
Word 2007 (EN)
Excel 2007 (EN)
Word 2007 (JA)
Excel 2007 (JA)
Word 97 (JA)
Excel 97 (JA)

msofficesvn's Issues

Jump to previous cursor position when the file is reopned.

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 4 Dec 2007 at 2:59

Compatibility for Office 365 for Bussiness

Does MSOffice SVN tool support Office 365? If yes, could you please explain how to install.

RegRead in Windows 7 64 bit

What steps will reproduce the problem?
1. install it in the Windows 7 64 bits
2. open RepoBrowse

What is the expected output? What do you see instead?
TortoiseSVN is launched.

What version of the product are you using? On what operating system?
Windows 7 64 bits

Please provide any additional information below.
The excelsvn_patch.txt is a quick patch.

Original issue reported on code.google.com by [email protected] on 28 Jul 2011 at 5:22

Attachments:

• excelsvn_patch.txt

Work on 2010

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?


Please provide any additional information below.
Well done!
But, it doesn't work on word 2010.
Word 2010+TSVN 1.6.15
Update and Commit commands don't work well.

Original issue reported on code.google.com by [email protected] on 25 Sep 2011 at 7:53

Word report error when close the modified read only file when get lock.

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 25 Aug 2008 at 5:55

Support for Publisher 2010

Hi there,

I wonder if it is possible to do a plugin for Microsoft Publisher 2010? It 
seems to only accept an com add-in so maybe not? I don't know much about office 
add-ins but will be keen to do some work for this if possible.


Cheers,
Chris

Original issue reported on code.google.com by [email protected] on 5 May 2012 at 11:26

Runtime error if you have activated windows explorer preview and open a powerpoint file

What steps will reproduce the problem?
1. activate windows explorer preview (reboot)
2. select a powerpoint file in your workingcopy  
3. error message comes up, or when you open that file and try it to lock

What is the expected output? What do you see instead?

Runtime error '-2147467259 (80004005)':

Presentation (unknown member): Invalid request. Automation rights are not 
granted.


What version of the product are you using? On what operating system?
1.3.2

Please provide any additional information below.
see screen

Original issue reported on code.google.com by [email protected] on 13 Nov 2012 at 1:38

Attachments:

• msofficesvn.png

Add-in does not remain in Excel 2016

Hello,

I installed the add-ins for Word, Excel and PowerPoint. For Word and PowerPoint, the ribbon bar entry remains even after I close the application and reopen it. For Excel, after I add the add-in, the tab appears in the ribbon bar, but as soon as I close Excel and re-open it, the tab is no longer there.

As far as I can tell, Excel is not disabling the add-in (it's not in the "disabled" list). Anyone else experiencing this?

Script is aborted when lock modified file.

What steps will reproduce the problem?
1. Modify the file under control of svn.
2. Get lock of the file.
3. Office application displays error and the add-in script are aborted.

What is the expected output? What do you see instead?
No error. No script abortion.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 2 Jul 2008 at 2:17

The Word-Plugin does not work when Word has a customized menu bar

The Word-Plugin did not work for me, since we have a customized menu bar,
where one item is not of type CommandBarPopup.

So, attached you can find a modified version of InstallSvnMenu and
DeleteSvnMenu, where the type is checked and only if it is or correct type
it is casted.

Red is your original code, green my modifications.

You are welcome to use my changes in your code. 

---
Sub InstallSvnMenu()
  ' Menu control object
  'Dim ctlMainMenu As CommandBarPopup
  Dim ctlMainMenu As CommandBarControl
  Dim ctlMainMenuPopup As CommandBarPopup
  Dim mnuSvn      As CommandBarControl
  Dim mnuSub1     As CommandBarButton
  Dim mnuSub2     As CommandBarButton
  Dim mnuSub3     As CommandBarButton
  Dim mnuSub4     As CommandBarButton
  Dim mnuSub5     As CommandBarButton
  Dim mnuSub6     As CommandBarButton
  Dim mnuSub7     As CommandBarButton
  Dim mnuSub8     As CommandBarButton
  Dim mnuSub9     As CommandBarButton
  Dim mnuSub10    As CommandBarButton

  ' If Subversion menu control already exists, exit subroutine

  ' Orig Code... does not work
  'For Each ctlMainMenu In Application.CommandBars(gMainMenuName).Controls
  '  If ctlMainMenu.Caption = gcapSvnMenuBar Then
  '    Exit Sub
  '  End If
  'Next

  For Each ctlMainMenu In Application.CommandBars(gMainMenuName).Controls
    If ctlMainMenu.Type = msoControlPopup Then
        Set ctlMainMenuPopup = ctlMainMenu
        If ctlMainMenuPopup.Caption = gcapSvnMenuBar Then
            Exit Sub
        End If
    End If
  Next

… rest identical

Sub DeleteSvnMenu()

  ' Orig Code... does not work  
  ' Command bar control object
  'Dim ctlMainMenu As CommandBarPopup

  ' If Subversion menu exists, delete it.
  'For Each ctlMainMenu In Application.CommandBars(gMainMenuName).Controls
  '  If ctlMainMenu.Caption = gcapSvnMenuBar Then
  '    Application.CommandBars(gMainMenuName).Controls(gcapSvnMenuBar).Delete
  '  End If
  'Next

  ' New Code by RB...

  Dim ctlMainMenu As CommandBarControl
  Dim ctlMainMenuPopup As CommandBarPopup

  ' If Subversion menu exists, delete it.
  For Each ctlMainMenu In Application.CommandBars(gMainMenuName).Controls
    If ctlMainMenu.Type = msoControlPopup Then
        Set ctlMainMenuPopup = ctlMainMenu
        If ctlMainMenuPopup.Caption = gcapSvnMenuBar Then

Application.CommandBars(gMainMenuName).Controls(gcapSvnMenuBar).Delete
        End If
    End If
  Next

End Sub 

---

Original issue reported on code.google.com by [email protected] on 28 Oct 2009 at 3:09

Error loading pptsvn in Powerpoint 2016

C:\Users<username>\AppData\Roaming\Microsoft\AddIns\pptsvn.ppam is not a valid Office Add-in.

Please advise. The Excel and Word loaded without issue.

Support Office 2007 ribbon interface

A user's request

---
I noticed the UI for the word addon runs in a compatibility mode of sorts,
under the "Add-Ins" (eng.) tab - would it be possible to use the Office
Fluent interface for it, at least as an option instead of the traditional
Office 97-2003 UI? I find I have to tab switch over to it quite frequently,
and Word doesn't expose the individual toolbar buttons for use in the
quick-access toolbar unless they're ribbon-aware.

Just a handy feature you might like to look into :)

---

Original issue reported on code.google.com by [email protected] on 27 Jul 2008 at 6:07

Runtime Error 4248 occurs when enable editing

What steps will reproduce the problem?
1. Open a word document file on a server by Word 2010.
2. Click Enable Editing button above the document.
3. Runtime Error 4248 occurs.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 14 Jul 2014 at 4:36

Attachments:

• word_runtime_error_4248.png

Installer / Uninstaller

Can anyone write a installer/uninstaller that copies/deletes the files.
Thanks!

Original issue reported on code.google.com by [email protected] on 4 Jun 2012 at 4:44

use SVN Revision in Office Document

We are using SVN for Office Dokuments as well. Some weeks ago I tried
with no success to get the SVN Revision number somewhere visably in the
Office Document. This number can be used in a Document History or Meta data
of the document.

Original issue reported on code.google.com by [email protected] on 6 Aug 2009 at 1:36

Need to support "use _svn folder" option of TortoiseSVN

[Content of the bug]

[TortoiseSVN]の設定にて
[".svn"ディレクトリの代わりに"_svn"を使用する]にチェックを
入れて使用すると、
バージョンコントロール下のフォルダのファイルでない旨��
�メッセージが表示され
コミット等ができません。

以下記事を発見したのですが"_svn"フォルダに変更時でも対��
�可能でしょうか？
http://www.in-vitro.jp/blog/index.cgi/Subversion/20060305_01.html

ちなみに私の環境の環境変数では
"SVN_ASP_DOT_NET_HACK=* " となっていたので
環境変数に"SVN_ASP_DOT_NET_HACK"が宣言されている場合"_svn"（な�
��か？）
と勝手に推測しております

---

[Walk around]

添付ファイルは_svnを使用するオプションがオンのときのみ�
��える日本語版アドイ
ンです。このアドインは暫定版です。

Original issue reported on code.google.com by [email protected] on 23 Aug 2009 at 2:56

Attachments:

• msosvn_svnopt.zip

Word 2010 x64 error.

What steps will reproduce the problem?
1. Follow the intallation instructions and placed the files in the Startup 
folder.
2. Open MS Word (MS Office 2010 version 14.0.6112.5000 64bit)
3. Mesaage box appears which says "compile error in hidden module: cmnIniFile. 
This error commonly occurs when code is incompatible with the version, platform 
or architecture of this application."
4. All the buttons on the ribbon don't work.

What version of the product are you using? On what operating system?
Version 132

Please provide any additional information below.
IF you can let me know how to build the dotm file in MS Word I can try to fix 
this. I am unfamiliar on how Word builds these files.

Original issue reported on code.google.com by [email protected] on 29 May 2012 at 5:22

auto-lock function is not working

What steps will reproduce the problem?

1. activate autolock function settings as described in 
http://code.google.com/p/msofficesvn/wiki/CustomSetting
2. no effects, its like before



What is the expected output? What do you see instead?

auto-lock feature

What version of the product are you using? On what operating system?

- needs lock property is set
- msofficesvn 1.3.2. or 1.4.0.
- Win7
- Office 2010 Prof 32 Bit

Original issue reported on code.google.com by [email protected] on 6 May 2013 at 9:01

Registory access problem on x64

Confirmed this works in Office 2010 Beta.

However, on x64 installations of windows, read/writes to the
HKEY_LOCAL_MACHINE\SOFTWARE by 32bit programs are redirected to
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node

This means that word will throw up a 80007002 error when it tries to read
the registry because TortoiseSVN doesn't make keys in that spot. The
solution is to duplicate the HKLM\Software\TortoiseSVN keys to
HKLM\Software\Wow6432Node?\TortoiseSVN and then this macro will work just fine.

Original issue reported on code.google.com by [email protected] on 2 Apr 2010 at 4:24

Add SVN 1.7 support

Add support for SVN 1.7 and later.

Original issue reported on code.google.com by [email protected] on 9 Nov 2011 at 12:39

Don't close and open a file in commit when the file doesn't need lock.

What steps will reproduce the problem?
1. Prepare the file that doesn't need lock because it is not shared among
several persons.
2. Commit it.
3. The file is closed and opened needlessly.

What is the expected output? What do you see instead?

 When the file doesn't have svn:needs-lock property, don't close it.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 4 Dec 2007 at 2:52

Not working with MS Office 2010 64 bits

What steps will reproduce the problem?
1. Install files as directed

What is the expected output? What do you see instead?
Subversion ribbon in any open documents, or at least in those already 
registered with TortoiseSVN.

Subversion ribbon appears only when the template itself is open.


What version of the product are you using? On what operating system?
1.4 on MS Windows 7.


Please provide any additional information below.
Could not check the registry as regedit is restricted by network administrators.

Original issue reported on code.google.com by [email protected] on 22 May 2013 at 6:35

Run time error 91 occurs in first commit in wordsvn 1.10alpha.

What steps will reproduce the problem?
1. Open a doc file by Word97.
2. Commit it.
3. Run time error 91 occurs

What is the expected output? What do you see instead?
Expect no error.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 16 May 2008 at 7:31

The svn deleted file must be closed before committing.

What steps will reproduce the problem?
1. SVN Delete
2. SVN Commit subsequently

What is the expected output? What do you see instead?
The svn deleted file must be closed before committing.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 25 May 2008 at 3:53

Can't assign short-cut key on Excel

What steps will reproduce the problem?
1. Word can assign short-cut key but Excel can't.
2.
3.

What is the expected output? What do you see instead?



Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 4 Dec 2007 at 3:04

Need description of update from old version

The installation document needs description of update from old version.

Original issue reported on code.google.com by [email protected] on 25 Aug 2008 at 5:53

Save file before diff

What steps will reproduce the problem?
1. Modify the file
2. Perform diff
3. No modification is detected

What is the expected output? What do you see instead?

 Ask user to save the modified file before performing diff

Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 4 Dec 2007 at 2:17

Within a folder with one or more Excel files, ExcelSVN will not work one of the Excel file.

What steps will reproduce the problem?
1. Create a SVN controlled folder with just one xlsx file. Make sure the folder 
and the xlsx file is committed in the subversion repository.
2. Open the file with Excel 2010 with ExcelSVN.
3. Click "Update" in "Subversion" tab.

What is the expected output? What do you see instead?

Expected output: TortoiseSVN should be triggered to update current file.

Actual output: Error message: "The active workbook is currently not in a folder 
under version control"

What version of the product are you using? On what operating system?

MSOfficeSVN 1.3.0
Office 2010
TortoiseSVN x64 1.7.3
Windows 7 x64

Please provide any additional information below.

Workaround: You can put a empty text file in the folder to make SubVersion 
correctly identify the folder is under version control.

Original issue reported on code.google.com by [email protected] on 12 Jan 2012 at 1:55

Needs to change module composition

 * Change the name of module to make it clear that what the module do.
 * Divide large module like common.bas.

Original issue reported on code.google.com by [email protected] on 9 May 2008 at 12:59

Display full path name of the file in "Not under version control folder" error.

What steps will reproduce the problem?
1. Add or commit the file that is not under version control folder.
2. Error message is displayed. But the file name of in the error message is
only file name.
3.

What is the expected output? What do you see instead?

Display full path name of the file in "Not under version control folder" error.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 4 Dec 2007 at 3:13

SVN command bar is always invoked as floating bar on Word

What steps will reproduce the problem?
1. Start Word
2. SVN command bar is displayed as floating bar
3.

What is the expected output? What do you see instead?

 Memorize previous position and dock other tools bar when it is invoked.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 4 Dec 2007 at 2:46