Bug 112533 - Easily Switch Between Open File Formats and Microsoft File Formats
Summary: Easily Switch Between Open File Formats and Microsoft File Formats
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
5.4.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-09-20 17:25 UTC by jfblagden
Modified: 2017-09-22 17:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description jfblagden 2017-09-20 17:25:14 UTC
Description:
This isn't really a bug. It's just a feature which I think would be very useful for people who might like to use open formats like ODT at times, but also need to be able to create documents in the Microsoft Office formats. Currently, the only way is to change the file types for text documents, spreadsheets, and presentations individually. I'd like a single switch or button to click on to be able to switch the file types for text documents, presentations, and spreadsheets. Since this feature is not yet available, I currently have LibreOffice set to use the Microsoft formats and I'll leave it that way until an easier way is made for switching formats.

Actual Results:  
N/A - just an enhancement request

Expected Results:
N/A - just an enhancement request


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:55.0) Gecko/20100101 Firefox/55.0
Comment 1 Jean-Baptiste Faure 2017-09-20 20:38:47 UTC
"Microsoft Office formats": what do you mean? Which one? 2003, 2007, 2010, 2013 or 2016? None meet the OOXML standard.

It is a bad idea to save in MSO format by default because LO use ODF internally and each save needs an conversion from ODF resulting in reduced performance and possibly formatting loss.
I think a better workflow is to always work in ODF and save a copy in OOXML only when you need to send the document to someone who need to edit it. If editing is not needed, use the pdf format. 

