Apache OpenOffice Community Forum

Posted: **Thu Nov 29, 2007 8:09 pm**

I am the tech coordinator for a school district. I am ready to pull the plug on Microsoft Office and switch 500 computers over to Open Office....if I could solve this one problem.

Both Open Office and Star Office save in .odt format. It is very easy to go in and change OO so that it always saves in .doc, .xls, .ppt format. My problem is that no matter how much I try, I can't get teachers to make that change. They would rather complain that OO won't work and when they send files, nobody can open them.

If I could find a log in script or registry file hack that will make that change at log in, I could eliminate 85% of the complaints.

We are using Windows 2k workstations and servers. Active Directory. Roaming Profiles for teachers, redirected docs for students. I have tried setting the default format before I image machines, but it doesn't stick. This seems to be a setting that is in each user's registry.

Any help you can give would be great!

Posted: **Thu Nov 29, 2007 11:45 pm**

You have to modify the configuration file in the OOo user profile : \Documents and settings\<user>\Application data\OpenOffice.org2\user\registry\data\org\openoffice\Setup.xcu, it should have the following nodes :

Code: Select all

...
   <node oor:name="com.sun.star.text.TextDocument">
    ...
    <prop oor:name="ooSetupFactoryDefaultFilter" oor:type="xs:string">
     <value>MS Word 97</value>
    </prop>
   </node>
...
   <node oor:name="com.sun.star.presentation.PresentationDocument">
    ...
    <prop oor:name="ooSetupFactoryDefaultFilter" oor:type="xs:string">
     <value>MS PowerPoint 97</value>
    </prop>
   </node>
   <node oor:name="com.sun.star.sheet.SpreadsheetDocument">
    ...
    <prop oor:name="ooSetupFactoryDefaultFilter" oor:type="xs:string">
     <value>MS Excel 97</value>
    </prop>
   </node>

The best would be to create a configuration for one user and copy this configuration file with a batch.

Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed.

Posted: **Tue Jan 29, 2008 12:33 pm**

For each profile do i require to run this batch file ? since we have nearly 200 users & many users log in to other systems
we are using windows XP. Your response will be of a great help

Regards

Gopal

Posted: **Tue Jan 29, 2008 10:14 pm**

Yes, it's the most frequent solution I've seen on forums: the script run at user logon look at the OOo profile, if there is one, nothing happens, else, the installation is launched and usually a standard user profile on the network is copied for the current user.

Posted: **Tue Jul 08, 2008 10:39 pm**

I've been trying to get this fix to work in Vista using OO3.0 and it does not appear to work. It seems that these settings are being held in some other location. Please let me know how to accomplish this default format change in Vista with OO3.0. Thanks!

Posted: **Tue Jul 08, 2008 11:08 pm**

Strange. I just tried to change the settings on my 3.0 beta and the entries seem to be the same:

Code: Select all

<node oor:name="com.sun.star.text.TextDocument">
  <prop oor:name="ooSetupFactoryWindowAttributes" oor:type="xs:string">
    <value>240,87,920,875;5;0,53,1400,971;</value>
  </prop>
  <prop oor:name="ooSetupFactoryDefaultFilter" oor:type="xs:string">
    <value>MS Word 97</value>
  </prop>
</node>
<node oor:name="com.sun.star.sheet.SpreadsheetDocument">
  <prop oor:name="ooSetupFactoryWindowAttributes" oor:type="xs:string">
    <value>240,87,920,875;5;0,52,1400,973;</value>
  </prop>
  <prop oor:name="ooSetupFactoryDefaultFilter" oor:type="xs:string">
    <value>MS Excel 97</value>
  </prop>
</node>

Note that the user profile is under /ooo-dev3/user/... instead of /openoffice.org2/user/...

Posted: **Wed Jul 09, 2008 3:26 pm**

OK thanks for checking, but just to verify.. you are using Vista SP1 and the settings actually show the change that you expect?
Also to verify this is the path of the Setup.xcu file you are using? C:\Users\username\AppData\Roaming\OpenOffice.org3\user\registry\data\org\openoffice\setup.xcu

I seems as though the settings that are being used are being pulled from another location.

Thanks,
Greg

Posted: **Wed Jul 09, 2008 4:12 pm**

I was under my xubuntu box in fact.

Are you sure the profile is under openoffice.org3? As the 3.0 is still a beta, I would have thought that profile would have been in something like ooo-dev3 folder like GNU/Linux systems.

Posted: **Wed Jul 09, 2008 6:05 pm**

