Re: [libreoffice-users] How to delete ~/.config/libreoffice/

2017-02-26 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Paolo, > generally to perform such operations on system / configuration > files or folder, I open the file manager with root privileges > (from terminal: sudo nautilus - or thunar, nemo... whathever you > have). you can rename, move or delete

Re: [libreoffice-users] How to delete ~/.config/libreoffice/

2017-02-26 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Andre, > change ¨4¨ into ¨4old¨ did not solve my problem. > "4" has been created new? Or is there also a "4-suse"? Could you post some of the fonts you couldn't see in LO, but are available for other programs like the fontmanager of KDE?

Re: [libreoffice-users] How to delete ~/.config/libreoffice/

2017-02-25 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Andre, > I use OpenSUSE Tumbleweed. In the new version of LibreOffice is a > shortage of fonts. I can choose 104 fonts from the 171 available of > my system fonts. I was advised to delete ~/.config/libreoffice/. > How can I do that? Could be yor

Re: [libreoffice-users] Slow opening documents

2017-02-21 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Leonardo, > > No, I'm sure it's not a HW problem, this was working perfectly > before 5.2. My machine is an i5 with 8gb RAM. > > What I found is, while the freeze is happening the CPU works at > +90% (soffice.bin process). Where did you get your

Re: [libreoffice-users] Help with LO Forms

2017-02-17 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ian, > > But I'm confused. The Handbook says Calc can be used as the > datasource for a Form in Writer. Don't know which Handbook you mean. The Handbook Base says: - - Calc or Excel spreadsheets can also be used as the table source for

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread Robert Großkopf
een exported into Base or something else (Firebird ...). So Ian has first to export the data- and I don't know if he doesn't need the contact to Calc for the data any more. > > > On 2/16/2017 11:52 AM, Robert Großkopf wrote: Hi Ian, >>>> I have a Spreadsheet of Data and I ha

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ian, > > I have a Spreadsheet of Data and I have prepared a Form in Writer > to display and edit this information. This won't work. You can't use a a table in Calc as a database and edit this data in a form of the database or in a form of wirter.

Re: [libreoffice-users] Re: about libreoffice online which is introduced in version 5.3

2017-02-15 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi anne-plogy, Am 15.02.2017 um 16:34 schrieb anne-ology: > yes. It would be good if you will answer to mails with pressing the button "answer to list". When I open my Thunderbird today I could see three answers from you which should be part of

Re: [libreoffice-users] Background and Border Color on Properties of Form Controls

2017-02-12 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Juan, > > When I insert a control form in Writer, for example a Date Field, > in General Properties of the field they aren't shown the > 'Background color' and 'Border color' options. It's this bug:

Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-27 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 27.01.2017 um 16:21 schrieb ptoye: > Hi Robert, > > I've had a look at some of your forms now, especially > filter_without_macros and I'm a bit puzzled. I see that the table > in the Display part of the form is populated by the "filterquery" >

Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-24 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Peter, have a look here: http://robert.familiegrosskopf.de/lo_hb_en/Example_Search_and_Filter.odb You don't need anything elese but a form and a subform. The example includes different forms, some of them working without any macro. Regards

Re: [libreoffice-users] Can I reload a form based on a parameter query?

2017-01-23 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Peter, > I have a form which at present is based on a parameter query - the > user types in a criterion and only the relevant database rows are > shown.When I press a button a macro does various actions, including > deleting the currently selected

Re: [libreoffice-users] Mysql Connector Java version

2017-01-12 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hir Girvin, > > I am upgrading software and I downloaded the MySQL_connector_java > driver version 5.1.40 for use in connecting LO 4.4.7 or 5.1.6 Base > to my MySQL databases. Previously, I have been using version > 5.1.18, which worked fine. Has

Re: [libreoffice-users] Development-Snapshot (5.3.0.1.0-1) - Base

