[libreoffice-users] Intro to LibreOffice Presentations

2013-03-13 Thread Aaron C Johnson
Hello everyone- Awhile back I created a couple of LibreOffice presentations that I used to help teach the basics of LibreOffice to our elementary school teachers. There are two presentations; the first one covers Writer and Calc, and the second one covers Impress. You can download them

Re: [libreoffice-users] Horizontal alignment of text in table cells

2013-03-13 Thread Ken Heard
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 2013-03-08 00:01, Steve Edmonds wrote: When you click in the table cell, does the top left drop down (next to the font) show Table Contents? Yes it does. This is the default style in the table where your paragraph properties are stored. By

[libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available

2013-03-13 Thread Alex Thurgood
Le 12/03/2013 21:16, Tom Davies a écrit : Hi Tom, Apparently it also doesn't work on Macs although i'm entirely certain how far that goes. For example could Base as a front-end on a Mac read MariaDb as a back-end on a Debian server. Presumably it does but i don't know of anyone that has

[libreoffice-users] Re: Problem with MySQL after upgrading OpSys

2013-03-13 Thread Alex Thurgood
Le 12/03/2013 15:37, Tom Davies a écrit : Hi Tom, My quick, probably inaccurate guess is the connector. Is the system 32 or 64bit? Clearly a GnuLinux. Is the MySql on the same computer or on a separate server? It has nothing to do with the connector. We are talking about the (in)correct

[libreoffice-users] Re: Can't view/edit python macro samples

2013-03-13 Thread Alex Thurgood
Le 12/03/2013 15:12, mickeyf a écrit : Hi Mickey, C:\Program Files (x86)\LibreOffice 4.0\share\Scripts\python\pythonSamples I was interested in using macros with calc, but since they should also be available in writer I find it a bit ironic that I need a external program (or non-integrated

[libreoffice-users] Re: Macros don't run

2013-03-13 Thread Alex Thurgood
Le 12/03/2013 15:13, Malcolm Moore a écrit : Hi Malcolm, If you recorded a calc macro in 3.5.4 and then open the same spreadsheet in 4.0.n the macro isn't there .. or at least I can't find them. Anyone got any ideas Quite possibly, the configuration files from 3.5.x which point to the

Re: [libreoffice-users] Re: Can't view/edit python macro samples

2013-03-13 Thread Tom Davies
Hi :) OpenSource is about choosing the right tool for the task.  NOT about making every tool vast and bloated by making it do everything badly.  It's tricky tho.  Exactly which parts of the programs would be used rarely and which would be used all the time by everyone.  With some things it's

[libreoffice-users] =IF Function

2013-03-13 Thread Tinkerer
Using Mac 10.8.2 and Libre 4.0.1, I find that the the IF function does not place a blank space as the second option. Have I done something insanely stupid, or is this a bug? Where I should get blank cells I am getting: #DIV/O! ASTest.ods

[libreoffice-users] Re: Intro to LibreOffice Presentations

2013-03-13 Thread Pedro
Hi Aaron Aaron C Johnson wrote Awhile back I created a couple of LibreOffice presentations that I used to help teach the basics of LibreOffice to our elementary school teachers. Fantastic! This is the true spirit of a User to User mailing list and of Open Source software. Thank you for

[libreoffice-users] Hyperlink Bug in calc - bug 62289

2013-03-13 Thread Tanstaafl
Hi everyone, Would appreciate if some of you could confirm this bug for me. I'm on Windows XP sp3, with LibreOffice 4.0.1 release... https://bugs.freedesktop.org/show_bug.cgi?id=62289 Bug report: A hyperlink defined on one worksheet that is linked to another sheet/tab in the same workbook

Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available

2013-03-13 Thread Heinrich Stoellinger
Hi Alex, A day or two ago I saw a MySQL-Native-Connector alpha version listed under base extensions. Would be super to be able to try it out. Is there a way to get involved in some testing? Regards H. S. On Wed, 13 Mar 2013 10:18:47 +0100, Alex Thurgood alex.thurg...@gmail.com wrote: Le

[libreoffice-users] [ANNOUNCEMENT] MySQL-Connector Extension

2013-03-13 Thread Dan Lewis
I have uploaded two connectors to the Extension website under Base Extensions version 1.0.3. Both are for Linux only. One is 32 bit (x86) and the second is 64 bit (x86_64). For now, either should be downloaded for testing only. The 32 bit connector works on LO 4.0.x and 4.1.0 alpha for

[libreoffice-users] Base Recovery failed

2013-03-13 Thread Marion Noel Lodge
Hi, I have a situation where the recovery of a damaged database failed to complete. Eventually I had to recover the file from a backup. The recovered backup file is now working normally, however whenever I start LibreOffice, it is still offering to recover the damaged database. Where do I go

Re: [libreoffice-users] =IF Function

2013-03-13 Thread Dave Barton
Original Message From: Tinkerer j_taylo...@btinternet.com To: users@global.libreoffice.org Date: Wed, 13 Mar 2013 04:03:55 -0700 (pdt) Using Mac 10.8.2 and Libre 4.0.1, I find that the the IF function does not place a blank space as the second option. Have I done something

Re: [libreoffice-users] Hyperlink Bug in calc - bug 62289

2013-03-13 Thread Dave Barton
Tanstaafl wrote: Hi everyone, Would appreciate if some of you could confirm this bug for me. I'm on Windows XP sp3, with LibreOffice 4.0.1 release... https://bugs.freedesktop.org/show_bug.cgi?id=62289 Bug report: A hyperlink defined on one worksheet that is linked to another

Re: [libreoffice-users] Re: Intro to LibreOffice Presentations

2013-03-13 Thread Aaron C Johnson
Pedro- On 03/13/2013 06:49 AM, Pedro wrote: Hi Aaron Fantastic! This is the true spirit of a User to User mailing list and of Open Source software. Thank you for sharing! I think you have just revealed a bug in Impress: if you look at the PDF, you will notice that in pages 8,9 and 23,24,25

Re: [libreoffice-users] Re: Problem with MySQL after upgrading OpSys

2013-03-13 Thread Ian Whitfield
Thanks Girvin and Alex (I wont echo all your comments here) OK - I'm using MySQL 5.1.55 and phpMyAdmin 3.5.4. Everything is on 'localhost' with just me as the user. I've just checked in PCC and both httpd and MySQL are set to Start on Boot and are running. I found my config.inc.php file

[libreoffice-users] Re: Intro to LibreOffice Presentations

2013-03-13 Thread Pedro
Hi again Aaron Aaron C Johnson wrote So you're saying that you downloaded the zip file and extracted it and opened the odp file and it crashed LibreOffice? I think I created the presentation in LibreOffice 3.5 (although I'm not positive) and last time I tried to extract the files and open

