I create this Conditional Text in LibreOffice Writer (4.2.3.3 Ubuntu 14.04)
Condition :
XI-Link.LEGGER.EKONOMI != “-”
Then :
75
Else :
“-”
why it always return true (show 75) even if the value is -
field XI-Link.LEGGER.EKONOMI is taken from field EKONOMI in table LEGGER from XI-Link (Database connection to spreadsheet ods file). EKONOMI in spreadsheet can contain number in percent (0%-100%) or “-” (without ")
source :
https://help.libreoffice.org/Writer/Conditional_Text
https://help.libreoffice.org/Writer/Formula