Den tors 16 maj 2019 kl 00:22 skrev Girvin Herr <[email protected]>:
> 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. > If I format a cell like your first example and enter a letter in that cell, let's say ”k”, I get: -k If I enter a number, the cell remains blank. Is this the behaviour you are looking for? The format string doesn't change if I don't change it. If I set it to [>0]"";[<0]"";"";"-"@ I get the same result, and I should since the two means exactly the same thing. Can you give an example that doesn't work? Kind regards Johnny Rosenberg > > 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 > -- 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
