Re: [libreoffice-users] Getting a line break through a query

2019-05-15 Thread Adam Fenn
Ahh, thank you so much! > On 15 May 2019, at 22:42, Drew Jensen wrote: > > Howdy, > > The carriage return is in the string but in the case of the Query designer > the result grid only displays single line data so it appears it is not > there. > > If the query is used to populate controls on a

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

2019-05-15 Thread Remy Gauthier
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,

[libreoffice-users] Cannot get summed values in a Base report

2019-05-15 Thread Girvin Herr
Greetings, I am using LibreOffice 5.3.4.2 on Slackware Linux 14.2 (K4.4.75). I have been able to do this in the past, but I seem to have "lost the bubble" on this and I can't find where I learned it from. I need to print a total sum of a field in all records at the end of a Base report.

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

2019-05-15 Thread Girvin Herr
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

Re: [libreoffice-users] Getting a line break through a query

2019-05-15 Thread Drew Jensen
Howdy, The carriage return is in the string but in the case of the Query designer the result grid only displays single line data so it appears it is not there. If the query is used to populate controls on a form (grid or single field) there is a property for the control 'MultiLine Input' and

[libreoffice-users] Getting a line break through a query

2019-05-15 Thread Adam Fenn
The base documentation states that you can get a line break using Char(13) e.g. SELECT "Firstname"||' '||"Surname"||Char(13)||"Road"||Char(13)||"Town" FROM "Table" However, when I run this I just get the concatenated query on one line with no line breaks. What am i doing wrong? Thanks for

Re: [libreoffice-users] compose characters

2019-05-15 Thread Federico Quadri
At 16:14 15/05/2019 +0200, Federico Quadri wrote: >Has anybody ever used the command "join tables"? Yes. >(don't know exact English menu name, "unisci tabella" in Italian). It's "Merge Tables" in English, but no matter. >I have never succeeded in using it. Once a table >has been split in

Re: [libreoffice-users] compose characters

2019-05-15 Thread Brian Barker
At 16:14 15/05/2019 +0200, Federico Quadri wrote: Has anybody ever used the command "join tables"? Yes. (don't know exact English menu name, "unisci tabella" in Italian). It's "Merge Tables" in English, but no matter. I have never succeeded in using it. Once a table has been split in two

Re: [libreoffice-users] compose characters

2019-05-15 Thread Federico Quadri
Has anybody ever used the command "join tables"? (don't know exact English menu name, "unisci tabella" in Italian). I have never succeeded in using it. Once a table has been split in two parts, no way to re-join them in a single one. The “join tables” command is always “greyed” (not

Re: [libreoffice-users] compose characters

2019-05-15 Thread M Henri Day
Den ons 15 maj 2019 kl 00:59 skrev Udvarias Ur : > Dear Thomas, > > OOPS! My bad. I could not find the character you want in the > "freedesktop.org" list. > > However, I did find 2 versions of the character (one with a short bar > the other with a long bar) in the "Character Map" program. You'll