Difference between revisions of "OpenOffice.org 3.x"

From WPKG | Open Source Software Deployment and Distribution
Jump to: navigation, search
(Avoid registration window)
 
(26 intermediate revisions by 20 users not shown)
Line 1: Line 1:
−
This is a silent installer and uninstaller for OpenOffice.org 3 (from OpenOffice.org / Sun Microsystems).
+
This is a silent installer and uninstaller for OpenOffice.org 3 (from OpenOffice.org/Sun Microsystems).
 +
 
 +
 
 +
== OpenOffice.org 3.4.1 ==
 +
 
 +
Download the installer http://www.openoffice.org/download/ and let the Installer unpack the files. Stop the setup and copy everything in your %SOFTWARE% Directory, customize with Microsoft ORCA tool if needed.
 +
 
 +
The product code for an English OpenOffice.org installation is different to the product code for a German or Italian installation. OpenOffice.org saves this Productcode into the setup.ini that is located in the program directory of OpenOffice.org (%PROGRAMFILES%\Openoffice3.3\setup.ini).
 +
 
 +
<source lang="xml">
 +
<package
 +
    id="OpenOffice"
 +
    name="OpenOffice.org 3.4.1"
 +
    revision="4"
 +
    reboot="false"
 +
    priority="0">
 +
 
 +
    <variable name="version" value="3.4.9593.500" />
 +
    <variable name="code" value="{7DA1C06F-C913-46C7-8A0F-DA2CBA17EA1D}" />
 +
 +
    <check type="file" condition="versionequalto" path="%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" value="%version%" architecture="x86" />
 +
    <check type="file" condition="versionequalto" path="%PROGRAMFILES% (x86)\OpenOffice.org 3\program\soffice.exe" value="%version%" architecture="x64" />
 +
 +
    <install cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" msiexec /qn /x %code%' architecture="x86" />
 +
    <install cmd='%COMSPEC% /C if exist "%PROGRAMFILES% (x86)\OpenOffice.org 3\program\soffice.exe" msiexec /qn /x %code%' architecture="x64" />
 +
    <install cmd='msiexec /qn /i "%SOFTWARE%\OpenOffice\3.41\openofficeorg341.msi" SETUP_USED=1 ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 +
 +
    <upgrade cmd='msiexec /qn /i "%SOFTWARE%\OpenOffice\3.41\openofficeorg341.msi" SETUP_USED=1 ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 +
 +
    <remove cmd='msiexec /qn /x %code%' />
 +
  </package>
 +
</source>
 +
 
 +
 
 +
