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
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.)
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 6.1.2.1.
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.)
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.