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.
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.
Although this can be done and was already told how, it’s absolutely not recommendable without first having an OpenDocument Format version.
I’ll reiterate rautamiekka advice…do 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.
Tools>Options>Load/Save>General
Document type … Always save as
Take a look here
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 FSO
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"
CheckCreate(Folder)
Folder = userProfile + "\AppData\Roaming\LibreOffice\4"
CheckCreate(Folder)
Folder = userProfile + "\AppData\Roaming\LibreOffice\4\user"
CheckCreate(Folder)
'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
FSO.CreateFolder(Folder)
End If
End Sub
Portable Installations on Network share
2 Years further...in 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:
%YourNetworkAppShare%\LibreOfficePortable\Data\settings\user\registrymodifications.cu
My 60 seconds..