Ask Your Question

Conditional Content - Show on Condition instead of Hide on Condition? Can it be done?

asked 2019-07-21 10:24:55 +0100

bobbyBilbo gravatar image

I'm making a large number of documents using the mail-merge approach connecting Writer to Base but I think it would be more efficient if I could Show hidden text on Condition as opposed to Hide hidden text on Condition.

For example I have 5 sentences and only one sentence should show if a condition from a Base field is true.

Currently I have to wrangle 4 hide conditions for each of the sentences that should remain hidden which can become a pain. With 5 sentences it means I have to manage about 20 hide conditions for the 5 sentences.

Example table

95.2 93.1 87.0 97.8 95.6 99.1

What I would like to do

SentenceA: The value is nearly 95 (Show if value > 94.5 and < 95.5) SentenceB: The value is way above 95 (Show if value > 97) SentenceC: The value is way below 95 (Show if value < 93 and > 90) SentenceD: The value is really, really way below 95 (Show if value < 90)

Is their a simple way to do this or do I have to go into Extensions territory?

Thanks for your help.

edit retag flag offensive close merge delete


And what are the 4 hide conditions, say, for SentenceA?

Mike Kaganski gravatar imageMike Kaganski ( 2019-07-21 11:40:43 +0100 )edit

Hi Mike

thanks for taking the time to reply. There are no hide conditions (in my ideal universe) for SentenceA - that's exactly what I'm asking about.

Is there a way to hide text and only show it on condition - without having to define lots of hide conditions for the other alternative sentences? Using Hide on Condition in the toy example above I have to define around N(number of sentences) X N-1(the desired sentence) / N for each sentence - so each sentence has 4 compound hide conditions. Unless I am misunderstanding which is very possible

I hope this clarifies my question - please let me know if I can provide more info.


bobbyBilbo gravatar imagebobbyBilbo ( 2019-07-21 11:59:06 +0100 )edit

I asked exactly for those "around N(number of sentences) X N-1(the desired sentence) / N for each sentence" - to understand how do you see that.

In the actual reality, if you have a single condition to show something, it means that you have exactly one condition to hide it, which is negation of the condition to show.

Mike Kaganski gravatar imageMike Kaganski ( 2019-07-21 15:00:19 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-07-22 00:55:39 +0100

bobbyBilbo gravatar image

Thanks Mike!

I think this is solved with a double negative, as you say the negation of the condition to hide. Because hidden text can be shown using a NOT condition then I can avoid having to define multiple hide conditions for a single block of text.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-21 10:24:55 +0100

Seen: 71 times

Last updated: Jul 22 '19