We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How can I export .ods files with conditional formatting without losing most of it? [closed]

asked 2012-02-21 02:44:49 +0200

anonymous user


updated 2021-06-04 01:23:33 +0200

Alex Kemp gravatar image

Now I want to switch from LibreOffice (for several reasons) to WordPerfect Office. As the latter does not understand .ods, I'd need to convert my .ods files into another format. My problem is that I use conditional formatting in some of them, and it would be quite an effort to restore it "from scratch". When I export to .xlsx, it is completely lost. Is there a way to keep these formats when saving in another format than .ods?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 04:51:36.883798

2 Answers

Sort by » oldest newest most voted

answered 2012-02-21 14:14:44 +0200

cloph gravatar image

for document with software that doesn't support OpenDocument Formats, it is best to use the binary Microsoft Office formats - those have years of history whereas the xml-based Microsoft formats are rather new and hence is not on par with the older formats yet.

Of course it also depends on what the other software package supports...

edit flag offensive delete link more


So, back to my question then, how can I export to Microsoft formats without losing conditional formatting?

tux. gravatar imagetux. ( 2012-02-21 16:57:58 +0200 )edit

If it doesn't work with the binary formats either, then file a bug with a sample document (the smaller, the better).

cloph gravatar imagecloph ( 2012-03-08 15:15:21 +0200 )edit

answered 2012-02-21 02:57:06 +0200

Hikari gravatar image

Well unfortunately features like that are less used and therefore less tested and receive less attention from devs.

What import features WordPerfect offer to import? If it's paid software, you should ask them for support. Say you have a ODS with conditional formatting you wanna import, that it doesn't support ods, so how can you move those formattings to a file format their software supports. If they answer it's not possible, well... ODS is OpenSource and it's just a matter of their well paid devs do some work.

edit flag offensive delete link more


Unlike .odt, .ods is rarely supported by major office suites. WordPerfect does not know the .ods format at all, so I'd need to export it first, hence my question...

tux. gravatar imagetux. ( 2012-02-21 12:03:11 +0200 )edit

Question Tools


Asked: 2012-02-21 02:44:49 +0200

Seen: 1,353 times

Last updated: Feb 21 '12