How to apply conditional format to odt file?

Question

I need to evaluate a cell on a table on a odt, file, and apply conditional format if value is > 0. Not in speedsheet, is for writer

Answer 1

Tested with LO 5.4 and 6.0.4 on Win 10:

IMHO, the best solution is to insert a LO Calc spreadsheet as "OLE Object" into the odt file. This gives you the complete Calc funtionality inside Writer.

To do so, put the cursor to where the table should appear. Select Menu "Insert" -> "Object" -> "OLE Object". In the following window, select "New" and "LibreOffice 6.0 Spreadsheet". Alternatively, you may insert an already-existing Calc table.

After clicking OK, the object will appear, and it's already activated (you can determine if it's active by the thick gray border and the row/column heads - you can "deactivate" it by clicking outside, anywhere in the Writer document; you can re-activate the Calc object by double-clicking inside its borders).

Now, you can edit the Calc table as usual. Notice that the Menus will adapt to the Calc features if the Calc OLE object is active. So, e.g. the "Format" Menu will only contain a "Conditional formatting" entry if the Calc OLE object is active.

Here are some screenshots:

1. Insert a OLE object in Writer:

2. Writer document with embedded Calc table:

3. Applying conditional formatting to some content of the embedded Calc sheet:

4. Resulting Writer document with conditionally-formatted Calc table (Calc object is active):

5. Same as 4, now Calc object is inactive: