Re: [libreoffice-users] Extract text from base field, place into new field
Hi Edwin,
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?
Only per macro:
1. Connect to the field in your form.
2. Read value from this field
3. Split content into an array
4. Take first entry of this array and put it to the new field.
But: You won't need the new field if you only want to extract the first
word and won't edit the new field. You could also get the first word by SQL:
SELECT "Sentence", LEFT("Sentence", POSITION(' ' IN "Sentence")) AS
"FirstWord" FROM "Table"
If there is only one word in "Sentence" this word wouldn't be shown. So
the code has to be expanded:
SELECT "Sentence", CASE WHEN POSITION(' ' IN "Sentence") > 0 THEN
LEFT("Sentence", POSITION(' ' IN "Sentence")) ELSE "Sentence" END AS
"FirstWord" FROM "Table"
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 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 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 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. 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
Re: [libreoffice-users] Strange style application behavior.
Hi Chris, without an example it is nearly impossible to reproduce and help here. You know there are character styles also? If you have set a character style, which defines the font to 12 pt, you could also set the paragraph style with a font of 18 pt. The font will appear with the special defined character style (and 12 pt). 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] Column/Row highlighting
Hi Harvey, Thanks, that's good to know. By the way, what exactly does 24.2.1.2 mean? It's my current version from OpenSUSE. Using OpenSuSE here also. But I have installed many versions from LO directly in parallel mode. Version 7.6.7.2 is the version with most bugfixes. Will be the last version of 7.6. Version 24.2.3.2 is the newest version. I would install this version. Your version 24.2.1.2 would be the following version: Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded 24.2.1.2: Year 2024, Month 2, 1. bugfix release, 2. release candidate. Most versions will get a first and a second release candidate. The first version of a new version (24.2.0) will often get more than 2 release condidates. Build ID of the SuSE-Version is very short: 420(Build:2). Build IDs of versions directly installed from LibreOffice will look like this: Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba 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? I would install version 24.2.3.2 directly from LibreOffice in parallel mode and try: https://wiki.documentfoundation.org/Installing_in_parallel/Linux It's only one line code in konsole, which installs the whole version in a subfolder of the *.rpm-files. Installs all as a user installation. 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] Column/Row highlighting
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 -- 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] imported styles changed alignment
Hi Philip, I would expect styles to be imported without any change happening during the import. Is there a setting I missed somewhere? Before choosing the file: Did you click "Overwrite" in dialog for loading styles. If there is a style with the same name it won't be imported with the new features by default. 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 Of Contents
Hi Chris, open Writer → Tools → Heading Numbering Numbering → Paragraph Style: Choose the style you need for level 1 and all other levels. Refresh TOC 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] Feature Request
Hi Grace, I would like to ask if a feature be added so that form fields can be set as transparent not just colors. This has been something that many users would like to see added: https://bugs.documentfoundation.org/show_bug.cgi?id=106810 Would this be possible, and if so how soon could this be added? Write a comment to this bug. Offer arguments why you need it. When opening a form for editing in Base I will get all the controls (except listboxes) with transparent background. It won't show the choosen background. When switching to input data the background will be shown. And now the problem: Background won't be shown in multiline textboxes. When switching from one row to the next the new content is set in front of the old content. So the transparent textbox is unusable. Hope this won't be the same behavior for all controls when setting transparaency has been added to form controls. 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] Libre shouldn't warn during saving in doc
Hi FARHAN ISHRAK Fahim, Today, I was saving a file to doc while working on libreoffice writer. It showed a warning that if I save in doc format, it may break formatting. Although there is an option to disable it, it shouldn't be popped up even. It will frighten more people to use it rather than attracting people to use it. What would you write when parts of format has been lost because you have saved in *.doc-format? You would say it's a bug of LO, but it might be a feature of *.odt to save, which can't be saved in doc-format. We just had such a discussion in other way: old *.xls-files couldn't save as much rows as current *.ods-files. If you save a big *.ods-file as *.xls, all rows which cannot been svade will be cut off. The warning "Don't do this. You will lose content." seem to be not strong enough. People, who use LibreOffice, should use the open document format. Could be imported to other Office suites if needed. 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] AltSearch extension no longer listed
Hi Robert, I can no longer find AltSearch (Alternative Find & Replace for Writer) at https://extensions.libreoffice.org/. Can anyone else find it? https://extensions.libreoffice.org/en/extensions/show/70066 Seems to be updated 17 hours ago. Regards Robert (Großkopf) -- 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] Cancel
Hi Sally, this is a list for userers of LibreOffice. Tehere is nobody who could cancel any redurring donation. 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] Frustration!
Hi Mike, seems LO detected a dark mode in your system. What do you see in Tools → Options → LibreOffice → Application Colors Scheme here is LibreOffice Light and all Colors are set to "Automatic". Try also Help → Restart in Save mode. 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] Base macros
Hi Edwin, OK, so I tried to follow the instructions as best as I could, but no success. I've attached a demo version of what I've tried, with essential image files, in exactly the same relation they are in the full version. I've added the macro and an action button. Attachments will be cut here. Send it directly to me per private mail. 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] Libre Office bugs (Windows 10 pro PC)
Hi Dutta, please report bugs to https://bugs.documentfoundation.org/ You have written your description to a users list. Ins this list users will help users, but nobody would solve bugs. 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] Base macros
Hi Edwin, Thank you. I should have clarified: the image that comes up on the form is a size limited version of the actual file on the hard disk. This will be the problem: Where could you get the path to the original sized images? Macro will work with a path to external images. 2. In each image button, under the additional information field, write the name of the image control. Don't know why an image button. Could be any button, which contains in additional information the name of the field with URL-information to the original image. 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] Base macros
Ho Edwin, started the macro and recognized I havent declared oDoc. Write after all the variables at first line: oDoc = ThisComponent 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] Base macros
Hi Edwin,
How should an external viewer open another picture, which isn't linked
in the form? A macro will open the thumbnails.
Link the original fotos to the form. Then take this procedure:
SUB ShowLinkedContent(oEvent AS OBJECT)
DIM oButton AS OBJECT, oForm AS OBJECT, oField AS OBJECT, oShell AS
OBJECT
DIM stField AS STRING, stUrl AS STRING, stContent AS STRING
DIM arUrl_Start()
oButton = oEvent.Source.Model
stField = oButton.Tag
oForm = oButton.Parent
oField = oForm.getByName(stField)
stUrl = oField.BoundField.getString
arUrl_Start = split(oDoc.Parent.Url,oDoc.Parent.Title)
oShell = createUnoService("com.sun.star.system.SystemShellExecute")
stContent = convertToUrl(arUrl_Start(0) + stUrl)
oShell.execute(stContent,,0)
END SUB
Write the name of the image control to the additional information of the
button, which should start this procedure.
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] Emailing calc spreadsheet
Hi Sue, all the 19 pages of your print are on "sheet 1" Scroll down, or scroll right. You will see all is there. If you want to send a document instead: Export to *.pdf. There will be also 19 pages. 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] Creating forms with math
Hi Thane, Is there a way to generate a PDF fillable form that will do basic math? No chance with LibreOffice. You will need Java script, which should be executed. Use Scribus instead. Also OpenSource and could create such a form by default. 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] paragraph style
Hi Thomas, Why is it, that a certain style produces two different appearances? What can I do to get the same style for all chapters. That will be required later when I set up an table of contents. Please upload an example somewhere in the web, which shows this behavior. Or: Write in ask.libreoffice.org. There you could upload files. 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] Saving an odm as a docx in editable form.
Hi *, we have saved the problem per private mail. A master document contains many write-protected linked documents. If you want to get such a document as a writable *.odt-file you have to break all this links. Dialog for breaking links isn't available if cursor in the master document is set in a section of a linked document. It has to be set in a text section, which is part of the master document. Then the dialog Edit → External Links… could be started. 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] Saving an odm as a docx in editable form.
Hi Chris, let us try: You have opened the *.odm, gone to File → Export and created a *.odt-document. You have opened this document, started Edit → External Links… and break all links to get the content without asking for updating links. Saved this file again (as odt) and svaed the file also as "Word 2007 docx". I have tested all this with German Base Handbuch. Could open the docx-file and edit it without any problem here. Seems it has problems with references, but this might be a problem with export filter *.docx. I don't use *.docx here. People, who use Word, could also open *.odt-files. Tested with Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 6; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded 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] Writer form design grid
Hi Mike, Snap-to-grid doesn't seem to do a lot - but as the grid size isn't changeable, it would not be a whole lot of help. I'm creating very much forms for databases (also for other people). I'm using grid only. Helps me very much. Points of the grid are small - right. But grid size could be changed to every distance I need. 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] Writer form design grid
Hi Mike, you could set something for the grid in Tools → Options → LibreOffice Writer → Grid Subdivisin will set more ore less grid points between the main points. You could set the color for the grid in Tools → Options → LibreOffice → Application Colors → Writer → Grid but the problem will be: the grid points are only one pixel. You could use helplines while moving a control: View → Grid and Helplines → Helplines while moving 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] pdf forms (OT?)
Hi Mike, It still leaves the question of how to extract the data from the completed form. Perhaps I've not hit the right keyword, but I've found /nothing/ on the net. Surely if there's a way of filling in a form, there's one of reading it!! I have tested (for German Base Handbuch) https://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/ Works with Linux this way: for i in *.pdf ; do pdftk "$i" dump_data_fields_utf8 >> auswertung.txt ; done Set *.pdf to the pdf file you need. All data could be read in the text file "auswertung.txt". This file is formed in a special way. I used this formatting to get the data out of a form into a database by macro. 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] Default Images Path
Hi Edwin, have tested here with a imagecontrol in a form. Clicked on the control and opened the folder "Downloads". Load an image from another forlder. Closed the imagecontrol and the form. Then opened again and clicked on the control: The last path will be opened. All with LO 24.2.0.2 on OpenSUSE 64bit rpm Linux. Which system and which version of LO do you use. You could copy the versions information on Help → LibreOffice: Version: 24.2.0.2 (X86_64) / LibreOffice Community Build ID: b1fd3a6f0759c6f806568e15c957f97194bbec8f CPU threads: 6; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded 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] Master document and styles.
Hi Michael, I can absorb those changes by loading the styles from his returned document into my template and then into the master. You could directly import all styles from one document to your master document. Import should overwrite the current versions of styles in the master document. Master document will take the styles, which are defined in the master document. If styles aren't installed in the master document it will take the styles from the first document, which contains the (new named) style. So: If nobody creates new styles or renames old styles all will work well in the master document and all will be formatted by the styles defined in the master document. Now, what's the best way to change all the sections other folks sent me and make sure that all the styles are consistently synchronized across all documents? Do you need also the normal document in this style? Then open the documents and import all styles from your master document to the document. Let overwrite the old styles. Hope I understood your problem well. 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] Master document, internal link between documents and pdf
Hi Michael, Can this work for page numbers too? (Using the original document as an example), adding to the reference for "WAGO" in the "C" document something that may say something like see "WAGO on page XXX" where the XXX is where the finished document will put the reference to WAGO? Connection will be created to the page number also. If you insert a reference, you could chose different behaviors on "Refer using": Page Number (unstyled) Page number (styled) Chapter Referenced text "Above"/"Below" I always chosed "Referenced text" for German Base-Handbuch. This book is created by a master document. All main chapters are separate documents with different sections for content and title/Toc. There are many references from one chapter to the other in the master document. Same master document works since 12 years with changing chapters for every new version of LO. I only set a link to the different chapters in my file system. So I don't need to change the link inside the master document. 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] Master document, internal link between documents and pdf
Hi Francois-Marie, The question is : In document C.odt I put the definition of electrical *connector* and give an antonomasia *WAGO*. In the W.odt document I put *WAGO*: electrical connector whose name is that of the manufacturer. I would like to put a link from WAGO in the C.odt document to WAGO in the W.odt document. Open Document W.odt. Go to position of the content, which should be linked to. Insert → Field → More Fields → Cross Refereence → Set Reference. Name of the reference should be "WAGO". Open Document C.odt. Go to the content, which should link to W.odt → "WAGO". Insert → Field → More Fields → Cross Refereence → Insert Reference. Name of the Reference should be "WAGO". Now you will see in C.odt "Error: Reference source not found". But if both documents are in a master document the reference could be found and will work. 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] Lost Ability To Open Hybrid PDF in Writer
Hi Dave, Yes, it definitely seems to be that one. I don't know how I missed it in my search of Bugzilla. Remembered to this post: https://ask.libreoffice.org/t/open-hybrid-pdf-file-in-write-instead-of-draw/99178 Haven't searched in Bugzilla for this one. 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] Lost Ability To Open Hybrid PDF in Writer
Hi Dave, may be this one: https://bugs.documentfoundation.org/show_bug.cgi?id=158442 Seems it is fixed for version LO 24.2, but is waiting for review in LO 7.6. 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] Min. skills for Base
Hi *, stability is a problem for all internal databases. You could test this by input some data, save this data and kill the LO-process. No data had been saved when database has been opened next time. Better: Move the internal database out of the *.odb-file. I'm using LOBase as backend for Firebird-database files if I create standalone-database solutions. Data were saved independent of a crash from LO. Best for solutions for groups (more than one user at the same time): MariaDB or PostgreSQL. Both could be connected by an internal driver supported by LO. Could also be connected to both by JDBC or ODBC. More informations could be found at https://documentation.libreoffice.org/en/english-documentation/ (Base Guide) Base Guide is a translation of German Base Handbuch, which conatins much more information at this time. See my homepage. 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] Min. skills for Base
Hi Jonathan, 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 You have opened the table "Owntunes". There is a field "Key". It will need an entry, but you haven't add an entry. Very often: There is a primary key field defined as INTEGER, but people have forgotten to set it as an AutoValue field. So a Input is needed, while a autoincremented field will do this automatically. You could change this field to AutoValue if you have designed it as an INTEGER-field and if it is the primary key field. 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] Base report text fields of variable size
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 -- 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] Address Book Conundrum
Hi Peter, Am 10.09.23 um 13:07 schrieb Peter Hillier-Brook: For donkey's years I've been using an address book created from a calc spreadsheet, assigned via the Address Data Source Wizard. In a freshly installed version of LibreOffice (7.6.0.3) it's no longer available as it requires the "base" component that is not present. It has required Base also in the past, but many people didn't recognize this. You connect from Writer thruogh Base to Calc. Why isn't Base available for your installation. I never git an installation without Base component (OpenSUSE 64bit rpm Linux here). 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] can anybody hear??
Am 03.09.23 um 16:31 schrieb t jackson: Messages I submit to users@global.libreoffice.org do not come back to me as a subscriber, and so I assume nobody else sees them either. This is just a test to see if perchance that blockage has been cleared since my last try. First Mail from you I see here … 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] problems on Ubuntu
Hi Rogier, When I click on the icon, it shows me an open file. for some reason they have been minimized. The minimized file appears on the desktop, but it goes in the upper left hand corner on my dual screen system, right where trash is. and it is hard to tell, but I can then drag it and enlarge it, and things are back to normal. What is still unclear is what caused this to happen, for I have no awareness of anything I did differently. Have seen this also on some newer versions of LO here: Minimized, looks like an icon … But I'm switching very often between different versions of LO so I haven't reset the user profile for this. Might be it will help. 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: (unresolved) Re: [libreoffice-users] weirdness in save dialogue box
Hi Steve, Years. I have had this issue for years. I had no response from this list and thought it must be an "improvement" and don't think I filed a bug as I just got used to working with it. If you also see this behavior as buggy behavior, why don't you confirm the bug? https://bugs.documentfoundation.org/show_bug.cgi?id=156765 Write about the system you are using. Write you get the same buggy behavior and switch it from UNCONFIRMED to NEW. 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] dbind-WARNING message.
Hi Michael, opening libreoffice or libreoffice7.5 or libreoffice 7.6 as a regular user see this message trying to acces /root file?? Which LO-version do you use: directly from LibreOffice or packed by the Linux distribution? I have just started LO 7.6.0.3 (from LibreOffice) installed in my user home directory through Konsole. No error appears in Konsole here. Then started LO 7.5.4.1 (packed by openSuse) installed for all users through Konsole. Also no error in Konsole. 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] alter appearnce hypertext
Hi *, Really? Do you think there exist a better one? Any recommendations for a different email client to run with Windows 10? Yes Brad I am aware of that and have been for many years. I had intended to send the email off-list to Martin, but the new Thunderbird is such a screw up it didn't indicate it was also sending to the list as well. Pity Mozilla have destroyed a great email client. Might be a discussion off topic. But this is the only one I am irritated of new Thunderbird: By default I answered direct to list. Could move the buttons of the mail editor to where I want. Now the buttons couldn't be moved and I have very ofter answered per private mail instead of mail to list. I don't think there is a mail client that will work better for me. And the described behavior might be changed in the future. And for all, who will need attachments and not only text context in a list: Use https://ask.libreoffice.org/ instead. 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] Header and footer
Hi Keerthana, While using libre office writer,I can't insert header and footer outside the border.what can I do? 1.: Right mousclick on the background of the page in Writer → Page Style → Header → Header on (or Footer → Footer on). 2.: Formate → Page Style … and then the same 3.: Mouse otside the writable area on the top → left mouse click and there appears "Header" with '+' to add the header. 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] Documentation of LibreOffice
Hi Dorothy, I tried to use LibreOffice to do a project but gave up after 2 weeks & forked out the money for Microsoft Access, which I'm finding much easier to use. For what its worth, I'm attaching the notes I wrote on my project & my attempts to use LO Base/ Calc & and MS Access / Excel. Where do I get this notes? Base: Do you know there is a Base Guide available: https://documentation.libreoffice.org/en/english-documentation/ And also the original with much more content, because it will be updated for every LO-Version: https://de.libreoffice.org/get-help/documentation/ But it is only available in German language. Reguards 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] Split window on top of each other in Word 07-2003 from LibreOffice
Hi Rainer, open the document in Writer. Go to Window → New Window. A second instance of the current window will be opend. Set position and height of the two opended windows to the height you wish. All content you change in one window will be also changed in the other window. 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] Image Anchor Selection
Hi T. R., Understandable. What I would really like is an option to make anchor-to-page the **default** in LO Writer. Please read https://ask.libreoffice.org/t/problem-with-anchor-picture-in-all-page/61556/6 I would never use this kind of anchor. I often work with master documents. If there is any image anchored to page it won't appear on the right position in the document. Moste images will disappear completely. Go on sidebar → Styles → Graphics. Modify Frame Style: Graphics → Type → Anchor → To Page Now all images in this document you will insert new will be anchored to page. Haven't tested if this will be saved when setting this document to default template. Go to Tools → Customize Chose tab Context Menus Chose Target → Image Search for "anchor" Klick on "Anchor to Page" in the list of "Available Command". Press arrow to the right. Position the new entry "To Page". It will appear now in the context menue, but directly, not in the submenu for anchoring. 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] Image Anchor Selection
Hi Joe, By dropping choices from a context menu seems to me to be a regression of functionality. Should I file a bug report? File a bug for this. And: open Tools → Customize → Context Menus. There is missing the context menu for "Anchor" - don't know how it appears. Add "Anchor to Page" from the available commands. Note: Might be it has been dropped because anchor to page means it is fixed like in old layout times on a page and will get troubles in master documents. 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] Failed connection to MySQL database
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 -- 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 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 -- 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] MariaDB Connector Question
Hi LAP, However, only the JDBC connector will connect to the specified database. The ODBC and C connectors will connect to _all_ the databases that are present in the MariaDB database directory, i.e. all tables from all databases are shown. Not all databases. All the data you are allowed (from your MariaDB) to connect to. Why does only the JDBC connector actually connect to the specified database? When connecting here with org.mariadb.jdbc.Driver there are also shown all databases I am allowed to read data. Tested with mariadb-java-client-3.1.3.jar, LO 7.5.3.2 on OpenSUSE 15.4 64bit rpm Linux. Go to Tools → Table Filter… and deactivate the databases you do not want to see. Go to View → Refresh Tables and the databases won't be shown any more. Is this normal behavior or is this a bug? Why should this be a bug. You could connect to different databases with this connection. Some people use this to copy data from one database to another, to switch during one 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
Re: [libreoffice-users] Mail Merge Label Problem
Hi Matt, We are trying to generate labels from the Mail Merge component of Libreoffice 7.2. We can work through the mail merge system however for some reason the Mail Merge can't locate a Database to pull the contact information from. Did you register any database file? You will nee a Base database file. If you will create it new the second step of the wizard asks if you want to register the database in LibreOffice. If it isn't registered other parts of LibreOffice know nothing about the database. If you have created a Base file and dien't register you could do this later by Tools → Options → LibreOffice Base → Databases → New All databases you could see here will be shown by the registered name when opening Writer and switch to View → Data Sources. 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] Actual bug report.
Hi Michael, I have ~104 "Fields" from a long google form. They look like this: Principle Investigator #1 Name: (Last, First) Principle Investigator #1 Title: Principle Investigator #1 Phone: Principle Investigator #1 Email: Mailing list membership for PI#1 [xxx Announce] Mailing list membership for PI#1 [xxx Alarm] Add another? Principle Investigator #2: Name: (Last, First) Principle Investigator #2: Title: You have imported tis fields to Base? HSQLDB will run, but field names in internal Firebird will end by 31 characters. https://www.dropbox.com/s/bi3ec5snrf2shht/MCT_Screenshot_20230410_084805_P2.png?dl=0 On this screen, I tried to resize the "Query Wizard" screen to be wider so that I can read the field names and I can't. So use the scrollbar at the bottom. It's shown in your screenshot. 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] FW: [Bug 154244] Print and Print preview does not show Textbox second line if the text is a double line. Only shows and print the first line.
Hi Georg, this is the wrong place to answer to a bug report. Go to https://bugs.documentfoundation.org/show_bug.cgi?id=154244 and write down a better description or, better, add an attachment for others to reproduce the buggy behavior. 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] Office doesn't handle its own graphics?
Hi Gavin, I'm creating a document in Writer, and wanted to include some graphics from Draw. But you can't insert a Draw file. Draw files are filtered out of the file dialog by default; and if you enable "all files" and select one, you get an error message. A draw document could contain many pages. On every page will be shapes/images. So a *.odg-document couldn't be imported as image to a *.odt-document. Mark the shape/image you want to import. Drag and drop it to Writer. Or: Export the marked content as *.wmf. So you could import this image by the import dialog of Writer. 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] Need help with LOBase
Hi Pertti,
I have been working on a LOBase database where the fields of interest are
(a) the husband (=table ”t_man”) and his ”surname” and ”firstname”
(b) the wife (= table ”t_wife”) and her ”firstname” (husband and wife
have same surname).
Isn't the same here in Germany for all husbands and wifes …
How to concatenate
"surname"||', '||"t_man"."firstname"||IFNULL(' &
'||"t_wife"."firstname",'') AS "Name"
Table have to be connected in the query. This is only the one field for
"Name"
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] Entering special characters in a form in Base
Hi Graham, I have created a simple database in Base to catalogue my books and as they are in a number of languages some of the titles and authors' names contain characters with diacritics. I had hoped that I could enter these as special characters as I could in a Writer document but the "special character" item under "insert" in the form view is faded out, i.e. is not active. Is there something I am missing here that would make this item active? Set the cursor in the form control. Click right mouse button → Special Character… or press shift+Ctrl+S Special characters in menue of the wirter document is greyed out, because you can't enter content in the background of the form. It is write protected. 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 Andrew, database of Harvey is MariaDB. So it has been quoted a littel bit different: SELECT `Name` FROM `Table` This kind of qouting could be used in Basic macros without any problems: stSql = "SELECT `Name` FROM `Table`" If there are double qoutes like in internal HSQLDB it looks a littel bit different: SELECT "Name" FROM "Table" and in Basic: stSql = "SELECT ""Name"" FROM ""Table""" 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 Harvey, would be better to post such a SQL-code you execute through Tools → SQL. This code should be the same as safed in the database for executing later through the form. I will send you an example with internal HSQLDB per private mail. 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 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 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] Questions about LOBase
Hi Pertti, Since years back I now again need to create a database preferable one that can extract and print reports. I noticed that LO has skipped ’Firebird’ and offers ’HSQLDB’ as a main option. _Questions: _(a) Is LOBase up-to-date and seriously still usable or shall I look for another program No problem to work with LO Base. If you don't need functions like DATEADD, LIST (Concatening text-content by grouping) or special windowfunctions you could use HSQLDB. HSQLDB wouldn't be removed, because it is better integrated into LO Base as Firebird. For creating a database as internal Firebird database you have to set the experimental mode "on". You could set it "off" afterwards, when Firebird database file has been created. (b) is JRE still needed (is it needed for the reports?) -- if so what is the exact name of the JRE-version to be downloaded & installed -- are there anything special to know when installing JRE Depend on the system you are using. Using Mac you could get some problems: https://ask.libreoffice.org/t/m1-macos-monterrey-12-2-1-java-se-17-libreoffice-7-3-0-3-not-using-the-java-installed/74683 (c) any advice regarding installing & using the ’modern’ LOBase? If you have used LO Base before and also used the Report Builder have a look at the installed extension. Reports would fail if you have installed the old extension, because LO has included ReportBuilder since LO 4.1 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] Java
Hi Joe, What is the correct procedure to install java so that LibreOffice can recognize and use it. UBUNTU 22.04LTS, LibreOffice Community 7.3.7.2 I havn't installed Ubuntu before. But for testing a server I installed UBUNTU 22.04 on an old notebook. It installed LibreOffice complete, together with Base. And Base could start, a table could be created in internal HSQLDB. This is the Java version it will show: Ubuntu 11.0.17 saved at /usr/lib/jvm/java-11-openjdk-amd64 Might be this is the way to get it separate: sudo apt update sudo apt install default-jre 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] Writer doc not going back to where I exited
Hi Chuck, have described this in https://bugs.documentfoundation.org/show_bug.cgi?id=152207 Will be fixed in LO 7.5, don't know if there is a backport to older versions of 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] LO data wizzard
Hi Dave, I was trying to use mail merge in LO. The documentation (7.1, but I have 7.4) has some errors/omissions. Which documentation did you use exactly? And, if using LO 7.4 - isn't there a newer documentation available as documentation for LO 7.1? https://documentation.libreoffice.org/en/english-documentation/ - Step 6. The text says to click Finish once the connection is tested. Actually, you need to select the correct sheet prior to Finish. Sometimes there will be more than one sheet with addresses. This won't appear if there is only on sheet. You need to select it if there are more sheets. Could be you are missing this hint? - Step 10. "Click Finish. The data source is now registered." I get an error that says the file already exists - overwrite it? There is already registered a database with the name you have choosen. Could be you are running through the process a second time. Look at Tools → Options → LibreOffice Base → Databases Default for a database for addresses is "Addresses". Default name of this database is "Addresses.odb", which might be created in your document directory. Clicking Help gets another error saying the page does not exist. So, what do I do here??? File a bug if there is a buttonb vor "Help" and no help is available. 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] File conversion issue
Hi Shiva Prasad, Recently, some .docx files are failing to convert to .pdf. Might be there are special formating in these *.docx, which aren't available in OpenDocument format. Something like this: https://bugs.documentfoundation.org/show_bug.cgi?id=143311 Have a look at https://bugs.documentfoundation.org for special bugs with *.pdf filter and printing. 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] Writer doc not going back to where I exited
Reported this bug: https://bugs.documentfoundation.org/show_bug.cgi?id=152207 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] Writer doc not going back to where I exited
One more hint: Created a small document with default "Lore Impsum" and images. If there are many images Writer won't find the right position inside the text again if it is at the end of the document and sets the cursor at the start of the text. Seems it runs like: Load text, goto page - oh, the page isn't there, so go to start. After cursor has been set the images will be loaded and the page will be there … I will report a bug for this. 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] Writer doc not going back to where I exited
Hi Tim, My writer document is not opening in the place I exited. Any ideas how to return to the same place? Did you include images? Are there images with bigger width than the width for the content (page-width - marin left and margin right)? Dtected this in a document: Changing content at pages before I included images with bigger width han the content allows - save, close and reopen: I got the right place for the cursor. Canging content after included images, save close and reopen: Document will show the cursor at start of the document, couldn't find last place. 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] Export to PDF Failure
Hi *, no problem to export to *.pdf with Version: 7.4.2.3 / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf 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 here. I would test with → new user profile (renaming home/user/.config/libreoffice/4 to /4old) → Reinstalling package for filters (but don't know in which package this filter has been stored) 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] Query about privacy
Hi Jodi, Hi Libre team you are writing to a mailinglist where users try to solve problems for users. I’m based in Australia and looking to use your office products. I wanted to know if the content of what is typed in your word processing document or spreadsheet document is something that can be seen by your system or third parties if I am using your desktop versions or online versions of your products? You are using your desktop versions only on desktop. There are some functions, which will use the contact to www, if you will allow this. Tools → Options → LibreOffice → General: "Send crash reports to The Document Foundation" Tools → Options → LibreOffice → Security options and warnings (a comlete dialog appears here) Tools → Options → LibreOffice → Online Update If you are using a cloud for your documents the cloud has nothing to do with LibreOffice. If you are using a product like Collabora Office, which could work also as online version, you will install this office on a server you want. There is no server, which is hosted from The Document Foundation for online office. 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] Java JRE not found on mac
Hi Simone, here two links with different solutions on the same platform you mentioned: https://ask.libreoffice.org/t/base-issue-no-java-installation-could-be-found/77351 https://ask.libreoffice.org/t/libreoffice-requires-oracles-jdk-on-mac-os-x/43388 There seems to be also special problems with LibreOffice from AppStore: https://bugs.documentfoundation.org/show_bug.cgi?id=151250 … and others 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] for a given odt, insert new text always in red (corrections)
Hi Uwe, Edit → Track Changes → Record Edit → Track Changes → Show Tools → Options → LibreOffice Writer → Changes → Insertions here switch to Attributes → [None] Color → Red Thanks for your answer. The only problem with this approach, is if I want to delete something. I understand that according to the logic of recorded changes, a deletion must be displayed. However in my workflow, I would like just silently delete text. I can set deleted text to a white font, but then a gap in the text would appear. You could delete text press DEL. Then right mouseclick and "Accept change". 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] for a given odt, insert new text always in red (corrections)
Hi Uwe, I would do it this way: Edit → Track Changes → Record Edit → Track Changes → Show Tools → Options → LibreOffice Writer → Changes → Insertions here switch to Attributes → [None] Color → Red 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] recurring error message
Hi Dirk, attachments will be cut off here. So you have to copy the content of the message. Or use https://ask.libreoffice.org/tag/base instead. 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]
Hi John, That said, I can't say that I've noticed the change. Was this a change? If so, at what point? If we know that, the most useful place to start is probably with the release notes. Has been in edit-menue of Writer also in older versions. Opend LO 6.1.5.2 and it is already part of edit-menue. 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] certificate undetect
Hi *, only copied from LO hel: Choose Tools - Options - LibreOffice - Security and, in the Certificate Path area, click Certificate. 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
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
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 Views and Queries
Hi John, ... MySQL/MariaDB with different drivers will be a new thread - or shouldn't we try it per private mail? ... Robert, I have only been following this thread as a lurker, not contributor, but if I may offer a view on that question: I'm surely not the only person finding this thread educational, and do not see this latest turn as off-topic. However, whether or not you find it appropriate to start a new thread, I do hope you will continue on-list. You are doing the world a service. … and I thought: Base - not much people are interested. In a mailinglist I'm missing the possibility to sort the mails by groups, to see something in screenshots. Better solution for this is something like https://ask.libreoffice.org/tag/base If there is any question related to Base I will (try to) answer also on this mailinglist. 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 Harvey, MySQL/MariaDB with different drivers will be a new thread - or shouldn't we try it per private mail? Which connector do you use? (MySQL or MariaDB? If MySQL: which version?) 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 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
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 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 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
Re: [libreoffice-users] Calculated values in View or Query
Hi Harvey, 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!! And all this translated from German Base Handbuch into English. I take this as special compliment. 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 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 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
Re: [libreoffice-users] export data from Calc, import to Base
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
Re: [libreoffice-users] Mysterious line-spacing
Hi Séamas, (Strangely, there’s an option within the style definition of “Don’t add space between paragraphs of the same style.” Why there should be an option of *not* doing something so unorthodox is another mystery; however, it also has no effect.) I use exactly this option to document code together with numbering like "001", "002" and grey background. So I (with the same style) spacing when starting the code and endig the code, but not during paragraphs inside the code. Sometimes there appears also a very thin line between the code-numbers. But I don't think this it what you have detected. Could you upload a screenshot somewhere? 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] no emails for comments and adding attachments on bugzilla, normal?
Hi Vani, last action for bug 131512 was: You have set yourself to cc and have written some comments. You won't get a mail for your own comments. If there will anybody add a comment you will get a mail with the content. 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] no emails for comments and adding attachments on bugzilla, normal?
Hi vani, why i am not receiving emails for my comments and adding of attachments on bugzilla. i could not find mailing list also. You have subscribed to bugzilla with a mail address. You will get all comments to a bug if you reported the bug or set yourself to cc. Could you post the bug number here? 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] output formats.
Hi Chris, For master documents: File → Export could give a *.odt-Document Save the file this way, reopen it and save it again in *.docx. I would prefer to export to *.pdf. No problems here since a long time with German Base Handbuch: 13 chapters, all the same styles. Export this very often when publishing of next version will arrive. 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] Right Mouse Click Problem
Thanks Robert. Obviously you are more skilled at searching Bugzilla than I am. Have only had a look at Bugs reported in last 7 days (after searching for menue …). So a little bit luck … 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] Right Mouse Click Problem
Seems to be this bug: https://bugs.documentfoundation.org/show_bug.cgi?id=149537 with many duplicates, -- 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] Right Mouse Click Problem
Hi *, Is anyone else experiencing this issue or have I missed something? Version: 7.4.0.0.beta1 (x64) / LibreOffice Community Build ID: cec1fe9b57a55c032f9f118c907f34e22a63d040 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-GB Calc: CL Same issue here with OpenSUSE 15.3 and LO 7.4.0.0.beta1. No contextmenue available - nothing happens with right mouse click. Have deleted ./config/libreofficedev/4 but nothing has been changed. Don't see any bugdescription for this. 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] What about "(web)" in title of writer window?
Hi Walther, Why is "(web)" added to the writer title like "foo (web) - LibreOffice Writer" ? Have tried it here with the same old version you are using, but packages from LO directly (not from Linux distribution). Don't get '(web)' there. Did you open the file from a server? 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] Connecting Document to Database
Hi Keith, I am having a problem with a form for a database that I constructed without the help of the form wizard, many years ago. I know that I have to link or connect the form to the database but I can't find out how to do it. It is a standalone form, isn't it? Database is an internal database (only a file *.odb)? Have a look for the Base file (*.odb). Go to Tools → Options → LibreOffice Base → Databases and register the 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
Re: [libreoffice-users] Existing Base Report now opens with error
Hy Harvey, 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? I'm working with LO 7.3.3.2 here, but have also installed many older versions. LO 7.2.7 will do the same. If you have created reports, which will use charts, the next version LO 7.4 would be your favorite. Charts won't be shown since a longer time in reports. No this bug has been fixed for LO 7.4 … The packaging-bugs of distribution versions won't be automatically switched to the bugdescrition from the distributions. Many years ago I posted also some bugs to OpenSUSE, but then I changed permanently to the packages directly from LO. Don't know why the same bug appears in 3 distributions, but doesen't appear in the original packages. 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
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] Vulnerability report
Hi Min Di, I found a vulnerability and I want to know if I should send you the vulnerability report through the website or through a special bug bounty platform? I would prefer to write a bug description at https://bugs.documentfoundation.org/ 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] Off Line Help Installation
Hi Joe, file:///opt/libreoffice7.3/help/en-GB/text/shared/05/new_help.html?System=UNIX=WRITER=.uno:HelpIndex#bm_id3806162 My guess is that you installed LibreOffice from an Ubuntu repository, rather than the original libreoffice download site. /tmp is a particularly stupid location - the clue is in the name. It's temporary. I downloaded the help file from LibreOffice.org. Joe Hope not only the help file but both: The whole LO from LibreOffice.org and not a part form Ubuntu and another part of LibreOffice.org. So please have a look at file:///opt/libreoffice7.3/help ist there exist any help. Then only the link is wrong. And the link will be set from the main program. 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
