Ask Your Question

Save as MS Office format by default

asked 2012-08-13 18:38:45 +0100

networkadmin gravatar image

I'm evaluating LibreOffice for a corporate roll-out. The pilot test PCs will need to be compatible with MS Office 2010 on the rest of the network. The biggest road block I've encountered is setting LibreOffice Calc/Impress/Writer to save in Microsoft Office 2007/2010 XML format by default rather than ODF for all users of the computer. Is there a way to configure this either with a command line switch during install or with a config file of some sorts? If I have to manually set it on 50 computers and for each user then there's no way LibreOffice will make it past the pilot test phase. Thanks in advance.

edit retag flag offensive close merge delete


There must have been a "silent update" to this thread on 2015-10-27 as it was listed again among the "most recent" ones. I take this as an oportunity to ask the questioner in what way he solved his problem and if the intended interoperability via MS formats worked satisfyingly for him. (There are limitations, aren't there?) As @networkadmin was last seen here 2012-08-20, he may not answer. Someone else having done similar things may step in.

Lupp gravatar imageLupp ( 2015-10-27 13:06:07 +0100 )edit

Although this can be done and was already told how, it's absolutely not recommendable without first having an OpenDocument Format version.

rautamiekka gravatar imagerautamiekka ( 2015-10-27 13:54:30 +0100 )edit

I'll reiterate rautamiekka NOT use xml format for interoperablity between MS and LO...Just completed an Excel2010 to LO5.0.2 Calc migration with xml. Issues stablized when we went to ODS format. Went with LO more for it's potential than functional superiority, but I still have issues with SUMIFS with more than 2 criteria, and with text comparisons. To many variables(Win10-64, cloud based storage(sync issues?)) to file bug reports. I am interested any other user's experience.

jaM gravatar imagejaM ( 2015-10-27 16:27:24 +0100 )edit

4 Answers

Sort by » oldest newest most voted

answered 2013-01-30 20:51:21 +0100

qubit gravatar image
edit flag offensive delete link more

answered 2012-08-13 20:13:05 +0100

Rajagopal S. Iyer gravatar image


Document type .. Always save as

edit flag offensive delete link more

answered 2013-12-10 20:00:37 +0100

jschuh gravatar image

I know this is an older post but I wanted to post the solution I used in case anyone else searched.

I don't know the relevancy for versions below 4.0 (I haven't used). But it does look like a users defaults are stored in %AppData%\LibreOffice\4\user in a file called registrymodifications.xcu

Log into a machine and make the changes needed for the default file formats then copy the file above to a location where you want new users to get the changes from. In the example below I just used c:\libredefaults. I then wrote a VB script that runs in the startup folder for all users and creates the directory if needed and copies the default file if not there. Yes a lot of different ways you could do this and I don't profess to be an expert.

Set oWS = WScript.CreateObject("WScript.Shell")
' Get the %userprofile% in a variable, or else it won't be recognized
userProfile = oWS.ExpandEnvironmentStrings( "%userprofile%" )

Dim objNetwork
Dim userName
Dim Folder

Set FSO = CreateObject("Scripting.FileSystemObject")

Set objNetwork = CreateObject("WScript.Network")
userName = objNetwork.userName

'Check Each level of Folder
Folder = userProfile + "\AppData\Roaming\LibreOffice"
Folder = userProfile + "\AppData\Roaming\LibreOffice\4"
Folder = userProfile + "\AppData\Roaming\LibreOffice\4\user"

'Copy File
If not (FSO.FileExists(Folder + "\registrymodifications.xcu")) then
    FSO.CopyFile "c:\libredefaults\registrymodifications.xcu", Folder + "\"
End If

Sub CheckCreate(InFolder)

    If NOT (FSO.FolderExists(Folder)) Then
    End If

End Sub
edit flag offensive delete link more

answered 2015-10-27 02:01:16 +0100

Portable Installations on Network share

2 Years case you use the Portable version which is even more handy for maintenance 
(just install once on network share) the registry modifications are kept here:


My 60 seconds..
edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2012-08-13 18:38:45 +0100

Seen: 42,946 times

Last updated: Oct 27 '15