Re: [libreoffice-users] Column/Row highlighting

2024-05-15 Thread Robert Großkopf
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

Re: [libreoffice-users] Column/Row highlighting

2024-05-15 Thread Robert Großkopf
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

Re: [libreoffice-users] imported styles changed alignment

2024-05-14 Thread Robert Großkopf
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

Re: [libreoffice-users] Table Of Contents

2024-05-09 Thread Robert Großkopf
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

Re: [libreoffice-users] Feature Request

2024-05-03 Thread Robert Großkopf
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

Re: [libreoffice-users] Libre shouldn't warn during saving in doc

2024-04-18 Thread Robert Großkopf
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

Re: [libreoffice-users] AltSearch extension no longer listed

2024-04-15 Thread Robert Großkopf
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: h

Re: [libreoffice-users] Cancel

2024-04-15 Thread Robert Großkopf
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?

Re: [libreoffice-users] Frustration!

2024-04-05 Thread Robert Großkopf
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:

Re: [libreoffice-users] Base macros

2024-03-28 Thread Robert Großkopf
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

Re: [libreoffice-users] Libre Office bugs (Windows 10 pro PC)

2024-03-26 Thread Robert Großkopf
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:

Re: [libreoffice-users] Base macros

2024-03-26 Thread Robert Großkopf
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

Re: [libreoffice-users] Base macros

2024-03-25 Thread Robert Großkopf
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?

Re: [libreoffice-users] Base macros

2024-03-25 Thread Robert Großkopf
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

Re: [libreoffice-users] Emailing calc spreadsheet

2024-03-20 Thread Robert Großkopf
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

Re: [libreoffice-users] Creating forms with math

2024-03-13 Thread Robert Großkopf
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:

Re: [libreoffice-users] paragraph style

2024-03-06 Thread Robert Großkopf
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

Re: [libreoffice-users] Saving an odm as a docx in editable form.

2024-03-04 Thread Robert Großkopf
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

Re: [libreoffice-users] Saving an odm as a docx in editable form.

2024-03-02 Thread Robert Großkopf
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

Re: [libreoffice-users] Writer form design grid

2024-02-15 Thread Robert Großkopf
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

Re: [libreoffice-users] Writer form design grid

2024-02-11 Thread Robert Großkopf
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:

Re: [libreoffice-users] pdf forms (OT?)

2024-02-09 Thread Robert Großkopf
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)

Re: [libreoffice-users] Default Images Path

2024-01-27 Thread Robert Großkopf
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

Re: [libreoffice-users] Master document and styles.

2024-01-14 Thread Robert Großkopf
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.

Re: [libreoffice-users] Master document, internal link between documents and pdf

2024-01-14 Thread Robert Großkopf
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?

Re: [libreoffice-users] Master document, internal link between documents and pdf

2024-01-13 Thread Robert Großkopf
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

Re: [libreoffice-users] Lost Ability To Open Hybrid PDF in Writer

2024-01-01 Thread Robert Großkopf
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:

Re: [libreoffice-users] Lost Ability To Open Hybrid PDF in Writer

2024-01-01 Thread Robert Großkopf
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:

Re: [libreoffice-users] Min. skills for Base

2024-01-01 Thread Robert Großkopf
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

Re: [libreoffice-users] Min. skills for Base

2023-12-31 Thread Robert Großkopf
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

Re: [libreoffice-users] Base report text fields of variable size

2023-11-21 Thread Robert Großkopf
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

Re: [libreoffice-users] Address Book Conundrum

2023-09-11 Thread Robert Großkopf
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

Re: [libreoffice-users] can anybody hear??

2023-09-04 Thread Robert Großkopf
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

Re: [libreoffice-users] problems on Ubuntu

2023-09-03 Thread Robert Großkopf
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

Re: (unresolved) Re: [libreoffice-users] weirdness in save dialogue box

2023-08-25 Thread Robert Großkopf
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?

Re: [libreoffice-users] dbind-WARNING message.

2023-08-24 Thread Robert Großkopf
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

Re: [libreoffice-users] alter appearnce hypertext

2023-08-20 Thread Robert Großkopf
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

Re: [libreoffice-users] Header and footer

2023-07-27 Thread Robert Großkopf
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

Re: [libreoffice-users] Documentation of LibreOffice

2023-07-22 Thread Robert Großkopf
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.

Re: [libreoffice-users] Split window on top of each other in Word 07-2003 from LibreOffice

2023-07-16 Thread Robert Großkopf
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

Re: [libreoffice-users] Image Anchor Selection

