Re: [libreoffice-users] Problem with text formatting in Report.

Greetings,

I tried this in calc (which I am assuming you are using), and it seems
to work for what you describe:

[<>""]-@

The interesting thing is that calc changed it afterwards to

[<>0]-@;Standard 

but it still seems to work.

I hope this helps.

Rémy.
Le mercredi 15 mai 2019 à 15:17 -0700, Girvin Herr a écrit :
> Greetings,
>
> I am using LibreOffice 5.3.4.2 on Slackware Linux 14.2 (K4.4.75).
>
> I have a database with a text field which may or may not be null. What I 
> want to do is to prefix a dash "-" before the text if the text field is 
> not null. At first, I tried this format:
>
> ;;;"-"@
>
> Somewhere, not by me, it got changed to:
>
> [>0]"";[<0]"";"";"-"@
>
> However, this does not work. I get the text when not null, but not the 
> dash in either case.
>
> Is there another way to do this?
>
> Thanks.
>
> Girvin Herr

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy