Re: [libreoffice-users] Concatenate Function inCalc

2019-04-03 Thread Robert Großkopf
Hi Luuk, > > I decided not to report this as a bug. > > Then only 'bug' i could find is that CONCAT is missing from the help, > > where CONCATENATE leads to: > https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060110.html?System=WIN=CALC=SC_HID_FUNC_VERKETTEN#bm_id3153084 > > > > I

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-03 Thread Robert Großkopf
Hi Jonathon, > > It doesn't matter if concat or concatentate is the correct command to > use. Neither concat(a20:a200) nor concatentate(a20:a200) return the > expected the result. Both return the value in a20. I couldn't confirm this with Version: 6.2.2.2 Build ID:

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-02 Thread Robert Großkopf
Hi Luuk, > In 6.2.0.3 on Windows, the function CONCATENATE(a1:a3) returns the value > of a1 > > This should be reported a a bug... So please report this, if you could see the buggy behaviour in LO 6.2.2.2 also. I can't report it, because I couldn't reproduce it with LO 6.2.2.2. Regards Robert

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-02 Thread Robert Großkopf
Hi Michael, > > This thread is about CONCATENATE being disfunctional in that it accepts > ranges, but does not act on them correctly. Please stop referring to CONCAT > as the reason that CONCATENATE is broken. Please red the first mail of jonathon. "With previous versions of LibO,

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-02 Thread Robert Großkopf
Hi Michael, > CONCATENATE must either fail to accept ranges (with an error), or accept > them and provide the combination that acceptance suggests. It is a bug that > it accepts ranges, but returns something else. Have opened Calc and looking for fuction CONCATENATE. Help in the dialog says:

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-01 Thread Robert Großkopf
Hi *, use CONCAT instead of CONCATENATE. CONCAT will accept cell-ranges. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] printing Labels in Calc

2019-01-27 Thread Robert Großkopf
Hi Wayne, > > Platform: AMD Phenom(tm) II X2 555 Processor × 2 > > Ubuntu 16.04 LTS > > LibreOffice Version: 5.1.6.2 > Build ID: 1:5.1.6~rc2-0ubuntu1~xenial4 > CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; > Locale: en-US (en_US.UTF-8); Calc: group You are using a very old version

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-17 Thread Robert Großkopf
Hi Paul, > > Opening the "2 Amps to Volts-High by Series" There seems to be something wrong in the saved query, which isn't shown while editing the query. For other users: 1. I have tested to execute the query. 2. Execution fails. 3. I opened the query in design-view. 4. I executed the query.

Re: [libreoffice-users] Re: Base/Firebird Queries broken

2019-01-16 Thread Robert Großkopf
Hi Drew, > > Yes, I have a suggestion - there is a property in the Base file which is > incorrectly set during the Migration Assistant run and must be fixed. The > error message looks like this is what is biting you. > > The fastest way to fix it is at follows: > Close the base file and exit

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-16 Thread Robert Großkopf
Hi Paul, > Ok, things are narrowing down on this issue. > > I have a Query Design view in which I have a field Series set to 134. > > I remove the 134 and press enter. > > Run Query (F5) > > It works. Save it at this point. Don't switch back. Does this work? Then try "Equipment"."Series" =

Re: [libreoffice-users] Re: Base/Firebird Queries broken

2019-01-16 Thread Robert Großkopf
Hi Paul, I would remove >> >>> "Ions-IM"."Select" = TRUE and >>> "Equipment"."Series" = 134 and try the query again. Both commands are right in the internal Firebird-Database. I could test it with with LO 6.1.4.2 here. But could be there is something wrong with the fields ... Is there

Re: [libreoffice-users] Re: Base/Firebird Queries broken