2017-01-09 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello H. Stoellinger, > Hello, Since I seem to be a glutton for punishment I tried out the > above snapshot (Jan. 7). Trying to run a report under base > (accessing MySQL views/tables) I get a Java-error: > "Java.Lang.IncompatibleClassChangeError"

Re: [libreoffice-users] LibreOffice 5 .config directory?

2017-01-06 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Jim: > I did a clean install of Ubuntu 16.04 which uses LO vers 5.1.4.2. > > When I look at my .config file I see /.config/libreoffice/4/user. > Why the '4', I expected '5'. Is this normal. It hasn't been changed from '4' to '5'. Could be the

Re: [libreoffice-users] Issues with date fields in dialogues

2017-01-03 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Peter, > I've been experimenting with date fields in dialogues and have > found what I think is an anomaly. As I understand it, a date field > is intended to hold a single date in its model. This can be viewed > when the dialogue is displayed.

Re: [libreoffice-users] Why is a custom menu item greyed out?

2017-01-03 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Peter, > I've been trying to add a custom menu to a document. I go through > the motions of adding the menu and saving it within the document, > but when I click on it, or any other menu on the menubar, it is > greyed out. Assigning the menu

Re: [libreoffice-users] How to insert the date into a date field in a dialog

2016-12-28 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Peter, could be something like this: DIM unoDate unoDate = createUnoStruct("com.sun.star.util.Date") unoDate.Year = Year(Date) unoDate.Month = Month(Date) unoDate.Day = Day(Date) unoDate is now the date, which should be put into the field:

Re: [libreoffice-users] Re Libre Bsea

2016-12-28 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Peter, > I make a niumber of regular monthly contributions to various > organisations. Is there any way I can automatically enter them all > at the beginning of the financial year. Our financial year runs for > 1st July to 30th June. Two

Re: [libreoffice-users] can i add a file to a form in base?

2016-11-25 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi davzeeppelin, have found nearly the same document translated to English. Don't know where to find on LO-website, but I have downloaded it sometimes ago: http://robert.familiegrosskopf.de/lo_hb_en/BH5008-Tasks_HR_JHW_20151222.odt And here are the

Re: [libreoffice-users] can i add a file to a form in base?

2016-11-25 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi davzeppelin, I have forgotten: Another example I have described in Base Handbuch. There is also a database added to the Base-Handbuch for this. But it isn't translated to English, too.

Re: [libreoffice-users] can i add a file to a form in base?

2016-11-25 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi davzeppelin, > > > greetings anyone, i'm trying to create a database where each entry > points to a pdf file too (which is different for every individual > form) > > following some tutorials on youtube i already made the basic table > and form

Re: [libreoffice-users] Title bar for dialogs

2016-11-21 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello ptoye, > I can't work out how to put text into the title bar for a dialog > I'm creating. The dialog editor just doesn't seem to have any > mechanism. Can some kind soul please put me out of my misery? Mark the whole dialog. See the properties

Re: [libreoffice-users] Base not starting

2016-11-20 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Dave, > > It appears that Base was not installed as part of the upgrade - > odd! So, my question is what components are needed? They are: * > Java runtime. Should not need as I have the 1.8 JDK, but... So it is installed. You could see this in

Re: [libreoffice-users] Base not starting

2016-11-19 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Dave, > > LO was installed as part of the upgrade from a previous version > where Base was installed. And? Have you had a look it has been installed? I have read the same on a German Ubuntu-Forum: Base wouldn't be installed by default, but could

Re: [libreoffice-users] Base not starting

2016-11-19 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Dave, > When I click on Base, nothing happens. Also, there is no File/Base > or File/Database. What gives? > > Dave, Ubuntu 16.10 mate LO 5.2.2 Where did you get LO from? Ubuntu repositories? Could be the standard-installation doesen't install

Re: [libreoffice-users] Re: Creating Form in Base and connect it to database

