Ask Your Question

Edit multiple Conditional Styles in one go

asked 2018-10-15 11:49:42 +0200

RobVld gravatar image

updated 2018-10-15 11:50:35 +0200

Because of bug 34412 the font size of conditional styles in an excel file is changed when the Excel file is saved in .ODS or .xlsx with LibreOffice I would like to know if it is possible to edit multiple Conditional Styles in one go. to repair the fontsize.

Thanks, Rob

edit retag flag offensive close merge delete


What is your version of LibreOffice? What version of Excel was your document created with? In which one of the many file formats used by different versions of Excel was it given to you?
(You should better not expect Excel to be compatible with itself.)

Lupp gravatar imageLupp ( 2018-10-15 14:00:48 +0200 )edit

Well Instead of changing all conditional styles created by Excel.. I changed the information in the styles.xml file of the ODS file... Then it was possible to modify the file in Excel (2007, still have to test it with Excel 2016) and LibreOffice without modification of the Font size... The Excel file was made in office 365 in xlsx format... I'm using LO

RobVld gravatar imageRobVld ( 2018-10-17 10:50:00 +0200 )edit

Well, as you obviously don't shy back from manipulating the file directly, this should be the best way in your specific case. Most users might better not tamper with the file on that level.
And also the "ordinary user" should stick to the native file formats of OpenDocument, and not assume there can be full equivalence concerning all the document's aspects when using alien file formats. (They might even be hostile in a ticklish way. After all MS Office is a profit center.)

Lupp gravatar imageLupp ( 2018-10-17 12:00:55 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-10-15 13:58:36 +0200

Lupp gravatar image

LibreOffice doesn't support "conditional styles" as a specific kind of styles. (Don't know what Excel does.) Cell styles used for overlaying attributes under conditions in CF are defined the same way as any cell style. This includes the full working of heritage.

Thus: If the cell styles for conditional application are derived from a common base cell style, you only need to modify this single style to get the change to work for all the styles inheriting from it and not having the respective attribute explicitly set to a different value.

When converting an Excel document to the native format of OpenDocument applications, always the set of automatically created styles shoud be inspected and reworked to get consistency concerning the clear and effective style concept available here.

After reading superficially through the mentioned bug tdf#34412 I wouldn't expect a definite solution there. The sheet/document models may be too different insofar.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-15 11:49:42 +0200

Seen: 30 times

Last updated: Oct 15 '18