2019-01-15 Thread Robert Großkopf
Hi Paul, Have a look at > "Ions-IM"."Select" = TRUE Did the migrationtool set the field "Select" to a BOOLEAN-field? > "Equipment"."Series" = 134 Did the migrationtool import the field as a INTEGER field? There is no function in the query, only 4 tables connected ... The only possibility to

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-14 Thread Robert Großkopf
Hi Paul, as Dan wrote: Post the code of the query (opening SQL-view and copy). There are functions, which will work in HSQLDB, but won't work, with the same name, in Firebird. Regrads Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community:

Re: [libreoffice-users] Help regarding LibOfficeBase/Firebird

2019-01-12 Thread Robert Großkopf
Hi Pertti, > > I have some old database-projects that I (very nicely) have built on > MSAccess2003 and want now to rebuild them onto LO-Base. > One of them has three tables (a main form and two subforms with about a > hundred records by 15-25 cols each) that I now have successfully >

Re: [libreoffice-users] Cell style background colour

2019-01-03 Thread Robert Großkopf
Hi Dan, > > Styles > Edit Style > Area is the correct path to take. (I forgot > about "Area", sorry.) You are right. But who will search for a special defined color in paragraph styles? Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community:

Re: [libreoffice-users] Cell style background colour

2019-01-01 Thread Robert Großkopf
Hi Jonny, > Sorry for bothering everyone again, but I can't find how to add colours to > the background colour palette. In older LibreOffice versions, or maybe it > was even Apache OpenOffice, I could add colours in Tools → Options… → > somewhere, but it seems to be removed.

Re: [libreoffice-users] Edit a style

2019-01-01 Thread Robert Großkopf
Hi Johnny, > Am I the only one who can't edit styles? > I right click on and click Edit, but no dialogue shows up. Just want to > make sure this is a real bug before reporting it. Creating new styles works > fine. I could right click and click "Modify" - no "Edit" there. And "Modify" will show

Re: [libreoffice-users] Looking for input form example...

2018-12-30 Thread Robert Großkopf
Hi Michael, > > What I'm convinced they want to do (I know, not right tool for the right > job) is have a form doc that can be opened on demand, filled in by the > operator then printed. I'm being led to believe that they don't even want > to save it to disk. So could be the XML-Formdocuments

Re: [libreoffice-users] Looking for input form example...

