[Solved] Hide text in Writer depending on a Calc cell value

Writing a book, Automating Document Production - Discuss your special needs here
Post Reply
angus73
Posts: 2
Joined: Sat Jun 10, 2017 9:53 pm

[Solved] Hide text in Writer depending on a Calc cell value

Post by angus73 »

Hi,
I have to automatically hide some text (ideally a section) in writer if the content of a calc cell is 0. If it's not 0, the text should be displayed.

I am trying to do it by using a DDE link, fields, conditionally hidden sections, but I cannot reach my goal.

Could anybody please help me?

Thank you very much in advance,

Andrea
Last edited by Hagar Delest on Sun Jun 11, 2017 12:43 pm, edited 1 time in total.
Reason: tagged [Solved].
LO 5.1.6.2 on Ubuntu 16.04
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Hide text in writer depending on a calc cell value

Post by acknak »

The help says that you can use a database field in the "Hide" condition for a section. It doesn't work to drag a field (column header) into the condition slot, so it may be that you have to type out the database field syntax. You have to configure the spreadsheet as a table and register it as a data source before you can access it through the condition.

I don't know how that works with something like your scenario; I've only used it with mail merge.
AOO4/LO5 • Linux • Fedora 23
angus73
Posts: 2
Joined: Sat Jun 10, 2017 9:53 pm

Re: Hide text in writer depending on a calc cell value

Post by angus73 »

Thanks a lot, it works! At least, at the moment, I managed to output a conditional text.

I will show here some details.

Thanks!
Andrea
LO 5.1.6.2 on Ubuntu 16.04
Post Reply