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

Remy,

Greetings.

I tried your suggestion, but it didn't work as expected. LO Report 
Builder did replace "[<>""]-@" with
"[<>0]-@;General", similar to what you experienced. However, the result 
is strange and almost indeterminate. Sometimes if the text field is 
alpha-numeric, the result is "-" without the text. Other times it is the 
text without the "-" prefix. Sometimes if the text field is 
numeric-only, the result is the text without the "-". Strange.

I then tried changing the format to "[<>0]"-"@;General" (quotes around 
dash) with the same results.

Then I tried "[<>0]"-"@;Standard" as your Calc experiment changed, and 
LO changed it to
"[<>0]"-"@;StanDarD", with the same results.

So, I am not sure what is going on. It almost looks like a bug with the 
unexpected results.

Thanks.
Girvin


On 5/15/19 5:03 PM, Remy Gauthier wrote:
> 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