2018-12-29 Thread Robert Großkopf
Hi Michael, > > Has anyone seen an example that is a form for taking simple input and then > outputs the form data in one of two manners, either as a simple text file > of the values of each field or as a "finished" or "print ready" page. > > Has anyone seen anything on the LO web pages like

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Robert Großkopf
Hi Harvey, > > Multiplying 2048.28*.146 yields correctly 295.54488, but when rounding > down to 2 decimal places, 295.55 is displayed (instead of > 295.54)(either using ROUND(2048.28*.146,2) or with field format. Please have a look at the values you have written. Gives 299.04888 here on Calc and

Re: [libreoffice-users] lo writer image in table border issue

2018-12-02 Thread Robert Großkopf
Hi Gary, the image has "Anchor > To Paragraph". There will no possibility for the following text to wrap around the image. Mark the image with right mousebutton, open the kontextmenu and look for "Anchor > As Character". Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice

Re: [libreoffice-users] Libreoffice 5.4.7 and 6.0.6 crash systematicaly opening Base with macros ...

2018-11-05 Thread Robert Großkopf
Hi Patrick, please post the script here or upload an example-file with the script. Could test it here wit 64bit rpm Linux. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to:

Re: [libreoffice-users] Is Report-Builder Broken?

2018-11-01 Thread Robert Großkopf
Hi Keith, > > Version: 6.1.2.1 > Build ID: 1:6.1.2-0ubuntu1 > CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: gtk3; > Locale: en-AU (en_AU.UTF-8); Calc: group threaded You are using the LO-version from Ubuntu, not directly from LO. So it could be LO is missing some packages. But:

Re: [libreoffice-users] Concatenating fields in related form

2018-09-18 Thread Robert Großkopf
Hi Adam, > > I can only get this to work (with a list box) if there is only one > project for each client. If I have two separate project records with > the same client id I get an error. There must be something wrong in your database-construction. Please load up an example with some dummy-data

Re: [libreoffice-users] Concatenating fields in related form

2018-09-16 Thread Robert Großkopf
Hi Adam, > I have a Client form with ClientID, FirstName and LastName fields and > a Project form with ClientID and FullName fields. In Filemaker I was > able to type in a client id into the Project form and it would insert > the first name and last name from the Client form into the FullName >

Re: [resent] Re: [libreoffice-users] report builder query - how to suppress output.

2018-09-03 Thread Robert Großkopf
Hi Mike, > > I'm still 'all at sea', I'm afraid. I can't for the life of me see how > to create a new section, never mind how to make it disappear conditionally. When starting to edit a report you could see Pageheader, Details and Pagefooter. This are 3 sections of the report. You could add

Re: [libreoffice-users] Java for browsers different than for LibreOffice?

2018-09-01 Thread Robert Großkopf
Hi Peggy, you could install bith versions of Java without any problem on the same machine. If your LO is 64bit you need 64bit-Java for this one; if the browser is 32bit you need 32bit for the browser. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community:

Re: [libreoffice-users] JRE help please

2018-09-01 Thread Robert Großkopf
Hi Peggy, is your system a Windows-system? You have a 64bit-system? Did you install Java and LibreOffice for the same 64bit or one for 32bit and the other for 64bit? Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3

Re: [libreoffice-users] report builder query - how to suppress output.

2018-08-28 Thread Robert Großkopf
Hi Mike, > > I can do a simple-minded report using report builder, which looks at the > moment to fulfil the need, except for one problem. When a database field > is empty (eg, no email or no 2nd address line), is there any way of > completely suppressing that line of output? I don't want

Re: [libreoffice-users] Re: Base: setting up a home pantry dbase aditional info

2018-08-24 Thread Robert Großkopf
Hi Alex, lunixbox, > > OK, so as I now understand it, you want a running total of all items > with a given Item-ID (hence the inventory aspect). I haven't answered to this because I have problems to understand ... Hope you are right. > > I would recommend that you read Robert Grosskopf's Base

Re: [libreoffice-users] SOLVED:Re: LibreOffice Base now does not apply named parameter substitution after upgrade from LO 6.0 to LO 6.1 and this breaks subforms based on mysql/mariadb tables

2018-08-20 Thread Robert Großkopf
Hi toodr, this is https://bugs.documentfoundation.org/show_bug.cgi?id=118112 Hope it will be fixed. Not everybody is able to change the content.xml. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To

Re: [libreoffice-users] Re: LibreOffice Basic macro stops working after upgrade from LO 6.0 to LO 6.1

2018-08-19 Thread Robert Großkopf
Hi Klaus, have tried it a little bit more. URL was wrong the first time. I get the object oBitmaps.getByName( "OOoLilyPond" ) ... but you will create a string of this. This coudn't work. What do you wan't to get from the object? Regards Robert -- Homepage: http://robert.familiegrosskopf.de

Re: [libreoffice-users] Re: LibreOffice Basic macro stops working after upgrade from LO 6.0 to LO 6.1

2018-08-19 Thread Robert Großkopf
Hi Klaus, > ' Load the image into the internal bitmap table: > oBitmaps.insertByName( "OOoLilyPond", ConvertToURL(sFile) ) ' Up to > here, > everything works fine. > sNewURL = oBitmaps.getByName( "OOoLilyPond" ) ' This line causes the > error. So the error is one row above.

Re: [libreoffice-users] LibreOffice Basic macro stops working after upgrade from LO 6.0 to LO 6.1

2018-08-19 Thread Robert Großkopf
Hi Klaus, no macro could be seen here. Attachements aren't allowed. You know there is a German mailinglist? (us...@de.libreoffice.org) Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to:

Re: [libreoffice-users] Opening foreign document from LOBase

2018-08-13 Thread Robert Großkopf
Hi Paddy, > Hi, >I am developing an LO database and I want to open a PDF document from a > button on a Base Form. I want a button on the form that will open a > specific, different PDF document for each record. I want it to open the > document in the default PDF reader? I have not been able

Re: [libreoffice-users] Base: check boxes in forms lost after update

2018-08-09 Thread Robert Großkopf
Hi Albrecht, could be it is this bug: https://bugs.documentfoundation.org/show_bug.cgi?id=105463 ... but it has been fixed a year ago ... Try to set the style of the box to 3D. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community:

Re: [libreoffice-users] Base: check boxes in forms lost after update

2018-08-09 Thread Robert Großkopf
Hi Albrecht, > > after updating LibreOffice on a Debian stretch system to 6.1.0.2 > (build-ID 1:6.1.0~rc2-3~bpo9+1), all check boxes in data base forms are > lost, and it looks as if the icons for form controls toolbar are partly > lost (see attached screen shot, German locale, i.e. “Markierfeld”

Re: [libreoffice-users] Unable to access offline help in 6.1

2018-08-09 Thread Robert Großkopf
Hi David, it isn't the online-help, which is shown there. Have a look at the addressbar. The address begins with file:/// ... Now have a look at opt/libreoffice6.1/help. All the files there are html, css, js, xsl - the help is now created for webbrowser, but it is a offline-help. Regards Robert

Re: [libreoffice-users] Re: Error messge interpretation...

2018-07-25 Thread Robert Großkopf
Hi Michael, > Wow! Where'd you find that referenced? Have written this down in German Base-Handbuch, but it isn't translated yet to English. Have also found it here: https://wiki.documentfoundation.org/Faq/Base/004 Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice

Re: [libreoffice-users] Re: Error messge interpretation...

2018-07-25 Thread Robert Großkopf
Hi Michael, > Here's the SQL statement (reformatted) I got in the trace of the ODBC > library call: > SELECT >   "SystemModels"."SystemModel" AS "SystemModel", >   "SystemModels"."SystemMfg" AS "SystemMfg", >   "SystemModels"."SystemMfgName" AS "SystemMfgName" > FROM >   "SystemModels"

Re: [libreoffice-users] Base : How to control insert into a form in order to generat my own keys by macro ?

2018-07-22 Thread Robert Großkopf
Hi Patrick, > > But it looks strange to call "UndoRecordChanges" form operation after my > own "YourInsertFunction", it look like this call undo my own insert ... > then, undo the operation of the form is not really no operation of the > form ... This should stop the prozess. I have had a look

Re: [libreoffice-users] Base : How to control insert into a form in order to generat my own keys by macro ?

2018-07-22 Thread Robert Großkopf
Hi Patrick, > > So, if I set the property {AllowInserts = false}, do the Form stop to > handling the insert but continue to fired /"Before Record Action"/ and > /"After Record Action"/ events ? I think no, because the form could will > not display the new line to insert ... You will need "Before

Re: [libreoffice-users] Error messge interpretation...

2018-07-17 Thread Robert Großkopf
Hi Michael, > > I "linked" the two fields for the subform and when I execute the form, I > get the error message: > > SQL Status: HY000 > Error code: 1 > > parameter marker count incorrect Could be you have written 2 fields for the mainform and one field for the subform? Other possibility:

Re: [libreoffice-users] Calculate difference between two dates (with time)

2018-07-13 Thread Robert Großkopf
Hi michael, at first: Why do you answer to the list, some other persons and my private mail-address? I am reading and writing the the list and doens#T need the same message twice. >> >> I have tried it with German date-time-values and have set only >> =A2 - A1 >> ... and it returns 06:50:00 >> >>

Re: [libreoffice-users] Calculate difference between two dates (with time)

2018-07-13 Thread Robert Großkopf
Hi Krunose, > > just a quick question: if A1 holds 1.7.18. 15:30 and if A2 holds 1.7.18. > 22:20, why then Did you type it right here? Point after 18? Dont know if this is a right format for a date/time-value. I have tried it with German date-time-values and have set only =A2 - A1 ... and it

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] Did a message reply to all?

2018-06-05 Thread Robert Großkopf
Hi Peggy, > Someone told me to use "reply all". I found an option under settings to set > it that way. Either has to be one of the other. I guess I'll have to > remember to uncheck it when I don't want to use it. Some groups don't want > to be bothered with everyone's reply. "Reply all" will

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

Re: [libreoffice-users] Set JRE in LibreOffice

2018-05-27 Thread Robert Großkopf
Hi Tom, > Is anyone here in the MariaDb or MySql communities? Is there any chance of > attracting some of their devs to work on an Open Source connector or better > yet to work with our devs to create native support? There is a native connector available for MySQL/MariaDB:

Re: [libreoffice-users] Set JRE in LibreOffice

2018-05-27 Thread Robert Großkopf
Hi Girvin, > > To create the relationships, I use the "Queries" "Database" option of > Base and the "Tasks" options. I prefer to start with the "Create Query > in Design View" to do most of the work. Seems you create the relation between tables in queries. That is not the way to create

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] 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] 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-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] 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 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 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] 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] Text input fields

