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] 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] 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] 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] 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] 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] 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] Interplay between outline and paragraph numbering

2017-02-26 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Martin, > > I now have two challenges: > > a. I'd like to include the outline numbering in the paragraph > numbers, i.e. instead of > > > 3. Some Chapter > > 1. First 2. Second > > > I want/need: > > > 3. Some Chapter > > 3.1. First 3.2.

Re: [libreoffice-users] Shortage of Fonts in LibreOffice 5.3.0.3

2017-02-26 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. So I missed - of course - my favorate Classical > Garamond. ´the asked font is not

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] 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: 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] 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] 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] 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:

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

2016-10-10 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gary, You have forgotten: , SELECT "place", ... With ' ' will be input text. It isn't an image, which could be shown. Save the images by a form in a separate table "images". You will get the image you want, if you start a subselect for it.

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] 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] 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] 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] 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] 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] 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] 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-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] 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] 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 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] 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-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] 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] 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, 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] 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] 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] 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, 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-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] 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] 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] 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] 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] 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] 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] 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] Calculate decimal seconds

2017-03-29 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Helo Vytas, > > I have a spreadsheet containing timing results which are displayed > using the a Format code of MM:SS.00 (02:58.03). > > What I require is the number of seconds the cell represents as a > decimal number of seconds (178.03) for the

Re: [libreoffice-users] Calc Question

2017-03-29 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Greg, mark the row and choose Sheet > Insert Page Break > Row Break Regards Robert - -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -BEGIN PGP SIGNATURE- Version: GnuPG v2

Re: [libreoffice-users] version 5 does not open

2017-08-13 Thread Robert Großkopf
Hi Chaim, > > I have an old computer (32 not 64) running Fedora. I updated to Fedora 26 > and office 5. I cannot open the office at all. I tried re-installing and it > didn't solve the problem. Where have you downloaded LO from? Is it x86, not x86/64

Re: [libreoffice-users] Re: Libreoffice Base

2017-04-24 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi John, > Thank you for your reply. I am using Libreoffice on Microsoft > Windows 10 and always update Libreoffice when one becomes > available. I have seen comments that say Java can be a problem, if > you moved over to Firebird does this remove

Re: [libreoffice-users] Base Subsection reporting

2017-05-27 Thread Robert Großkopf
Hi Pieter, > I need a printed (paper or PDF) report from a small selection of my DB. I > am puzzled what is the best way to achieve that. > Filter? > Query? > other? > I am new to Base (but no PC dummy!) Best way to get a report is: Create a table "filter", which will only be needed for

Re: [libreoffice-users] LO base reference?

2017-05-07 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Dave, > > I'm involved in a project that will produce a dataset as its > product. I'm considering using LO base so as to avoid vendor > lock-in. I've found a base document from 2014 that seems promising, > is there a more up-to-date place to start

Re: [libreoffice-users] Base query - CONCAT function

2017-09-15 Thread Robert Großkopf
Hey Harvey, > I wanted to use the CONCAT function in a Base query. However, it seems > that if ONE of the elements of the list to be concatenated is NULL then > the CONCAT function returns a NULL. Am I right? Is it a bug or a > feature? feature, because anythin, which is connected with NULL

Re: [libreoffice-users] LO Base Queries, Forms & Reports not appearing

2017-09-15 Thread Robert Großkopf
Hi Noel, > I am transferring an H2 database from a Windows PC to a late model Apple > Mac, (Capitan 10.11.6). On the main Base window, the Tables are all > displaying normally, but nothing shows up under Queries, Forms or Reports. Did you create queries, forms and reports for the database in a

Re: [libreoffice-users] Base query - CONCAT function

2017-09-16 Thread Robert Großkopf
Hi Harvey, > > But shouldn't the CONCAT( ' & ', [Partnervorname] ), '' ) actually > return a NULL due to the '' (i.e. not a space, zero length)? NULL: There is nothing inside, no string, no number, no data ... Empty: Could only be for strings - nothing to see, but its a string with zero length.

Re: [libreoffice-users] Base query - CONCAT function