Re: [libreoffice-users] Base Recovery failed

2013-03-13 Thread Paul D. Mirowsky
If the Base file is the only one failing, you should have a lock-file at the same location as the originating Base file. Delete the lock file. Hope this helps. On 3/13/2013 9:17 AM, Marion Noel Lodge wrote: Hi, I have a situation where the recovery of a damaged database failed to complete.

Re: [libreoffice-users] Base Recovery failed

2013-03-13 Thread Dan Lewis
On 03/13/2013 09:17 AM, Marion Noel Lodge wrote: Hi, I have a situation where the recovery of a damaged database failed to complete. Eventually I had to recover the file from a backup. The recovered backup file is now working normally, however whenever I start LibreOffice, it is still

[libreoffice-users] Re: =IF Function - SOLVED

2013-03-13 Thread Tinkerer
I could not get your prompts to work, but they gave me ideas. The final formula was: =IFERROR(C30*100/B30,) This also covered other errors where only one number was present, so no calculation was possible. Many thanks, Tink. -- View this message in context:

Re: [libreoffice-users] [ANNOUNCEMENT] MySQL-Connector Extension

2013-03-13 Thread Heinrich Stoellinger
Hello Dan, Sorry to be a nuissance - but I can only find Access2Base under Base Extensions. The page is http://extensions.libreoffice.org/extension-center?getCategories=Base_ExtensiongetCompatibility=any Is this correct? Regards Heinz On Wed, 13 Mar 2013 14:05:39 +0100, Dan Lewis