2018-04-24 Thread Robert Großkopf
Hi Steve, tested a little bit more. Seems it is displayed a field like View → Field Shadings Could be it works with Insert → Field → More Fields Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe

Re: [libreoffice-users] Text input fields

2018-04-23 Thread Robert Großkopf
Hi Steve, > None of the form controls I see there are like in the document, they > also don't seem to act like the form controls. You have been asked for checkboxes. This checkboxes are at View > Toolbars > Form Controls You could start from this Toolbar another Toolbar for formcontrols like

Re: [libreoffice-users] Text input fields

2018-04-22 Thread Robert Großkopf
Hi Steve, > > I am wanting to insert more of these but can't seem to locate the item > within LO and would appreciate a hit as to the location in the menus. > I suppose, while I am asking, which menu has the check boxes. Are you looking for View > Toolbars > Form Controls ? Regards Robert --

Re: [libreoffice-users] Call for testers - automatic migration of embedded hsqldb Base files to embedded Firebird Base files

2018-04-11 Thread Robert Großkopf
Hi all, have put the content of the mail I wrote to a bug-report: https://bugs.documentfoundation.org/show_bug.cgi?id=116944 Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to:

Re: [libreoffice-users] Call for testers - automatic migration of embedded hsqldb Base files to embedded Firebird Base files

