Re: [libreoffice-users] libre office base report problem
Hi Hanspeter, I experienced tha same; I am missing the Report Navigator to change the query linked to the report. Ubuntu 24.04.1 LTS with LO 24.2.5.2 I tried this: Opened a report for editing in Version: 24.2.5.2 (X86_64) / LibreOffice Community Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59 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 Report navigator appears as an icon and also in menue (View → Report navigator) Do you use the packaged from LO or packages directly from you Linux distribution? 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 base report problem
Hi Shrikant, I am, using libre office Base I have created report using report designing The problem is no changes are accepted After saving this report when i open this showing no changes What version of LO do you use? What did you try to 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] Page numbers (sigh)
Hi Chris, At the moment, my page numbers in the upper right hand corned of the header literally say "Page number". I have no idea where that came from. Te digits are gone. Uncheck "View → Field Names" (Ctrl+F9)> Also, somewhere along the line the page numbers, before they vanished, began to count by twos from the first page, i.e. 1, 3, 5, 7, and now I have half as many pages as I thought I had. Seems you have changed the page type to only left pages: Change Page Style → Page → Layout Settings → Page Layout → Right and Left 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] Different character spacing on different PCs in writer.
Hi Steve, only a question about the two Linux-configurations: Do you use LO from repositories of OpenSUSE or from LibreOffice directly? Do you use different window manager like kde or gtk? Using the same version of OpenSUSE 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] Comment field feature request in LO Base GUI
Hi Harvey, Does my suggestion count as a bug, our rather something else, e.g. feature request? Feature request could be set in the importance of the bug. It is sommething like the lowest importance. Write the bug, post the link to the bug and I could set it as feature request. Add an example which show where to add 'Document Information' for a form or a report. 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] Comment field feature request in LO Base GUI
Hi Harvey, One aspect of working with LOBase is the error proneness of keeping track of, beyond the use of intelligent names, what individual Queries/Views/Tables are used for. Was it ever considered (and rejected?) to extend the 'Document Information' feature to Queries and Tables, similar to that for Forms and Reports, but more in the sense of an editable comment field? Write an enhacement request at https://bugs.documentfoundation.org/ So we won't forget it. But at this moment this has never been planned. I write a documentation for every database I'm creating. There also exists the BaseDocumenter Extension. 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] Version of Libreoffice has a wrong number?
Hi Jarek, Hello Libreoffice users, I have LibreOffice version 24.25 installed. There doesen't exist any version like this. 24 → Year 2024 2 → Month 2 (February) So the version will have 24.2.5.2, the 5th bug fixe release of version 24.2 wonder why I get version 24.2.12 when I start. Also this Information can't be right. 24.2 will work well, but there isn't any version with 12 bug fix releases in LO. Linit for nearly all versions will be 7. Please open you installed LO, go to Tools → Help → About LibreOffice There you could copy the version information an post it here Version: 24.2.5.2 (X86_64) / LibreOffice Community Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59 CPU threads: 6; OS: Linux 6.4; 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] Data base problem
Hi Peter, which kind of database engine do you use for "Financial"? Seems it uses a JDBC-connection. Do you use internal HSQLDB or do you try to connect to something like an external database (MySQL/MariaDB for example)? 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] Libreoffice F1 Help function
Hi Harvey, I tried that (from OpenSUSE) with no success. Help files are part of libreoffice-l10n-en or other local packages in OpenSUSE. By the way, I assume your wonderful Base Handbook is still at V7.4. Right? German version if for LO 24.2. I will update to LO 24.8 in next weeks, but there are not so much added contents yet. English translationis from a very old version of Base Handbuch. Might be about LO 6.0 … German Base Handbuch has about 720 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] Libreoffice F1 Help function
Hi Harvey, what should I do to recover the missing index.html file? Try to reinstall the Help of LO. There should be a comnplete help in /usr/share/libreoffice/help and it is linked to /usr/lib64/libreoffice/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: [libreoffice-users] Libreoffice F1 Help function
Hi Harvey, Other files/directories are there. However. Are they complete? Could this be an integration error in the OpenSUSE Leap 156 repo? Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 2; OS: Linux 6.4; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded Same version here with same SUSE-version. No problem to start help from LibreOffice 24.2.4.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] Help with failing AutoValue increment in LO Base table
Am 20.07.24 um 08:16 schrieb Robert Großkopf: Hi Harvey, I don't have mariadb installed on my desktop (which is LOBase client connectect via ethernet (hone zone) to mariadb on NAS sever) There shouldn't be any difference between MariaDB on a Linux sytem connected through localhost or connected from another system in your local network. How did you create the connection to MariaDB to JDBC? I could reproduce the behavior when I don't use the connection through the MySQL/MariaDB-wizard but through JDBC direct. I don't know how to get the right code for Base to set autoincremented value through the GUI here at this moment. Seems it must be set in the properties for incremented values… Got it: Go to Edit → Database → Advanced Settings → Generated values Retrieve Generated Values → checked Auto-increment Statement: AUTO_INCREMENT Query of genetated vales doesn't need an entry. 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] Help with failing AutoValue increment in LO Base table
Hi Harvey, I don't have mariadb installed on my desktop (which is LOBase client connectect via ethernet (hone zone) to mariadb on NAS sever) There shouldn't be any difference between MariaDB on a Linux sytem connected through localhost or connected from another system in your local network. How did you create the connection to MariaDB to JDBC? I could reproduce the behavior when I don't use the connection through the MySQL/MariaDB-wizard but through JDBC direct. I don't know how to get the right code for Base to set autoincremented value through the GUI here at this moment. Seems it must be set in the properties for incremented values… 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] Help with failing AutoValue increment in LO Base table
Hi Harvey, tested with LO 24.2.5.2 and MariaDB on OpenSUSE 15.6 64bit rpm Linux. Works well with internal driver, also with JDBC (mariadb-java-client 3.1.3) Its the same behavior with special version LO 24.2.4.2 fronm OpenSUSE you use. Note: A funny bug appears: The wizard (JDBC-connection) also offers "AutoValue" when the content of the field is VARCHAR. 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] Version 25.2 is strange
Hi Fred, I belibve he said something like ... "Hello Libreoffice users, I have version 22.5.2 installed. However, when I run it from the desktop, it says Libreoffice 24.2.12. Why is that so? Best regards -- Jarek" Regards Fred James … and both versions have never existed and will never exist. 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] Deleting a Date in a png in Libre Draw
Hi Charles, So, I opened Libre Draw, search the 392 page User Guide but when I place the cursor on the PNG in Draw I just get these crosshairs. How can I get rid of the crosshairs and instead highlight the date and delete that date? Draw is for vectror graphics, not for pixels. You have to use GIMP or something like this to remove content from the png. 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] Forms
Hi Peter, open the form for editing, not for input data. Click on a field of the form. Right mouseclick → Form properties → Data Choose the new table. Save the form. 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] Open form from button
Hi Edwin, Is it possible to open to put a button in a form to open a different form from a linked field? One possibility: Create a table "tbl_Filter". Might be you are already using such a table for only one row. This table should contain a field like "Plant_ID". So you could save the identifier for the plant in this table. Open the new form, which depends on a query like this: SELECT * FROM "MyTable" WHERE "ID" = (SELECT "Plant_ID" FROM "tbl_Filter") Might be a macro like this helps: SUB OpenFormPlant(oEvent AS OBJECT) oForm = oEvent.Source.Model.Parent IF hasUnoInterfaces(oForm, "com.sun.star.form.XForm" ) THEN stID = oForm.getString(oForm.FindColumn("ID")) oConnection = oForm.activeConnection() oSQL_Statement = oConnection.createStatement() stSql = "UPDATE ""tbl_Filter"" SET ""Plant_ID"" = '"+stID+"'" oSQL_Statement.executeUpdate(stSql) ThisDatabaseDocument.FormDocuments.getByName("frm_PropagatingPlant").open END IF END SUB 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] LOBase reports fail
Hi Harvey, Great stuff. Thanks. You are sooo helpful.:-) Do you mean to move all the individual 46 rpm files tor the my_rpms repo, or the 3 rpm folders? Or does it not matter? All 46 rpm filses should be in folder. But seems you have solved that. 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] LOBase reports fail
Hi Harvey, download the three packages from LO: one for main program, one for language and one for help. Unzip this packages in a folder. Create a folder "my_rpms" in you home directory for the *.rpm-files. Move all rpm-files from the unzipped packages to "my_rpms". Start Yast. Start Software-Repositories Add "my_rpms" as a repository, folder only without description … Start "Install Software" Unistall all the LibreOffice installations, which appear in Yast. Chose the new version from the new "repository" (your folder). Install and ignore the warnings "files might be corrupt". It always apperas for every file in this folder. 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] LOBase reports fail
Hi Harvey, LibreOffice Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 2; OS: Linux 6.4; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded Seems many LO version packed by a Linux distribution will fail to execute any report. Don't know why. Please install the original from LibreOffice. It 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
[libreoffice-users] Re: LOBase reports fail
Hi Harvey, LibreOffice Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 2; OS: Linux 6.4; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded Please install LibreOffice directly from LibreOffice. Not only the packages from OpenSUSE, also the packages from Ubuntu won't show a report. 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 descriptions not retained
Hi Thomas, easiest way is to insert the images into Writer. You could edit this images with an external tool when inserted into Writer - no problem. Linked images I would add in a subfolder of the Writer Document. So you could move the Writer document together with the subfolder to any other place and the links will work well (relative links). 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] calc: all links broken in existing spreadsheet
Hi Tom, I just upgraded to: Version: 7.6.7.2 (X86_64) / LibreOffice Community Build ID: 60(Build:2) CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 4:7.6.7-0ubuntu0.23.10.1~bpo22.04.1 Calc: threaded From which version did you "upgrade". All links in my major daily planner spreadsheet are now broken. Does appear any tooltip if you move the mouse over a link? Something like [Ctrl+Click]? Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Using Libre Office and Evolution to mail merge contacts
Hi Johnp, I am having trouble finding the EvolutionLocal in the exchange database. Any suggestions would be appreciated. Just openes LO 24.2.3.2 in OpenSUSE 64bit rpm Linux. No problem to get an entry for Evolution local. Which system and which version of LO do you use. Mine: Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba 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 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, again
Hi Thomas, Heading 1 + Heading 2 properly set, as far as I can tell. Tools -> Heading numbering set properly (I hope). Still, inserting a TOC that is supposed to show Heading 1 + 2 includes EVERY paragraph of the entire document. Set some paragraphs to "Heading1" and "Heading2". Other paragraphs are "TextBody". Set numbering for the headings as decribed above. Created a TOC. Couldn't see any other content than Heading1 and Heading2 in Toc. I don't know what is gowing wrong with your document. Using LO 24.2.3.2 on OpenSUSE 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] 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