Re: [libreoffice-users] Extract text from base field, place into new field
Hi Edwin, On Wed, 2024-05-22 at 16:01 +1000, Edwin Humphries wrote: > Hi all > > I need to copy the first word from an existing field and place it > into a > new field. Is there a way to do that autoagically? This might work for you, assuming the field with the text is called SELECT `YourTextField`, SUBSTR( `YourTextfield`, 1, LOCATE( ' ', `YourTextfield` ) - 1 ) `FirstWord` FROM `YourTableName` You can generate this in the query Design View, by just adding an extra column with SUBSTR( `YourTextField`, 1, LOCATE( ' ', `YourTextfield` ) - 1 ) and, say, FirstWord as Alias. The LOCATE function finds the position of the first space in the field. The position less 1 is the LENGTH required by the SUBSTR function. The experts may have an opinion on this. Cheers Harvey -- 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] Table filter in Base
Hi Robert, On Sun, 2024-05-19 at 19:18 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > I can confirm that with my current LO 24.2.1.2 this is NOT the > > behaviour. Removing ANY ONE table in the Table Filter followed by > > Refresh Tables causes ALL Table to disappear, and the Table Filter > > thereafter shows none selected. It is only possible to regain a > > view on > > ALL tables by closing and reopening the database. It's ALL OR > > NOTHING. > > Try to rename the user folder of LO: > > /home/user/.config/libreoffice/4 ...doesn't work. I get locked out of the databases because the 'class' files cannot be loaded. Have renamed back again. > > > > > Will Leap 15.6 with bug fixes to 24.2.1.2. in early June have this > > problem sorted? > > No it doesen't appear. But it is the same version you use at this > moment. So the behavior is a special behavior of the constellation in > your system - not of LO, packed by SuSE. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > -- 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] Table filter in Base
Hi Robert, On Sun, 2024-05-19 at 09:15 +0200, Robert Großkopf wrote: > Hi Harvey, > > have tested with LO 24.2.3.2 on OpenSUSE (original packages from LO): > > Started > Tools → Table Filter > Marked "All views" → OK > Started > View → Refresh Tables > All tables and view could be seen, special "information_schema" and > the > database I have connected to. > > Could save this and reopen → same behavior. > > Then clicked in Tools → Table Filter on checkbox "information_schema" > to > unselect this tree. > Refreshing tables and "information_schema" couldn't be seen any more. > > Then clicked in Tools → Table Filter on checkbox for the database, > which > is shown now to unselect this table. > Refreshing tables and the table couldn't be seen any more. > I can confirm that with my current LO 24.2.1.2 this is NOT the behaviour. Removing ANY ONE table in the Table Filter followed by Refresh Tables causes ALL Table to disappear, and the Table Filter thereafter shows none selected. It is only possible to regain a view on ALL tables by closing and reopening the database. It's ALL OR NOTHING. Will Leap 15.6 with bug fixes to 24.2.1.2. in early June have this problem sorted? > With direct connection "information_schema" won't be shown, but all > databases I could connect to and input data. There it is indeed > impossible to unselect a whole database. "test" appears here, but I > could unselect all tables. > > A little bit tricky to get back the tables, because they will > disappear > in the direct connection if I have unselected them. I have to > unselect > the table and select the table afterwords to see all tables - which > are > all selected then. > > Seems to work better with JDBC than with direct connection. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > -- 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] Table filter in Base
The Table Filter in Base doesn't seem to work well in my configuration. I am running Base as frontend to a network server with mysql/mariadb containing several databases, connected via MySQL(JDBC) Logging in to the mysql server causes Base to show ALL the tables of these databases (including the mysql and performance_schema tables) in the Tables window. I supposed that I could limit the view to the database tables on which I am working at any time by applying the Table Filter (Tools > Table Filter). Unfortunately, the Table Filter causes only NO databases/tables AT ALL to be shown, and then ONLY AFTER closing Base and opening it again. So the option seems to be ALL or NONE, but certainly not selectively filtered tables. Is this behaviour a result of my network configuration or a fault in LOBase? Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded Cheers Harvey -- 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] Column/Row highlighting
On Wed, 2024-05-15 at 09:15 +0200, Robert Großkopf wrote: > Hi Thomas, > > > Probably I am a little stupid, but what is the difference between > > "24.2.3" and "7.6.7" (in my case 7.6.6). > > These number look VERY different. > > Version numbering had been changed. > 24 → Year 2024 > 2 → February > 3 → third bugfix release. > > > > Or does it not really matter? > > Doesn't matter for you. Next main number will be 24.8, then 25.2 … > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > Hi Robert, Thanks, that's good to know. By the way, what exactly does 24.2.1.2 mean? It's my current version from OpenSUSE. The above current version has a problem with the Impress odp export to pptx. My correspondent using Windows 10 cannot open the pptx. So I had to revert to 7.6 for him. Are you suggesting with your above explanation that I may have to wait until August for a version that works in that respect? Cheers Harvey -- 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] LO pptx-file cannot be opened in MS-Office
Hi Regina, The LO 7.6 Variant works a treat! Many thanks for the tip! Problem solved. You guys are very special!! You have thereby also made me aware that the LO V24.x and V7.y series are both managed in the OpenSUSE repositories. Greetings Harvey On Thu, 2024-05-02 at 13:39 +0200, Regina Henschel wrote: > Hi Harvey, > > Harvey Nimmo schrieb am 30.04.2024 um 09:34: > > Each month I have to prepare a contribution to a presentation. > > I write my contribution in LO-Impress as .odp, save it and send it > > as > > .pptx for a colleague to integrate it using MS-Office with other > > pptx. > > presentations. > > > > This usually works well, but last month the colleague who does the > > pptx > > integration could not open my file. Until last month the above > > procedure worked well and failed in the last week of March. > > Do you have a new LibreOffice version compared to the situation in > February? > > > > > Is anyone able to put their finger on a possible cause/solution? > > > I am using OpenSUSE Linux 15.5 with LO > > Version: 24.2.1.2 (X86_64) / LibreOffice Community > > Build ID: 420(Build:2) > > CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 > > Locale: en-GB (en_GB.UTF-8); UI: en-GB > > Calc: threaded > > You can try, whether the problem occurs too when using a LibreOffice > 7.6. Perhaps try it with a portable version. > https://www.libreoffice.org/download/portable-versions/ > > Kind regards, > Regina > -- 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] LO pptx-file cannot be opened in MS-Office
Yes, I took this version on 2024.03.07. In detail it is - Update to 24.2.1.2 (jsc#PED-7496): https://wiki.documentfoundation.org/ReleaseNotes/24.2 https://wiki.documentfoundation.org/Releases/24.2.1/RC1 and https://wiki.documentfoundation.org/Releases/24.2.1/RC2 https://wiki.documentfoundation.org/Releases/7.6.4/RC1 https://wiki.documentfoundation.org/Releases/7.6.3/RC2 https://wiki.documentfoundation.org/Releases/7.6.3/RC1 https://wiki.documentfoundation.org/Releases/7.6.2/RC2 - Remove the following patches, as they're no longer required for LibreOffice 24.2: * CVE-2023-6185.patch * CVE-2023-6186-1.patch * CVE-2023-6186-2.patch * CVE-2023-6186-3.patch * CVE-2023-6186-4.patch * CVE-2023-6186-5.patch On Thu, 2024-05-02 at 13:39 +0200, Regina Henschel wrote: > Hi Harvey, > > Harvey Nimmo schrieb am 30.04.2024 um 09:34: > > Each month I have to prepare a contribution to a presentation. > > I write my contribution in LO-Impress as .odp, save it and send it > > as > > .pptx for a colleague to integrate it using MS-Office with other > > pptx. > > presentations. > > > > This usually works well, but last month the colleague who does the > > pptx > > integration could not open my file. Until last month the above > > procedure worked well and failed in the last week of March. > > Do you have a new LibreOffice version compared to the situation in > February? > > > > > Is anyone able to put their finger on a possible cause/solution? > > > I am using OpenSUSE Linux 15.5 with LO > > Version: 24.2.1.2 (X86_64) / LibreOffice Community > > Build ID: 420(Build:2) > > CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 > > Locale: en-GB (en_GB.UTF-8); UI: en-GB > > Calc: threaded > > You can try, whether the problem occurs too when using a LibreOffice > 7.6. Perhaps try it with a portable version. > https://www.libreoffice.org/download/portable-versions/ > > Kind regards, > Regina > -- 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] LO pptx-file cannot be opened in MS-Office
This attempt (conversion of wmf/emf to png) did not work, as the colleague has just informed me. He is using Windows 10 (22H2, x64) and Microsoft 356 (current version). His error starts with an invitation to repair the pptx followed by a statement that some of the pptx (protected) content could not be repaired and is removed. I am trying to find out which content may have been removed, as that would be the potential culprit. Cheers Harvey On Tue, 2024-04-30 at 10:48 +0200, Harvey Nimmo wrote: > Thanks. One of the pictures is in wmf format (whatever that is!). All > the others are either png or jpg. I have converted the wmf to png, > but > now I have to wait for my colleague to be free enough to test it. > > Cheers > Harvey > > > On Tue, 2024-04-30 at 10:20 +0200, Italo Vignoli wrote: > > Check the pictures, I am sure there is one which creates the issue. > > > > On 30/04/24 10:13, Harvey Nimmo wrote: > > > Hallo Italo, > > > > > > Thank you very much for your offer. Unfortunately, the slides > > > contain > > > personal data, that I cannot really share. > > > > > > For your information, I am obliged to use a given format for each > > > slide > > > that contains a photo and text box with information, with further > > > text > > > boxes for flexible usage. > > > > > > Cheers > > > Harvey > > > > > > On Tue, 2024-04-30 at 10:03 +0200, Italo Vignoli wrote: > > > > In my experience, in the extremely rare cases where this > > > > happens, > > > > the > > > > problem lies in one or more graphic elements in the master or > > > > in > > > > one > > > > or > > > > more slides. > > > > > > > > Usually, these are non-standard EPS images - the ones that > > > > cause > > > > the > > > > most problems are those generated by the latest Adobe software > > > > - > > > > which > > > > make the file unreadable by MS PowerPoint. > > > > > > > > In these cases, the EPS image should be opened with Inkscape, > > > > saved > > > > as > > > > PNG and replaced in the slide(s). > > > > > > > > To provide a more precise opinion, though, I should see the > > > > file. > > > > > > > > If you can send it to my address as attachment (the list > > > > doesn't > > > > accept > > > > attachments) I can double check. > > > > > > > > On 30/04/24 09:34, Harvey Nimmo wrote: > > > > > Each month I have to prepare a contribution to a > > > > > presentation. > > > > > I write my contribution in LO-Impress as .odp, save it and > > > > > send > > > > > it > > > > > as > > > > > .pptx for a colleague to integrate it using MS-Office with > > > > > other > > > > > pptx. > > > > > presentations. > > > > > > > > > > This usually works well, but last month the colleague who > > > > > does > > > > > the > > > > > pptx > > > > > integration could not open my file. Until last month the > > > > > above > > > > > procedure worked well and failed in the last week of March. > > > > > > > > > > Is anyone able to put their finger on a possible > > > > > cause/solution? > > > > > > > > > > I am using OpenSUSE Linux 15.5 with LO > > > > > Version: 24.2.1.2 (X86_64) / LibreOffice Community > > > > > Build ID: 420(Build:2) > > > > > CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 > > > > > Locale: en-GB (en_GB.UTF-8); UI: en-GB > > > > > Calc: threaded > > > > > > > > > > I expect an input from the colleague about his Office/Windows > > > > > versions. > > > > > > > > > > Best regards > > > > > Harvey Nimmo > > > > > > > > > > > > > > > > > > > > > -- > > Italo Vignoli - it...@vignoli.org > > mobile/signal +39.348.5653829 > > GPG Key ID - 0xAAB8D5C0 > > DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 > > > > > > -- 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] LO pptx-file cannot be opened in MS-Office
Thanks. One of the pictures is in wmf format (whatever that is!). All the others are either png or jpg. I have converted the wmf to png, but now I have to wait for my colleague to be free enough to test it. Cheers Harvey On Tue, 2024-04-30 at 10:20 +0200, Italo Vignoli wrote: > Check the pictures, I am sure there is one which creates the issue. > > On 30/04/24 10:13, Harvey Nimmo wrote: > > Hallo Italo, > > > > Thank you very much for your offer. Unfortunately, the slides > > contain > > personal data, that I cannot really share. > > > > For your information, I am obliged to use a given format for each > > slide > > that contains a photo and text box with information, with further > > text > > boxes for flexible usage. > > > > Cheers > > Harvey > > > > On Tue, 2024-04-30 at 10:03 +0200, Italo Vignoli wrote: > > > In my experience, in the extremely rare cases where this happens, > > > the > > > problem lies in one or more graphic elements in the master or in > > > one > > > or > > > more slides. > > > > > > Usually, these are non-standard EPS images - the ones that cause > > > the > > > most problems are those generated by the latest Adobe software - > > > which > > > make the file unreadable by MS PowerPoint. > > > > > > In these cases, the EPS image should be opened with Inkscape, > > > saved > > > as > > > PNG and replaced in the slide(s). > > > > > > To provide a more precise opinion, though, I should see the file. > > > > > > If you can send it to my address as attachment (the list doesn't > > > accept > > > attachments) I can double check. > > > > > > On 30/04/24 09:34, Harvey Nimmo wrote: > > > > Each month I have to prepare a contribution to a presentation. > > > > I write my contribution in LO-Impress as .odp, save it and send > > > > it > > > > as > > > > .pptx for a colleague to integrate it using MS-Office with > > > > other > > > > pptx. > > > > presentations. > > > > > > > > This usually works well, but last month the colleague who does > > > > the > > > > pptx > > > > integration could not open my file. Until last month the above > > > > procedure worked well and failed in the last week of March. > > > > > > > > Is anyone able to put their finger on a possible > > > > cause/solution? > > > > > > > > I am using OpenSUSE Linux 15.5 with LO > > > > Version: 24.2.1.2 (X86_64) / LibreOffice Community > > > > Build ID: 420(Build:2) > > > > CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 > > > > Locale: en-GB (en_GB.UTF-8); UI: en-GB > > > > Calc: threaded > > > > > > > > I expect an input from the colleague about his Office/Windows > > > > versions. > > > > > > > > Best regards > > > > Harvey Nimmo > > > > > > > > > > > > > > > > -- > Italo Vignoli - it...@vignoli.org > mobile/signal +39.348.5653829 > GPG Key ID - 0xAAB8D5C0 > DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 > > -- 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] LO pptx-file cannot be opened in MS-Office
Hallo Italo, Thank you very much for your offer. Unfortunately, the slides contain personal data, that I cannot really share. For your information, I am obliged to use a given format for each slide that contains a photo and text box with information, with further text boxes for flexible usage. Cheers Harvey On Tue, 2024-04-30 at 10:03 +0200, Italo Vignoli wrote: > In my experience, in the extremely rare cases where this happens, the > problem lies in one or more graphic elements in the master or in one > or > more slides. > > Usually, these are non-standard EPS images - the ones that cause the > most problems are those generated by the latest Adobe software - > which > make the file unreadable by MS PowerPoint. > > In these cases, the EPS image should be opened with Inkscape, saved > as > PNG and replaced in the slide(s). > > To provide a more precise opinion, though, I should see the file. > > If you can send it to my address as attachment (the list doesn't > accept > attachments) I can double check. > > On 30/04/24 09:34, Harvey Nimmo wrote: > > Each month I have to prepare a contribution to a presentation. > > I write my contribution in LO-Impress as .odp, save it and send it > > as > > .pptx for a colleague to integrate it using MS-Office with other > > pptx. > > presentations. > > > > This usually works well, but last month the colleague who does the > > pptx > > integration could not open my file. Until last month the above > > procedure worked well and failed in the last week of March. > > > > Is anyone able to put their finger on a possible cause/solution? > > > > I am using OpenSUSE Linux 15.5 with LO > > Version: 24.2.1.2 (X86_64) / LibreOffice Community > > Build ID: 420(Build:2) > > CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 > > Locale: en-GB (en_GB.UTF-8); UI: en-GB > > Calc: threaded > > > > I expect an input from the colleague about his Office/Windows > > versions. > > > > Best regards > > Harvey Nimmo > > > > > > > -- > Italo Vignoli - it...@vignoli.org > mobile/signal +39.348.5653829 > GPG Key ID - 0xAAB8D5C0 > DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 > > -- 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] LO pptx-file cannot be opened in MS-Office
Yes, ppt was the 'solution' we found. However, the final result was optically seriously suboptimal. Cheers Harvey On Tue, 2024-04-30 at 15:57 +0800, Peter Langfelder wrote: > No idea about the cause/causes, but when I do the same type of > presentation sharing, I save my presentation as a ppt (the old > powerpoint format). No complaints from my co-workers yet. Admittedly > my presentations are very simple (text, some tables, PNG images); ppt > may not work if you need more features. > > HTH, > > Peter > > On Tue, Apr 30, 2024 at 3:36 PM Harvey Nimmo wrote: > > > > Each month I have to prepare a contribution to a presentation. > > I write my contribution in LO-Impress as .odp, save it and send it > > as > > .pptx for a colleague to integrate it using MS-Office with other > > pptx. > > presentations. > > > > This usually works well, but last month the colleague who does the > > pptx > > integration could not open my file. Until last month the above > > procedure worked well and failed in the last week of March. > > > > Is anyone able to put their finger on a possible cause/solution? > > > > I am using OpenSUSE Linux 15.5 with LO > > Version: 24.2.1.2 (X86_64) / LibreOffice Community > > Build ID: 420(Build:2) > > CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 > > Locale: en-GB (en_GB.UTF-8); UI: en-GB > > Calc: threaded > > > > I expect an input from the colleague about his Office/Windows > > versions. > > > > Best regards > > Harvey Nimmo > > > > > > > > -- > > 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] LO pptx-file cannot be opened in MS-Office
Each month I have to prepare a contribution to a presentation. I write my contribution in LO-Impress as .odp, save it and send it as .pptx for a colleague to integrate it using MS-Office with other pptx. presentations. This usually works well, but last month the colleague who does the pptx integration could not open my file. Until last month the above procedure worked well and failed in the last week of March. Is anyone able to put their finger on a possible cause/solution? I am using OpenSUSE Linux 15.5 with LO Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded I expect an input from the colleague about his Office/Windows versions. Best regards Harvey Nimmo -- 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] Labels created in Writer shifts downward while printed
The phenomenon you describes suggests that the label size might be set wrongly. Even if the label size is set to match the published values. Maybe you should try reducing the label height by a millimeter or two, (deviating a little from the published value) Cheers Harvey On Fri, 2024-03-22 at 20:01 -0700, Richard England wrote: > Another (final) thought. Are you using 100% scaling when printing? > If > there is any scaling or "fit to page" in effect that might be a > problem. > > If that does not help I hope someone else comes along with a better > suggestion. > > Good luck. > > ~~R > > On 3/22/24 18:19, Hartman Tam wrote: > > Hello Richard, > > > > Thanks for the quick response. I tried both the paper tray and > > manual > > feed slot which both have the same problem. This lead me to believe > > that if slipping actually occurred, it will be the rollers deep > > inside > > the printer. Unfortunately, the printer user manual which doesn't > > include instructions for cleaning the roller inside the printer but > > the paper pickup roller serving the paper tray only. > > > > And I would like to add, the shift is gradually/accumulative. That > > means, the first row is well aligned, and start from second row it > > starts to shift down a little bit, third row doubles that, and so > > on. > > This lead me to believe it shouldn't be a slipping issue as it > > won't > > be that consistent. > > > > Thanks, > > Hartman > > > > On 23/03/2024 00:46, Richard England wrote: > > > I don't own this printer model but it sounds like the paper could > > > be > > > slipping inside (and the rollers aren’t moving the paper through > > > the > > > printer correctly). Try cleaning the rollers inside the printer > > > with > > > a lint free damp cloth (make sure not too damp and printer is > > > switched off and unplugged) > > > > > > ~~R > -- 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] Min. skills for Base
Don't give up...Base is a powerful tool for managing all kinds of data. and Robert Großkopf is an excellent advisor! Happy new year to all! Harvey On Sun, 2023-12-31 at 13:43 -0500, Jonathan Ames wrote: > In trying to reopen table I'd created, I cannot add records -- says > ERROR > "Attempt to insert null into a non-nullable column: column: Key > table: > Owntunes in statement [INSERT INTO "Owntunes" ( "Pubdomain?","Song") > VALUES > ( ?,?)]--" anyway I don't know what it means. The table is "Owntunes. > All I > did was try to begin a new record.I also get a very small red icon > containing an "I" with a slash through it, near top left of "open > database". Manual "Base" section doesn't cover this. Using MAC OS > Sonoma. > Have Java on computer. Wondering if I will really have to learn to > code if > I want sort of consumer database formerly available (e.g., Lotus > Approach) > -- I'm 77. New to LibreOffice: is understanding and responding to > such as > above required for use? > > Sort of like the following learning curve: > > > 1. - Databases store and manipulate data. > 2. - Data can be numeric or verbal. > 3. - E = MC2 > > Do other folks give up on LibreOffice Base as too technical? Any idea > where > they end up? > > Thanks > > Jonathan > > Jonathan Ames, PhD > Clinical Psychologist > 607-227-4792 - Cell > jnthn.a...@gmail.com > www.whatnowconnect.com > > > Email Confidentiality Notice: The information contained in this > transmission is confidential, proprietary or privileged and may be > subject > to protection under the law, including the Health Insurance > Portability and > Accountability Act (HIPAA). The message included in this email is for > the > sole use of the intended individual or entity to whom it is > addressed. If > you are not the intended recipient, you are notified that any use, > distribution or copying of the message is strictly prohibited and you > may > be subject to criminal or civil penalties. If you received this > transmission in error, please contact the sender immediately by > replying to > this email and delete the material from all computers. > > > -- 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] Base report text fields of variable size
On Tue, 2023-11-21 at 08:54 +0100, Robert Großkopf wrote: > Hey Harvey, > > > The next question, though, is how do I ensure that only complete > > records are printed on a page? I.e. How do I prevent the records > > being > > split between the bottom of one page and the top of the next? > > The 'Force new section' function seems to print only one record per > > page. > > Set "Keep together" for the Group. Doesn't work in "Detail" so create > a > group instead. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > Thank you, Robert. That works !! Problem solved! You are special. Keep an eye open for my next question. ;-) Cheers Harvey l -- 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] Base report text fields of variable size
The next question, though, is how do I ensure that only complete records are printed on a page? I.e. How do I prevent the records being split between the bottom of one page and the top of the next? The 'Force new section' function seems to print only one record per page. Cheers Harvey On Mon, 2023-11-20 at 18:08 +0100, Harvey Nimmo wrote: > Sorry to trouble you. 'Auto grow' is the answer to my question. I > failed to notice this improvement since I generated the report > originally many years ago! > > Cheers > Harvey > > On Mon, 2023-11-20 at 17:54 +0100, Harvey Nimmo wrote: > > When creating a Base report consisting of a list of sddresses, for > > example, some of the text fields occupy more than the fixed space > > allowed by the Base report editor. The overlarge texts are > > highlighted > > with red triangles and the field sizes can be edited with Writer. > > This > > editing task is exceedingly > > tedious when the list is long. > > > > Does anyone have an idea how use the Base report editor to avoid > > having > > to edit each overlarge text field individually? > > > > Cheers > > Harvey > > > > -- 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] Base report - text fields of variable size
Sorry to trouble you. 'Auto grow' is the answer to my question. I failed to notice this improvement since I generated the report originally many years ago! Cheers Harvey On Mon, 2023-11-20 at 17:54 +0100, Harvey Nimmo wrote: > When creating a Base report consisting of a list of sddresses, for > example, some of the text fields occupy more than the fixed space > allowed by the Base report editor. The overlarge texts are > highlighted > with red triangles and the field sizes can be edited with Writer. > This > editing task is exceedingly > tedious when the list is long. > > Does anyone have an idea how use the Base report editor to avoid > having > to edit each overlarge text field individually? > > Cheers > Harvey > -- 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] Base report - text fields of variable size
When creating a Base report consisting of a list of sddresses, for example, some of the text fields occupy more than the fixed space allowed by the Base report editor. The overlarge texts are highlighted with red triangles and the field sizes can be edited with Writer. This editing task is exceedingly tedious when the list is long. Does anyone have an idea how use the Base report editor to avoid having to edit each overlarge text field individually? Cheers Harvey -- 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] Mail bounce: alarmax...@gmail.com [Was: How can I rejoin this list please?]
Just to be clear: the problem occurred when I sent any mail from my (non-gmail) ISP to a gmail destination. All gmail destinations blocked all emails from me. The rejection mail I received told me to make an SPF or DKIM entry at my ISP (similar to the text in Budge's post on this). I did what was recommended in the rejection mail and the problem disappeared. Apparently, Microsoft/outlook/google had made a change that affected non-customers. My sister reported the same phenomenon that was similarly corrected. Cheers Harvey On Sat, 2023-07-08 at 16:01 -0400, John Kaufmann wrote: > On 2023-07-08 14:43, Harvey Nimmo wrote: > > > I had this problem with any email sent to a gmail account. ... > > I doubt it's so simple, Harvey. I have no such problem with my own > gmail account (which has no outlook.com server in the mix). > jk > -- 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] Mail bounce: alarmax...@gmail.com [Was: How can I rejoin this list please?]
Hello Budge, I had this problem with any email sent to a gmail account. As indicated by the email rejection message, the solution is to login to your email account at your ISP and set the SPF parameters for your email domain. I needed help from my ISP to make the right settings in my case. Cheers Harvey On Sat, 2023-07-08 at 19:15 +0100, Budge wrote: > Hi John, > I checked out the Google link on authentication and it seems that the > problem probably lies with my ISP. I have asked him to check the > headers to find out if the problem is with him or further away. Will > let you know what I learn. > Regards, > Budge. > > On 07/07/2023 17:45, John Kaufmann wrote: > > Your email has not been hacked. All of my (and presumably others') > > posts to the list in the last few days have returned that bounce > > from alarmax...@gmail.com - probably a list subscriber. The first > > obvious curiosity about this is that it's a gmail address, but the > > bounce comes from postmas...@outlook.com, so it's not gmail > > bouncing the message; likely there's an interesting mail > > configuration issue -- and on the list side as well, since the > > bounce is returned to the poster rather than to the list. > > > > As alarmax...@gmail.com is the only list subscriber bouncing list > > mail, I wrote directly, to see if there is a response from my email > > address. It did NOT bounce, so the problem presumably lies in a > > list configuration interaction with that user's mail configuration. > > If there is a reply, I will of course report it. > > > > jk > > > > On 2023-07-06 11:02, Budge wrote: > > > > > > ... something strange happened in the background when I first > > > asked how to renew. > > > I had from postmas...@outlook.com the following message:- > > > > > > *mx.google.com rejected your message to the following email > > > addresses:* > > > > > > alarmax...@gmail.com > > > Your message wasn't delivered because the recipient's email > > > provider rejected it. > > > > > > *mx.google.com gave this error: > > > This mail is unauthenticated, which poses a security risk to the > > > sender and Gmail users, and has been blocked. The sender must > > > authenticate with at least one of SPF or DKIM. For this message, > > > DKIM checks did not pass and SPF check for [errichel.co.uk] did > > > not pass with ip: [2a01:111:f400:7e8b::207]. The sender should > > > visit > > > https://support.google.com/mail/answer/81126#authentication for > > > instructions on setting up authentication. p13- > > > 20020a056402074d00b0051bfa6da365si551974edy.585 - gsmtp > > > * > > > > > > No idea why or what. Whoever uses Outlook anyway but does it > > > mean my mail has been hacked? > > > > > > -- 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] Failed connection to MySQL database
Hi Robert, > Hi Harvey, > > > > I am running mariadb 10 on the backend. File mysql-connector- > > java.jar > > is registered under Options -> LibreOffice -> Advanced -> Class > > Path at > > /usr/share/java/ > > For MariaDB I would use the JDBC-connector fro MariaDB, not from > MySQL. > You could get the connector form here: > https://downloads.mariadb.com/Connectors/java/ > Connection to: org.mariadb.jdbc.Driver > For connecting with drivers since version 3.0. you have to add > ?permitMysqlScheme to the database name > test?permitMysqlScheme > will be the connection string for the database 'test'. > > > > I'm not sure I follow what you saying about connection change. I > > haven't changed the connection parameters nor the method. I have > > tried > > setting up the database with an alternative connection method (i.e > > 'Direct'). That succeeds, but I need to transfer all my macros, > > queries, forms and reports from the old .odb to the new one. > > Couldn't you change the connection in the file, which had been > connected > by JDBC? > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > For the moment, I have discovered that the name of the file referred to in the Class Path (or the actual file name) had been changed to 'mysql- connector-j.jar- not by me, but possibly during the course of recent repository updates. All works now as before. I would not have noticed it without your inputs, so many thanks for the tips! It seems wise to consider switching to mariadb connectors but for the moment, I won't experiment with the mariadb connectors until I have made sure that Plan Bs are in place. Cheers Harvey -- 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] adding page numbers to document
In Writer, place your cursor at the place you want the page number to appear. If you want it in the footer or header you will first have to select the blue footer or header marker on your page. Click Insert -> Page Number. If you want "page of total page count", you will have to add e.g. the word 'of' or '/' or whatever, and then click on Insert -> Field -> Page Count. On Tue, 2023-05-23 at 23:31 -0700, Helen Chesbrough wrote: > Please tell me how to add page numbers to my document. > -- 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] Failed connection to MySQL database
On Tue, 2023-05-23 at 15:05 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > I connect daily to a MySQL database located on a network server > > from > > the LO-Base front-end on my desktop. The connection type is > > MySQL(JDBC). However, today, the "driver class > > 'com.mysql.jdbc.Driver' > > could not be loaded". There seems to be no way to make the > > connection, > > although I am not aware of having changed anything. I can access > > the > > database via my browser using phpMyAdmin, so, I assume, there is > > nothing wrong with the database schemata themselves. > > You are using JDBC with MySQL. Don't know how you have set the > connection, but if there has been a update of your system the driver > class might be wrong. Could be it has changed to > com.mysql.cj.jdbc.Driver. > > Which version of MySQL is version on your system? > Did you include the driver manually by LibreOffice in ClassPath > (Options > → LibreOffice → Extended…)? > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > Thanks for your input, robert. I am running mariadb 10 on the backend. File mysql-connector-java.jar is registered under Options -> LibreOffice -> Advanced -> Class Path at /usr/share/java/ I'm not sure I follow what you saying about connection change. I haven't changed the connection parameters nor the method. I have tried setting up the database with an alternative connection method (i.e 'Direct'). That succeeds, but I need to transfer all my macros, queries, forms and reports from the old .odb to the new one. Cheers Harvey -- 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] Failed connection to MySQL database
What can have gone wrong here? I connect daily to a MySQL database located on a network server from the LO-Base front-end on my desktop. The connection type is MySQL(JDBC). However, today, the "driver class 'com.mysql.jdbc.Driver' could not be loaded". There seems to be no way to make the connection, although I am not aware of having changed anything. I can access the database via my browser using phpMyAdmin, so, I assume, there is nothing wrong with the database schemata themselves. Any suggestions out there? Version: 7.3.4.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded Cheers Harvey -- 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] LibreOffice issue
I'm not a windows user, but perhaps the LibreOffice process is running in the background and not able to access a foreground window. In that case, you should try to kill the LibreOffice that is running in the background by opening the process manager (what's its correct name,anyone?) look for LibreOffice and kill the process. After you have done that, you should be able to restart LibreOffice sucessfully Cheers Harvey On Fri, 2023-04-14 at 14:38 +0300, Ігор Ніколюк wrote: > I am windows 10 user of LibreOffice (official windows) my LibreOfice > stopped opening and i dont know why. Can you help me please? > > > -- 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] Basic Macros with Base
Hi Robert, the thought occurs to me that the existing quotes within the SQL statements may need their own treatment. The statements that work under the LOBase Tools>SQL... function have different type of single quotemarks for the column names (e.g. containing two separate words) or the text to be set in the columns. I have assumed that the macro (SQL) string variables just need to be enclosed in double quotemarks. Is this right? Cheers Harvey On Wed, 2023-01-25 at 21:51 +0100, Robert Großkopf wrote: > Hi Harvey, > > > > how would this work for me, where I only want to create a SQL > > statement > > as a string and execute it. > > Mcro works with SQL-code, which has been saved in a field of a table. > Field in the table is called "SQL-Code". Table is datasource of a > form. > A button in this form will start the code. > > First needed object is executing a button in the form to start the > procedure. > > If you will save all code directly in a macro you will need > → a connection to the database > → SQL code, which has been maskes with double doublequotes for > fieldnames and tablenames > → var for creating a statement > → execute the sql-code in this created statement > > At which line of the macro the code stops for you? > > > > > > Here a code from German Base Handbuch: > > > > > > SUB ChangeData(oEvent AS OBJECT) > > > DIM oConnection AS OBJECT > > > DIM oForm AS OBJECT > > > DIM stSql AS STRING > > > DIM oSql_Statement AS OBJECT > > > DIM inValue AS INTEGER > > > oForm = oEvent.Source.Model.Parent > > > oConnection = oForm.activeConnection() > > > stSQL = oForm.getString(oForm.findColumn("SQL-Code")) > > > inValue = MsgBox("Should SQL-Code" & CHR(13) & stSQL & CHR(13) > > > & > > > "be executed?", 20, "Execute SQL-Code") > > > IF inValue = 6 THEN > > > oSQL_Statement = oConnection.createStatement() > > > oSQL_Statement.execute(stSql) > > > END IF > > > END SUB > > > > > > SQL-Code is part of a table. Field in the table is "SQL-Code". > > > Table > > > is > > > datasource of a form. A button in this form will be enough to > > > execute > > > the macro. You coud update, insert or delete rows by command > > > "execute". > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > -- 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] Basic Macros with Base
Hi Robert, how would this work for me, where I only want to create a SQL statement as a string and execute it. Can it be that the string is not recognised as SQL? (In my MSAccess days it worked). Here the run-time error indicates that the "Object variable is not set" although it is valid SQL text and works 'by hand'. Cheers Harvey On Wed, 2023-01-25 at 07:43 +0100, Robert Großkopf wrote: > Hi Harvey, > > why do you want to use Access2Base? > > Here a code from German Base Handbuch: > > SUB ChangeData(oEvent AS OBJECT) > DIM oConnection AS OBJECT > DIM oForm AS OBJECT > DIM stSql AS STRING > DIM oSql_Statement AS OBJECT > DIM inValue AS INTEGER > oForm = oEvent.Source.Model.Parent > oConnection = oForm.activeConnection() > stSQL = oForm.getString(oForm.findColumn("SQL-Code")) > inValue = MsgBox("Should SQL-Code" & CHR(13) & stSQL & CHR(13) & > "be executed?", 20, "Execute SQL-Code") > IF inValue = 6 THEN > oSQL_Statement = oConnection.createStatement() > oSQL_Statement.execute(stSql) > END IF > END SUB > > SQL-Code is part of a table. Field in the table is "SQL-Code". Table > is > datasource of a form. A button in this form will be enough to execute > the macro. You coud update, insert or delete rows by command > "execute". > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > -- 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] Basic Macros with Base
You guys are terrific. Thanks for your help! The reason I went to the macros was because I was looking for a repository within LOBase for a number of SQL sequences (e.g. UPDATE tbl SET Col WHERE expr) that a would want to execute from time to time. A macro seemed to be the only possibility. What else could you suggest? (It's a rather trivial requirement actually and using a macro could become a sledgehammer to crack a nut. Collecting my SQL statements into a text file somewhere in the bowels of my machine to be called up with cut and paste struck me as a bit primitive and inelegant). On Tue, 2023-01-24 at 17:07 -0500, Andrew Pitonyak wrote: > > I have a guess since I was not previously aware of this method. > > There is precedence for LO adding support for Microsoft Office (MSO) > compatibility. I am guessing that this method was added for MSO > compatibility with MS Access (but that is just a guess). I would > assume, therefore, that it should act similarly to how the method > work in MS Access (again a guess). > > When I really want to know, I pull the code and then I go looking for > the method in the code to see what it does. > > Also, if it immediately registers as an error, then you might need to > turn on compatibility mode. > > Well, that is what I thought until I googled a bit > > This implies that the command is based on an extension rather than > directly supported by LO. > > https://extensions.libreoffice.org/en/extensions/show/access2base > https://extensions.openoffice.org/en/project/access2base-api-base-users > https://ask.libreoffice.org/t/syntax-form-controls-base/45282 > > but then this seems to imply otherwise > > https://books.libreoffice.org/en/BG72/BG7209-Macros.html > > Sorry, not much help :-( > > > On Tuesday, January 24, 2023 15:50 EST, Harvey Nimmo > wrote: > Thanks. Not sure I can understand how that should work...hmmm > > I based my syntax on the example here > > https://learn.microsoft.com/en-us/office/vba/api/access.docmd.runsql > > > > On Tue, 2023-01-24 at 20:39 +, Dave Howorth wrote: > > On Tue, 24 Jan 2023 20:32:18 +0100 > > Harvey Nimmo wrote: > > > > > Where can I find the syntax of the DoCmd.RunSQL command to be > > > used > > > with a LOBase Macro in Basic? > > > > I've never heard of the command, but google suggests > > > > https://docs.libreoffice.org/wizards/html/classaccess2base_1_1DoCmd.html#a3c1b223e5e4024f2a8b955b2df3b6f92 > > > > I've no idea whether it is correct/relevant. > > > > > My assumption was > > > X = "SQL string" > > > DoCmD.RunSQL X > > > -- 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] Basic Macros with Base
Thanks. Not sure I can understand how that should work...hmmm I based my syntax on the example here https://learn.microsoft.com/en-us/office/vba/api/access.docmd.runsql On Tue, 2023-01-24 at 20:39 +, Dave Howorth wrote: > On Tue, 24 Jan 2023 20:32:18 +0100 > Harvey Nimmo wrote: > > > Where can I find the syntax of the DoCmd.RunSQL command to be used > > with a LOBase Macro in Basic? > > I've never heard of the command, but google suggests > > https://docs.libreoffice.org/wizards/html/classaccess2base_1_1DoCmd.html#a3c1b223e5e4024f2a8b955b2df3b6f92 > > I've no idea whether it is correct/relevant. > > > My assumption was > > X = "SQL string" > > DoCmD.RunSQL X > -- 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] Basic Macros with Base
The only reference, I found to DoCmd in the LO Base Guide 7.3 is on page 504 (Special commands), i.e. rather brief ("To name a few"). As the employed syntax compiles in LOBase without error, I assume it is correct as described below, so far. So I'm looking for a better explanation for the behaviour. By the way, I am running Version: 7.3.4.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded LO Base is my front end toward a Mariadb (V10) as backend database server system. Cheers Harvey On Tue, 2023-01-24 at 14:45 -0500, Andrew Pitonyak wrote: > > I am not familiar with "DoCmd.RunSQL", I will have to look it up > (unless you have a few links). Is DoCmd a server? > > I have not used Base with Macros in a long time, but, last time I > did, I was creating connections to a database and then running SQL > commands using a connection object. > > I have examples in AndrewBase.odt if that is of any help to you. > > https://www.pitonyak.org/database/ > https://www.pitonyak.org/database/AndrewBase.odt (called Random DB > Ramblins, and yes that is spelled incorrectly). > > > On Tuesday, January 24, 2023 14:32 EST, Harvey Nimmo > wrote: > Where can I find the syntax of the DoCmd.RunSQL command to be used > with > a LOBase Macro in Basic? > > My assumption was > X = "SQL string" > DoCmD.RunSQL X > > The SQL string runs correctly is correct when executed as SQL Command > in the Base Tools/SQL window. > > The Basic Macro with the above statemsnt compiles without error when > the SQL command text is enclosed in "" quotes. But at runtime it > halts > with the message that the variable X is not set. However, a Basic > Print > statement shows the correct value for X. > > (By the way, the Watch function displays no values for any variable. > Not sure if it should) > > My conclusion is that I ma using the wrong syntax for DoCmd.RunSQL > > Any ideas? > > > -- 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] Basic Macros with Base
Where can I find the syntax of the DoCmd.RunSQL command to be used with a LOBase Macro in Basic? My assumption was X = "SQL string" DoCmD.RunSQL X The SQL string runs correctly is correct when executed as SQL Command in the Base Tools/SQL window. The Basic Macro with the above statemsnt compiles without error when the SQL command text is enclosed in "" quotes. But at runtime it halts with the message that the variable X is not set. However, a Basic Print statement shows the correct value for X. (By the way, the Watch function displays no values for any variable. Not sure if it should) My conclusion is that I ma using the wrong syntax for DoCmd.RunSQL Any ideas? -- 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] Printing labels from LO-Base
Help no longer needed. The label fields had to be re-entered. I could not (did not) recognise that they did not have a connection to the database in spite of the fact that all fields were still present from previous uses. I suppose it must have something to do with the loss of database registration (during OS/LO updates?) Problem solved. On Mon, 2022-12-12 at 20:44 +0100, Harvey Nimmo wrote: > I need help to print address labels from my database. I have had it > working e.g. a year ago, but now I am having trouble. My database > Mariadb10 on a backend server and Base on my frontend desktop. > > I have followed the following procedure (as last year) > > 1. From Base (adresslisten database) select File → New → Labels > 2. In window ‘Labels’ check that source of data and fields under > ‘Label text:” is as desired and select Table Query Q_labels_Xmas (ie. > the one set up for labels) > 3. If not, choose Table and Database fields as desired, moving > fields into Label Text box > 4. Select Format ‘Sheet’ > 5. Select Brand (z.B. Herma A4) and Type (z.B. 4278) of labels > 6. Check Tab Format of labels, in particular the left margin > should > be at least 0,55 cm and top margin 2,25 cm (in case of Herma 4278 > labels) > 7. Tab ‘Options’ are ‘Entire page’ and ‘Synchronise contents’ > 8. Click ‘New Document’ > 9. In Writer document click page navigator ‘First Mail Merge > Entry’ > to highlight the related line of icons. > 10. Before generating the labels (point 13) got to the > File>Printer > Settings>Options and check the box ‘Left pages’ in order to suppress > the generation of blank right pages. > 11. Click icon ‘Edit individual Documents’. All labels should now > appear in a new untitled document > 12. Save the document for later printing or print directly > > All fields appear in the Writer as expected. > However, step 9 fails, there is no response to synchronising with the > database data. There is no response to going to the first data > record. > There is also no response at step 11. There is also no response to > 'Synchronise labels'. > > I am using: > Version: 7.3.4.2 / LibreOffice Community > Build ID: 30(Build:2) > CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 > Locale: en-GB (en_GB.UTF-8); UI: en-GB > Calc: threaded > > What am I missing? Any ideas? > -- 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] Printing labels from LO-Base
I need help to print address labels from my database. I have had it working e.g. a year ago, but now I am having trouble. My database Mariadb10 on a backend server and Base on my frontend desktop. I have followed the following procedure (as last year) 1. From Base (adresslisten database) select File → New → Labels 2. In window ‘Labels’ check that source of data and fields under ‘Label text:” is as desired and select Table Query Q_labels_Xmas (ie. the one set up for labels) 3. If not, choose Table and Database fields as desired, moving fields into Label Text box 4. Select Format ‘Sheet’ 5. Select Brand (z.B. Herma A4) and Type (z.B. 4278) of labels 6. Check Tab Format of labels, in particular the left margin should be at least 0,55 cm and top margin 2,25 cm (in case of Herma 4278 labels) 7. Tab ‘Options’ are ‘Entire page’ and ‘Synchronise contents’ 8. Click ‘New Document’ 9. In Writer document click page navigator ‘First Mail Merge Entry’ to highlight the related line of icons. 10. Before generating the labels (point 13) got to the File>Printer Settings>Options and check the box ‘Left pages’ in order to suppress the generation of blank right pages. 11. Click icon ‘Edit individual Documents’. All labels should now appear in a new untitled document 12. Save the document for later printing or print directly All fields appear in the Writer as expected. However, step 9 fails, there is no response to synchronising with the database data. There is no response to going to the first data record. There is also no response at step 11. There is also no response to 'Synchronise labels'. I am using: Version: 7.3.4.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded What am I missing? Any ideas? -- 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] Bug report in calc, V.7.4
On Thu, 2022-09-01 at 17:39 +1000, Stephen Morris wrote: > On 29/8/22 09:21, Regina Henschel wrote: > > Hi Matthias, > > > > Matthias Lammer schrieb am 29.08.2022 um 00:24: > > > Dear LibreOffice team, > > > > > > I want to file a very severe bug as follows: > > > > > > I create a simple function in Basic: > > > > > > Function myAdd(x, y, z) > > > myAdd = x + y + z > > > End Function > > > > > > Then I can call it as usual with =myAdd(...). Next, I want to > > > update > > > myAdd to subtract the values, I end up with: > > > > > > Function myAdd(x, y, z) > > > myAdd = x - y - z > > > End Function > > > > > > I save my changes and press F9 for recalculation > > > > That will not work. Neither any of the cells referenced as > > parameter > > nor the formula in the cell has changed. So F9 will not detect any > > change. > > > > but Calc still gives me > > > the value for the adding up the 3 values. > > > > You need to use a 'Recalculate Hard' in this case, that is > > Strg+Shift+F9. > Just a silly question, which key is Strg? > > regards, > Steve > > > > > Kind regards, > > Regina > > Strg is the German abbreviation for 'Steuerung', i.e. Control, Ctrl, on the English keyboard. Harvey -- 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] LO Base Query - 'count' function behaviour
Yes that works, too. I notice that Base strips off the 'AS' keywords. Cheers Harvey On Tue, 2022-08-16 at 16:02 +0200, Robert Großkopf wrote: > Hi Harvey, > > tested this: > > SELECT COALESCE ( `User`, 'Empty' ) AS `User`, COUNT( `ID` ) FROM > `test`.`User` AS `User` GROUP BY `User` > > You don't need to change the alias for `Location` to `Loc`. > I could save this, open this to edit in GUI, execute it - no Problem > with direct connection on MariaDB. > > When trying the same with MariaDB and JDBC I will get: > Column 'User' in group statement is ambiguous at > /home/buildslave/source/libo- > core/connectivity/source/drivers/jdbc/SQLException.cxx:35 > > Changing the code to > SELECT COALESCE ( `User`, 'Empty' ) AS `Us`, COUNT( `ID` ) FROM > `test`.`User` AS `User` GROUP BY `User` > and the query will work. Won't be detroyed also through GUI. > > GUI will destroy the query when setting > GROUP BY `Us` instead of GROUP BY `User`. Seems it hat problems using > the alias for a group. But the alias isn't needed there, so set > `Location` instead of `Loc` > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- 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] LO Base Query - 'count' function behaviour
Just one remark on this, though. The GUI and SQL Edit views seem not to be consistent with each other. Just opening the Query to Edit GUI, adjusting the pane size (say) and saving the result, destroys the query. Cheers Harvey On Tue, 2022-08-16 at 10:54 +0200, Harvey Nimmo wrote: > Thank you, Robert! As always on target. > > This is better than filling the Location fields with some unneeded > value. Great stuff. Man lernt nie aus! > > Cheers > Harvey > > On Tue, 2022-08-16 at 10:15 +0200, Robert Großkopf wrote: > > Hi Harvey, > > > > > > SELECT `Location`, COUNT( `Location` ) FROM > > > `Item_Management`.`Items` > > > `Items` GROUP BY `Location` > > > > > > The result is correct for all LOCATIONS that are not empty, but > > > surpisingly the blank field for the empty locations is > > > accompanied > > > by > > > the value 0. How can I get the right count for the empty fields > > > as > > > well? > > > > Try this: > > SELECT COALESCE(`Location`,'Empty') AS `Loc`, COUNT( `ID` ) FROM > > `Item_Management`.`Items` GROUP BY `Loc` > > > > COUNT: Always use a field which should never be NULL (primary key > > for > > example) > > Set a vallue for a field, which is empta at this moment. If > > "Location" > > contains characters it will work with 'Empty' as shown above. > > > > Didn't test it! > > > > Regards > > > > Robert > > -- > > Homepage: https://www.familiegrosskopf.de/robert > > > -- 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] LO Base Query - 'count' function behaviour
Thank you, Robert! As always on target. This is better than filling the Location fields with some unneeded value. Great stuff. Man lernt nie aus! Cheers Harvey On Tue, 2022-08-16 at 10:15 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > SELECT `Location`, COUNT( `Location` ) FROM > > `Item_Management`.`Items` > > `Items` GROUP BY `Location` > > > > The result is correct for all LOCATIONS that are not empty, but > > surpisingly the blank field for the empty locations is accompanied > > by > > the value 0. How can I get the right count for the empty fields as > > well? > > Try this: > SELECT COALESCE(`Location`,'Empty') AS `Loc`, COUNT( `ID` ) FROM > `Item_Management`.`Items` GROUP BY `Loc` > > COUNT: Always use a field which should never be NULL (primary key for > example) > Set a vallue for a field, which is empta at this moment. If > "Location" > contains characters it will work with 'Empty' as shown above. > > Didn't test it! > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- 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] LO Base Query - 'count' function behaviour
I have a table consisting of (unique) ITEMS and with a column LOCATION for the land of origin of the ITEMS. Some LOCATION fields are still empty. A query counts the number entries in the LOCATION column for each country present. Essentially the GUI just shows the functions LOCATION 'group' and LOCATION 'count'. SELECT `Location`, COUNT( `Location` ) FROM `Item_Management`.`Items` `Items` GROUP BY `Location` The result is correct for all LOCATIONS that are not empty, but surpisingly the blank field for the empty locations is accompanied by the value 0. How can I get the right count for the empty fields as well? Cheers Harvey -- 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] LO Base Views and Queries
Hi Robert, I have chosen the configuration LO-Base front ent to Mariadb backend becuase of the advantage of database server with Terrabytes of disk space. But I am wondering seriously whether I have made a good choice. There seem to be serious compatibilty problems between them in spite of the LO MySQL(JDBC) driver interface. For example, The GUI tells me that 3 arguments required by the LO-Base DATEDIFF() function is to incorrect, and accepts only two arguments (as per MYSQL). But a LO-Base query with 2 arguments, which is syntactically accepted, returns no data. I am beginning to feel a bit frustrated with this LO-Base/Mariadb idea. That would be a pity, as the GUI would theoretically be good to avoid all the SQL typing work (not really within the scope of my expertise), and the Forms and Reports are a bonus that is missing in the phpMyAdmin environment. But perhaps it's just the hot weather. Cheers Harvey On Fri, 2022-08-12 at 10:09 +0200, Robert Großkopf wrote: > Hi Harvey, > > > OK. Thanks, Robert. That is more or less the conclusion that I had > > come > > to. Not very user-friendly, but it works. > > Reason for this behavior might be you are using a server database for > many users. Have had a look with PHPMyAdmin. Couldn't edit the view > there also. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- 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] LO Base Views and Queries
OK. Thanks, Robert. That is more or less the conclusion that I had come to. Not very user-friendly, but it works. Cheers Harvey On Fri, 2022-08-12 at 08:36 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > I cannot confirm the Firebird icon. My database backend is > > MySQL(JDBC), > > (actually Mariadb). I prefer to continue for the time being with > > the > > OpenSUSE packages delivered with my Linux Leap 15.4. > > Editing views with external databases won't work. It's the same > behavior > for every other connection with MySQL/MariaDB, also with PostgreSQL. > > So: Create queries, save it as a query, create a view of this query. > For > changing a view: Edit the query you have saved. Delete the view. > Create > the view from the query again. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- 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] LO Base Views and Queries
Hi Robert, I cannot confirm the Firebird icon. My database backend is MySQL(JDBC), (actually Mariadb). I prefer to continue for the time being with the OpenSUSE packages delivered with my Linux Leap 15.4. Cheers Harvey On Thu, 2022-08-11 at 18:06 +0200, Robert Großkopf wrote: > Hi Harvey, > > LO won't be installed without internal HSQLDB. But with that behavior > you reported you are using internal Firebird. Will be shown at the > bottom of the window in statusbar. > > You are using packages from your distribution, not from LO directly. > Have tested the same version you are using, only from LO directly: > Version: 7.3.4.2 / LibreOffice Community > Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5 > CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 > (cairo+xcb) > Locale: de-DE (de_DE.UTF-8); UI: de-DE > Calc: threaded > > If I choose to edit views they will be opened in this version with > the > query editor. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- 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] LO Base Views and Queries
Hi Robert, Thanks, so far...;-) I understand that a View would be more efficient in execution than the equivalent query. And this seems to be more or less the practical extent of justification for view over query. My version: Version: 7.3.4.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded How do I identify the internal db used? Firebird (version 3.0.4.33045- 1.7) is installed in my configuration, HSQLDB is not. I think I understand your tip to mean that i should use queries until they are 'final' and then create views as appropriate. Cheers Harvey On Thu, 2022-08-11 at 16:38 +0200, Robert Großkopf wrote: > Hi Harvey, > > > I'm unsure of the practical implications of the difference between > > Base > > implementation of Views and Queries. Perhaps someone can enlighten > > me. > > One thing, however, does hit me. > > Views will be executed in the database. The content will look for > Base > like a non-writable table. You could filter data, sort data and use > this > views for repprts, but you couldn't update, add or delete data. > > Database won#t know anything about queries in the queries pane. > Queries > will send from tBase to the database. So queries will be a little bit > slower. But queries could be used for input, update or delete data, > if > all primary keys of the included tables were available. > > > > Initial design of a View with the GUI, is done similar to a Query, > > which is OK. However, when the View is stored, then further > > development > > of that View seems very limited if not impossible, as the Table- > > type > > GUI is opened on Edit. > > Which version pf LO and which (internal) database do you use? This > bug > (opening table editor, not query editor) has been solved for internal > Firebird database some times ago. In LO 7.4.0.2 the query editor will > appear. > > One hint: I will save all views separately as queries. It is because > a > view could depend on another view. So I couldn't chang the view I > first > created, if another view needs data of this view. I have to delete > other > views depending on this view and have to recreate them afterwards. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- 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] LO Base Views and Queries
I'm unsure of the practical implications of the difference between Base implementation of Views and Queries. Perhaps someone can enlighten me. One thing, however, does hit me. Initial design of a View with the GUI, is done similar to a Query, which is OK. However, when the View is stored, then further development of that View seems very limited if not impossible, as the Table-type GUI is opened on Edit. Is there a way to return to the Query-type feature to continue modifying the View design once the View has been stored and closed? -- 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] Calculated values in View or Query
That is marvellous. Thank you, Robert!! I must get used to visiting the Document Foundation website, as I tend to stick with the help function and otherwise OpenSUSE. Excellent tip. The Base Guide answers my question precisely, listing as it does the built-in functions together with a remark in each case "[Works in the GUI]" - or not (e.g. CASE) Great stuff!! Harvey On Wed, 2022-08-10 at 10:06 +0200, Robert Großkopf wrote: > Hi Harvey, > > most SQL code I create direcly without using GUI, so I don't know if > all > of this could also be created through GUI. > > Have a look at the Base Guide > https://nextcloud.documentfoundation.org/s/qjFkGwpEEkNrt6f. > The GUI has been created to work perfect with internal HSQLDB (very > old…), but there is no special SQL-version, which isn't running in LO > Base. Base Guide will show you the code for internal HSQLDB and also > for > Firebird - and some hints for other databases. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- 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] Calculated values in View or Query
Hi Robert, I suppose my question could be reformulated: what version of SQL does Base support? To what extent is that SQL supported in the BASE query/view graphical interface? I haven't been able to find an answer in the LO Help (yet). Cheers Harvey On Wed, 2022-08-10 at 08:31 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > For example, I would like to extract a text string from a field in > > each > > record and display it in an extra view and/or query field, or > > multiply > > two field values and record the result in an extra field. > > A little example will help: What is the content of the field in tehe > table, whot should be shown in the query? > > https://ask.libreoffice.org will be a better place for this, because > you > could post screenshots and add a simple example database. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- 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] Calculated values in View or Query
I wonder if anyone knows a simple way in Base to calculate a value for a view and/or query field entry from the contents of other data fields of a record. (I know this feature from MSAccess) For example, I would like to extract a text string from a field in each record and display it in an extra view and/or query field, or multiply two field values and record the result in an extra field. If so, how would that be done? Cheers Harvey -- 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] export data from Calc, import to Base
Thanks for all the good tips. I have it working. This last one from Robert works, too. I had tried it before but for some reason only one record was imported that time. Anyway, good this time, although patience was needed to import more than 7000 records (felt like a minute, maybe only half). Cheers Harvey On Tue, 2022-08-09 at 07:24 +0200, Robert Großkopf wrote: > Hi Harvey, > > mark the content. Copy it to clipboard. > > Go to the database file and open the tables pane. > > Right mousclick → insert. > > Choose the table where to append the data to, choose the column in > the > wizard and it will be done. > > You won't need a *.csv-file and phpMyAdmin to do this the same way > for > MariaDB/MySQL. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- 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] export data from Calc, import to Base
Dear formum, I believe my objective should be rather simple, but I need to be pointed in the right direction. I have a column of text data (unique values) in Calc that I want to transfer to a Base table. The Base table has been set up with three columns, two of which I expect to remain empty after the data import. The one column of unique values will be the primary key. I thought that the best way to implement the data transfer would be to create a .csv file from the column of data, but I need help to find out how Calc supports this. Can anyone help? One idea I had, was to copy the data column (which contains more than 7000 values, incidentally) to a text file. Unfortunately, I do not understand enough about regular expressions to add two commas before each linefeed. Help there would be appreciated. (For completeness, the Base Table is a front end to a backend Mysql database, and I expect the import to be done using phpMyAdmin) Regards Harvey -- 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] Open letter for revive LOOL, add your +1 if you agree
I, as mere LO user, would like to understand the significance, actual or surmised, of the closure of the LO Online repository. Does this potentially signal the end of LO? Cheers Harvey On Sun, 2022-07-10 at 19:42 -0300, Daniel A. Rodriguez wrote: > I've sent a message to the BoD Discuss mailing list. It is an open > letter aimed at showing the community's interest in the TDF reviving > LibreOffice Online. > If you agree, feel free to add your +1. > > https://www.mail-archive.com/board-discuss@documentfoundation.org/msg05970.html -- 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] Calc function COUNTA
Thanks for all the inputs! Great stuff. As I said, I wanted to count the number of non-blank cells in a column, but as =COUNTA(A$2:A$1, ISBLANK=0) is above an otherwise empty column returns the value 1, I am obviously not using the function correctly. =COUNTA(A$2:A$1) does the trick. Thanks. Cheers Harvey On Sun, 2022-06-26 at 06:40 +0100, Brian Barker wrote: > At 21:41 25/06/2022 +0200, Harvey Nimmo wrote: > > I wanted to count the number of non-blank items in a list of items > > using COUNTA. Cell A1 has the formula =COUNTA(A$2:A$1, > > ISBLANK=0) above an otherwise empty column. It returns the value > > 1! > > Is that supposed to mean something? > > Yes: it's the correct result! > > The big question is what you intend the formula to mean. ISBLANK() > is > a function, so makes no sense without the parentheses and a > parameter. Did you expect that second parameter to COUNTA() to mean > something? > > What were you actually trying to achieve? Do you want your formula > to > omit cells containing just blanks in its count, as well as empty > cells? If so, you need to construct a formula that achieves this. > But > you need to speak Spreadsheet, not just English, to do so! Try > =SUMPRODUCT(LEN(TRIM(A$2:A$1))>0) > > > It's obviously not a big problem, because a workaround is obvious. > > I don't think it's a problem at all. > > > But do I have to mistrust the results of the COUNTA function? > > No. As others have said, if your specified range is empty, the first > parameter contributes zero to the COUNTA() sum. But then the > (apparently meaningless) second parameter contributes itself, so the > total is indeed one. > > 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
[libreoffice-users] Calc function COUNTA
I wanted to count the number of non-blank items in a list of items using COUNTA. Cell A1 has the formula =COUNTA(A$2:A$1, ISBLANK=0) above an otherwise empty column. It returns the value 1! Is that supposed to mean something? Has anyone notice this? It's obviously not a big problem, because a workaround is obvious. But do I have to mistrust the results of the COUNTA function? Cheers Harvey -- 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] Existing Base Report now opens with error
I see that the rpm Version on the LO site is up to 7.2.7, or even 7.3.3. Can I take either as is? Cheers Harvey On Fri, 2022-05-20 at 18:04 +0200, Harvey Nimmo wrote: > Thanks for the quick reply. Would this bug be picked up automatically > by the OpenSUSE integrators? > > Regards > Harvey > > On Fri, 2022-05-20 at 17:30 +0200, Robert Großkopf wrote: > > Hi Harvey, > > > I am using LO on OpenSUSE Linux Leap 15.3 > > > Version: 7.2.5.1 / LibreOffice Community > > > Build ID: 20(Build:1) > > > CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3 > > > Locale: en-GB (en_GB.UTF-8); UI: en-GB > > > Calc: threaded > > > > > This is a special bug of OpenSUSE build: > > https://bugs.documentfoundation.org/show_bug.cgi?id=148841 > > Same bug appears with Mageia build: > > https://bugs.documentfoundation.org/show_bug.cgi?id=148042 > > Same with Debian: > > https://bugs.documentfoundation.org/show_bug.cgi?id=147947 > > > > Change to the build directly from LO and it will work. > > My System: OpenSUSE 15.3 with many different versions direct from > > LO > > (installed parallel) and packages from OpenSUSE. Bug appears with > > packages from OpenSUSE, never appears with packages from LO. > > > > Regards > > > > Robert > > -- > > Homepage: https://www.familiegrosskopf.de/robert > > > > -- 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] Existing Base Report now opens with error
Thanks for the quick reply. Would this bug be picked up automatically by the OpenSUSE integrators? Regards Harvey On Fri, 2022-05-20 at 17:30 +0200, Robert Großkopf wrote: > Hi Harvey, > > I am using LO on OpenSUSE Linux Leap 15.3 > > Version: 7.2.5.1 / LibreOffice Community > > Build ID: 20(Build:1) > > CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3 > > Locale: en-GB (en_GB.UTF-8); UI: en-GB > > Calc: threaded > > > This is a special bug of OpenSUSE build: > https://bugs.documentfoundation.org/show_bug.cgi?id=148841 > Same bug appears with Mageia build: > https://bugs.documentfoundation.org/show_bug.cgi?id=148042 > Same with Debian: > https://bugs.documentfoundation.org/show_bug.cgi?id=147947 > > Change to the build directly from LO and it will work. > My System: OpenSUSE 15.3 with many different versions direct from LO > (installed parallel) and packages from OpenSUSE. Bug appears with > packages from OpenSUSE, never appears with packages from LO. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- 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] Existing Base Report now opens with error
I am using LO Base client to a backend MySQL database (on my local network). I created a set of reports with Base that worked in the past. For some reason now when opening a report an error message crops up and the report cannot be generated. "[jni_uno bridge error] UNO calling Java methode execute: non-UNO exception occurred: java.lang.NoClassDefFoundError:Could not initialize class org.jfree.report.JFreeReportBoot". This is followed by a java stack trace. What has happened that the report generation no longer works? What is needed to repair this? I am using LO on OpenSUSE Linux Leap 15.3 Version: 7.2.5.1 / LibreOffice Community Build ID: 20(Build:1) CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded -- 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] Cannot save file
Just guessing, Thomas, but I suspect the first questions the experts will ask you next is: What LO version are you using on what operating system. you will find it under Help > AboutLibreOffice and click Version Information and paste that to a mail. That way you might pre-empt the experts' question and speed things up a bit. Cheers Harvey On Wed, 2022-03-02 at 17:14 +0900, Thomas Blasejewicz wrote: > Good afternoon > Another incomprehensible behavior arose. > > I open a new document, copy text from a text file and try to save > the > document as .odt. > Yet, nothing happens. > I tried to save the document in different locations, but that does > not > change anything. > Creating a document in the same way in Word (which I rarely use) > causes > no problems. > > How can I fix this very annoying behavior. > Thank you > Thomas > > > -- 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] Use of Ctrl while selecting text fields in LO Base forms
Hallo Robert, this seems to work, but somewhat counter-intuitively, in the sense that the selected objects appear to become grouped, prior to aligning them. In other words, It becomes impossible to identify which objects have been selected for alignment. But thanks for the tip. It kinda helps to make progress at last! Regards Harvey On Wed, 2022-02-23 at 17:47 +0100, Robert Großkopf wrote: > Hi Harvey, > > try it with Shift and left mouse click. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- 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] Use of Ctrl while selecting text fields in LO Base forms
Yes, I did. Crtl-Shift groups the chosen elements On Wed, 2022-02-23 at 08:42 -0500, Dan Lewis wrote: > Have you tried Crtl+Shift to select separate elements? > > Dan > > On 2/23/22 6:52 AM, Harvey Nimmo wrote: > > While trying to edit form elements for LO Base I am expecting to be > > able to select individual form elements, e.g. to align them, and > > size > > them together. However, using the Ctrl button to select more than > > one > > form element (e.g. text boxes) causes a second box, say, to be > > selected > > and a previous box is deselected. > > > > I thought that maybe my Ctrl key was broken, so I tried it on my > > file > > manager. But there the Ctrl button can be used to select several > > files > > at once, as expected. It suggests, therefore, a problem with > > LibreOffice. > > > > 'Edit > Select All' causes nothing to be selected in the LO Base > > Form > > Editor, whereas in the LO Writer it works as expected. > > > > Does anyone know if there is a switch in the Forms editor in Base > > that > > would activate the Select function? I have spent hours looking for > > a > > possible remedy! Very frustrating!! > > > > Version: 7.2.3.2 / LibreOffice Community > > Build ID: 20(Build:2) > > CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3 > > Locale: en-GB (en_GB.UTF-8); UI: en-GB > > Calc: threaded > > > > > > > > > > > > -- 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] Use of Ctrl while selecting text fields in LO Base forms
While trying to edit form elements for LO Base I am expecting to be able to select individual form elements, e.g. to align them, and size them together. However, using the Ctrl button to select more than one form element (e.g. text boxes) causes a second box, say, to be selected and a previous box is deselected. I thought that maybe my Ctrl key was broken, so I tried it on my file manager. But there the Ctrl button can be used to select several files at once, as expected. It suggests, therefore, a problem with LibreOffice. 'Edit > Select All' causes nothing to be selected in the LO Base Form Editor, whereas in the LO Writer it works as expected. Does anyone know if there is a switch in the Forms editor in Base that would activate the Select function? I have spent hours looking for a possible remedy! Very frustrating!! Version: 7.2.3.2 / LibreOffice Community Build ID: 20(Build:2) CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded -- 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] Question
I'm not quite sure how I understand this answer to sleepy's question. Is it "No, macros are off by default" or "Yes...but..."? "Excel VBA not likely to run..": I assume it is not designed to run Excel VBA? Cheers Harvey On Wed, 2021-10-06 at 09:05 -0400, Alan B wrote: > Default in LO 7.1.5.2 > > Security level High - Only signed macros from trusted sources allowed > to > run. > > Plus not 100% compatible with Excel. Excel VBA not likely to run in > Calc. > (Formulas are a different story. Much better cross product support.) > > On Wed, Oct 6, 2021, 7:36 AM sleepy wrote: > > > Does LibreOffice Calc have macros turned on by default? I > > accidently opened > > a xlsx file using Calc and I'm a really paranoid and think the file > > is > > infected I meant to download it but I accidently opened 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 > > -- 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] Two parallel text flows in one document possible?
I just klick on the top of the one column to select the content of the whole column. Then go to Tools > Language > For Selection and select the language to be checked for that column. On Fri, 2021-04-16 at 07:45 -0400, John Kaufmann wrote: > Sorry, but I was hoping you would ask HOW the spell-check language is > set separately on each column. > [I hate it when someone says "Of course" on an issue I don't see.] ;- > ) > Since you grasped it immediately, I'm afraid I must ask one of you: > How do you do that? > > > On 2021-04-15 14:22, Ulf Dunkel wrote: > > A two-column TABLE seems to be a very smart solution for this. > > Thank you, Harvey. > > > > - - - - - > > > > Am 15.04.21 um 12:09 schrieb Harvey Nimmo: > > > Hi, > > > I sometimes have to translate documents. So that I can see the > > > relationship of the texts I put one language on the right and the > > > other > > > left on the page. For that I use a two-column table which works > > > quite > > > well. Not sure if that is the most elegant solution for what you > > > want. > > > Of course you can format each column as you want (e.g. with no > > > table > > > borders), and the spell-check language can be set separately on > > > each > > > column. > > > > > > Greetings > > > Harvey > > > > > > > > > On Thu, 2021-04-15 at 11:42 +0200, Ulf Dunkel wrote: > > > > Hello everyone. > > > > > > > > I would like to write a book in German and English in parallel > > > > and > > > > let > > > > the German text flow on the left and the English text on the > > > > right, > > > > or > > > > two columns of German on the left and English on the right. Is > > > > that > > > > technically possible in LO Writer? I haven't found anything > > > > about it > > > > yet. > > > > > > > > Best, Ulf -- 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] Two parallel text flows in one document possible?
Hi, I sometimes have to translate documents. So that I can see the relationship of the texts I put one language on the right and the other left on the page. For that I use a two-column table which works quite well. Not sure if that is the most elegant solution for what you want. Of course you can format each column as you want (e.g. with no table borders), and the spell-check language can be set separately on each column. Greetings Harvey On Thu, 2021-04-15 at 11:42 +0200, Ulf Dunkel wrote: > Hello everyone. > > I would like to write a book in German and English in parallel and > let > the German text flow on the left and the English text on the right, > or > two columns of German on the left and English on the right. Is that > technically possible in LO Writer? I haven't found anything about it > yet. > > Best, Ulf > -- 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] Re: Printing labels from a database is missing every other page
Thanks to all you guys for your help. It is possible to insert a page break in the template, but there was none there in my case, so I still have to ask myself: where does the blank page come from? There is a setting, however, to print only left hand pages. That does the trick of suppressing the blank pages. Many thanks, again Harvey On Tue, 2020-12-15 at 09:42 -0800, Richard England wrote: > Is there a page break inserted at the end of the template page? > > ~~R > > > On 12/15/20 8:53 AM, Harvey Nimmo wrote: > > and finally > > It is not as bad as I had surmised. All the is happening, is that > > the > > label printing process is generating an extra blank page between > > valid > > pages. All labels are actually printed. Only the blank label pages > > have > > to be extracted from the print job (and reused!);-) > > On Tue, 2020-12-15 at 17:39 +0100, Harvey Nimmo wrote: > > > Sorry, I forgot to provide the LO version I am using: > > > LO Version: 6.4.5.2Build ID: 40(Build:2)CPU threads: 2; OS: Linux > > > 5.3; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); > > > UI- > > > Language: en-GBCalc: threaded > > > And additionally, I should day that the odt label file generated > > > shows 13 pages in the statistics at the foot of the window, but > > > fails > > > to show the blank pages, i.e. only 7 pages are shown. > > > CheersHarvey > > > On Tue, 2020-12-15 at 17:30 +0100, Harvey Nimmo wrote: > > > > What could be going wrong here? Can anyone help? > > > > I am trying to print a set of address labels (3x5 per page) > > > > using > > > > LO Base connected to a remote MariaDB. The report facilities > > > > correctly show the data I want to be printed. > > > > The label procedure apparently produces the label report > > > > corresponding to selected db-records and correctly shows the > > > > number > > > > of A4 label pages generated (13). However, on printing them to > > > > actual labels, every second page is blank. > > > > Inspection of the print file using print preview indeed shows > > > > all > > > > even pages to be blank, and exporting the file to PDF > > > > compresses > > > > the whole file automatically to 7 pages. > > > > What must I do to get the labels from the even pages printed > > > > out? > > > > Cheers > > > > Harvey > > > > > > > > > > -- 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] Re: Printing labels from a database is missing every other page
and finally It is not as bad as I had surmised. All the is happening, is that the label printing process is generating an extra blank page between valid pages. All labels are actually printed. Only the blank label pages have to be extracted from the print job (and reused!);-) On Tue, 2020-12-15 at 17:39 +0100, Harvey Nimmo wrote: > Sorry, I forgot to provide the LO version I am using: > LO Version: 6.4.5.2Build ID: 40(Build:2)CPU threads: 2; OS: Linux > 5.3; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); UI- > Language: en-GBCalc: threaded > And additionally, I should day that the odt label file generated > shows 13 pages in the statistics at the foot of the window, but fails > to show the blank pages, i.e. only 7 pages are shown. > CheersHarvey > On Tue, 2020-12-15 at 17:30 +0100, Harvey Nimmo wrote: > > What could be going wrong here? Can anyone help? > > I am trying to print a set of address labels (3x5 per page) using > > LO Base connected to a remote MariaDB. The report facilities > > correctly show the data I want to be printed. > > The label procedure apparently produces the label report > > corresponding to selected db-records and correctly shows the number > > of A4 label pages generated (13). However, on printing them to > > actual labels, every second page is blank. > > Inspection of the print file using print preview indeed shows all > > even pages to be blank, and exporting the file to PDF compresses > > the whole file automatically to 7 pages. > > What must I do to get the labels from the even pages printed out? > > Cheers > > Harvey > > > > -- 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] Re: Printing labels from a database is missing every other page
Sorry, I forgot to provide the LO version I am using: LO Version: 6.4.5.2Build ID: 40(Build:2)CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); UI- Language: en-GBCalc: threaded And additionally, I should day that the odt label file generated shows 13 pages in the statistics at the foot of the window, but fails to show the blank pages, i.e. only 7 pages are shown. CheersHarvey On Tue, 2020-12-15 at 17:30 +0100, Harvey Nimmo wrote: > What could be going wrong here? Can anyone help? > I am trying to print a set of address labels (3x5 per page) using LO > Base connected to a remote MariaDB. The report facilities correctly > show the data I want to be printed. > The label procedure apparently produces the label report > corresponding to selected db-records and correctly shows the number > of A4 label pages generated (13). However, on printing them to > actual labels, every second page is blank. > Inspection of the print file using print preview indeed shows all > even pages to be blank, and exporting the file to PDF compresses the > whole file automatically to 7 pages. > What must I do to get the labels from the even pages printed out? > Cheers > Harvey > > -- 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] Printing labels from a database is missing every other page
What could be going wrong here? Can anyone help? I am trying to print a set of address labels (3x5 per page) using LO Base connected to a remote MariaDB. The report facilities correctly show the data I want to be printed. The label procedure apparently produces the label report corresponding to selected db-records and correctly shows the number of A4 label pages generated (13). However, on printing them to actual labels, every second page is blank. Inspection of the print file using print preview indeed shows all even pages to be blank, and exporting the file to PDF compresses the whole file automatically to 7 pages. What must I do to get the labels from the even pages printed out? Cheers Harvey -- 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] Logic of headers (and footers) or my lack of it!
Hello Regina, Thanks for taking the trouble to offer help. Perhaps if I describe my 'case' it will help to see where I am coming from. I wanted to define a header for each page that is either a copy of the previous header or a new one. The application in my current case is collection of handwritten court papers (from 1813) that I want to transcribe. The originals are in jpeg. Some are just single sheets, some sheets are left and right pages together, some are just snippets. Obviously the order is important, and the source names of the jpeg files serve very well as a header that should not of itself belong the the transcription text. hence my simple requirement. It was a deliberate choice to try to use the header feature (rather than headings within the body of the text) because it made sense to me to keep the metadata (i.e. file names of each sheet) separate from the actual content of each sheet. In the end, I would have a complete LO text document in which each page was headed with the file name to identify its source and a page full of text showing the textual content of each sheet. The resulting document would evidently contain 29 pages with about 20 different headers. I was expecting some simple implementation but, to my surprise, did not find such. In the meantime Remy has made a suggestion that show how much more complex it could be, than expected. Greetings Harvey On Sat, 2020-05-30 at 22:49 +0200, Regina Henschel wrote: > Harvey Nimmo schrieb am 30-May-20 um 18:54: > > My intention was to use the header function to describe each page > > of a > > 29 page document separately, with a couple of exceptions where two > > pages may have the same header. > > What do you mean by "describe"? There exists some variables like > chapter > number and text, that will adapt automatically to the content of the > page. > > > > > I thought that it would just be a simple question of telling the > > header > > of each page to copy (or not) the header of the previous page. How > > mistaken could I be?!! > > ?? You really need to describe more detailed the desired content of > the > "header". > > Kind regards > Regina > -- 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] Logic of headers (and footers) or my lack of it!
Thanks, Remy. I think this could be close to the solution I am looking for, but that means I have some 20 page styles for 29 pages of documentbut...OKIs the MS-Word solution patented? If not, could it be implemented here? Cheers Harvey On Sat, 2020-05-30 at 14:36 -0400, Remy Gauthier wrote: > Hi, > The header is attached to the page style you are using. For a given > page style, the header will be the same. I think you are looking for > a function similat to MS-WORD where you can link consecutive headers > and footers to have them "copied" from one section to the other, when > pages are separated with section breaks. LO does not operate quite > like that: LO provides page styles that contain the complete > definition of what your page should look like, along with header and > footer. So, for a given page style, the header will be the same when > it is applied to a page, what ever the page is. > So, to have the same header on pages 1-5, use Page Style 1To have a > different header on page 6, use Page Style 2To have the same header > on pages 7-10 as on pages 1-5, apply Page Style 1 to those pagesEtc. > To quickly see the page style, look in the middle of the status bar > at the bottom of the screen. You can right-click to set the page > style for the current page (actually from the last manual page break > to the next one). If you want to insert a page break and jump on a > new style, then go to Insert -> Other Breaks > Manual Break and on > the dialog, select page break and set the name of the style you want > from the drop-down. > To create a new style, go Style -> Manage Styles and when the thing > opens on the right, go to page styles and create what you need (right > click on a style and then New...) > I hope this helps. > Rémy. > > > Le samedi 30 mai 2020 à 18:54 +0200, Harvey Nimmo a écrit : > > My intention was to use the header function to describe each page > > of a29 page document separately, with a couple of exceptions where > > twopages may have the same header. > > I thought that it would just be a simple question of telling the > > headerof each page to copy (or not) the header of the previous > > page. Howmistaken could I be?!! > > No matter what I tried, I was totally unable to find the trick for > > sucha simple feature...so that I am beginning to question my > > sanity. ;-)The final result was that the first header was all > > right, but all thesubsequent headers oscillated between the one for > > page 29 and page 26.J-) > > I'm using LO on Linux. > > Version: 6.4.2.2Build ID: 40(Build:2)CPU threads: 2; OS: Linux > > 4.12; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); > > UI-Language: en-GBCalc: threaded > > So what's the trick? I am sure that other users have been down > > asimilar path. > > GreetingsHarvey > > > > -- 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] Logic of headers (and footers) or my lack of it!
My intention was to use the header function to describe each page of a 29 page document separately, with a couple of exceptions where two pages may have the same header. I thought that it would just be a simple question of telling the header of each page to copy (or not) the header of the previous page. How mistaken could I be?!! No matter what I tried, I was totally unable to find the trick for such a simple feature...so that I am beginning to question my sanity. ;-) The final result was that the first header was all right, but all the subsequent headers oscillated between the one for page 29 and page 26. J-) I'm using LO on Linux. Version: 6.4.2.2 Build ID: 40(Build:2) CPU threads: 2; OS: Linux 4.12; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); UI-Language: en-GB Calc: threaded So what's the trick? I am sure that other users have been down a similar path. Greetings Harvey -- 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] LO Base: Boolean Report values
On Thu, 2019-12-12 at 20:28 +0100, Robert Großkopf wrote: > Hi Harvey > > > > I was just about to answer that I had tried that and it did not > > work, > > until I noticed your square brackets []. That did the trick!! You > > are > > wonderful. > > > > But where is that documented? > > Don't know wher I found it, when I created the Base-Handbook. But > have a > lokk for the English version of the Base-Handbook. I have written > there > a chapter for the Report-Builder. I copied the code from there. > > If you will try it in German have a look at my homepage. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert I've found it. V6.2. Many thanks again! > -- 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] LO Base: Boolean Report values
On Thu, 2019-12-12 at 19:46 +0100, Robert Großkopf wrote: > Hi Harvey, > > try this: > Write into Data > Data field > > IF([NameOfBoolField];"y";"n") > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert Hi Robert, I was just about to answer that I had tried that and it did not work, until I noticed your square brackets []. That did the trick!! You are wonderful. But where is that documented? Regards Harvey -- 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] LO Base: Boolean Report values
I wonder if anyone knows how to solve this little problem? I am trying to construct a report from a Table/Query in Base. Amongst other data there are five boolean flags (Type Yes/No[BIT] to be printed from each record. Thinking that it would take up too much space on the paper together with the labels, in my naivity, I thought it would be easy, to print a single character (e.g. "y", "n", or even better U+2611, U+2610) for the values each time, rather than the clumsy defaults TRUE or FALSE. After several hours(!!) of experimentation with 'IF' expressions and field definitions in various places (Report fields, Query fields), I have come to the end of my creativity. I cannot believe that this simple idea has no simple solution...but what is it? Can anyone point me in the right direction? Kind Regards Harvey -- 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] Function WEEK in Base
On Sun, 2019-08-25 at 15:34 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > I am using Mariadb10 as backend from a Base client via JDBC. I have > > created the function within a Base Query (GUI). > > So it isn't a LO-problem. WEEK gives (in MariaDB/MySQL) 0 - 53, if > you > start the week with Sunday. > WEEK('2019-01-01',1) gives 1, because it returns values from 1 - 53. > See https://mariadb.com/kb/en/library/week/ for the right mode. > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > Terrific, Robert! That is what I needed to know! Many thanks. Harvey -- 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] Function WEEK in Base
On Sun, 2019-08-25 at 14:32 +0200, Harvey Nimmo wrote: > On Sun, 2019-08-25 at 08:21 +0200, Robert Großkopf wrote: > > Hi Harvey, > > > > > Does anyone know why the function WEEK returns a zero for > > > Tuesday, > > > Jan > > > 1st, 2019? i.e. WEEK('19-01-01') > > > > Must be WEEK('2019-01-01'), if you are using the internal HSQLDB. > > Gives > > '1' here. > > Must be EXTRACT(WEEK FROM CAST('2019-01-01' AS TIMESTAMP)), if you > > are > > using internal Firebird. Also the result is '1' here. > > > > > > According to my calendar it should be week 1 and, in Calc, the > > > WEEKNUM > > > and ISOWEEKNUM both return 1. (WEEKNUM starts the week on Sunday, > > > ISOWEEKNUM on Monday, but otherwise no difference) > > > > Regards > > > > Robert > > -- > > Homepage: http://robert.familiegrosskopf.de > > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > > Hallo Robert, > > I am using Mariadb10 as backend from a Base client via JDBC. I have > created the function within a Base Query (GUI). > > Cheers > HArvey ...and by the way, it makes no difference whether 2019-01-01 or 19-01- 01 the result is the same -- 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] Function WEEK in Base
On Sun, 2019-08-25 at 08:21 +0200, Robert Großkopf wrote: > Hi Harvey, > > > Does anyone know why the function WEEK returns a zero for Tuesday, > > Jan > > 1st, 2019? i.e. WEEK('19-01-01') > > Must be WEEK('2019-01-01'), if you are using the internal HSQLDB. > Gives > '1' here. > Must be EXTRACT(WEEK FROM CAST('2019-01-01' AS TIMESTAMP)), if you > are > using internal Firebird. Also the result is '1' here. > > > > According to my calendar it should be week 1 and, in Calc, the > > WEEKNUM > > and ISOWEEKNUM both return 1. (WEEKNUM starts the week on Sunday, > > ISOWEEKNUM on Monday, but otherwise no difference) > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 Hallo Robert, I am using Mariadb10 as backend from a Base client via JDBC. I have created the function within a Base Query (GUI). Cheers HArvey -- 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] Function WEEK in Base
Does anyone know why the function WEEK returns a zero for Tuesday, Jan 1st, 2019? i.e. WEEK('19-01-01') According to my calendar it should be week 1 and, in Calc, the WEEKNUM and ISOWEEKNUM both return 1. (WEEKNUM starts the week on Sunday, ISOWEEKNUM on Monday, but otherwise no difference) Cheers Harvey -- 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] Re: SQL Syntax UPDATE
On Tue, 2019-07-23 at 21:02 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > I remember using VBA from my days with MSAccess, but our LO/Linux > > world > > has such an 'embarrassment of riches' I don't quite know where to > > start. You could say I'm a bit intimidated by the idea. Any > > suggestions > > where I might start? > > I see your mailaccount is from *.de (Germany). So could be you > understand the German descriptions of the Base-Handbuch. You could > find > the newest versions on my homepage. There are also example-databases > where you could find parts of macro-code. > > You could also find older versions, which are translated into > English: > http://robert.familiegrosskopf.de/lo_hb_en/ > ... but my English might be a littel bit too funny ... > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > Thanks, Robert. I am at home in both languages, so to speak, so there is no problem there. As I see it, your handbook is limited to Basic, i.e. no Java, no python, so that solves the first problem (I might have tried to venture into python). OpenSUSE has not yet integrated 6.2, so I hope I can use the 6.2 Handbook without further ambiguities. I know that I was waiting for the ODBC connection to be set up in 6.2, but the connection issue is solved, thanks to your help! In short, I'll give it a try! Many thanks again. No doubt I'll be in touch again! Cheers Harvey -- 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] Re: SQL Syntax UPDATE
On Tue, 2019-07-23 at 19:03 +0200, Alexander Thurgood wrote: > Le 23/07/2019 à 18:37, Harvey Nimmo a écrit : > > Hi Harvey, > > > A bit disappointing though. Is there no possibility for storing > > those > > kinds of SQL statements, so that they could be used again? > > I have a few in mind, and it seems a bit primitive to have to > > create a > > clipboard type of text file for that kind of thing. > > As yet, and as Robert has indicated, nothing in the Base UI allows > you > to save UPDATE queries and run them from the SQL Query UI. It has > unfortunately always been this way, since StarOffice (so that's a > very > long time for a seemingly critically missing piece of functionality). > > No one has undertaken to add the required functionality to the UI, or > internal LO parser (which would allow for graphical UI manipulation > of > update statements). > > The only remaining possibility then is via macro, which can be stored > in > the ODB file, and triggered for example, via a button press on a > form, > or a form reload, or some other action that can be used as the event > trigger. > > Alex > Hallo Alex, yes, thanks for that suggestion. I was 'kinda feared' you might suggest that. I think I would need some very solid documentation to go that way. What flummexes me most there is the multitude of methods available that house the relatively modest functions I need. I remember using VBA from my days with MSAccess, but our LO/Linux world has such an 'embarrassment of riches' I don't quite know where to start. You could say I'm a bit intimidated by the idea. Any suggestions where I might start? Cheers Harvey -- 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] SQL Syntax UPDATE
On Tue, 2019-07-23 at 18:08 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > I am not using macros (yet...hmm). I create the queries with the > > GUI in > > SQL view. > > I execute using the 'Run Query (F5)' function from the editor. The > > SQL > > text is not allowed to be stored with the syntax error in the one > > case. > > In the case of the shorter command, the SQL text is stored as a > > query > > and, it seems, could be run from the GUI, if it weren't for the > > executeUpdate() error. > > The query-editor will only work with queries, not with updates or > inserts. You have to start the command through > Tools > SQL > in the Base-file. > > > > The database itself is backend mariadb connectect via JDBC. > > So you have to use > UPDATE `Adressensammlung`.`Adressen` SET `Adressen`.`Print_flag` = > TRUE > WHERE `Adressen`.`Xmas` = TRUE; > > Regards > > Robert > -- Hi Robert, Thanks a lot, that works fine! A bit disappointing though. Is there no possibility for storing those kinds of SQL statements, so that they could be used again? I have a few in mind, and it seems a bit primitive to have to create a clipboard type of text file for that kind of thing. Cheers Harvey -- 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] SQL Syntax UPDATE
On Tue, 2019-07-23 at 16:53 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > I'm getting "Can not issue data manipulation statements with > > executeQuery()." > > Where do you start the update? > > Tools > SQL? > > Or is there a macro working? Then you have to run executeUpdate() > instead. > > Which database-connection do you use? > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > Hallo Robert, I am not using macros (yet...hmm). I create the queries with the GUI in SQL view. I execute using the 'Run Query (F5)' function from the editor. The SQL text is not allowed to be stored with the syntax error in the one case. In the case of the shorter command, the SQL text is stored as a query and, it seems, could be run from the GUI, if it weren't for the executeUpdate() error. The database itself is backend mariadb connectect via JDBC. Cheers Harvey -- 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] SQL Syntax UPDATE
On Tue, 2019-07-23 at 16:21 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > The SQL editor is rejecting this UPDATE query that, I believe, > > obeys > > the standard SQL syntax. > > > > UPDATE 'Adressensammlung'.'Adressen' SET 'Adressen'.'Print_flag' = > > TRUE > > WHERE 'Adressen'.`Xmas` = TRUE; > > > > I'm no SQL expert but I cannot for the life of me understand what > > is > > wrong with that command. > > You have to mask tablenames and fieldnames with ", if you are using > the > internal databases. > > UPDATE "Adressensammlung"."Adressen" SET "Adressen"."Print_flag" = > TRUE > WHERE "Adressen"."Xmas" = TRUE; > > Could be you are using MySQL/MariaDB (I see there is a database-name > in > the code). So you could also mask databasename, tablename and > fieldname > with `. > > UPDATE `Adressensammlung`.`Adressen` SET `Adressen`.`Print_flag` = > TRUE > WHERE `Adressen`.`Xmas` = TRUE; > > Everything, which is masked with ', will be detected as text, not as > a > name of the database, table or field. > > Regards > > Robert Hallo Robert, nice to hear from you again! even with UPDATE "Adressensammlung"."Adressen" SET "Adressen"."print_flag" = TRUE WHERE "Adressen"."Xmas" = TRUE; I'm getting "Syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE" Or with UPDATE "Adressensammlung"."Adressen" SET "Print_flag" = FALSE; I'm getting "Can not issue data manipulation statements with executeQuery()." Cheers Harvey -- 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] SQL Syntax UPDATE
I'm running LO Version: 6.1.3.2 on OpenSUSE LEAP 15.1 and have run into a snag with a query I am trying to construct. The SQL editor is rejecting this UPDATE query that, I believe, obeys the standard SQL syntax. UPDATE 'Adressensammlung'.'Adressen' SET 'Adressen'.'Print_flag' = TRUE WHERE 'Adressen'.`Xmas` = TRUE; I'm no SQL expert but I cannot for the life of me understand what is wrong with that command. Must I understand that LO Base is not supporting the standard SQL syntax? Cheers Harvey -- 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] Re: Form fields not filled
On Thu, 2019-07-18 at 21:14 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > > > > Bugzilla? What is the link? > > https://bugs.documentfoundation.org/ > > You could add an attachment with internal Firebird database. Query- > GUI > will show the same behaviour as in MariaDB. > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > Bug 126468 submitted. By an internal Firebird database, do you mean a Base database on localhost? I have attached nothing. Regards Harvey -- 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] Re: Form fields not filled
On Thu, 2019-07-18 at 16:53 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > OpenSUSE provides only the ODBC connector for mariadb, no JDBC > > connector. > > I'm using only JDBC with OpenSUSE. You have to dowload it directly > from > MariaDB > > > > What I saw was: > > > > SELECT * .*, ., . > > FROM > > . ORDER BY ASC, > > ASC > > > > After deleting the text ', ., > > .' > > from the SQL query, the extra fields were not displayed on running > > the > > query. But on saving the query again, the deleted text was added > > again, > > and it's back to square one. > > > > Is this a bug? > > Yes, it is a buggy behaviour of the editor. Have tested this: Created > a > query for MariaDB, tried to set a field to "unvisible", which should > only be used to sort the query, but it doesen't work. > The behaviour is the same in the internal Firebird database, but it > will > work right with internal HSQLDB. > > Would your report the bug? I will confirm it. > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > Bugzilla? What is the link? Cheers Harvey -- 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] Re: Form fields not filled
On Thu, 2019-07-18 at 10:48 +0200, Alexander Thurgood wrote: > Le 18/07/2019 à 09:47, Harvey Nimmo a écrit : > > Hi Harvey, > > > I using LibreOffice (version 6.1.2.3) Base as client to a backend > > Mariadb10 via MySQL(JDBC) connector. > > > > I have a created a Query in Base of the form SELECT * FROM > > > > ORDER BY ASC, ASC > > > > How did you create this query ? Sounds like you did this via the > Query > Designer GUI ? > > How is the query being executed ? Via the internal LO SQL parser > (default when executing via Query Designer) or directly via the db > engine (direct SQL button activated) ? > > FWIW, there are a few known issues between the MySQL (JDBC) Connector > and a MariaDB backend when used in combination through LO. > > Have you tried using the MariaDB JDBC connector instead ? > > > Alex > Hi Alex, things have become a bit clearer now. Yes, I created the query via the Base GUI. The query is called up by Data control of the form. OpenSUSE provides only the ODBC connector for mariadb, no JDBC connector. It is the behaviour of the GUI query editor that got me confused. With the GUI query editor, I copied the entire table as .* into the query fields. I followed up by adding two of the table fields to the query and selected 'ascending' for sorting for each of these 2 fields. I noticed then, that I could not deselect the 'Visible' flags for these 2 sort fields. Why on earth not? The behaviour means that the 2 fields will each now appear twice when running the query. No wonder then that the Form based on this query did not transfer the data from those fields back to the table. It could not cope with the ambiguity On inspecting the SQL text of the query, I was expecting a query of the kind: SELECT * FROM ORDER BY ASC, ASC What I saw was: SELECT * .*, ., . FROM . ORDER BY ASC, ASC After deleting the text ', ., .' from the SQL query, the extra fields were not displayed on running the query. But on saving the query again, the deleted text was added again, and it's back to square one. Is this a bug? It can't be right, that the 'Visible' flags of the extra fields cannot be deselected. Obviously, the corresponding SQL queries, with or without the flags are different giving different query results, but the GUI behaviour forces only the one variant. Also, surely, 'hidden' behaviour, as happens to the SQL text by just saving the GUI query without any changes must always be wrong. Fortunately, I have the workaround of removing the sort fields from the GUI query and adding them to the form. Cheers Harvey -- 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] Re: Form fields not filled
On Thu, 2019-07-18 at 10:48 +0200, Alexander Thurgood wrote: > Le 18/07/2019 à 09:47, Harvey Nimmo a écrit : > > Hi Harvey, > > > I using LibreOffice (version 6.1.2.3) Base as client to a backend > > Mariadb10 via MySQL(JDBC) connector. > > > > I have a created a Query in Base of the form SELECT * FROM > > > > ORDER BY ASC, ASC > > > > How did you create this query ? Sounds like you did this via the > Query > Designer GUI ? > > How is the query being executed ? Via the internal LO SQL parser > (default when executing via Query Designer) or directly via the db > engine (direct SQL button activated) ? > > FWIW, there are a few known issues between the MySQL (JDBC) Connector > and a MariaDB backend when used in combination through LO. > > Have you tried using the MariaDB JDBC connector instead ? > > > Alex > Hi Alex, Yes, I created the query via the Base GUI. The query is called up by Data control of the form. OpenSUSE provides only the ODBC connector for mariadb, no JDBC connector. Thanks for your input! Cheers Harvey -- 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] Form fields not filled
I using LibreOffice (version 6.1.2.3) Base as client to a backend Mariadb10 via MySQL(JDBC) connector. I have a created a Query in Base of the form SELECT * FROM ORDER BY ASC, ASC Why MUST these two sort fields be set to 'visible' in the query (thus extending the above syntax accordingly), since they are any case part of the source table? The columns appear twice in the opened query? I have created a Form based on the above query. However, on filling out the form for a new record and saving the data, a new record is created in the table but the data of above two fields remain blank, i.e. are NOT transferred to the source table. The two fields in the source table remain blank, whereas all other fields are filled as expected. Are these two aspects related? Should this be the behaviour? I would not have expected the data from the two fields to be rejected. Cheers Harvey -- 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] Table fields from Mariadb to Base
On Wed, 2019-07-17 at 09:54 +0200, Harvey Nimmo wrote: > On Wed, 2019-07-17 at 09:09 +0200, Robert Großkopf wrote: > > Hi Harvey, > > > > couldn't see this behaviour in LO 6.2.5.2 on OpenSUSE 15, 64bit rpm > > Linux. But my MariaDB is a local database. Think it is a problem of > > the > > remote-connection to your database. The changing of the table must > > reach > > the database and after changing the table inside the database the > > information could be send back to the query. > > > > Do you use parameters for the connetion to the database, for > > example > > jdbc:mysql://«Host of > > database»:3306/«databasename»?autoReconnect=true > > > > @Dan: If you add a field to a table for an external database the > > Base-file must not be saved. There has nothing been changed in > > Base, > > only in the (external) database. > > > > Regards > > > > Robert > > -- > > Homepage: http://robert.familiegrosskopf.de > > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > > > > Hallo Robert, > > it seems that autoReconnect=true does the trick. I had been using the > MySQL(JDBC) method where there seemed to be no place to set the > autoReconnect option. Having switched to the pure JDBC method, I can > add autoReconnect=true and it works now as expected. > > Many thanks! > > Harvey Ah but.it seems to be not so simple...:-J After setting the method to JDBC with the option autoReconnect=true, it becomes not possible to edit the existing fields of the table. A new field could be added, but the existing ones cannot be changed. So I have to return to the MySQL(JDBC) option. However, it accepts adding ?autoReconnect=true behind the database name AND the addition of new fields is transferred to the forms function immediately. In other words, the problem is solved, by adding the option ?autoReconnect=true behind the database name in every case. Is that documented somewhere? Many thanks again Cheers Harvey -- 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] Table fields from Mariadb to Base
On Wed, 2019-07-17 at 09:09 +0200, Robert Großkopf wrote: > Hi Harvey, > > couldn't see this behaviour in LO 6.2.5.2 on OpenSUSE 15, 64bit rpm > Linux. But my MariaDB is a local database. Think it is a problem of > the > remote-connection to your database. The changing of the table must > reach > the database and after changing the table inside the database the > information could be send back to the query. > > Do you use parameters for the connetion to the database, for example > jdbc:mysql://«Host of > database»:3306/«databasename»?autoReconnect=true > > @Dan: If you add a field to a table for an external database the > Base-file must not be saved. There has nothing been changed in Base, > only in the (external) database. > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > Hallo Robert, it seems that autoReconnect=true does the trick. I had been using the MySQL(JDBC) method where there seemed to be no place to set the autoReconnect option. Having switched to the pure JDBC method, I can add autoReconnect=true and it works now as expected. Many thanks! Harvey -- 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] Table fields from Mariadb to Base
On Tue, 2019-07-16 at 22:11 +0200, Harvey Nimmo wrote: > On Tue, 2019-07-16 at 21:28 +0200, Robert Großkopf wrote: > > Hi Haevey, > > > > > > Having added the new field to the table using the Base client, I > > > expected it to appear in the query which is of the form (SELECT * > > > FROM > > > ). It didn't until I closed Base and restarted it. > > > > How did you add the field? Tools → SQL? Or did you add it in the > > GUI. > > If added through Tools → SQL a refresh of the tables is needed > > (View > > → > > Refresh Tables). The GUI doesn't recognize automatically what has > > been > > changed in this way. > > > > Regards > > > > Robert > > -- > > Homepage: http://robert.familiegrosskopf.de > > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > > > > Thanks for the input! > > I added the field via the Base table GUI. Of course, I could have > added > the new field explicitly to the query (so that the field may then > appear twice) (but why?). Maybe this behaviour is only evident with a > remote database? > > Cheers > Harvey > A further input: my first action after updating the table was to go to edit the form (to add the new field). The field did not show up in the list of controls. It was this that made me open the query to check if it were there. It wasn't, so I then opened the table, where it was shown as expected, no data, as yet, having been entered in any of the new fields. Now I have slight doubts, having tried adding a new test field. This field showed up when I opened the query, but was not to be seen in the data control field of the form. In other words, maybe the order 'open query/open form (for edit)' or the other way round, as in the previously reported case, produces different results. Cheers Harvey -- 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] Table fields from Mariadb to Base
On Tue, 2019-07-16 at 21:28 +0200, Robert Großkopf wrote: > Hi Haevey, > > > > Having added the new field to the table using the Base client, I > > expected it to appear in the query which is of the form (SELECT * > > FROM > > ). It didn't until I closed Base and restarted it. > > How did you add the field? Tools → SQL? Or did you add it in the GUI. > If added through Tools → SQL a refresh of the tables is needed (View > → > Refresh Tables). The GUI doesn't recognize automatically what has > been > changed in this way. > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > Thanks for the input! I added the field via the Base table GUI. Of course, I could have added the new field explicitly to the query (so that the field may then appear twice) (but why?). Maybe this behaviour is only evident with a remote database? Cheers Harvey -- 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] Table fields from Mariadb to Base
I am connecting a Base client (Version: 6.1.3.2) to a remote mariadb using the MySQL (JDBC) connector. A form I had generated in Base needed a new field that had to be added to the source (Base) query and the related (Mariadb) table. Having added the new field to the table using the Base client, I expected it to appear in the query which is of the form (SELECT * FROM ). It didn't until I closed Base and restarted it. Is this a bug? Known or new? Best Regards Harvey -- 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] Help with formula - number conversion
On Fri, 2019-07-12 at 13:00 -0400, Tanstaafl wrote: > On Thu Jul 11 2019 15:12:05 GMT-0400 (Eastern Standard Time), Harvey > Nimmo wrote: > > Sorry, Tanstaafl! > > > > There is a slight error in the above. The formula should read > > =HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0) > > > > 'SEC' is the secant function. Also 'MIN' would also be wrong since > > it > > calculates the minimum of a set of values. > > awesome! Thanks very much Harvey! Worked like a charm... You're welcome. But Brian Barker's suggestion is both more elegant and simpler, because it considers takes account of times greater than 24 hours. Say your time is in cell A1 in text format (e.g. '25:01:50) Then adding the formula to another cell =ROUND(a1*1440,0) or just ROUND(a1*1440) gives the right answer (1502), whereas my previous formula would wrongly return 1 (hour) instead of 25, giving total 62. Cheers Harvey -- 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] LibreOffice Base fails to connect to remote mariadb
On Fri, 2019-07-12 at 16:08 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > However, whereas I can now connect successfully with jdbc to the > > database, my existing (LO) input forms won't let me change the > > data.The > > form controls are completely deactivated. > > Open one of the tables, not a form. Could you input data here? If > not: > Base is missing a primary key for the table. Input of data will be > only > possible through Tools > SQL (or by macro) without a primary key. > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > Yes, I can enter data directly into a table. Cheers Harvey -- 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] LibreOffice Base fails to connect to remote mariadb
On Thu, 2019-07-11 at 21:47 +0200, Robert Großkopf wrote: > Hi Harvey, > > have the same system here and have written down all what I have > tested here: > http://robert.familiegrosskopf.de/lo_hb_xhtml/Base_02_DatenbankErstel > len.xhtml#__RefHeading__875_19302748411 > > Its part of the German Base-Handbuch. > > Older (bad) translated versions: > http://robert.familiegrosskopf.de/lo_hb_en/BH5002-CreatingADatabase.o > dt > OR > http://robert.familiegrosskopf.de/lo_hb_en/BH5002-CreatingADatabase_H > R_JHW_20151220.odt > > Regrads > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > Thanks for the inputs. What needed to be installed for the jdbc alternative was the mysql-connector-java package. However, whereas I can now connect successfully with jdbc to the database, my existing (LO) input forms won't let me change the data.The form controls are completely deactivated. Cheers Harvey -- 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] LibreOffice Base fails to connect to remote mariadb
Having tried unsuccessfully to connect my remote mariadb from LibreOffice Base under Leap 15.0, I am still having problems under Leap 15.1. My LO version is 6.1.3.2. The JDBC and ODBC drivers 'fail to load'. Can someone please point me in the right direction to troubleshoot this problem systematically? For example with ODBC: What is the syntax for the name of the 'ODBC data source'? I am getting the error "SQL Status: IM002 [unixODBC][Driver Manager]Data source name not found, and no default driver specified" I have no problem to connect to the remote database with, say, Mysql workbench or phpMyAdmin from the same client desktop, so the database is accessible. Cheers Harvey -- 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] Help with formula - number conversion
On Thu, 2019-07-11 at 20:55 +0200, Harvey Nimmo wrote: > On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote: > > Hi everyone, > > > > I need some help with converting a number (in a text field) to a > > different type. > > > > The type of number is time, and it is in the form of: > > > > hh:mm:ss > > > > I need to convert this to just minutes, rounded up, so if ss is > > more > > than 30 it adds another minute. > > > > I'm at a loss as to how to even start (I'm not a spreadsheet > > guy)... > > > > I would appreciate any pointers on how to get this done... > > > > Thanks! > > You might like to try the following. > Given that your value is in field A1 in the form hh:mm:ss > then you can do the conversion by entering the following in another > field > =(HOUR(A1)*60)+MINUTE(A1)+ROUND(SEC(A1/60),0) > > It doesn't seem to matter if the value in A1 is in time format or > text > format. > > I'm sure there are buffs out there who could offer a more elegant > solution, but the above seems to work all right for the cases I > tried. > > Cheers > Harvey Sorry, Tanstaafl! There is a slight error in the above. The formula should read =HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0) 'SEC' is the secant function. Also 'MIN' would also be wrong since it calculates the minimum of a set of values. Cheers Harvey -- 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] Help with formula - number conversion
On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote: > Hi everyone, > > I need some help with converting a number (in a text field) to a > different type. > > The type of number is time, and it is in the form of: > > hh:mm:ss > > I need to convert this to just minutes, rounded up, so if ss is more > than 30 it adds another minute. > > I'm at a loss as to how to even start (I'm not a spreadsheet guy)... > > I would appreciate any pointers on how to get this done... > > Thanks! You might like to try the following. Given that your value is in field A1 in the form hh:mm:ss then you can do the conversion by entering the following in another field =(HOUR(A1)*60)+MINUTE(A1)+ROUND(SEC(A1/60),0) It doesn't seem to matter if the value in A1 is in time format or text format. I'm sure there are buffs out there who could offer a more elegant solution, but the above seems to work all right for the cases I tried. Cheers Harvey -- 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] Calc error?
On Fri, 2018-12-28 at 20:12 +0100, Piet van Oostrum wrote: > Harvey Nimmo writes: > > > I'm running LO on OpenSuse and I wonder if anyone alse can confirm > > this > > error on calc. > > > > Multiplying 2048.28*.146 yields correctly 295.54488, but when > > rounding > > down to 2 decimal places, 295.55 is displayed (instead of > > 295.54)(either using ROUND(2048.28*.146,2) or with field format. > > > > 2048.28*.146 = 299.04888 > not 295.54488 > -- > Piet van Oostrum > WWW: http://piet.vanoostrum.org/ > PGP key: [8DAE142BE17999C4] Sorry Piet, for causing you trouble. My mistake. See my previous replies. Cheers Harvey -- 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] Calc error?
On Fri, 2018-12-28 at 19:12 +, Brian Barker wrote: > At 20:06 28/12/2018 +0100, Harvey Nimmo wrote: > > However, I do not have 'Limit decimals for general number format' > > set to anything. (i.e. No tick) > > Good-oh! And what about "Precision as shown"? > > Brian Barker 'Precision as shown' is also not set (No tick) Harvey -- 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] Calc error? SOLVED
I think you have put your finger on it, Michael. The 2024.28 figure is calculated but displayed to only 2 decimal places. It is, to 4 decimal places, 2024.2829 which results in 295.5452888. So, thanks for the enlightenment!! Cheers Harvey On Sat, 2018-12-29 at 05:11 +1000, Michael D. Setzer II wrote: > =With the updated first number I get the 295.54 as it should > be. > Third position is a 4, it doesn't change the 2nd position. > > Num 1 > Num 2 > Num 1 * Num 2 > Rounded > 2024.28 > 0.146 > 295.54488 > 295.54 > > > Are the values you show for the Num 1 and Num 2 entered link that or > are > that what is displayed on screen.The actual numbers could throw off > the > calcs. > > > If the 0.146 number is display like that, but actually contains > 0.146001936490999 it would change the value. > > > > > On 28 Dec 2018 at 19:47, Harvey Nimmo wrote: > > > Subject:;Re: [libreoffice-users] Calc error?From:60;Harvey > nimmohar...@nimmo.det; > To:;Robert grokopfrob...@familiegrosskopf.de, >