2018-04-11 Thread Robert Großkopf
Hi *, have tested this kind of migration: Downloaded the daily build of 2018-04-11, 6.1.0.0.alpha0+ Opened the database, which is part of the Base Handbook: "Media_without_Macros". No comment like "Internal HSQLB" apperas at the bottom of the window. Tried to open the tablecontainer. No table

Re: [libreoffice-users] Problems creating a split database

2018-03-09 Thread Robert Großkopf
Hi Anne, > > I don't want to use absolute addressing, in order to keep the database > portable, but I seem to have got the relative addressing wrong. The > attached image shows the structure as it stands at the moment. The URL > I'm giving is in the format ..\Images\someImage.jpg - btw,

Re: [libreoffice-users] Problems creating a split database

2018-03-06 Thread Robert Großkopf
Hi Anne, > > Just to clarify - I gather I need to add a field where I have at > the moment only the text/URL field. I then try to set up the control > for the image so that it reads the url and displays the image. Have I > got that right? Test time, tomorrow. Yes, it's the right way.

Re: [libreoffice-users] Problems creating a split database

2018-03-06 Thread Robert Großkopf
Hi Anne, the Base-Handbook you are using is very old. Just some days ago the new German Base-Handbuch for LO 6.0 has been published - nearly 600 pages. The Base-Handbook conbtains a chapter for changing an internal database to an external database. It is a part of the attachment. It is better

Re: [libreoffice-users] override automatic fraction

