The Sun ODF Plugin for Microsoft Office and the Excel issue after uninstalling or upgrading the Plugin

Many people complain about an issue they have with Excel after uninstalling or upgrading the Sun ODF Plugin for Microsoft Office: When starting Excel, Excel complains that the Add-In odfaddin.xla can't be found: 'C:\\Program Files\\Sun\\Sun ODF Plugin for Microsoft Office <old version>\\converter\\odfaddin.xla' could not be found. (...)

I would like to point out that this is not an issue from the ODF Plugin installer, but in Excel itself:

The ODF Plugin installer writes some HKEY_LOCAL_MACHINE entries into the registry to activate the Plugin, and these entries are removed when uninstalling the Plugin, or point to the correct version when doing an upgrade installation. But for some reason, Excel will put a reference to the Add-In file odfaddin.xla into the user's configuration (HKEY_CURRENT_USER) when starting Excel after the ODF Plugin installation. This entry - of course - won't be removed from the installer when uninstalling the ODF Plugin.

So to get rid of the annoying error message, you need to remove that reference yourself:

In Office 2007, use Microsoft Office Button => Excel Options => Add-Ins => Manage Excel Add-ins (Go...) => uncheck "Odfaddin". In older versions, use Tools => Add-Ins => uncheck "Odfaddin"

If it doesn't work (which seems to happen at least in Office 2007 after upgrading the ODF Plugin), remove the reference to the old Add-In in the registry directly: HKEY_CURRENT_USER\\Microsoft\\Office\\<version>\\Excel\\Options => "OPEN"="\\"C:\\\\Program Files\\\\Sun\\\\Sun ODF Plugin for Microsoft Office <old version>\\\\converter\\\\odfaddin.xla\\""

In more detail - this happens in the different phases when installing the ODF Plugin, running Excel and then uninstalling or upgrading the ODF Plugin:

Step 1: Installing the ODF Plugin:

 

  + [HKEY_LOCAL_MACHINE\\SOFTWARE\\Classes\\CLSID\\{16A1C170-D2C8-423B-AEC6-BAD7A26F1828}\\InprocServer32]
  + @="C:\\\\Program Files\\\\Sun\\\\Sun ODF Plugin for Microsoft Office 3.1\\\\converter\\\\odfaddin.dll"

  + [HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Office\\Excel\\Addins\\ODFAddIn.Connect]
  + "Description"="Load and save files in OASIS OpenDocument format"
  + "FriendlyName"="ODF Add-in"
  + "LoadBehavior"=dword:00000003 
 
Step 2: Starting Excel (now Excel creates the entry that leads to the problem):

 

  + [HKEY_CURRENT_USER\\Microsoft\\Office\\12.0\\Excel\\Options]
  + "OPEN"="\\"C:\\\\Program Files\\\\Sun\\\\Sun ODF Plugin for Microsoft Office 3.1\\\\converter\\\\odfaddin.xla\\""
 
Step 3a: Uninstalling the ODF Plugin (all entries written by the installer are being removed): 

 

  - [HKEY_LOCAL_MACHINE\\SOFTWARE\\Classes\\CLSID\\{16A1C170-D2C8-423B-AEC6-BAD7A26F1828}\\InprocServer32]
  - @="C:\\\\Program Files\\\\Sun\\\\Sun ODF Plugin for Microsoft Office 3.1\\\\converter\\\\odfaddin.dll"

  - [HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Office\\Excel\\Addins\\ODFAddIn.Connect]
  - "Description"="Load and save files in OASIS OpenDocument format"
  - "FriendlyName"="ODF Add-in"
  - "LoadBehavior"=dword:00000003

  still there (of course!):
  HKEY_CURRENT_USER\\Microsoft\\Office\\12.0\\Excel\\Options]
  "OPEN"="\\"C:\\\\Program Files\\\\Sun\\\\Sun ODF Plugin for Microsoft Office 3.1\\\\converter\\\\odfaddin.xla\\""
 
Step 3b: Upgrading the ODF Plugin, instead of uninstalling:

  [HKEY_LOCAL_MACHINE\\SOFTWARE\\Classes\\CLSID\\{16A1C170-D2C8-423B-AEC6-BAD7A26F1828}\\InprocServer32]
  - @="C:\\\\Program Files\\\\Sun\\\\Sun ODF Plugin for Microsoft Office 3.1\\\\converter\\\\odfaddin.dll"
  + @="C:\\\\Program Files\\\\Sun\\\\Sun ODF Plugin for Microsoft Office 3.2\\\\converter\\\\odfaddin.dll" 

 

  still there (of course!):
  HKEY_CURRENT_USER\\Microsoft\\Office\\12.0\\Excel\\Options]
  "OPEN"="\\"C:\\\\Program Files\\\\Sun\\\\Sun ODF Plugin for Microsoft Office 3.1\\\\converter\\\\odfaddin.xla\\""
 

So if Excel has a reference to the Add-In, Excel should probably simply disable the Add-In when it doesn't exist anymore, instead of complaining over and over again. Or at least ask the user whether or not to keep the entry...

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Malte Timmermann

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today