2023-06-14 Thread Robert Großkopf
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

Re: [libreoffice-users] Image Anchor Selection

2023-06-07 Thread Robert Großkopf
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"

Re: [libreoffice-users] Failed connection to MySQL database

2023-05-23 Thread Robert Großkopf
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:

Re: [libreoffice-users] Failed connection to MySQL database

2023-05-23 Thread Robert Großkopf
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

Re: [libreoffice-users] MariaDB Connector Question

2023-05-22 Thread Robert Großkopf
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

Re: [libreoffice-users] Mail Merge Label Problem

2023-04-12 Thread Robert Großkopf
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

Re: [libreoffice-users] Actual bug report.

2023-04-10 Thread Robert Großkopf
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

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.

2023-04-07 Thread Robert Großkopf
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:

Re: [libreoffice-users] Office doesn't handle its own graphics?

2023-03-15 Thread Robert Großkopf
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

Re: [libreoffice-users] Need help with LOBase

2023-02-19 Thread Robert Großkopf
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

Re: [libreoffice-users] Entering special characters in a form in Base

2023-02-15 Thread Robert Großkopf
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

Re: [libreoffice-users] Basic Macros with Base

2023-01-26 Thread Robert Großkopf
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

Re: [libreoffice-users] Basic Macros with Base

2023-01-26 Thread Robert Großkopf
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:

Re: [libreoffice-users] Basic Macros with Base

2023-01-25 Thread Robert Großkopf
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

Re: [libreoffice-users] Basic Macros with Base

2023-01-24 Thread Robert Großkopf
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 =

Re: [libreoffice-users] Questions about LOBase

2023-01-20 Thread Robert Großkopf
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

Re: [libreoffice-users] Java

2022-12-20 Thread Robert Großkopf
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,

Re: [libreoffice-users] Writer doc not going back to where I exited

2022-12-16 Thread Robert Großkopf
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:

Re: [libreoffice-users] LO data wizzard

2022-11-29 Thread Robert Großkopf
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?

Re: [libreoffice-users] File conversion issue

2022-11-29 Thread Robert Großkopf
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

Re: [libreoffice-users] Writer doc not going back to where I exited

2022-11-25 Thread Robert Großkopf
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?

Re: [libreoffice-users] Writer doc not going back to where I exited

2022-11-24 Thread Robert Großkopf
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,

Re: [libreoffice-users] Writer doc not going back to where I exited

2022-11-24 Thread Robert Großkopf
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

Re: [libreoffice-users] Export to PDF Failure

2022-11-13 Thread Robert Großkopf
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

Re: [libreoffice-users] Query about privacy

2022-11-05 Thread Robert Großkopf
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

Re: [libreoffice-users] Java JRE not found on mac

2022-10-24 Thread Robert Großkopf
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

Re: [libreoffice-users] for a given odt, insert new text always in red (corrections)

2022-10-22 Thread Robert Großkopf
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

Re: [libreoffice-users] for a given odt, insert new text always in red (corrections)

2022-10-21 Thread Robert Großkopf
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

Re: [libreoffice-users] recurring error message

2022-10-09 Thread Robert Großkopf
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?

Re: [libreoffice-users]

2022-09-21 Thread Robert Großkopf
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

Re: [libreoffice-users] certificate undetect

2022-09-06 Thread Robert Großkopf
Hi *, only copied from LO hel: Choose Tools - Options - LibreOffice - Security and, in the Certificate Path area, click Certificate. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] LO Base Query - 'count' function behaviour

2022-08-16 Thread Robert Großkopf
Hi Harvey, tested this: SELECT COALESCE ( `User`, 'Empty' ) AS `User`, COUNT( `ID` ) FROM `test`.`User` AS `User` GROUP BY `User` You don't need to change the alias for `Location` to `Loc`. I could save this, open this to edit in GUI, execute it - no Problem with direct connection on

Re: [libreoffice-users] LO Base Query - 'count' function behaviour

2022-08-16 Thread Robert Großkopf
Hi Harvey, SELECT `Location`, COUNT( `Location` ) FROM `Item_Management`.`Items` `Items` GROUP BY `Location` The result is correct for all LOCATIONS that are not empty, but surpisingly the blank field for the empty locations is accompanied by the value 0. How can I get the right count for

Re: [libreoffice-users] LO Base Views and Queries

2022-08-13 Thread Robert Großkopf
Hi John, ... MySQL/MariaDB with different drivers will be a new thread - or shouldn't we try it per private mail? ... Robert, I have only been following this thread as a lurker, not contributor, but if I may offer a view on that question: I'm surely not the only person finding this thread