That path is correct.. I've installed 3.0 beta multiple times on different Vista machines and that is the path every time. Is this a problem?

Posted: **Wed Jul 09, 2008 9:06 pm**

No, I just find strange that the Windows dev build uses the same path as the final one whereas the GNU/Linux one uses a different one so that the test profile doesn't mix with the final one.

BTW, it rang a bell, perhaps it's the same kind of issue as that one (see last posts): keeps prompting "OOo update available".

Posted: **Thu Jul 10, 2008 3:51 pm**

I looked at those posts and I suppose all of these could be a Vista issue. Do you have a Vista machine that you could verify this ODT to DOC issue one? I sure would like to know if Vista is not going to be able to allow me to modify these settings on all 70,000 workstations that I need to eventually deploy on. Works fine in XP so I'm hoping a fix for Vista can be identified.

Posted: **Thu Jul 10, 2008 4:46 pm**

No Vista here so I can't check. We've to wait for someone with Vista to make that check!

Posted: **Thu Jul 10, 2008 9:04 pm**

OK thanks for your help.. hopefully someone with Vista will be able to figure out what is going on...

Posted: **Thu Jul 10, 2008 9:17 pm**

Turns out this is an issue in XP as well. The setup.xcu is located now under this path. C:\Documents and Settings\us340094\Application Data\OpenOffice.org3\user\registry\data\org\openoffice

Do you have XP?

Greg

Posted: **Thu Jul 10, 2008 9:29 pm**

gjeseritz wrote:Turns out this is an issue in XP as well. The setup.xcu is located now under this path. C:\Documents and Settings\us340094\Application Data\OpenOffice.org3\user\registry\data\org\openoffice

What do you mean? That's exactly the path I mentioned above:

Hagar de l'Est wrote:You have to modify the configuration file in the OOo user profile : \Documents and settings\<user>\Application data\OpenOffice.org2\user\registry\data\org\openoffice\Setup.xcu

Of course you've to adapt the version number.

Posted: **Tue Jul 22, 2008 10:24 pm**

So I figured out my problem. When I was testing I would make a change to the Setup.XCU file and then make a copy to my desktop. I then would go into Writer make a change to the default file format and close down writer. I would then copy and replace the setup.xcu file from me desktop to it's location in my profile and after starting up Writer, it was not showing the change I expceted.. I found that I needed to stop the soffice.bin and exe files in task manager... When they are restarted with the opening of Writer again, they re load the setup.xcu file and my changes appear.

This will be a non issue from this point.

Thanks for your help.
Greg

Posted: **Wed May 13, 2009 4:11 pm**

Win2003 x64 bit
OOo 3.1