2016-11-06 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Pál, > I am using Gentoo linux system. I have installed Libreoffice > without java support, so I am going now to correct this. After this the wizard should work. And this will be the better way to get a working form for new users of Base. When

Re: [libreoffice-users] Creating Form in Base and connect it to database

2016-11-06 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi csanyipal, > > I have installed LibreOffice version 5.1.4.2 out there. Which system do you use? > > I created new Base file with connection to one of mine database. > Within Base I created a Form ( not with Form Wizard, because it is > not

Re: [libreoffice-users] Creating a General Ledger in Base

2016-11-03 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi John, > I have looked all over the world, using google, but I have not > found any sample general ledger examples using LO Base. I have created many examples for Base - but I dont know much about a general ledger. Could be you could use something

Re: [libreoffice-users] Re: How do I install the current Linux version

2016-10-31 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Tim, > > What I do is unpack the install files [I use .deb files] and place > them all in a temporary folder I call "lib". Nice and simple, I > have that folder in the "home" folder called "timothy". > > This will give me "/home/timothy/lib"

Re: [libreoffice-users] Re: How do I install the current Linux version

2016-10-31 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ken, > > I will have a look, if I find something special for your > situation. Couldn't find a clear description for this problem when looking for Mint. But when I am looking for installing LO with Linux I found this:

Re: [libreoffice-users] Re: How do I install the current Linux version

2016-10-31 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ken, >> 4. Use your install-program and add the directory as a local >> source for your installer. 5. Now you could choose the directory >> with your installer and could install all packages from there. > > I did OK until step 4, and then my lack

Re: [libreoffice-users] Re: How do I install the current Linux version

2016-10-30 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ken, > > So I still need to go somewhere to find out how I install the > current version after I have it downloaded. > > Thanks for the help and suggestions, everyone. You could download the packages for your system here:

Re: [libreoffice-users] Adding Watermarks

2016-10-25 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ken, > LO 5.1.5, Windows 7 > > The help file says to go to Format - Page and select the > background tab. Then it says "On the background tab page...". You have to use "Area" instead. Seems the help isn't updated there. Regards Robert

Re: [libreoffice-users] libreoffice developers please answer my question about security!

2016-10-18 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Nasrin, we had the same discussion on German mailinglist. The special fix, which has been published for AOO now, has been included in version LO 4.2. It's a little bit ago - about 2 years and 10 months. So no problems to take the last LO

Re: [libreoffice-users] Master Document Chapters Auto-numbering

2016-10-18 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi *, > > Now that you're done (I assume), I'll confess to how much our > discussion has renewed my interest in and appreciation for LaTeX. > Aside from the insertion of your images, I have to wonder if your > life would have been easier using LaTeX

Re: [libreoffice-users] Re: Document protection

2016-10-17 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ken, > >> Once the form is created, and the info in the form is write >> protected, save the file. The mark the file as read only. I >> think that will force a name change when you try to save it. I have just used *.pdf-forms for my children.

Re: [libreoffice-users] Re: Document protection

2016-10-17 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi *, >> >> So what I need, as I said in the original post, is a document >> that will be "locked", but you can still complete the fields. >> When that is accomplished, the file will be marked read only so >> when it's saved with new information, a

Re: [libreoffice-users] Master Document Chapters Auto-numbering

2016-10-16 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Julian, > 1. My Master Documents chapters numbering always starts from 1 - > how can this run concurrently for chapter1, chapter 2 etc etc.? > > 2. My introductory chapter has several subheadings, with the > proviso of the above, how can I

Re: [libreoffice-users] Strange pdf printout in Calc vs. Excel

2016-10-14 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Bruce, > There is actually an enhancement request related to PDF export in > Calc: https://bugs.documentfoundation.org/show_bug.cgi?id=54052 You recognized Valter himself wrote this enhancement request four years ago? > > I agree the default of

Re: [libreoffice-users] Strange pdf printout in Calc vs. Excel

2016-10-13 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Valter, > > I noticed that if I have a Calc file with multiple sheets, even if > with regular print area defined, if I click the "Print PDF > directly" button while positioned in a specific sheet, the command > prints out *all the sheets* I have

Re: [libreoffice-users] Re: I need Autocorrect working in two languages in one document

2016-10-13 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi *, I have tried this: First paragraph defined with German language. Second paragraph defined with Englisch language. Wrote something in the first paragraph, for example the wrong word "dei", and it was autocorrected to "die". Wrote also "ihs",

Re: [libreoffice-users] loading a database with images

2016-10-11 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, would be good if you will send me the database with private mail - so I could have a look, which error appears. Regards Robert -BEGIN PGP SIGNATURE- Version: GnuPG v2

Re: [libreoffice-users] loading a database with images

2016-10-11 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, 1. A subselect should only have one value (one row, one field). 2. If you will connect to the current row of the outer select, the table of the outer select must have an alias. SELECT "event_name", "first_name", "middle_initial",

Re: [libreoffice-users] loading a database with images

2016-10-11 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, > SELECT "event_name", "first_name", "middle_initial", "last_name", > "sex", "age", "email", "place", CASE WHEN "age" BETWEEN 0 AND 18 > THEN 'Youth' WHEN "age" BETWEEN 19 AND 59 THEN 'Adult' ELSE > 'Senior' END "Group", CASE WHEN "place" <=

Re: [libreoffice-users] loading a database with images

2016-10-11 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, > Go it. The old primary key problem. Base insists that it create one > and call it ID instead of using another name. > How do you create tables? Every name for a field with primary-key is allowed. Primary-key has only to be unique. Your

Re: [libreoffice-users] loading a database with images

2016-10-11 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, How do you create tables? Every name for a field with primary-key is allowed. Primary-key has only to be unique. Your query (by adding the comma) could also work, if the images are in the same path as the *.odb-file. In the form you have

Re: [libreoffice-users] loading a database with images

2016-10-10 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, > > SELECT "place" You have forgotten: , SELECT "place", ... > CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN > 'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3 > THEN 'image3.png' WHEN "place" >= 4 THEN

Re: [libreoffice-users] Base: Table Data View missing controls

2016-09-14 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi *, it's this one: https://bugs.documentfoundation.org/show_bug.cgi?id=97731 Robert -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQIcBAEBAgAGBQJX2YXzAAoJELDKYwaoS9AIzEoP/2RYgL+sPS5UMCgCDHAPUgDA

Re: [libreoffice-users] Re: Base constantly crashes

2016-09-03 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Larry, > > I have Apple's Java installed. That bug is not the problem and was > fixed in LibreOffice. However the latest comments on that report > lead to a new bug > https://bugs.documentfoundation.org/show_bug.cgi?id=101057 which is > the cause

Re: [libreoffice-users] Base constantly crashes

2016-09-03 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Larry, > Every time I open a database (or create a new one) LibreOffice > crashes as soon as I click on anything. Totally unusable. There seems to be a problem with Oracle-Java and Mac OS: https://bugs.documentfoundation.org/show_bug.cgi?id=94716

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

2016-08-28 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Bruce, > On form Form_Filter, is it possible to define the List Box using > General - List Entries and Data - ValuelList No problem to define it separately. But I would only use this kind of entries if I would knew all entries, which ever should

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

2016-08-28 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Alanon, could be you are looking for something like this: http://robert.familiegrosskopf.de/download/Filter_Database.odb One table "Table" with the content you will list, one other table called "Filter" with only one row. A query lists the

Re: [libreoffice-users] Re: Time Calculations in LOBase

2016-08-25 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Don, > It occurs to me my OP may not have been as clear as it should be. > To clarify, I need to calculate the decimal value of the times > involved: (([day_end]-[day_start])-([lunch_end]-[lunch_start])) = > H.nn worked > > So, for example:

<    1   2   3   4