Re: [libreoffice-users] LO Base Views and Queries

2022-08-12 Thread Robert Großkopf
Hi Harvey, MySQL/MariaDB with different drivers will be a new thread - or shouldn't we try it per private mail? Which connector do you use? (MySQL or MariaDB? If MySQL: which version?) Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to:

Re: [libreoffice-users] LO Base Views and Queries

2022-08-12 Thread Robert Großkopf
Hi Harvey, OK. Thanks, Robert. That is more or less the conclusion that I had come to. Not very user-friendly, but it works. Reason for this behavior might be you are using a server database for many users. Have had a look with PHPMyAdmin. Couldn't edit the view there also. Regards

Re: [libreoffice-users] LO Base Views and Queries

2022-08-12 Thread Robert Großkopf
Hi Harvey, I cannot confirm the Firebird icon. My database backend is MySQL(JDBC), (actually Mariadb). I prefer to continue for the time being with the OpenSUSE packages delivered with my Linux Leap 15.4. Editing views with external databases won't work. It's the same behavior for every

Re: [libreoffice-users] LO Base Views and Queries

2022-08-11 Thread Robert Großkopf
Hi Harvey, LO won't be installed without internal HSQLDB. But with that behavior you reported you are using internal Firebird. Will be shown at the bottom of the window in statusbar. You are using packages from your distribution, not from LO directly. Have tested the same version you are

Re: [libreoffice-users] LO Base Views and Queries

2022-08-11 Thread Robert Großkopf
Hi Harvey, I'm unsure of the practical implications of the difference between Base implementation of Views and Queries. Perhaps someone can enlighten me. One thing, however, does hit me. Views will be executed in the database. The content will look for Base like a non-writable table. You

Re: [libreoffice-users] Calculated values in View or Query

2022-08-10 Thread Robert Großkopf
Hi Harvey, The Base Guide answers my question precisely, listing as it does the built-in functions together with a remark in each case "[Works in the GUI]" - or not (e.g. CASE) Great stuff!! And all this translated from German Base Handbuch into English. I take this as special compliment.

Re: [libreoffice-users] Calculated values in View or Query

2022-08-10 Thread Robert Großkopf
Hi Harvey, most SQL code I create direcly without using GUI, so I don't know if all of this could also be created through GUI. Have a look at the Base Guide https://nextcloud.documentfoundation.org/s/qjFkGwpEEkNrt6f. The GUI has been created to work perfect with internal HSQLDB (very old…),

Re: [libreoffice-users] Calculated values in View or Query

2022-08-10 Thread Robert Großkopf
Hi Harvey, For example, I would like to extract a text string from a field in each record and display it in an extra view and/or query field, or multiply two field values and record the result in an extra field. A little example will help: What is the content of the field in tehe table, whot

Re: [libreoffice-users] export data from Calc, import to Base

2022-08-08 Thread Robert Großkopf
Hi Harvey, mark the content. Copy it to clipboard. Go to the database file and open the tables pane. Right mousclick → insert. Choose the table where to append the data to, choose the column in the wizard and it will be done. You won't need a *.csv-file and phpMyAdmin to do this the same

Re: [libreoffice-users] Mysterious line-spacing

2022-07-22 Thread Robert Großkopf
Hi Séamas, (Strangely, there’s an option within the style definition of “Don’t add space between paragraphs of the same style.” Why there should be an option of *not* doing something so unorthodox is another mystery; however, it also has no effect.) I use exactly this option to document code

Re: [libreoffice-users] no emails for comments and adding attachments on bugzilla, normal?

2022-07-20 Thread Robert Großkopf
Hi Vani, last action for bug 131512 was: You have set yourself to cc and have written some comments. You won't get a mail for your own comments. If there will anybody add a comment you will get a mail with the content. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert --

Re: [libreoffice-users] no emails for comments and adding attachments on bugzilla, normal?

2022-07-20 Thread Robert Großkopf
Hi vani, why i am not receiving emails for my comments and adding of attachments on bugzilla. i could not find mailing list also. You have subscribed to bugzilla with a mail address. You will get all comments to a bug if you reported the bug or set yourself to cc. Could you post the bug

Re: [libreoffice-users] output formats.

2022-06-27 Thread Robert Großkopf
Hi Chris, For master documents: File → Export could give a *.odt-Document Save the file this way, reopen it and save it again in *.docx. I would prefer to export to *.pdf. No problems here since a long time with German Base Handbuch: 13 chapters, all the same styles. Export this very often

