Re: [libreoffice-users] Static vs. dynamic time

2020-10-02 Thread Michael Manning
When I have needed a static date or time in Libreoffice Calc, I have found that the only way to do this is to enter the date or time directly into the spreadsheet and not to use a formula. As an example of this, I have been using Calc to measure the drift of timepieces compared to a time standard

[libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBC

2020-07-27 Thread Michael Manning
connecting to the test database in MariaDB. This has now worked perfectly. Many thanks again. Mike email: michaelgmann...@gmail.com On Mon, 27 Jul 2020 at 22:57, Michael Manning wrote: > The server appears to be running on port 3306 according to this command > and result: > > $ mysql -

[libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBC

2020-07-27 Thread Michael Manning
, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. cheers Mike email: michaelgmann...@gmail.com | facebook.com/MikeLouise On Mon, 27 Jul 2020 at 22:33, Michael Manning wrote: > Thank you for your responses. >

[libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBC

2020-07-27 Thread Michael Manning
> Le 27/07/2020 à 09:06, Michael Manning a écrit : > > Hi Michael, > > > > > Issues arise when attempting to create a new database within Libreoffice. > > When I test connecting to a database, I get the following error message: > > SQL Status: 08S01 > >

[libreoffice-users] Connecting libreoffice to MySQL/MariaDB via JDBC

2020-07-27 Thread Michael Manning
I am trying to connect Libreoffice to MariaDB databases. I am using the following configuration - Linux Mint 19.2, - MariaDB - Server version: 10.4.6-MariaDB and have connected successfully via the mysql command line, and via PHPMyAdmin to create databases, tables and to successfully search these

Re: [libreoffice-users] Problem with print dialogue

2020-04-07 Thread Michael Manning
Hi John, You might be able to move the Print dialog screen by holding down the Alt key while clicking-and-holding the mouse button on the dialog screen. This may allow you to move the screen around so that you can see the OK button. You should then be able to select this button. cheers Mike On

Re: [libreoffice-users] how do I delete a page in libreoffice?

2019-04-28 Thread Michael Manning
Hi William, I am feeling a little confused by your request. In general wordprocessors take text and format it into a series of pages for printing or viewing. There is no real concept of pages as such as there is with desktop publishing applications. It is possible to remove page breaks but if you

Re: [libreoffice-users] Libre affected by gmail

2019-04-14 Thread Michael Manning
Have a look at: https://www.labnol.org/internet/gmail-size-search/26669/ Mike On Mon, 15 Apr 2019 at 04:42, charles meyer wrote: > Hi Folks, > > I've Googled this but found little help in reducing my gmail account use. > > For any of the fellow Gmail users on this list... > > I've save my

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-01 Thread Michael Manning
I am running an older version of LibreOffice Version: 5.1.6.2 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial6 CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; Locale: en-AU (en_AU.UTF-8); Calc: group running on Linux Mint 18.3 the function concatenate(text1:text4) gives the result text1 the

Re: [libreoffice-users] Buttons/Icons missing from the form Formatting Toolbar.

2019-03-24 Thread Michael Manning
Hi Dave, I see exactly the same problem in my older version of Libreoffice (ver. 5.1.6.2) running on Linux Mint (version 18.3). The buttons appear for a fraction of a second when I turn these buttons on or off but then disappear. regards Mike On Mon, 25 Mar 2019 at 03:53, Dave Barton wrote:

Re: [libreoffice-users] Spellchecker/Dictionary Functions not working

2016-12-01 Thread Michael Manning
Version: 5.1.5.2 Build ID: 7a864d8825610a8c07cfc3bc01dd4fce6a9447e5 CPU Threads: 2; OS Version: Linux 3.19; UI Render: default; Locale: en-AU (en_AU.UTF-8); Calc: group Linux Mint 17.3 I am having no issues with adding words to the user-defined dictionary. When I go to: Tools - Options -

Re: [libreoffice-users] Re: LibreOffice Base and SQLite

2016-09-25 Thread Michael Manning
system. The possible use of Kexi as a possible simple database system has also been hightlighted. cheers Mike On 22 September 2016 at 20:05, Alexander Thurgood <alex.thurg...@gmail.com> wrote: > Le 22/09/2016 à 06:41, Michael Manning a écrit : > > Hi Michael, > > > Afte

[libreoffice-users] LibreOffice Base and SQLite

2016-09-21 Thread Michael Manning
Hi, I am running Libreoffice Version: 5.1.3.2 with Linux Mint 17.3 32 bit and trying to connect Base to SQLite. I am using the tutorial at: https://wiki.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org as I cannot seem to find an equivalent tutorial for Libreoffice.

Re: [libreoffice-users] Libre Office 4.4.1.2 Concern

2015-04-06 Thread Michael Manning
Hi, I am using LibreOffice Version: 4.4.1.2 Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432 Locale: en_AU with Windows 7 64 bit enterprise, Service Pack 1 and have not experienced any issues with the software hanging regards Mike On Mon, Apr 6, 2015 at 10:28 AM, Tim Lloyd

Re: [libreoffice-users] Can I use a listbox to query database

2013-12-11 Thread Michael Manning
Bob, Can I make the suggestion that you use 3 tables - one for the presenters, one for the presentations, and one for the topics. You may need another one but we will get to that in a minute. I am suggesting a separate table for presenters as one presenter may make a number of presentations over

Re: [libreoffice-users] How to unprotect readonly parts of a document?

2013-05-17 Thread Michael Manning
This is very strange. I have not seen this issue before. After experimenting with the file for a bit, I found that 1. I saved the file to my disk 2. added a space at the beginning of the line 3 saved the file again 4. closed the file 5 opened the file in LibreOffice. I found that the read-only

Re: [libreoffice-users] New bug 64028: Calc forgets cell format when cell is cut (^X)

2013-04-29 Thread Michael Manning
:) -- *From:* Michael Manning michaelgmann...@gmail.com *To:* Tom Davies tomdavie...@yahoo.co.uk *Sent:* Monday, 29 April 2013, 4:05 *Subject:* Re: [libreoffice-users] New bug 64028: Calc forgets cell format when cell is cut (^X) I am using Windows 7 and LO Version

Re: [libreoffice-users] Bug to Triage (LibreOffice 4 Hangs with Outlook 2010)

2013-04-17 Thread Michael Manning
I am using LibreOffice Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89) on Microsoft Windows 7, and Microsoft Office Outlook 2007 SP3 (not the same conditions at the bug report) I created a test spreadsheet - test.ods - and selected Send - Email as OpenDocument spreadsheet.

Re: [libreoffice-users] Bug to Triage (LibreOffice 4 Hangs with Outlook 2010)

2013-04-17 Thread Michael Manning
using Send - Email as OpenDocument spreadsheet to myself. I was then able to open the file attachment in when the email arrived in Outlook and save it to my local hard disk. regards Mike On Thu, Apr 18, 2013 at 1:01 PM, Joel Madero jmadero@gmail.com wrote: On 04/17/2013 07:56 PM, Michael

Re: [libreoffice-users] Fatal error

2012-08-27 Thread Michael Manning
This problem is really unfortunate. I experienced this issue and was able to follow the procedures that I had found previously to install the software on my Win 64bit machine. However users of this software should never see this issue. It needs to be fixed quickly. I cannot recommend

Re: [libreoffice-users] Reply settings on this list have changed

2012-08-16 Thread Michael Manning
I strongly support the change. It is the fail-safe option. Users of this list know how to use their email to send back to the list regards Mike -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Release Notes LibO 3.5.4.2

2012-05-31 Thread Michael Manning
Have a look at: http://wiki.documentfoundation.org/Releases/3.5.4/RC2 cheers Mike On Thu, May 31, 2012 at 1:58 PM, Daniel Gonzalez gonzale...@gmail.comwrote: Hello, Someone could tell me where I can see the list of fixes and new features in LibO 3.5.4.2 thanks --

Re: [libreoffice-users] My story

2012-05-10 Thread Michael Manning
I have been testing LibreOffice Base 3.5 and MySQL on a Windows 7 64bit computer. I have found that the OpenOffice connector does work for me with LibreOffice but the discussion that it does not work for everyone and is likely to fail at some time in the future encouraged me to have another look