Re: [libreoffice-users] Getting a line break through a query
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 form (grid or single field) > there is a property for the control 'MultiLine Input' and default is NO. > > For a Grid control you would select a column and change that 'MultiLine > Input' property for the column from No to Yes and the string will break. > > Best wishes, > > Drew > > On Wed, May 15, 2019 at 4:56 PM Adam Fenn wrote: > >> 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 your help, >> Adam Fenn. >> -- >> To unsubscribe e-mail to: users+unsubscr...@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 >> >> > > -- > To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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
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+unsubscr...@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
[libreoffice-users] Cannot get summed values in a Base report
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. Looking at another report of mine that works, the "Data" tab for the summation field is: Data Field Type Function Data Field Cost Function Accumulation Scope Report However, when I try these parameters in the new report, when I select "Accumulation" in the Function field, it changes "Data Field" to "[AccumulationCostReport]" and the Function and Scope fields go blank. When I run the report with this, the summation field is blank. Since this is in the Report Builder, the Help is useless. Can someone explain the process to get this done? Thanks. Girvin Herr -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Problem with text formatting in Report.
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+unsubscr...@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
Re: [libreoffice-users] Getting a line break through a query
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 default is NO. For a Grid control you would select a column and change that 'MultiLine Input' property for the column from No to Yes and the string will break. Best wishes, Drew On Wed, May 15, 2019 at 4:56 PM Adam Fenn wrote: > 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 your help, > Adam Fenn. > -- > To unsubscribe e-mail to: users+unsubscr...@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 > > -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Getting a line break through a query
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 your help, Adam Fenn. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] compose characters
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 parts, no way to re-join >them in a single one. The "join tables" command >is always "greyed" (not available) independently >by cursor position (inside outside table1, table2). If you split a table, I think you will find that an empty paragraph is inserted between the parts. You can see this by toggling on the display of non-printing characters. You can only join tables that are immediately adjacent, of course, so you will need to delete this empty paragraph before you can do so. I have read about this empty paragraph in the help guide but, in fact, no way to delete it. If I put the cursor just before (or after) the end-of-paragraph symbol, and press the "delete" key on the keyboard, nothing happens. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] compose characters
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 parts, no way to re-join them in a single one. The "join tables" command is always "greyed" (not available) independently by cursor position (inside outside table1, table2). If you split a table, I think you will find that an empty paragraph is inserted between the parts. You can see this by toggling on the display of non-printing characters. You can only join tables that are immediately adjacent, of course, so you will need to delete this empty paragraph before you can do so. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] compose characters
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 available) independently by cursor position (inside – outside table1, table2). Federico Quadri la10...@iperbole.bologna.it -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] compose characters
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 find > them in the "STIXSizeOneSym" font. > > On 2019-05-14 4:35 a.m., Thomas Blasejewicz wrote: > > Good afternoon > > I have to enter into a technical text a capital "M" with a short bar > > on top of it. > > Some sort of mathematical expression indicating a vector. > > > > I know there is something like "composing characters", but I cannot > > get it right. > > All I ever get is a diacritical mark either left or right from the M. > > I would appreciate if someone could point me in the right direction. > > > > While googling about this, I also found some talk a "autocorrect > > options" using : : > > Yet, I cannot make this work either. > > I suppose, there is a trick for this one too. > > > > Thank you > > Thomas > > > -- > Udvarias Ur > > This letter was generated and sent from Thunderbird 60.5.1 on Ubuntu Linux > 16.04.6 LTS. > > Cette lettre a été générée et envoyée à partir de Thunderbird 60.5.1 sur > Ubuntu Linux 16.04.6 LTS. Udvarius, as you've discovered, most fonts do not support creating an « M» via a compose key ; generally speaking it's easier to use such a key to place a bar over a vowel than a consonant. But there's no need for the OP to restrict himnself to a certain font ; rather than using the compose key, *in LibreOffice* one can use the «bar over» button to produce such characters, as per the instructions in my first reply above to the OP. Moreover, one can easily copy such a character and paste it into, e g, an epost message ; that is how I am able to write «M» in this reply Henri -- To unsubscribe e-mail to: users+unsubscr...@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
