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: [email protected]
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
