Using conditional formatting in OO writer

[onlinealien]

I am trying to create a Health and safety risk assessment document where I can show the severity of risk in different colors ( green, red...) in a table cell . I know this is possible in OO Calc but I am looking to use the Writer.

How is it possible to get this function working in Open office Writer?

Thank you

[John_Ha]

Welcome to the forum.

If you search Help with conditional you will see what can be done with conditional formatting. For example, Defining Conditions says:

Conditions are logical expressions that you can use to control the display of fields and sections in your document. Although the following examples apply to fields, they also apply to sections.
You can define conditions for the following field types:
1. Conditional text: displays text A if the condition is true, or text B if the condition is false.
2. Hidden text: hides the content of the field if the condition is true.
3. Hidden paragraph: hides the paragraph if the condition is true.
4. Any record and next record: controls the access to database records.
...

One way might be to have three fields, one red, one orange, one green. Now hide the two not needed, and show the third according to the condition.

Also see Developing conditional content on pp 397 of the Writer Manual

If this solves the problem, please click the Edit button on your original post and edit the Title to [Solved].

[RoryOF]

There are some suggestions on the use of conditional formatting in Writer on this (and subsequent) page
http://www.linuxtopia.org/online_books/ ... tyles.html

[jrkrideau]

For a health and safety document don't forget to allow for colour blindness. http://designshack.net/articles/accessi ... ind-users/

[RoryOF]

There is further information on Conditional styles in Writer at
https://www.linux.com/learn/tutorials/3 ... ice-writer

I admit that this is new to me. I must brood on what use I can make of it.

[acknak]

I don't think this is possible in Writer. I don't know of any way to connect a formula to text formatting or a table property.

Conditional styles allow a style to be associated with certain situations in the document: if this paragraph appears in a list, apply style LIST. No user-specified conditions are allowed.

Conditional text is text only; no formatting.

[F3K Total]

There is a little possibility, if you want to format numbers.
You can have three colors depending on the value, using Number Format... (rightclick in the cell)
E.g. this

Code: Select all

[<3][GREEN]0;[<6][YELLOW]0;[RED]0

gives this result:

CF.png (2.3 KiB) Viewed 4736 times

See example attached
R

[onlinealien]

Thank you so much for your effort

F3K Total, number formatting is simple and genuis - that's all what I need

I played with conditional paragraph styling but couldn't get nowhere

Thanks

[acknak]

There is a little possibility, if you want to format numbers. ...

Good suggestion!

The other workaround would be to use an embedded spreadsheet object in place of the Writer table.

[onlinealien]

There is a little possibility, if you want to format numbers. ...

Good suggestion!

The other workaround would be to use an embedded spreadsheet object in place of the Writer table.

You're right, acknak. Number formatting is very limited in options and colors; embedding a spreadsheet is the ideal solution.

Thanks