Re: [libreoffice-users] [ANNOUNCEMENT] MySQL-Connector Extension

2013-03-13 Thread Dan Lewis
When I went to the Extension web page, I had to select Base Extensions and Any Version. That is when I saw two extensions listed: Access2Base and MySQL Native Connector. When I clicked on the latter, I went to the MySQL Native Connector page. Next you need to click the 1.0 link below

Re: [libreoffice-users] [ANNOUNCEMENT] MySQL-Connector Extension

2013-03-13 Thread Heinrich Stoellinger
Thanks, Dan. I have downloaded the connector and will install it on my 32-bit-Linux-Debian and Debian-Wheezy systems. Regards Heinz On Wed, 13 Mar 2013 16:56:41 +0100, Dan Lewis elderdanle...@gmail.com wrote: When I went to the Extension web page, I had to select Base Extensions and Any

Re: [libreoffice-users] [ANNOUNCEMENT] MySQL-Connector Extension

2013-03-13 Thread Heinrich Stoellinger
Hi Dan, Thanks again! Eureka! I had to add the .oxt file extension to the name. Now I can access a MySQL database stored on the Debian Wheezy system (MySQL 5.5) from my laptop client running Linux-Mint-Nadia. The systems are connected through a LAN. They are both 32-bit. I will test it more in

Re: [libreoffice-users] [ANNOUNCEMENT] MySQL-Connector Extension

2013-03-13 Thread Heinrich Stoellinger
Hi again, Your connector also works from the client an Linux-Mint-Nadia to a server running Debian-Squeeze and MySQL 5.1. Super!! And - by the way - LO is at Version 4.0.1.2 (Build ID: 84102822e3d61eb989ddd325abf1ac077904985) Regards H On Wed, 13 Mar 2013 14:05:39 +0100, Dan Lewis

[libreoffice-users] Help! Sheets tab not showing in Calc

2013-03-13 Thread Carl Paulsen
LibreOffice 3.5.6.2 Mac OS 10.6.8 I have a spreadsheet with 4 sheets. File has been taking a long time to save (10 seconds or so for a 650kb file). Auto-filter is currently on for at least one sheet. This morning I closed the file because after saving, the display of the grid was wrong.

Solved: Re: [libreoffice-users] Help! Sheets tab not showing in Calc

2013-03-13 Thread Carl Paulsen
OK, after working on this more, I found 2 things. First, I was able to switch between the sheets using the Navigator (I double-clicked where it showed the number of sheets on bottom left of file window). Then I noticed that the scroll bar had been expanded to the entire width of the window,

[libreoffice-users] Re: =IF Function

2013-03-13 Thread Tinkerer
Thank you Brian I'd forgotten that there is a material difference between Empty cells and Blank cells, even though I noticed that the result sometimes varied. Tink. -- View this message in context: http://nabble.documentfoundation.org/IF-Function-tp4043493p4043610.html Sent from the Users

Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available

2013-03-13 Thread Girvin R. Herr
Dan, I don't know where I read this warning, in this forum or some other, but there should be a warning to users who convert to Mariadb from MySQL. Yes, they can convert to Mariadb, but they may not be able to go back to MySQL once they used Mariadb on the database. I have not yet made that

Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available

2013-03-13 Thread Girvin R. Herr
Dan, That is another issue. It is good that you were able to get MySQL back when you needed it. I think what I read was that Mariadb changed the database itself somehow, making it incompatible with MySQL. Thus, all the work done on it with Mariadb was lost from the last MySQL-compatible

[libreoffice-users] Text-boxes. How to set up?

2013-03-13 Thread Tom
Hi :) How can i make a nicely curved text-box that automatically keeps all the text inside the boundaries of the box? At the moment i cheat a lot and it's a lot of work that ends up never looking quite right The 'attachment' shows the type of curved shape i am aiming for. Ideally text written

