-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
-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
-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"
>
-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
-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
-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:
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
-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.
-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
-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?
-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
-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
-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.
-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
-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
-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
-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
-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
-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
-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:
-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
-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
-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
-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
-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
-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.
-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
-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
-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
-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.
-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
-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
-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
-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
-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:
-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"
-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
-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:
-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
-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",
-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" <=
-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
-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
-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
-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",
-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
-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
-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
-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
-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
-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
-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.
-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"
-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
-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:
-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
-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
-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
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
-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
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
-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
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
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
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.
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" ||
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
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
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
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
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
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
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
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
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
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
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
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
>
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
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
--
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:
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
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 =
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
--
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:
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
>
>
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
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:
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
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
--
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.
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:
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
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
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
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
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
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
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
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
1 - 100 of 345 matches
Mail list logo