Re: [libreoffice-users] Right Mouse Click Problem

2022-06-27 Thread Robert Großkopf
Thanks Robert. Obviously you are more skilled at searching Bugzilla than I am. Have only had a look at Bugs reported in last 7 days (after searching for menue …). So a little bit luck … Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to:

Re: [libreoffice-users] Right Mouse Click Problem

2022-06-27 Thread Robert Großkopf
Seems to be this bug: https://bugs.documentfoundation.org/show_bug.cgi?id=149537 with many duplicates, -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Right Mouse Click Problem

2022-06-27 Thread Robert Großkopf
Hi *, Is anyone else experiencing this issue or have I missed something? Version: 7.4.0.0.beta1 (x64) / LibreOffice Community Build ID: cec1fe9b57a55c032f9f118c907f34e22a63d040 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-GB Calc:

Re: [libreoffice-users] What about "(web)" in title of writer window?

2022-05-31 Thread Robert Großkopf
Hi Walther, Why is "(web)" added to the writer title like "foo (web) - LibreOffice Writer" ? Have tried it here with the same old version you are using, but packages from LO directly (not from Linux distribution). Don't get '(web)' there. Did you open the file from a server? Regards

Re: [libreoffice-users] Connecting Document to Database

2022-05-29 Thread Robert Großkopf
Hi Keith, I am having a problem with a form for a database that I constructed without the help of the form wizard, many years ago. I know that I have to link or connect the form to the database but I can't find out how to do it. It is a standalone form, isn't it? Database is an internal

Re: [libreoffice-users] Existing Base Report now opens with error

2022-05-20 Thread Robert Großkopf
Hy Harvey, I see that the rpm Version on the LO site is up to 7.2.7, or even 7.3.3. Can I take either as is? I'm working with LO 7.3.3.2 here, but have also installed many older versions. LO 7.2.7 will do the same. If you have created reports, which will use charts, the next version LO 7.4

Re: [libreoffice-users] Existing Base Report now opens with error

2022-05-20 Thread Robert Großkopf
Hi Harvey, I am using LO on OpenSUSE Linux Leap 15.3 Version: 7.2.5.1 / LibreOffice Community Build ID: 20(Build:1) CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded This is a special bug of OpenSUSE build:

Re: [libreoffice-users] Vulnerability report

2022-04-21 Thread Robert Großkopf
Hi Min Di, I found a vulnerability and I want to know if I should send you the vulnerability report through the website or through a special bug bounty platform? I would prefer to write a bug description at https://bugs.documentfoundation.org/ Regards Robert -- Homepage:

Re: [libreoffice-users] Off Line Help Installation

2022-03-22 Thread Robert Großkopf
Hi Joe, file:///opt/libreoffice7.3/help/en-GB/text/shared/05/new_help.html?System=UNIX=WRITER=.uno:HelpIndex#bm_id3806162 My guess is that you installed LibreOffice from an Ubuntu repository, rather than the original libreoffice download site. /tmp is a particularly stupid location - the

Re: [libreoffice-users] Off Line Help Installation

2022-03-20 Thread Robert Großkopf
Hi Paolo, Hi.   Yes, I can confirm. I have LO  7.3.0.3  on ubuntu 20.04.   When I press  F1,  it opens a browser  with address: file:///tmp/lu18302293odos5.tmp/NewHelp0.html and says  'file not found'. This is a totally wron path. Have a look for your LibreOffice program installation. here

Re: [libreoffice-users] Off Line Help Installation

2022-03-20 Thread Robert Großkopf
Hi Joe, could be you didn't see it is the offline help you are using. The browser will be opened and there should appear as address something beginning with "file:///…" This is the current offline help. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe

Re: [libreoffice-users] Import script problems

2022-03-03 Thread Robert Großkopf
Hi Dan, PERFORM IMPORT SCRIPT DATA FROM 'Main-subform.cvs' STOP ON ERROR; CHECKPOINT; This seems to be the right path: "You can specify the ACL file path with an absolute or relative path. If you use a relative path, it must be relative to the .properties file." (p 310 of User Guide HSQLDB

Re: [libreoffice-users] Security at Libre Office

2022-02-24 Thread Robert Großkopf
Hi Anna, I am looking to replace our Access Database. How is your security at LibreOffice? The internal databases of LibreOffice are not protected. You could use the database file if the system allows to use this file. And if you use the file you could also do anything with the database.

  1   2   3   4   >