[libreoffice-users] Re: Intro to LibreOffice Presentations

2013-03-13 Thread Tinkerer
Aaron On a Mac 10.8.2 using Libre 4.0.1 everything works OK I would fault the PPT's. The Black fonts on a Dark background were impossible to read and not all projectors would cope adequately. I went through the slides altering the font colour where I had difficulty reading. The finished result

Re: [libreoffice-users] Re: Intro to LibreOffice Presentations

2013-03-13 Thread Aaron C Johnson
Pedro- On 03/13/2013 09:14 AM, Pedro wrote: Hi again Aaron I have tested it under LO 3.3.4.1, 3.4.5.2, 3.5.5.3, 3.6.5.2 and 4.0.1.2 All crashed when I click on the miniature (on the Slide Pane) of any of the slides mentioned in the previous message. Okay, I just tested this on Windows XP SP3

Re: [libreoffice-users] [ANNOUNCEMENT] MySQL-Connector Extension

2013-03-13 Thread Dan Lewis
So, you also noticed this. When using the native connector, MySQL will display all of the databases for which the given user has been given access. JDBC/ODBC will only display the specific database that is listed in the database file. Some thoughts. If you are going to use the native

Re: [libreoffice-users] Re: Intro to LibreOffice Presentations

2013-03-13 Thread Aaron C Johnson
On 03/13/2013 02:18 PM, Tinkerer wrote: Aaron On a Mac 10.8.2 using Libre 4.0.1 everything works OK I would fault the PPT's. The Black fonts on a Dark background were impossible to read and not all projectors would cope adequately. I went through the slides altering the font colour where I had

Re: [libreoffice-users] Text-boxes. How to set up?

2013-03-13 Thread Dan Lewis
One way to do this is to 1. Use Draw to make your curved text-box. 2. Convert this box into a bitmap and save it as a PNG. 3. Use this as the background for your pages. 4. Use paragraph styles to place the text where you want it. (Use the Indenting Spacing tab of the paragraph style.) With

[libreoffice-users] Re: Problem with MySQL after upgrading OpSys

2013-03-13 Thread Alexander Thurgood
Le 13/03/13 14:54, Ian Whitfield a écrit : Hi Ian, I added in the following two lines .. /$cfg['Servers'][$i]['root'] = 'root';// //$cfg['Servers'][$i]['password'] = 'x';/ I then tried again to log in via phpMyAdmin. The screen does start OK and I enter 'root' as the user and

Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available

2013-03-13 Thread Jay Lozier
On 03/13/2013 02:47 PM, Girvin R. Herr wrote: Dan, That is another issue. It is good that you were able to get MySQL back when you needed it. I think what I read was that Mariadb changed the database itself somehow, making it incompatible with MySQL. Thus, all the work done on it with

Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available

2013-03-13 Thread Girvin R. Herr
Jay Lozier wrote: On 03/13/2013 02:47 PM, Girvin R. Herr wrote: Dan, That is another issue. It is good that you were able to get MySQL back when you needed it. I think what I read was that Mariadb changed the database itself somehow, making it incompatible with MySQL. Thus, all the work

Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available

2013-03-13 Thread Dan Lewis
On 03/13/2013 06:55 PM, Jay Lozier wrote: On 03/13/2013 02:47 PM, Girvin R. Herr wrote: Dan, That is another issue. It is good that you were able to get MySQL back when you needed it. I think what I read was that Mariadb changed the database itself somehow, making it incompatible with

Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available

2013-03-13 Thread Jay Lozier
On 03/13/2013 07:12 PM, Girvin R. Herr wrote: Jay Lozier wrote: On 03/13/2013 02:47 PM, Girvin R. Herr wrote: Dan, That is another issue. It is good that you were able to get MySQL back when you needed it. I think what I read was that Mariadb changed the database itself somehow, making it

Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available