2018-03-04 Thread Robert Großkopf
Hi Eric, > I want to enter the date 3/4 into a cell formatted for date. How do I keep it > from changing my entry to three-quarters? > Open LO, goto Tools > Options > Lanuage Settings > Languages > Date acceptance patterns Here you could enter all you want. But better wuld be the input 3/4/

Re: [libreoffice-users] Base: turn of header after 1st page

2018-03-01 Thread Robert Großkopf
Hi Paul, > > Has anyone been able to use Base Reports and turn off the Header after > the first page? It is impossible at this moment to show something dependent on pagecount in ReportBuilder: https://bugs.documentfoundation.org/show_bug.cgi?id=52486 Pageheader couldn't be hidden by changing

Re: [libreoffice-users] what version of LO would work on a really old system?

2018-02-24 Thread Robert Großkopf
Hi Tim, > > Robert The custom install as you stated seems to come up in Windows, not > DEB based Linux install, unless you install through the repository, and > package managers like Synaptic. I have never installed LibreOffice on a Windows-system. You could choose the packages under OpenSUSE,

Re: [libreoffice-users] what version of LO would work on a really old system?

2018-02-24 Thread Robert Großkopf
Hi Henri, > > Surprised to hear that the Ubuntu respositories don't provide a complete LO > package - I install via the PPA on my Linux Mint machine, which is an > Ubuntu fork, and get everything, including Math and Base. What gives ?... Every Linux-distribution does allow to install only parts

Re: [libreoffice-users] base table window navigation tool

2018-01-23 Thread Robert Großkopf
Hi Robert, > At least under Ubuntu Gnome this tool is awfully small, unreadable. How to > enlarge it ? I tried using gnome_color chooser (suggested by the French > forum), to no avail. Could you please explain where to find "base table navigation tool"? Doens't know what you mean. I have read

Re: [libreoffice-users] Re: Database corruption since LO 5.7.3 installed

2018-01-15 Thread Robert Großkopf
Hi Peter, here the macro for saving data while opening or running Base: SUB DatabaseBackup(inMax AS INTEGER) REM A copy of the databasefile *.odb would be created in the Backup-folder. REM The amount is limited to 5 copies. After it has reached 5 copies, the

Re: [libreoffice-users] Re: Database corruption since LO 5.7.3 installed

2018-01-07 Thread Robert Großkopf
Hi Remy, seems you haven't read the first mail of this thread: "If I try opening it in a Zip file reader I'm told it's not a valid Zip file." The way to repair a *.odb-file is described in the Base-Handbook in detail. But if you can't extract anything there you couldn't get data out of a

Re: [libreoffice-users] Re: Database corruption since LO 5.7.3 installed

2018-01-07 Thread Robert Großkopf
Hi Peter, > > Both LO and Java are 64-bit versions. Is it a good idea to revert to 32-bit > versions? I'm not sure how LO decides which Java to use if given the choice; > I assume it picks up the same bit-version. Bugzilla doesn't show any obvious > connection between 64-bit and database

Re: [libreoffice-users] Database corruption since LO 5.7.3 installed

2018-01-07 Thread Robert Großkopf
Hi Peter, Am 07.01.2018 um 13:23 schrieb ptoye: > Since upgrading to LO 5.7.3 a database of mine keeps getting corrupted. When > I try to open it it opens in Writer with the text Ó×r6ÒÒ#v If I try > opening it in a Zip file reader I'm told it's not a valid Zip file. It's not > consistent

Re: [libreoffice-users] Graphic with multiple curves

2017-12-30 Thread Robert Großkopf
Hi Marco, > > Imagine I want to draw 12 curves (months) all in the same graphic, one > for each month with different x and y: > month,x,y > Jan,10,20 > Jan,15,30 > Jan,20,20 > Feb,5,10 > Feb,10,15 > Feb,30,30 > etc. > > How can I do it in Calc? I have tried this, but I 'm not a Calc-expert:

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

  1   2   >