2017-09-15 Thread Robert Großkopf
Hi Harvey, > Hi Robert, > Thanks for answering. > Your suggestion, however, do not work on my Opensuse Leap 42.3 / > LibreOffice 5.3.3.2 configuration. > > I use the Query design feature to enter > > "Vorname" || IFNULL( ' & ' || "Partnervorname", ' ' ) || "Nachname" >  or > > "Nachname" ||

Re: [libreoffice-users] Base query - CONCAT function

2017-09-15 Thread Robert Großkopf
Hi Harvey, > > I have a backend Mariadb 10 which I access directly using the using the > MySQL connector. All right. With MariaDB (and MySQL) the two pipes (||) dont work. But something like SELECT CONCAT("Vorname, ' ',IFNULL("Partnervorname",' '),"Nachname") AS "Name" FROM "Table" should

Re: [libreoffice-users] Mysql Native Connector for LO 5.4

2017-09-08 Thread Robert Großkopf
Hi H. Stoellinger, you could try this one: https://extensions.libreoffice.org/extensions/mysql-native-connector Works here with LO 5.4.1.2 on OpenSUSE. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To

Re: [libreoffice-users] Write Protection Locked

2017-09-10 Thread Robert Großkopf
Hi Gordon, > Trying to edit a master (.odm) document. Write protection is locked on. > > Ctrl+Shift+M removes the 'Read Only'  note at head of page, but edit > access is still barred. Suggestions? Could the document be write-protected by the system, not by LO? If protection of LO is disabled

Re: [libreoffice-users] syntax error in SQL - error 1000

2017-09-11 Thread Robert Großkopf
Hi Peter, > I have a query which works fine. But when I edited it in the graphical query> > editor LO refused to save it saying that there was an SQL error. The> detailed message was "syntax error, unexpected $end, expecting BETWEEN or IN> or SQL_TOKEN_LIKE". Even if I try to save the unedited

Re: [libreoffice-users] left adjusted last lines in 'd justified paragraphs???

2017-08-25 Thread Robert Großkopf
Hello Dennis, > > I don't come clear with LibreOffice. No matter what I try, I end in a > paragraph - as paragraphs are kind of swiss-knives in LibreOffice. > However, the rules to the paragraph element are classic and not helpful. > For example, I inserted a line-break into a list entry. The

Re: [libreoffice-users] Recalculating table in Writer

2017-10-23 Thread Robert Großkopf
Hi Kolbjørn, > In Writer I have a table with 2 rows and 2 columns. > In row 2 column 2 I have a formula adding the value in row 1 column 2 to > the value in row 2 column 1 together showing the result in row 2 column 2. > When changing one of the input values row 2 col 2 is not updated unless > I

Re: [libreoffice-users] Re: Reports Libre Base

2017-11-27 Thread Robert Großkopf
Hi Peter, > Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2 > > Ubuntu 16.4 > > When I first found the problem I removed LibreBase and reinstalled it > but the problem with reportsremained the  same. This is a special Ubuntu-version of LO. Have a look into your packagemanager. Did you install all

Re: [libreoffice-users] Re: Reports Libre Base

2017-11-28 Thread Robert Großkopf
Hi Peter, install all what begins with libreoffice-report . This will install the report-builder. I haven't installed any Ubuntu-version here, only SUSE. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To

Re: [libreoffice-users] Re: Reports Libre Base

2017-11-28 Thread Robert Großkopf
Hi Peter, > Definitly a hard crash. When restarted it goes into a recovery process.  > If I install Open Office will it work with the Lire Base data bases or > would I need to export the data and recreate new data bases? If you are using the internal HSQLDB (and not Firebird!) it will be no

Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-11-29 Thread Robert Großkopf
Hi Harvey, > > The UPDATE query is allowed (i.e. stored in the queries list) if you > 'edit in SQL view' and then set the 'Run SQL Command directly' in the > SQL editor. If you don't do it this way only SELECT queries are > permitted. If I try this the message appears: Statement does not

Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-11-30 Thread Robert Großkopf
Hi Harvey, > > I am accessing a backend Mariadb V10 on a backend server via > MySQL(Native). > > The Base query contains only the following statement: > UPDATE Family.Adressen SET Print_flag = FALSE; > > LO Version 5.3.5.2 from OpenSuse on Linux. > Have tested this with nearly the same

Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-12-01 Thread Robert Großkopf
Hi Harvey, > > Obviously, I found this behaviour (by accident) because I was looking > for it, and because I needed it. Also obviously, my feeling is that > LOBase is not doing itself a favour by restricting usage of SQL in this > way. I would prefer a feature that allowed data manipulation via >

Re: [libreoffice-users] libre-office in the browser?

2017-12-01 Thread Robert Großkopf
Hi Dave, > I need to use different computers belonging to other people to work on > documents. I normally use LO Writer and would prefer to be able to use > it in a browser without installing anything on the computers I'm using. > I have access to a server and could do a server-side install to

Re: [libreoffice-users] ttf-mscorefonts-installer

2017-11-10 Thread Robert Großkopf
Hi Joe, > > ttf-mscorefonts-installer Never heard LO will install ttf-mscorefonts. On my system (OpenSUSE) is a special script to download ttf-mscorefonts. It has nothing to do with LO. Could be there is the same script for Ubuntu. So start this script with your installer. Regards Robert --

Re: [libreoffice-users] Create scan button?

2017-11-19 Thread Robert Großkopf
Hi James, > I occasionally scan documents into LibreOffice with a single sheet > scanner. This means for each page I have to click on > Insert>Media>Scan>Request. Is it possible to create an icon to run > those steps? Haven't tested, but: Tools > Customize > Toolbars > Add Command there:

Re: [libreoffice-users] Create scan button?

2017-11-19 Thread Robert Großkopf
Hi James, >>> Hasn't any icon, so it would appear with text in the standard toolbar. You could also add an icon to "Request". Choose the added "Request" and change the icon. There would appear a dialog with icons. >> That appears to work, but it's Insert>Request. Now to find

Re: [libreoffice-users] Macro Dim Dialog and Control

2017-11-19 Thread Robert Großkopf
Hi Jonny, > > This works, but what about oDlg and oCtl? Are there special data types for > them too? The documentation I've found so far doesn't give any hints at > all. I tried this: > Dim Dlg As com.sun.star.awt.XDialog ' No error here, > ' but next line throws an error: > oDlg =

Re: [libreoffice-users] Re: Base document doesn't sent DocumentLoeded event ...

2017-12-08 Thread Robert Großkopf
Hi Patrick, Alexander, > > Sounds similar to bug 91828. > > Also, you might want to read bug reports 91879 and 107839 to see if they > are related to your problem. And also this one for opening a database-document: https://bugs.documentfoundation.org/show_bug.cgi?id=96625 Regards Robert --

Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-12-02 Thread Robert Großkopf
Hi Harvey, here is a little example-database for executing SQL by a macro. http://robert.familiegrosskopf.de/download/Example_InsertUpdateDelete_SQL.odb Open the form and try. Could be constructed a little bit better, but works when code is right. Regards Robert -- Homepage:

Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-12-03 Thread Robert Großkopf
Hi Harvey, >> >> here is a little example-database for executing SQL by a macro. >> http://robert.familiegrosskopf.de/download/Example_InsertUpdateDelete >> _SQL.odb >> Open the form and try. Could be constructed a little bit better, but >> works when code is right. >> >> Regards >> >> Robert > >

Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-12-03 Thread Robert Großkopf
Hi Harvey, > > I've got it. The hsqldb driver pool had to be enabled in the Base > options settings. Have never touched there anything. The conneection-pool is disabled here. Do you use the LO-version from OpenSUSE or do you use LO downloded directly from LO-website? I prefer the version from

Re: [libreoffice-users] Insert current date

2018-05-21 Thread Robert Großkopf
Hi Howard, > > Now, how would I change the result to -MM-DD? Dubbelclick on the date. You get the dialog for changing the format. I don't know how to change the standard - except to change the language of the text to, for example, Englisch(Canadian). Regards Robert -- Homepage:

Re: [libreoffice-users] Insert current date

2018-05-21 Thread Robert Großkopf
Hi T.R., Am 21.05.2018 um 16:46 schrieb T. R. Valentine: > Why not use the default of +<;> (that's a semicolon)? > > Add the to insert current time. This is the default for Calc. There isn't any default for date ore time in Writer. But the combination is free for using in Writer also. So you

Re: [libreoffice-users] Insert current date

2018-05-21 Thread Robert Großkopf
Hi Peggy, there is no macro needed. Open a Writer-document Go to Tools > Customize > Keyboard Type in "Functions": 'Date' Now look for a free Shortcut-Key, for example Ctrl+7. Click "Modify" on the right. Click "Save". Now you could insert the current date with Ctrl+7. Regards Robert --

Re: [libreoffice-users] Set JRE in LibreOffice

2018-05-23 Thread Robert Großkopf
Hi Thomas, > The Java website allows you download the newest version, but does NOT > ask about 32/64-bit installation. > (I presume it detects that automatically) No, it seems it doesn't. I haven't any Windows running here, but heard a lot of wrong Java for LO, because 64bit and 32bit problem.

Re: [libreoffice-users] Set JRE in LibreOffice

2018-05-23 Thread Robert Großkopf
Hi Thomas, which version of LO do you use? 64bit or 32bit? You need Java 32bit for LO 32bit and Java 64bit for LO 64bit. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to:

Re: [libreoffice-users] Set JRE in LibreOffice

2018-05-25 Thread Robert Großkopf
Hi Zarah, > i read somewhere that libreoffice 64 bit and 32 bit both supports java > 32 bit version. This is a wrong information. We have a lot of trouble with Windows-users, who didn't realize 64bit Java is needed for 64bit LO. There are many people in mailinglists, also in bugtracker reporting

Re: [libreoffice-users] Set JRE in LibreOffice

2018-05-25 Thread Robert Großkopf
Hello Girvin, > > I remember a while back, LO was making an effort to remove Java > requirements. Some progress to that end has been made over the years, > but I suspect there are still some threads connecting LO to Java, > besides Base. It is only the internal HSQLDB-database (Java), which will

Re: [libreoffice-users] Delete Footnotes?

2018-05-16 Thread Robert Großkopf
Hi Peggy, > I am just learning to use Writer and started a document. I added footnotes > and then changed things around and the footnotes need to be deleted so I > can start over. But I can't find any way to delete them. They won't > highlight. What am I missing? You have to delete the number

Re: [libreoffice-users] Calc - opening a .csv file challenge

2018-06-12 Thread Robert Großkopf
Hi Charles, > > A friend emailed me a .csv file created and saved in Excel 10 exported in > the .csv format but no matter how I try opening it – Western Europe > (ASCII/US) or (ISO-8859-1) or (Windows – 1252/Win Latin 1) it just opens to > gibberish. Could you open the file in a texeditor? Don't

Re: [libreoffice-users] Set JRE in LibreOffice

2018-05-27 Thread Robert Großkopf
Hi *, I 'm using the internal database for deveopement of databases, with pupils in scool and for some little projects, which only need a standalone-database. For "normal" use I also prefer MariaDB. The native driver had some (little) problems here so I switched to JDBC. I am using

Re: [libreoffice-users] Writer paragraph numbered list issue

2018-06-04 Thread Robert Großkopf
Hi bunk3m, > > The document goes from paragraph 1 to 11 and then should have 11.1 to > 11.9 but I end up with paragraph 1 to 20. Go to paragraph, which shows '12' Right Mouseclick > Demote One Level ... and so on for all following paragraphs ... Could be you have to change the numbering: Right

Re: [libreoffice-users] Writer page numbering issue + numbered list issue

2018-06-04 Thread Robert Großkopf
Hi bunk3m, > How do I manually change the starting page number for the legal > document?  What's the secret to get this to work? > Go to the first paragraph of the first page of your document. Right mouseclick > Paragraph > Text Flow > Breaks Choose "Instert" Choose "With page style" Choose

  1   2   >