Best regards. JBF
Comment 2 jfblagden 2017-09-20 20:59:47 UTC
(In reply to Jean-Baptiste Faure from comment #1)
> "Microsoft Office formats": what do you mean? Which one? 2003, 2007, 2010,
> 2013 or 2016? None meet the OOXML standard.
> 
> It is a bad idea to save in MSO format by default because LO use ODF
> internally and each save needs an conversion from ODF resulting in reduced
> performance and possibly formatting loss.
> I think a better workflow is to always work in ODF and save a copy in OOXML
> only when you need to send the document to someone who need to edit it. If
> editing is not needed, use the pdf format. 
> 
> Best regards. JBF

I was referring to the 2007 MSO format specifically. Who is LO? Also, I want to be able to save my documents in the Microsoft Office format because most of the people with whom I exchange documents use Microsoft Office instead of Libreoffice or some other FOSS office suite – usually because they don’t know any better or because they either think or know that LibreOffice is missing some critical feature that they need. For me, it's just impractical to save documents in ODF all of the time, especially because some of the people with whom I exchange documents are using Macs - Microsoft Office for Windows can use ODF files, but not the Mac version. For me, it’s a lot more practical to only save FOSS-related documents in the ODF format. For example, I made a presentation about open-source software in the ODP format because pretty much everyone who I would send it to will be using LibreOffice or some other open-source office suite (https://www.dropbox.com/s/fgpdzbhqp9zz3ro/Introduction%20to%20Open%20Source.odp?dl=0). I’m just trying to be practical. FOSS is great, but most folks don’t use it, and so I have to be able to use some proprietary stuff as well. That’s why I have Skype installed on my Linux box – because everyone uses Skype. Even if a Mac user normally uses FaceTime, they usually have Skype installed anyway just so they can communicate with people who don’t have Macs or iOS devices.
Comment 3 Thomas Lendo 2017-09-20 22:18:19 UTC
Where should such switch be located?
And what's missing in Tools > Options > Load/Save > General, where you can specify a default file format?
Comment 4 jfblagden 2017-09-21 00:04:06 UTC
What's missing is the ability to easily switch Writer, Calc and Impress from using the ODF formats to the MSO formats and back again. A general format switch would be useful both for me and also for others. 

Besides, what if you set up a Windows user with LibreOffice and they don't know how to switch file types? Wouldn't it be easier for new user to be able to just flip a switch or for you to be able to quickly flip that switch for them when you're getting them started? Or would you prefer to talk them through that over the phone or have to switch over three different formats right in front of them? What might that make them think about FOSS? It very well could make them think that it takes too much configuration to be usable by people who are not as interested in FOSS as us?
Comment 5 Jean-Baptiste Faure 2017-09-21 04:52:26 UTC
You should try this extension: https://extensions.libreoffice.org/extensions/multisave
Comment 6 Thomas Lendo 2017-09-21 05:03:41 UTC
Most programs have their own file format with them they work best. Saving in Microsoft Office (MSO) formats will sometimes result in little dataloss or something will look differently after saving, closing and reopening the file. Because of that there is this warning dialog window when saving in other format than OpenDocument, which is the default in LibreOffice (LO/LibO).

I can follow you, but if the user wants to save every time in a specific file format like a doc then there is the switch in the options dialog. If someone wants only save a single file, then this can be done in the file save dialog where many file types are available. All changes must be done for a single LibO component (Writer, Calc, Draw ...) because not every file format is available for every component (e.g. there is no MSO format for Draw).

Between them ... there is nothing available. Again, where should such a switch be available?
Comment 7 jfblagden 2017-09-21 17:24:27 UTC
(In reply to Jean-Baptiste Faure from comment #5)
> You should try this extension:
> https://extensions.libreoffice.org/extensions/multisave

That's a neat extension. It's not really what I was looking for, but it should do the job. However, I tried it, and it didn't work. I was able to get to the point where I could pick the formats in which I wanted to save my document. Whenever I hit the Save button from MultiSave's popup window, nothing happens, even when I check and uncheck different formats and change the name of my document.
Comment 8 Jean-Baptiste Faure 2017-09-21 20:06:34 UTC
(In reply to jfblagden from comment #7)
> (In reply to Jean-Baptiste Faure from comment #5)
> > You should try this extension:
> > https://extensions.libreoffice.org/extensions/multisave
> 
> That's a neat extension. It's not really what I was looking for, but it
> should do the job. However, I tried it, and it didn't work. I was able to

Sorry, I think I gave you the wrong extension. The correct one should be this one: https://extensions.libreoffice.org/extensions/multisave-1

Best regards. JBF
Comment 9 jfblagden 2017-09-21 20:49:43 UTC
(In reply to Jean-Baptiste Faure from comment #8)
> (In reply to jfblagden from comment #7)
> > (In reply to Jean-Baptiste Faure from comment #5)
> > > You should try this extension:
> > > https://extensions.libreoffice.org/extensions/multisave
> > 
> > That's a neat extension. It's not really what I was looking for, but it
> > should do the job. However, I tried it, and it didn't work. I was able to
> 
> Sorry, I think I gave you the wrong extension. The correct one should be
> this one: https://extensions.libreoffice.org/extensions/multisave-1
> 
> Best regards. JBF

Thank you! It works! 

I just wish it were a wee bit faster and had an automatic setting. But it works, and that's what really matters here.
Comment 10 jfblagden 2017-09-22 13:21:11 UTC
(In reply to Jean-Baptiste Faure from comment #8)
> (In reply to jfblagden from comment #7)
> > (In reply to Jean-Baptiste Faure from comment #5)
> > > You should try this extension:
> > > https://extensions.libreoffice.org/extensions/multisave
> > 
> > That's a neat extension. It's not really what I was looking for, but it
> > should do the job. However, I tried it, and it didn't work. I was able to
> 
> Sorry, I think I gave you the wrong extension. The correct one should be
> this one: https://extensions.libreoffice.org/extensions/multisave-1
> 
> Best regards. JBF

I used that version of the MultiSave extension, and I noticed that it doesn't work too well when going from a Microsoft format to an open format. I converted an Excel spreadsheet and a Word document, both of which I started and continued working on in LibreOffice, but the open-source versions of those documents which were created by MultiSave were corrupt. The PDF, RTF, and MSO versions of those documents worked fine, but not the open-source format versions.
Comment 11 jfblagden 2017-09-22 13:38:31 UTC
Until that bug gets squashed, I guess I might be able to get by with the PDF conversion feature. Something which I appreciate about LibreOffice is that it has easy-access buttons for things I often want to do, like superscripts, exporting to PDF, strikethrough, and toggling formatting marks - things which  iWork lacks and sorely needs. From that, you can probably figure out that I'm switching from MacOS to Linux. I remember that in iWork, you had to go File, Export, the format you wanted, click Next, choose where you want to new file stored, and then click on Export. But in LibreOffice, the same operation can be accomplished with only two clicks. Not to mention that LibreOffice can directly work with MS Office files without having to do any conversions and it can even start documents in the MS formats.
Comment 12 Timur 2017-09-22 15:26:34 UTC
This is bugzilla for bug reports and how you explain is for user support at ask.libreoffice.org. I close as NAB.
What you mention in Comment 10 coulbe be bug but you need to search first and report with details: https://wiki.documentfoundation.org/QA/BugReport.
Comment 13 jfblagden 2017-09-22 16:18:32 UTC
(In reply to Timur from comment #12)
> This is bugzilla for bug reports and how you explain is for user support at
> ask.libreoffice.org. I close as NAB.
> What you mention in Comment 10 coulbe be bug but you need to search first
> and report with details: https://wiki.documentfoundation.org/QA/BugReport.
By bug, are you referring to the switch, or the issue with the multiFormatSave extension?
Comment 14 jfblagden 2017-09-22 17:33:24 UTC
Would my format switch question be better placed here: https://wiki.documentfoundation.org/Design