Please note, that if you encounter any errors stating that you should use setup.exe, you could use [http://www.instedit.com/ InstEd (free msi editor)] in order to remove the check (search for '''SETUP_USED''') and remove the row. After this the installation continues as usual.
 +
 
 +
Additional note:
 +
This error can be avoided by adding '''SETUP_USED=1''' to msi paramters.
 +
 
 +
More advice:
 +
Quickstarter should be terminated before installing or upgrading:
 +
 
 +
<source lang="xml">
 +
  <install cmd="taskkill /F /IM soffice.exe">
 +
    <exit code="any" />
 +
  </install>
 +
  <install cmd="taskkill /F /IM soffice.bin">
 +
    <exit code="any" />
 +
  </install>
 +
 
 +
  <upgrade cmd="taskkill /F /IM soffice.exe">
 +
    <exit code="any" />
 +
  </upgrade>
 +
  <upgrade cmd="taskkill /F /IM soffice.bin">
 +
    <exit code="any" />
 +
  </upgrade>
 +
 
 +
</source>
 +
 
 +
It seems that the [https://issues.apache.org/ooo/show_bug.cgi?id=119802 installer has a bug] when upgrading an existing OpenOffice installation. A simple workaround is to rename an existing "program" subfolder first and delete it after installation:
 +
 
 +
Before install/upgrade command:
 +
<source lang="xml">
 +
  <upgrade  architecture="x86" cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program" ren "%PROGRAMFILES%\OpenOffice.org 3\program" "program.old"' />
 +
  <upgrade  architecture="x64" cmd='%COMSPEC% /C if exist "%PROGRAMFILES(X86)%\OpenOffice.org 3\program" ren "%PROGRAMFILES(X86)%\OpenOffice.org 3\program" "program.old"' />
 +
</source>
 +
 
 +
After install/upgrade command:
 +
<source lang="xml">
 +
  <upgrade  architecture="x86" cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program.old" rd /S /Q "%PROGRAMFILES%\OpenOffice.org 3\program.old"' />
 +
  <upgrade  architecture="x64" cmd='%COMSPEC% /C if exist "%PROGRAMFILES(X86)%\OpenOffice.org 3\program.old" rd /S /Q "%PROGRAMFILES(X86)%\OpenOffice.org 3\program.old"' />
 +
 
 +
</source>
 +
 
 +
== OpenOffice.org 3.3 ==
 +
 
 +
Download the installer http://download.openoffice.org/ and let the Installer unpack the files. Stop the setup and copy everything in your %SOFTWARE% Directory, customize with Microsoft ORCA tool if needed.
 +
 
 +
The product code for an English OpenOffice.org installation is different to the product code for a German or Italian installation. OpenOffice.org saves this Productcode into the setup.ini that is located in the program directory of OpenOffice.org (%PROGRAMFILES%\Openoffice3.3\setup.ini), BUT it seems that setup.ini gave an incorrect build number on this occasion.
 +
 
 +
 
 +
<source lang="xml">
 +
<package id="openoffice" name="OpenOffice.org 3.3" revision="3" reboot="false" priority="5">
 +
  <!-- The product version 3.3.9567 and code 3E171899-0175-47CC-84C4-562ACDD4C021 come from the file /var/lib/wpkg/software/openoffice/3.3/setup.ini
 +
      BUT, the file version of soffice.exe seems to actually be 3.3.9556.500 by going through the debug logs and confirming by looking at view
 +
      properties of  C:\Program Files\OpenOffice.org 3\program\soffice.exe -->
 +
 
 +
  <check type="logical" condition="or">
 +
    <check type="file" condition="versionequalto" path="%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" value="3.3.9556.500" />
 +
    <check type="file" condition="versionequalto" path="%PROGRAMFILES(x86)%\OpenOffice.org 3\program\soffice.exe" value="3.3.9556.500" />
 +
  </check>
 +
 
 +
  <install cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" msiexec /qn /x {3E171899-0175-47CC-84C4-562ACDD4C021}' />
 +
 
 +
  <install cmd='msiexec /qn /i "%SOFTWARE%\openoffice\3.3\openofficeorg33.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 +
 
 +
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\openoffice\3.3\openofficeorg33.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 +
 
 +
  <remove cmd='msiexec /qn /x {3E171899-0175-47CC-84C4-562ACDD4C021}' />
 +
</package>
 +
 
 +
</source>
 +
 
 +
 
 +
Please note, that if you encounter any errors stating that you should use setup.exe, you could use [http://www.instedit.com/ InstEd (free msi editor)] in order to remove the check (search for '''SETUP_USED''') and remove the row. After this the installation continues as usual.
 +
 
 +
== OpenOffice.org 3.2.1 ==
 +
 
 +
Download the installer http://download.openoffice.org/ and let the Installer unpack the files. Stop the setup and copy everything in your %SOFTWARE% Directory, customize with Microsoft ORCA tool if needed.
 +
 
 +
The product code for an English OpenOffice.org installation is different to the product code for a German ({DFFC0648-BC4B-47D1-93D2-6CA6B9457641}) or Italian installation. OpenOffice.org saves this Productcode into the setup.ini that is located in the program directory of OpenOffice.org (%PROGRAMFILES%\Openoffice3.2\setup.ini).
 +
 
 +
Upgrade from 3.2 worked fine for me, so no previous install/uninstall checks.
 +
 
 +
<source lang="xml">
 +
<package id="openoffice32" name="OpenOffice.org 3.2" revision="321" reboot="false" priority="5">
 +
 
 +
  <check type="file" condition="versionequalto" path="%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" value="3.2.9498.500" />
 +
 
 +
  <install cmd='msiexec /qn /i "%SOFTWARE%\openoffice.org.3.2\openofficeorg32.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 +
 
 +
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\openoffice.org.3.2\openofficeorg32.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 +
 
 +
  <remove cmd='msiexec /qn /x {DFFC0648-BC4B-47D1-93D2-6CA6B9457641}' />
 +
</package>
 +
 
 +
</source>
 +
== OpenOffice.org 3.2.0 ==
 +
 
 +
Download the installer http://download.openoffice.org/, unpack files to a local directory, customize with Microsoft ORCA tool if needed, and upload to your software source repository the following files:
 +
 
 +
The product code for an English OpenOffice.org installation set is different to the product code for a German or Italian installation set. OpenOffice.org saves this ProductCode into the setup.ini that is located in the program directory of OpenOffice.org.
 +
 
 +
<source lang="xml">
 +
<package id="openoffice32" name="OpenOffice.org 3.2.0" revision="320" reboot="false" priority="0">
 +
  <!--  http://download.openoffice.org/other.html -->
 +
  <check type="uninstall" condition="exists" path="OpenOffice.org 3.2" />
 +
  <install cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" msiexec /qn /x {97B3824E-B2D2-4C49-A860-BCA56F10B040}' /> <!-- product code -->
 +
  <install cmd='msiexec /qn /i "%SOFTWARE%\bureautique\openoffice.org.3.2.0\openofficeorg32.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' /><!---->
 +
  <upgrade cmd='msiexec /qn /x {7C35B9AB-2CE3-4C18-BE7C-5B97EA089EB3}' /> <!-- upgrade code -->
 +
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\bureautique\openoffice.org.3.2.0\openofficeorg32.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 +
  <remove cmd='msiexec /qn /x {97B3824E-B2D2-4C49-A860-BCA56F10B040}' /> <!-- Product code found in %PROGRAMFILES%\Openoffice3.2\setup.ini } -->
 +
</package>
 +
 
 +
</source>
 +
== OpenOffice.org 3.1.1 ==
 +
The product code for an English OpenOffice.org installation set is different to the product code for a German or Italian installation set. OpenOffice.org saves this ProductCode into the setup.ini that is located in the program directory of OpenOffice.org.
 +
 
 +
 
 +
Problem: OO 3.1.0 and 3.1.1 both announces themself as OO 3.1. While the original Installer (.exe) upgrades an OO 3.1.0 to OO 3.1.1 well, the extracted 3.1.1 MSI-Installer (as described below for OO 3.1.0) does not work. The described check on path "OpenOffice.org 3.1" does not work either. So here is my new package config for OO.
 +
 
 +
<source lang="xml">
 +
<?xml version="1.0" encoding="UTF-8"?>
 +
<packages>
 +
<package id="openoffice" name="OpenOffice.org 3.1.1" revision="311" reboot="false" priority="0">
 +
 
 +
  <check type="file" condition="versionequalto" path="%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" value="3.1.9420.500" />
 +
  <install cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" msiexec /qn /x {D765F1CE-5AE5-4C47-B134-AE58AC474740}' />
 +
  <install cmd='msiexec /qn /i "%SOFTWARE%\ooo311\openofficeorg31.msi" ALLUSERS=1 ADDLOCAL=ALL' />
 +
  <upgrade cmd='msiexec /qn /x {D765F1CE-5AE5-4C47-B134-AE58AC474740}' />
 +
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\ooo311\openofficeorg31.msi" ALLUSERS=1 ADDLOCAL=ALL' />
 +
  <remove cmd='msiexec /qn /x {D765F1CE-5AE5-4C47-B134-AE58AC474740}' />
 +
 
 +
</package>
 +
</packages>
 +
</source>
 +
 
 +
 
 +
=== Without Quickstart and Online-Update ===
 +
 
 +
As described below you only have to add "REMOVE=gm_o_Quickstart,gm_o_Onlineupdate" to the parameter list of msiexec when installing the new msi.
 +
 
 +
== OpenOffice.org 3.1.0 ==
  
 
Download the installer http://download.openoffice.org/, unpack files to a local directory, customize with Microsoft ORCA tool if needed, and upload to your software source repository the following files:
 
Download the installer http://download.openoffice.org/, unpack files to a local directory, customize with Microsoft ORCA tool if needed, and upload to your software source repository the following files:
  
 +
java/
 
  licenses/
 
  licenses/
 
  readmes/
 
  readmes/
 +
redist/
 
  instmsia.exe
 
  instmsia.exe
 
  instmsiw.exe
 
  instmsiw.exe
−
  ooo300.mst                          # Microsoft Transform File created by you with the ORCA tool, this is not necessary
+
  ooo31.mst                          # Microsoft Transform File created by you with the ORCA tool, this is not necessary
 
  openofficeorg1.cab
 
  openofficeorg1.cab
−
  openofficeorg30.msi
+
  openofficeorg31.msi
 
  setup.exe
 
  setup.exe
−
  setup.ini                           # this file contains the numeric ID you need for uninstallation, {85F0337D-33AC-43B4-A003-DF35061F1D8D} in case of italian localized version
+
  setup.ini                         # this file contains the numeric ID you need for uninstallation, {43A650AA-D1DC-4C52-8819-D7848B3A08DA} in case of italian localized version
  
−
This example is for the italian localization, and associates OpenOffice as the default program for DOC, XLS and PPT files. Please update when the final will be released, adapt to your localizations, and change file associations to your needs.
+
This example is for the italian localization, and associates OpenOffice as the default program for DOC, XLS and PPT files. Adapt to your localizations and change file associations to your needs.
  
  
Line 19: Line 193:
 
<?xml version="1.0" encoding="UTF-8"?>
 
<?xml version="1.0" encoding="UTF-8"?>
 
<packages>
 
<packages>
−
<package id="openoffice300-ita" name="OpenOffice.org 3.0.0 italian" revision="1" reboot="false" priority="0">
+
<package id="openoffice31-ita" name="OpenOffice.org 3.1 italian" revision="1" reboot="false" priority="0">
  
−
   <check type="uninstall" condition="exists" path="OpenOffice.org 3.0" />
+
   <check type="uninstall" condition="exists" path="OpenOffice.org 3.1" />
−
   <install cmd='msiexec /qn /i "%SOFTWARE%\ooo300-ita\openofficeorg30.msi" TRANSFORMS=%SOFTWARE%\ooo300-ita\ooo300.mst ALLUSERS=1 SELECT_WORD=1 SELECT_EXCEL=1 SELECT_POWERPOINT=1' />
+
   <install cmd='msiexec /qn /i "%SOFTWARE%\ooo310-ita\openofficeorg31.msi" TRANSFORMS=%SOFTWARE%\ooo310-ita\ooo31.mst ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1' />
−
   <upgrade cmd='msiexec /qn /i "%SOFTWARE%\ooo300-ita\openofficeorg30.msi" TRANSFORMS=%SOFTWARE%\ooo300-ita\ooo300.mst ALLUSERS=1 SELECT_WORD=1 SELECT_EXCEL=1 SELECT_POWERPOINT=1' />
+
   <upgrade cmd='msiexec /qn /i "%SOFTWARE%\ooo310-ita\openofficeorg31.msi" TRANSFORMS=%SOFTWARE%\ooo310-ita\ooo31.mst ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1' />
−
   <remove  cmd='msiexec /qn /x {85F0337D-33AC-43B4-A003-DF35061F1D8D}' />
+
   <remove  cmd='msiexec /qn /x {43A650AA-D1DC-4C52-8819-D7848B3A08DA}' />
  
 
</package>
 
</package>
Line 32: Line 206:
  
 
Seems to reboot the system despite the reboot="false" option when Quickstart is already loaded (ie: execute wpkg-start.bat explicitly or manual restart the WPKGSrv).
 
Seems to reboot the system despite the reboot="false" option when Quickstart is already loaded (ie: execute wpkg-start.bat explicitly or manual restart the WPKGSrv).
 +
 +
== OpenOffice.org 3.1.0: Easy Installation without Quickstart and Online-Update ==
 +
 +
To install OpenOffice.org without the Quickstart-Application (parameter gm_o_Quickstart) and wihtout the automatic Onlineupdate (parameter gm_o_Onlineupdate) use this package file. Just extract the OpenOffice-Installer and call the setup with the following package file.
 +
 +
<source lang="xml">
 +
<package id="openoffice" name="OpenOffice.org 3.1" revision="310" reboot="false" priority="0">
 +
  <check type="uninstall" condition="exists" path="OpenOffice.org 3.1" />
 +
  <install cmd='msiexec /qn /i "%SOFTWARE%\openoffice\openofficeorg31.msi" ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 +
  <install cmd='cmd /c del /q /s "%Public%\Desktop\OpenOffice.org 3.1.lnk"' />
 +
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\openoffice\openofficeorg31.msi" ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 +
  <upgrade cmd='cmd /c del /q /s "%Public%\Desktop\OpenOffice.org 3.1.lnk"' />
 +
  <remove  cmd='msiexec /qn /x {43A650AA-D1DC-4C52-8819-D7848B3A08DA}' />
 +
</package>
 +
</source>
 +
 +
== Poor availability of installer without JRE ==
 +
 +
Beware that for many non-US localizations, italian included, OpenOffice.org installer is not available in the "without Java JRE" version. As a side effect, a "with Java JRE" is so bad behaved that it does create a directory %PROGRAMFILES%\JRE\ and copy the JRE installer "jre-windows-i586.exe" in it, even if you specified in the Microsoft Transform that JRE is not to be installed. Uninstallation then cleanly removes this directory, however this is a waste of resources and a waste of time.
 +
 +
Issue number 95374 has been filed in OpenOffice.org requesting "non JRE" installers for all localizations; it has been answered pointing out that resources for translation are short, so that not all versions are translated and submitted to the Quality Assurance process. Solution is to volunteer and help localization and QA teams.
 +
  
 
== Avoid registration window ==
 
== Avoid registration window ==
Line 39: Line 235:
 
<install cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\common.xcu' />
 
<install cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\common.xcu' />
 
<upgrade cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\setup.xcu' />
 
<upgrade cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\setup.xcu' />
−
<upgrade cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\common.xcu' /
+
<upgrade cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\common.xcu' />
 
</source>
 
</source>
 
You can get setup.xcu and common.xcu from this location:
 
You can get setup.xcu and common.xcu from this location:
 
http://wiki.services.openoffice.org/wiki/Documentation/Administration_Guide/Deactivating_Registration_Wizard
 
http://wiki.services.openoffice.org/wiki/Documentation/Administration_Guide/Deactivating_Registration_Wizard
  
−
== Poor availability of installer without JRE ==
 
  
−
Beware that for many non-US localizations, italian included, OpenOffice.org installer is not available in the "without Java JRE" version. As a side effect, a "with Java JRE" is so bad behaved that it does create a directory %PROGRAMFILES%\JRE\ and copy the JRE installer "jre-6u7-windows-i586-p.exe" in it, even if you specified in the Microsoft Transform that JRE is not to be installed. Uninstallation then cleanly removes this directory, however this is a waste of resources and a waste of time.
+
== File types associations  ==
  
−
Issue number 95374 has been filed in OpenOffice.org requesting "non JRE" installers for all localizations.
 
−
 
−
== File types associations  ==
 
 
Since Ooo does not configure file types other than ODF to be opened by default in Ooo I've created a registry file to set it (it has to be added for each user of the computer, so if you install Ooo as admin and have other users working consider adding batch script to 'All users'->'autostart'. Check [http://wpkg.org/Adding_Registry_Settings WPKG Adding Registry Settings] for details.
 
Since Ooo does not configure file types other than ODF to be opened by default in Ooo I've created a registry file to set it (it has to be added for each user of the computer, so if you install Ooo as admin and have other users working consider adding batch script to 'All users'->'autostart'. Check [http://wpkg.org/Adding_Registry_Settings WPKG Adding Registry Settings] for details.
  
−
In order to avoid this in future releases, issue number 95375 has been filed in OpenOffice.org requesting the restore of "SELECT_WORD=1/0" and "SELECT_EXCEL=1/0" installer command line switches, which do not seem to be effective in the 3.0.0 release.
+
In order to avoid this in future releases, issue number 95375 has been filed in OpenOffice.org requesting the restore of "SELECT_WORD=1/0" and "SELECT_EXCEL=1/0" installer command line switches, which do not seem to be effective in the 3.0.0 release. As a workaround, Sun answered that the command line switch "REGISTER_ALL_MSO_TYPES=1/0", or equivalently the .msi file property "REGISTER ALL MSO TYPES" should be used to get what requested.
  
  
Line 279: Line 471:
 
</source>
 
</source>
  
 +
== File Type Association - Alternative Method ==
 +
 +
The command "assoc" can be used to change file associations very easily, and doesn't require messing around with the registry.  This should work regardless of whether or not OO.o was installed using REGISTER_ALL_MSO_TYPES.
 +
 +
<code>associations.bat:</code>
 +
<source lang="winbatch">
 +
REM Word documents .doc, .docx etc.
 +
assoc .doc=OpenOffice.org.Doc
 +
assoc .dot=OpenOffice.org.Dot
 +
assoc .docx=OpenOffice.org.Docx
 +
assoc .docm=OpenOffice.org.Docm
 +
assoc .rtf=OpenOffice.org.rtf
 +
 +
REM Powerpoint slideshows, .ppt, .pptx etc.
 +
assoc .pps=OpenOffice.org.Pps
 +
assoc .ppsm=OpenOffice.org.Ppsm
 +
assoc .ppsx=OpenOffice.org.Ppsx
 +
assoc .ppt=OpenOffice.org.Pptx
 +
assoc .pptm=OpenOffice.org.Pptm
 +
assoc .pptx=OpenOffice.org.Pptx
 +
 +
REM Excel spreadsheets, .xls, .xlsx  etc.
 +
assoc .xls=OpenOffice.org.Xls
 +
assoc .xlt=OpenOffice.org.Xlt
 +
assoc .xlsb=OpenOffice.org.Xlsb
 +
assoc .xlsx=OpenOffice.org.Xlsx
 +
assoc .xlsm=OpenOffice.org.Xlsm
 +
assoc .xltx=OpenOffice.org.Xlsx
 +
assoc .xltm=OpenOffice.org.Xlsm
 +
</source>
  
 
== OpenOffice Extensions  ==
 
== OpenOffice Extensions  ==
Line 293: Line 515:
 
For instructions on automating installation of OpenOffice extensions, per-machine, see [http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Extensions/unopkg OpenOffice.org's wiki on unopkg].
 
For instructions on automating installation of OpenOffice extensions, per-machine, see [http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Extensions/unopkg OpenOffice.org's wiki on unopkg].
  
−
[[category:Silent Installers]][[category:NSIS]]
+
 
 +
[[category:Silent Installers]][[category:NSIS]][[category:OpenOffice]]

Latest revision as of 14:19, 3 October 2012

This is a silent installer and uninstaller for OpenOffice.org 3 (from OpenOffice.org/Sun Microsystems).


OpenOffice.org 3.4.1

Download the installer http://www.openoffice.org/download/ and let the Installer unpack the files. Stop the setup and copy everything in your %SOFTWARE% Directory, customize with Microsoft ORCA tool if needed.

The product code for an English OpenOffice.org installation is different to the product code for a German or Italian installation. OpenOffice.org saves this Productcode into the setup.ini that is located in the program directory of OpenOffice.org (%PROGRAMFILES%\Openoffice3.3\setup.ini). 

<package
    id="OpenOffice"
    name="OpenOffice.org 3.4.1"
    revision="4"
    reboot="false"
    priority="0">

    <variable name="version" value="3.4.9593.500" />
    <variable name="code" value="{7DA1C06F-C913-46C7-8A0F-DA2CBA17EA1D}" />
 
    <check type="file" condition="versionequalto" path="%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" value="%version%" architecture="x86" />
    <check type="file" condition="versionequalto" path="%PROGRAMFILES% (x86)\OpenOffice.org 3\program\soffice.exe" value="%version%" architecture="x64" />
 
    <install cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" msiexec /qn /x %code%' architecture="x86" />
    <install cmd='%COMSPEC% /C if exist "%PROGRAMFILES% (x86)\OpenOffice.org 3\program\soffice.exe" msiexec /qn /x %code%' architecture="x64" />
    <install cmd='msiexec /qn /i "%SOFTWARE%\OpenOffice\3.41\openofficeorg341.msi" SETUP_USED=1 ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 
    <upgrade cmd='msiexec /qn /i "%SOFTWARE%\OpenOffice\3.41\openofficeorg341.msi" SETUP_USED=1 ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
 
    <remove cmd='msiexec /qn /x %code%' />
  </package>


Please note, that if you encounter any errors stating that you should use setup.exe, you could use InstEd (free msi editor) in order to remove the check (search for SETUP_USED) and remove the row. After this the installation continues as usual.

Additional note: This error can be avoided by adding SETUP_USED=1 to msi paramters.

More advice: Quickstarter should be terminated before installing or upgrading: 

  <install cmd="taskkill /F /IM soffice.exe">
    <exit code="any" />
  </install>
  <install cmd="taskkill /F /IM soffice.bin">
    <exit code="any" />
  </install>

  <upgrade cmd="taskkill /F /IM soffice.exe">
    <exit code="any" />
  </upgrade>
  <upgrade cmd="taskkill /F /IM soffice.bin">
    <exit code="any" />
  </upgrade>

It seems that the installer has a bug when upgrading an existing OpenOffice installation. A simple workaround is to rename an existing "program" subfolder first and delete it after installation:

Before install/upgrade command: 

  <upgrade  architecture="x86" cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program" ren "%PROGRAMFILES%\OpenOffice.org 3\program" "program.old"' />
  <upgrade  architecture="x64" cmd='%COMSPEC% /C if exist "%PROGRAMFILES(X86)%\OpenOffice.org 3\program" ren "%PROGRAMFILES(X86)%\OpenOffice.org 3\program" "program.old"' />

After install/upgrade command: 

  <upgrade  architecture="x86" cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program.old" rd /S /Q "%PROGRAMFILES%\OpenOffice.org 3\program.old"' />
  <upgrade  architecture="x64" cmd='%COMSPEC% /C if exist "%PROGRAMFILES(X86)%\OpenOffice.org 3\program.old" rd /S /Q "%PROGRAMFILES(X86)%\OpenOffice.org 3\program.old"' />

OpenOffice.org 3.3

Download the installer http://download.openoffice.org/ and let the Installer unpack the files. Stop the setup and copy everything in your %SOFTWARE% Directory, customize with Microsoft ORCA tool if needed.

The product code for an English OpenOffice.org installation is different to the product code for a German or Italian installation. OpenOffice.org saves this Productcode into the setup.ini that is located in the program directory of OpenOffice.org (%PROGRAMFILES%\Openoffice3.3\setup.ini), BUT it seems that setup.ini gave an incorrect build number on this occasion. 


<package id="openoffice" name="OpenOffice.org 3.3" revision="3" reboot="false" priority="5">
  <!-- The product version 3.3.9567 and code 3E171899-0175-47CC-84C4-562ACDD4C021 come from the file /var/lib/wpkg/software/openoffice/3.3/setup.ini
       BUT, the file version of soffice.exe seems to actually be 3.3.9556.500 by going through the debug logs and confirming by looking at view
       properties of  C:\Program Files\OpenOffice.org 3\program\soffice.exe -->
  
  <check type="logical" condition="or">
    <check type="file" condition="versionequalto" path="%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" value="3.3.9556.500" />
    <check type="file" condition="versionequalto" path="%PROGRAMFILES(x86)%\OpenOffice.org 3\program\soffice.exe" value="3.3.9556.500" />
  </check>

  <install cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" msiexec /qn /x {3E171899-0175-47CC-84C4-562ACDD4C021}' />
  
  <install cmd='msiexec /qn /i "%SOFTWARE%\openoffice\3.3\openofficeorg33.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />

  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\openoffice\3.3\openofficeorg33.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
  
  <remove cmd='msiexec /qn /x {3E171899-0175-47CC-84C4-562ACDD4C021}' />
</package>


Please note, that if you encounter any errors stating that you should use setup.exe, you could use InstEd (free msi editor) in order to remove the check (search for SETUP_USED) and remove the row. After this the installation continues as usual.

OpenOffice.org 3.2.1

Download the installer http://download.openoffice.org/ and let the Installer unpack the files. Stop the setup and copy everything in your %SOFTWARE% Directory, customize with Microsoft ORCA tool if needed.

The product code for an English OpenOffice.org installation is different to the product code for a German ({DFFC0648-BC4B-47D1-93D2-6CA6B9457641}) or Italian installation. OpenOffice.org saves this Productcode into the setup.ini that is located in the program directory of OpenOffice.org (%PROGRAMFILES%\Openoffice3.2\setup.ini).

Upgrade from 3.2 worked fine for me, so no previous install/uninstall checks. 

<package id="openoffice32" name="OpenOffice.org 3.2" revision="321" reboot="false" priority="5">

  <check type="file" condition="versionequalto" path="%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" value="3.2.9498.500" />

  <install cmd='msiexec /qn /i "%SOFTWARE%\openoffice.org.3.2\openofficeorg32.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />

  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\openoffice.org.3.2\openofficeorg32.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />

  <remove cmd='msiexec /qn /x {DFFC0648-BC4B-47D1-93D2-6CA6B9457641}' /> 
</package>

OpenOffice.org 3.2.0

Download the installer http://download.openoffice.org/, unpack files to a local directory, customize with Microsoft ORCA tool if needed, and upload to your software source repository the following files:

The product code for an English OpenOffice.org installation set is different to the product code for a German or Italian installation set. OpenOffice.org saves this ProductCode into the setup.ini that is located in the program directory of OpenOffice.org. 

<package id="openoffice32" name="OpenOffice.org 3.2.0" revision="320" reboot="false" priority="0">
  <!--  http://download.openoffice.org/other.html -->
  <check type="uninstall" condition="exists" path="OpenOffice.org 3.2" />
  <install cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" msiexec /qn /x {97B3824E-B2D2-4C49-A860-BCA56F10B040}' /> <!-- product code -->
  <install cmd='msiexec /qn /i "%SOFTWARE%\bureautique\openoffice.org.3.2.0\openofficeorg32.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' /><!---->
  <upgrade cmd='msiexec /qn /x {7C35B9AB-2CE3-4C18-BE7C-5B97EA089EB3}' /> <!-- upgrade code -->
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\bureautique\openoffice.org.3.2.0\openofficeorg32.msi" ALLUSERS=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
  <remove cmd='msiexec /qn /x {97B3824E-B2D2-4C49-A860-BCA56F10B040}' /> <!-- Product code found in %PROGRAMFILES%\Openoffice3.2\setup.ini } -->
</package>

OpenOffice.org 3.1.1

The product code for an English OpenOffice.org installation set is different to the product code for a German or Italian installation set. OpenOffice.org saves this ProductCode into the setup.ini that is located in the program directory of OpenOffice.org.


Problem: OO 3.1.0 and 3.1.1 both announces themself as OO 3.1. While the original Installer (.exe) upgrades an OO 3.1.0 to OO 3.1.1 well, the extracted 3.1.1 MSI-Installer (as described below for OO 3.1.0) does not work. The described check on path "OpenOffice.org 3.1" does not work either. So here is my new package config for OO. 

<?xml version="1.0" encoding="UTF-8"?>
<packages>
<package id="openoffice" name="OpenOffice.org 3.1.1" revision="311" reboot="false" priority="0">

  <check type="file" condition="versionequalto" path="%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" value="3.1.9420.500" />
  <install cmd='%COMSPEC% /C if exist "%PROGRAMFILES%\OpenOffice.org 3\program\soffice.exe" msiexec /qn /x {D765F1CE-5AE5-4C47-B134-AE58AC474740}' />
  <install cmd='msiexec /qn /i "%SOFTWARE%\ooo311\openofficeorg31.msi" ALLUSERS=1 ADDLOCAL=ALL' />
  <upgrade cmd='msiexec /qn /x {D765F1CE-5AE5-4C47-B134-AE58AC474740}' />
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\ooo311\openofficeorg31.msi" ALLUSERS=1 ADDLOCAL=ALL' />
  <remove cmd='msiexec /qn /x {D765F1CE-5AE5-4C47-B134-AE58AC474740}' />

</package>
</packages>


Without Quickstart and Online-Update

As described below you only have to add "REMOVE=gm_o_Quickstart,gm_o_Onlineupdate" to the parameter list of msiexec when installing the new msi.

OpenOffice.org 3.1.0

Download the installer http://download.openoffice.org/, unpack files to a local directory, customize with Microsoft ORCA tool if needed, and upload to your software source repository the following files: 

java/
licenses/
readmes/
redist/
instmsia.exe
instmsiw.exe
ooo31.mst                          # Microsoft Transform File created by you with the ORCA tool, this is not necessary
openofficeorg1.cab
openofficeorg31.msi
setup.exe
setup.ini                          # this file contains the numeric ID you need for uninstallation, {43A650AA-D1DC-4C52-8819-D7848B3A08DA} in case of italian localized version

This example is for the italian localization, and associates OpenOffice as the default program for DOC, XLS and PPT files. Adapt to your localizations and change file associations to your needs. 


<?xml version="1.0" encoding="UTF-8"?>
<packages>
<package id="openoffice31-ita" name="OpenOffice.org 3.1 italian" revision="1" reboot="false" priority="0">

  <check type="uninstall" condition="exists" path="OpenOffice.org 3.1" />
  <install cmd='msiexec /qn /i "%SOFTWARE%\ooo310-ita\openofficeorg31.msi" TRANSFORMS=%SOFTWARE%\ooo310-ita\ooo31.mst ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1' />
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\ooo310-ita\openofficeorg31.msi" TRANSFORMS=%SOFTWARE%\ooo310-ita\ooo31.mst ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1' />
  <remove  cmd='msiexec /qn /x {43A650AA-D1DC-4C52-8819-D7848B3A08DA}' />

</package>
</packages>


Seems to reboot the system despite the reboot="false" option when Quickstart is already loaded (ie: execute wpkg-start.bat explicitly or manual restart the WPKGSrv).

OpenOffice.org 3.1.0: Easy Installation without Quickstart and Online-Update

To install OpenOffice.org without the Quickstart-Application (parameter gm_o_Quickstart) and wihtout the automatic Onlineupdate (parameter gm_o_Onlineupdate) use this package file. Just extract the OpenOffice-Installer and call the setup with the following package file. 

<package id="openoffice" name="OpenOffice.org 3.1" revision="310" reboot="false" priority="0">
  <check type="uninstall" condition="exists" path="OpenOffice.org 3.1" />
  <install cmd='msiexec /qn /i "%SOFTWARE%\openoffice\openofficeorg31.msi" ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
  <install cmd='cmd /c del /q /s "%Public%\Desktop\OpenOffice.org 3.1.lnk"' /> 
  <upgrade cmd='msiexec /qn /i "%SOFTWARE%\openoffice\openofficeorg31.msi" ALLUSERS=1 REGISTER_ALL_MSO_TYPES=1 ADDLOCAL=ALL REMOVE=gm_o_Quickstart,gm_o_Onlineupdate' />
  <upgrade cmd='cmd /c del /q /s "%Public%\Desktop\OpenOffice.org 3.1.lnk"' /> 
  <remove  cmd='msiexec /qn /x {43A650AA-D1DC-4C52-8819-D7848B3A08DA}' />
</package>

Poor availability of installer without JRE

Beware that for many non-US localizations, italian included, OpenOffice.org installer is not available in the "without Java JRE" version. As a side effect, a "with Java JRE" is so bad behaved that it does create a directory %PROGRAMFILES%\JRE\ and copy the JRE installer "jre-windows-i586.exe" in it, even if you specified in the Microsoft Transform that JRE is not to be installed. Uninstallation then cleanly removes this directory, however this is a waste of resources and a waste of time.

Issue number 95374 has been filed in OpenOffice.org requesting "non JRE" installers for all localizations; it has been answered pointing out that resources for translation are short, so that not all versions are translated and submitted to the Quality Assurance process. Solution is to volunteer and help localization and QA teams.


Avoid registration window

<install cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\setup.xcu' />
<install cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\common.xcu' />
<upgrade cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\setup.xcu' />
<upgrade cmd='"C:\Program Files\OpenOffice.org 3\program\unopkg.exe" add --shared %SOFTWARE%\openoffice\noreg\common.xcu' />

You can get setup.xcu and common.xcu from this location: http://wiki.services.openoffice.org/wiki/Documentation/Administration_Guide/Deactivating_Registration_Wizard


File types associations

Since Ooo does not configure file types other than ODF to be opened by default in Ooo I've created a registry file to set it (it has to be added for each user of the computer, so if you install Ooo as admin and have other users working consider adding batch script to 'All users'->'autostart'. Check WPKG Adding Registry Settings for details.

In order to avoid this in future releases, issue number 95375 has been filed in OpenOffice.org requesting the restore of "SELECT_WORD=1/0" and "SELECT_EXCEL=1/0" installer command line switches, which do not seem to be effective in the 3.0.0 release. As a workaround, Sun answered that the command line switch "REGISTER_ALL_MSO_TYPES=1/0", or equivalently the .msi file property "REGISTER ALL MSO TYPES" should be used to get what requested.


registry.reg: 

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppsx]
"Application"="simpress.exe"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppsx\OpenWithList]
"a"="simpress.exe"
"MRUList"="ba"
"b"="soffice.bin"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppsx\OpenWithProgids]
"PowerPoint.SlideShow.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pptx]
"Progid"="OpenOffice.org.Pptx"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pptx\OpenWithList]
"a"="simpress.exe"
"MRUList"="ba"
"b"="soffice.bin"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pptx\OpenWithProgids]
"PowerPoint.Show.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppt]
"Progid"="OpenOffice.org.Ppt"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppt\OpenWithList]
"a"="soffice.bin"
"MRUList"="ab"
"b"="simpress.exe"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ppt\OpenWithProgids]
"PowerPoint.Show.8"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.rtf]
"Progid"="OpenOffice.org.Rtf"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.rtf\OpenWithList]
"a"="WORDPAD.EXE"
"MRUList"="ba"
"b"="soffice.bin"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.rtf\OpenWithProgids]
"rtffile"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pps]
"Progid"="OpenOffice.org.Pps"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pps\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pps\OpenWithProgids]
"PowerPoint.SlideShow.8"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docx]
"Progid"="OpenOffice.org.Docx"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docx\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docx\OpenWithProgids]
"Word.Document.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docm]
"Progid"="OpenOffice.org.Docm"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docm\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.docm\OpenWithProgids]
"Word.Document.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsx]
"Progid"="OpenOffice.org.Xlsx"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsx\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsx\OpenWithProgids]
"Excel.Sheet.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsm]
"Progid"="OpenOffice.org.Xlsm"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsm\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsm\OpenWithProgids]
"Excel.Sheet.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otg]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otg\OpenWithList]
"a"="soffice.bin"
"MRUList"="ba"
"b"="soffice.exe"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otg\OpenWithProgids]
"opendocument.DrawTemplate.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.doc]
"Progid"="OpenOffice.org.Doc"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.doc\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.doc\OpenWithProgids]
"Word.Document.8"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xls]
"Progid"="OpenOffice.org.Xls"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xls\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xls\OpenWithProgids]
"Excel.Sheet.8"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odp]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odp\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odp\OpenWithProgids]
"opendocument.ImpressDocument.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otp]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otp\OpenWithList]
"a"="soffice.exe"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.otp\OpenWithProgids]
"opendocument.ImpressTemplate.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odt]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odt\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odt\OpenWithProgids]
"opendocument.WriterDocument.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ott]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ott\OpenWithList]
"a"="soffice.exe"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ott\OpenWithProgids]
"opendocument.WriterTemplate.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odg]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odg\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odg\OpenWithProgids]
"opendocument.DrawDocument.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ods]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ods\OpenWithList]
"a"="soffice.bin"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ods\OpenWithProgids]
"opendocument.CalcDocument.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ots]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ots\OpenWithList]
"a"="soffice.exe"
"MRUList"="a"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ots\OpenWithProgids]
"opendocument.CalcTemplate.1"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odb]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odb\OpenWithList]

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.odb\OpenWithProgids]
"opendocument.DatabaseDocument.1"=hex(0):