2013-03-13 Thread Jay Lozier
On 03/13/2013 07:19 PM, Dan Lewis wrote: On 03/13/2013 06:55 PM, Jay Lozier wrote: On 03/13/2013 02:47 PM, Girvin R. Herr wrote: Dan, That is another issue. It is good that you were able to get MySQL back when you needed it. I think what I read was that Mariadb changed the database itself

Re: [libreoffice-users] Text-boxes. How to set up?

2013-03-13 Thread Brian Barker
At 12:05 13/03/2013 -0700, Tom Davies wrote: Ideally text written into the box on page 1 would automatically flow into the box on the next page ... Help | frames;linking. Or LibreOffice 3.6 Writer Guide p 122 Linking frames. I trust this helps. Brian Barker -- For unsubscribe instructions

[libreoffice-users] Bug 62303 - Enhancement request: Set default install folder under Windows to \LibreOffice\

2013-03-13 Thread V Stuart Foote
Bug fdo#62303 ( https://bugs.freedesktop.org/show_bug.cgi?id=62303 ) has been submitted as an enhancement request to adjust the installation folder on Windows to a non-versioned folder e.g. C:\Program Files\LibreOffice\ Brief discussion on Discuss (

[libreoffice-users] Help with sorting a CSV file using LibreOffice Calc

2013-03-13 Thread David Gulley
Hi, I'm having a bit of a problem sorting records in a CSV file using LibreOffice Calc. I have a CSV file that contains information about ethnic media organizations. The file contains 3 columns: company ID#, company name, and ethnicities. The first field contains an alphanumeric 6 to 8 digit

Re: [libreoffice-users] Bug 62303 - Enhancement request: Set default install folder under Windows to \LibreOffice\

2013-03-13 Thread Dan Lewis
On 03/13/2013 10:26 PM, V Stuart Foote wrote: Bug fdo#62303 ( https://bugs.freedesktop.org/show_bug.cgi?id=62303 ) has been submitted as an enhancement request to adjust the installation folder on Windows to a non-versioned folder e.g. C:\Program Files\LibreOffice\ Brief discussion on Discuss

RE: [libreoffice-users] Bug 62303 - Enhancement request: Set default install folder under Windows to \LibreOffice\

2013-03-13 Thread V Stuart Foote
Dan, Would cause no change for Windows OS installations. You'd still have to do msiexec.exe /A administrative installation each of which registers its own LibreOffice user profile and minimal Windows registry entries. So, you can have one full installation, and multiple functional but not

Re: [libreoffice-users] Help with sorting a CSV file using LibreOffice Calc

2013-03-13 Thread Tim Lloyd
Hi David, what is the sensitivity of this file? Could you drop it onto the list via the nabble interface? https://www.libreoffice.org/get-help/nabble-mailing-list-interface/ Cheers On 03/14/2013 01:38 PM, David Gulley wrote: Hi, I'm having a bit of a problem sorting records in a CSV file

RE: [libreoffice-users] Bug 62303 - Enhancement request: Set default install folder under Windows to \LibreOffice\

2013-03-13 Thread V Stuart Foote
The Wiki notes on doing the administrative installation are at this link., Along with a link to Florian Reisinger's LibreOffice Server Installation GUI extension for doing parallel administrative installs while avoiding Windows command line and msiexec.exe. Currently for Windows OS's only.

Re: [libreoffice-users] Help with sorting a CSV file using LibreOffice Calc

2013-03-13 Thread Jay Lozier
On 03/13/2013 10:38 PM, David Gulley wrote: Hi, I'm having a bit of a problem sorting records in a CSV file using LibreOffice Calc. I have a CSV file that contains information about ethnic media organizations. The file contains 3 columns: company ID#, company name, and ethnicities. The first

RE: [libreoffice-users] Put LibreOffice as unedited document viewer only

2013-03-13 Thread Dennis E. Hamilton
Open the document that you want to make read-only. Click the File | Save As ... menu. On the Save As change the name if you want to keep the editable version separate. If not, leave the name and location the same. On the Save As dialog, check the Save with Password. (Don't worry, that will