I am using LibreOffice 3.6.4.3. I have tried to export a document that uses conditional formatting to change the cell’s background color to XHTML. Any colors that are set using what I call “normal formatting” (i.e. Right click on cell → Format Cells → Background Tab → choose light red → click OK) export correctly when I use the export function (File → Export → Save as type XHTML). However, any cells that are conditionally formatted (Format → Conditional Formatting → Conditional Formatting…) do not have their colors exported. In my specific case, I have three layers of formatting, the first checks if ISNA(E2) and leaves the background as No Fill, the second checks if the value is less than D2 and sets the background to red, and the third checks if it is greater than D2 and sets it to green. When I do an export where cells are conditionally formatted with a red background, the “normal formatting” gets exported correctly, but the conditional formatting does not.
Hi @Anonymous2,
This situation looks like a good candidate for a bug report: https://www.libreoffice.org/get-help/bug/
Could you please file a bug and attach
- The original file
- The exported XHTML file
Please mention in the bug report what discrepancies you observe between the original file and the export.
Thanks!