My batch script looks like this (I'm sure it could be done better, but it works fine) Of course xcopy command needs to have one exported profile, just run Ooo, configure it and copy created files to a network location. 

if not exist "%APPDATA%\OpenOffice.org\3" regedit "/S \\server_name\software\OpenOffice.org3pl"\user_profile\ooo3.reg
if not exist "%APPDATA%\OpenOffice.org\3"  xcopy "\\server_name\Software\OpenOffice.org3pl\user_profile" "%APPDATA%" /Y /E

If someone has already Microsoft Office 2003 or 2007 and want to use Ooo, but doesn't want it to take over his MS files extensions try this: 

if not exist "%PROGRAMFILES%\Microsoft Office\OFFICE12\winword.exe"
(if not exist "%PROGRAMFILES%\Microsoft Office\OFFICE11\winword.exe"
(if exist "%PROGRAMFILES%\OpenOffice.org 3"
(if not exist "%APPDATA%\OpenOffice.org\3" 
regedit /S "\\_server_name\software\Office\OpenOffice.org3pl\user_profile\ooo3.reg")))

if not exist "%PROGRAMFILES%\Microsoft Office\OFFICE12\winword.exe"
(if not exist "%PROGRAMFILES%\Microsoft Office\OFFICE11\winword.exe"
(if exist "%PROGRAMFILES%\OpenOffice.org 3"
(if not exist "%APPDATA%\OpenOffice.org\3" 
xcopy "\\server_name\Software\OpenOffice.org3pl\user_profile" "%APPDATA%" /Y /E)))

File Type Association - Alternative Method

The command "assoc" can be used to change file associations very easily, and doesn't require messing around with the registry. This should work regardless of whether or not OO.o was installed using REGISTER_ALL_MSO_TYPES.

associations.bat: 

REM Word documents .doc, .docx etc.
assoc .doc=OpenOffice.org.Doc
assoc .dot=OpenOffice.org.Dot
assoc .docx=OpenOffice.org.Docx
assoc .docm=OpenOffice.org.Docm
assoc .rtf=OpenOffice.org.rtf

REM Powerpoint slideshows, .ppt, .pptx etc.
assoc .pps=OpenOffice.org.Pps
assoc .ppsm=OpenOffice.org.Ppsm
assoc .ppsx=OpenOffice.org.Ppsx
assoc .ppt=OpenOffice.org.Pptx
assoc .pptm=OpenOffice.org.Pptm
assoc .pptx=OpenOffice.org.Pptx

REM Excel spreadsheets, .xls, .xlsx  etc.
assoc .xls=OpenOffice.org.Xls
assoc .xlt=OpenOffice.org.Xlt
assoc .xlsb=OpenOffice.org.Xlsb
assoc .xlsx=OpenOffice.org.Xlsx
assoc .xlsm=OpenOffice.org.Xlsm
assoc .xltx=OpenOffice.org.Xlsx
assoc .xltm=OpenOffice.org.Xlsm

OpenOffice Extensions

Similar to Firefox extensions, if you install OpenOffice extensions from within OpenOffice (using Tools → Extension Manager) they're installed per-user; if you install them from the command-line (using unopkg.exe), they're installed per-machine.

Extensions are set to either only be allowed to be installed per-user, not per-machine; or they can be installed per-machine but will prompt upon installation for the licence to be accepted (despite the fact the LGPL doesn't have to be accepted by the end user). This presents some difficulty in automating an installation of OpenOffice extensions. There's a worthwhile forum post related to this: [http://www.oooforum.org/forum/viewtopic.phtml?t=75460 'Shared' vs. 'My' Extensions]. For reference, see OpenOffice.org wiki's Simple License.

oiaohm: "CMD /c echo yes|unopkg add --shared extension.oxt" for install line works with all extenions makes the ones with licence install does not interfere with thoses without out. No batch file required. For people doing deploys on Linux and Mac with other systems it works with bash instead of command as well. Will added some full examples of extension deployment from what I use.

For instructions on automating installation of OpenOffice extensions, per-machine, see OpenOffice.org's wiki on unopkg.

Retrieved from "https://wpkg.org/index.php?title=OpenOffice.org_3.x&oldid=11197"