I was able to fix the default save-as type on a per machine bases by editing one line in each of the .xcu files. (i.e. doesn't matter which user is logging in.)
The files are located here on my machine:
"C:\Program Files (x86)\OpenOffice.org 3\Basis\share\registry\modules\org\openoffice\Setup"
Note: If your not running the 64bit version of windows then the above path would not contain the " (x86)" portion of the path.

The files I edited are name:
Setup-writer.xcu
Setup-calc.xcu

For Setup-writer.xcu i change from this:

Code: Select all

<node oor:name="com.sun.star.text.TextDocument" oor:op="replace">
    ........
    <prop oor:name="ooSetupFactoryDefaultFilter">
         <value>writer8</value>
    </prop>
    ........
</node>

to this:

Code: Select all

<node oor:name="com.sun.star.text.TextDocument" oor:op="replace">
    ........
    <prop oor:name="ooSetupFactoryDefaultFilter">
         <value>MS Word 97</value>
    </prop>
    ........
</node>

For Setup-calc.xcu i change from this:

Code: Select all

<node oor:name="com.sun.star.sheet.SpreadsheetDocument" oor:op="replace">
    ........
    <prop oor:name="ooSetupFactoryDefaultFilter">
         <value>calc8</value>
    </prop>
    ........
</node>

to this:

Code: Select all

<node oor:name="com.sun.star.sheet.SpreadsheetDocument" oor:op="replace">
    ........
    <prop oor:name="ooSetupFactoryDefaultFilter">
         <value>MS Excel 97</value>
    </prop>
    ........
</node>

Hope this helps.

Posted: **Fri Jan 22, 2010 11:48 am**

Hi!

I can' find Setup-Writer XCU in my programfiles?
Only the file Setup-brand.xcu
Can i edit in "ooSetupFactoryDefaultFilter" there?

Running OpenOffice 3.1

Posted: **Wed Mar 10, 2010 12:22 pm**

I am also facing the same problem not able to find the setup-writer.xcu file.

kindly help me.

Posted: **Wed Mar 10, 2010 12:29 pm**

Did you never hear of Start Button / Search / Files and Folders/ for setup*.xcu?

On my Win2K system the various Openoffice setup*.xcu files are in
C:\Program Files\OpenOffice.org 3\Basis\share\registry\modules\org\openoffice\Setup

Posted: **Fri Apr 02, 2010 11:19 am**

It works, but you have to restart! In the writer-config there are more lines to change

It should work like this:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<oor:component-data xmlns:oor="http://openoffice.org/2001/registry" xmlns:install="http://openoffice.org/2004/installation" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" oor:name="Setup" oor:package="org.openoffice">
  <node oor:name="Office">
    <node oor:name="Factories">
      <node oor:name="com.sun.star.text.GlobalDocument" oor:op="replace">
        <prop oor:name="ooSetupFactoryDocumentService" oor:finalized="true">
          <value>com.sun.star.text.GlobalDocument</value>
        </prop>
        <prop oor:name="ooSetupFactoryCommandConfigRef">
          <value>WriterCommands</value>
        </prop>
        <prop oor:name="ooSetupFactoryActualFilter" oor:finalized="true">
          <value>writerglobal8</value>
        </prop>
        <prop oor:name="ooSetupFactoryActualTemplateFilter" oor:finalized="true"/>
        <prop oor:name="ooSetupFactoryDefaultFilter">
          <value>MS Word 97</value>
        </prop>
        <prop oor:name="ooSetupFactoryEmptyDocumentURL" oor:finalized="true">
          <value>private:factory/swriter/GlobalDocument</value>
        </prop>
        <prop oor:name="ooSetupFactoryWindowAttributes">
          <value/>
        </prop>
        <prop oor:name="ooSetupFactoryIcon">
          <value>11</value>
        </prop>
        <prop oor:name="ooSetupFactoryTemplateFile">
          <value/>
        </prop>
        <prop oor:name="ooSetupFactoryShortName">
          <value>sglobal</value>
        </prop>
        <prop oor:name="ooSetupFactoryUIName">
          <value>Writer</value>
        </prop>
        <prop oor:name="ooSetupFactoryWindowStateConfigRef">
          <value>WriterGlobalWindowState</value>
        </prop>
        <prop oor:name="ooSetupFactoryCmdCategoryConfigRef">
          <value>GenericCategories</value>
        </prop>
      </node>
      <node oor:name="com.sun.star.text.TextDocument" oor:op="replace">
        <prop oor:name="ooSetupFactoryDocumentService" oor:finalized="true">
          <value>com.sun.star.text.TextDocument</value>
        </prop>
        <prop oor:name="ooSetupFactoryCommandConfigRef">
          <value>WriterCommands</value>
        </prop>
        <prop oor:name="ooSetupFactoryActualFilter" oor:finalized="true">
          <value>writer8</value>
        </prop>
        <prop oor:name="ooSetupFactoryActualTemplateFilter" oor:finalized="true">
          <value>writer8_template</value>
        </prop>
        <prop oor:name="ooSetupFactoryDefaultFilter">
          <value>MS Word 97</value>
        </prop>
        <prop oor:name="ooSetupFactoryEmptyDocumentURL" oor:finalized="true">
          <value>private:factory/swriter</value>
        </prop>
        <prop oor:name="ooSetupFactoryWindowAttributes">
          <value/>
        </prop>
        <prop oor:name="ooSetupFactoryIcon">
          <value>2</value>
        </prop>
        <prop oor:name="ooSetupFactoryTemplateFile">
          <value/>
        </prop>
        <prop oor:name="ooSetupFactoryShortName">
          <value>swriter</value>
        </prop>
        <prop oor:name="ooSetupFactoryUIName">
          <value>Writer</value>
        </prop>
        <prop oor:name="ooSetupFactoryWindowStateConfigRef">
          <value>WriterWindowState</value>
        </prop>
        <prop oor:name="ooSetupFactoryCmdCategoryConfigRef">
          <value>GenericCategories</value>
        </prop>
      </node>
      <node oor:name="com.sun.star.sdb.FormDesign" oor:op="replace">
        <prop oor:name="ooSetupFactoryDocumentService" oor:finalized="true">
          <value>com.sun.star.text.TextDocument</value>
        </prop>
        <prop oor:name="ooSetupFactoryActualFilter" oor:finalized="true">
          <value>writer8</value>
        </prop>
        <prop oor:name="ooSetupFactoryActualTemplateFilter" oor:finalized="true">
          <value>writer8_template</value>
        </prop>
        <prop oor:name="ooSetupFactoryDefaultFilter">
          <value>MS Word 97</value>
        </prop>
        <prop oor:name="ooSetupFactoryEmptyDocumentURL" oor:finalized="true">
          <value>private:factory/swriter</value>
        </prop>
        <prop oor:name="ooSetupFactoryCommandConfigRef">
          <value>WriterCommands</value>
        </prop>
        <prop oor:name="ooSetupFactoryIcon">
          <value>2</value>
        </prop>
        <prop oor:name="ooSetupFactoryShortName">
          <value>swform</value>
        </prop>
        <prop oor:name="ooSetupFactoryUIName">
          <value xml:lang="en-US">Base: Form Design</value>
        </prop>
        <prop oor:name="ooSetupFactoryWindowStateConfigRef">
          <value>WriterFormWindowState</value>
        </prop>
        <prop oor:name="ooSetupFactoryCmdCategoryConfigRef">
          <value>GenericCategories</value>
        </prop>
      </node>
      <node oor:name="com.sun.star.sdb.TextReportDesign" oor:op="replace">
        <prop oor:name="ooSetupFactoryDocumentService" oor:finalized="true">
          <value>com.sun.star.text.TextDocument</value>
        </prop>
        <prop oor:name="ooSetupFactoryActualFilter" oor:finalized="true">
          <value>writer8</value>
        </prop>
        <prop oor:name="ooSetupFactoryActualTemplateFilter" oor:finalized="true">
          <value>writer8_template</value>
        </prop>
        <prop oor:name="ooSetupFactoryDefaultFilter">
          <value>MS Word 97</value>
        </prop>
        <prop oor:name="ooSetupFactoryEmptyDocumentURL" oor:finalized="true">
          <value>private:factory/swriter</value>
        </prop>
        <prop oor:name="ooSetupFactoryCommandConfigRef">
          <value>WriterCommands</value>
        </prop>
        <prop oor:name="ooSetupFactoryIcon">
          <value>2</value>
        </prop>
        <prop oor:name="ooSetupFactoryShortName">
          <value>swreport</value>
        </prop>
        <prop oor:name="ooSetupFactoryUIName">
          <value xml:lang="en-US">Base: Report Design</value>
        </prop>
        <prop oor:name="ooSetupFactoryWindowStateConfigRef">
          <value>WriterReportWindowState</value>
        </prop>
        <prop oor:name="ooSetupFactoryCmdCategoryConfigRef">
          <value>GenericCategories</value>
        </prop>
      </node>
      <node oor:name="com.sun.star.xforms.XMLFormDocument" oor:op="replace">
        <prop oor:name="ooSetupFactoryDocumentService" oor:finalized="true">
          <value>com.sun.star.text.TextDocument</value>
        </prop>
        <prop oor:name="ooSetupFactoryActualFilter" oor:finalized="true">
          <value>writer8</value>
        </prop>
        <prop oor:name="ooSetupFactoryActualTemplateFilter" oor:finalized="true">
          <value>writer8_template</value>
        </prop>
        <prop oor:name="ooSetupFactoryDefaultFilter">
          <value>MS Word 97</value>
        </prop>
        <prop oor:name="ooSetupFactoryEmptyDocumentURL" oor:finalized="true">
          <value>private:factory/swriter?slot=21053</value>
        </prop>
        <prop oor:name="ooSetupFactoryCommandConfigRef">
          <value>WriterCommands</value>
        </prop>
        <prop oor:name="ooSetupFactoryWindowAttributes">
          <value/>
        </prop>
        <prop oor:name="ooSetupFactoryIcon">
          <value>2</value>
        </prop>
        <prop oor:name="ooSetupFactoryShortName">
          <value>swxform</value>
        </prop>
        <prop oor:name="ooSetupFactoryUIName">
          <value xml:lang="en-US">XML Form Document</value>
        </prop>
        <prop oor:name="ooSetupFactoryWindowStateConfigRef">
          <value>XFormsWindowState</value>
        </prop>
        <prop oor:name="ooSetupFactoryCmdCategoryConfigRef">
          <value>GenericCategories</value>
        </prop>
      </node>
    </node>
  </node>
</oor:component-data>

Posted: **Wed Apr 14, 2010 1:36 pm**

is there any way we can create a batch file for this? if so please let us know.

Thanks
Sudheendra S
Bangalore
INDIA

Apache OpenOffice Community Forum

Default format (odt to doc) for domain users

Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users

Re: Default format (odt to doc) for domain users