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

Hi, Le 14/03/2013 01:50, jathan a écrit : Thank very much to all for your help ;) An apology for some ambiguity in my explanation. That I want to do with LibreOffice is use it in read-only mode by default in place of edit function as odfviewer: http://opendocumentfellowship.com/odfviewer, pptvie

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

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

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

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 fi

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

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. h

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

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 us

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

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 f

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

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

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

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 stri

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

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 ( http://nabble.documentfoundation.org/Install-

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

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 instruction

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

On 13/03/13 04:22, Tom Davies wrote: Hi :) I'm not quite sure which platform you mean or what type of files you are talking about. If it's Windows and MS formats then just try reinstalling the same version of LibreOffice to get back to the question you get asked during normal installation. On

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

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 s

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

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

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 MySQL

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

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 d

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

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 Maria

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

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] Text-boxes. How to set up?

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

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

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 d

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

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

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

[libreoffice-users] Re: Intro to LibreOffice Presentations

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 loo

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

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 in

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

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 dat

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

I agree. That will go into the chapter on using Base to connect to various data sources. I think that was originally scheduled to be chapter 8 or 9, but I think this chapter should be moved up to chapter 5. Personal experience: I used synaptic to completely remove mariadb including the

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

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

[libreoffice-users] Re: =IF Function

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 mail

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

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, h

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

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. Aut

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

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

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

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 t

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

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 wrote: When I went to the Extension web page, I had to select "Base Extensions" and "Any Version". That is whe

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

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 b

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

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_Extension&getCompatibility=any Is this correct? Regards Heinz On Wed, 13 Mar 2013 14:05:39 +0100, Dan Lewis wrote:

Re: [libreoffice-users] =IF Function

At 04:03 13/03/2013 -0700, J Taylor wrote: Using Mac 10.8.2 and Libre 4.0.1, I find that the IF function does not place a blank space as the second option. I think this is a little confused. Do you mean that IF() appears not to be capable of having a null string (not a blank) as its third pa

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

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: http://nabble.documentfoundatio

Re: [libreoffice-users] Base Recovery failed

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 offeri

Re: [libreoffice-users] Base Recovery failed

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.

[libreoffice-users] Re: Intro to LibreOffice Presentations

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 o

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

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 (I

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

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 th

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

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 anot

Re: [libreoffice-users] =IF Function

Original Message From: Tinkerer 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 insanely stupid, or is t

[libreoffice-users] Base Recovery failed

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 to

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

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 bot

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

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 wrote: Le 12/03/2013 21:16, Tom Davies

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

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 th

[libreoffice-users] Re: Intro to LibreOffice Presentations

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] =IF Function

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

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

Hi :) Ah, for Gnu&Linux i am not sure.  Can you try to reinstall?  There is probably somewhere in the settings that allows you to set this.  Personally i find it's the default.  What happens when you try just double-clicking on an MS document?  Whenever i have installed LibreOffice in Gnu&Lin

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

Hi :) I'm not quite sure which platform you mean or what type of files you are talking about.  If it's Windows and MS formats then just try reinstalling the same version of LibreOffice to get back to the question you get asked during normal installation.  On Windows instead of doing the full r

Re: [libreoffice-users] Intro to LibreOffice Presentations

Hi :) You might like to use a copyright (well, specifically copyleft really) license from Creative Commons http://creativecommons.org/ All LibreOffice's official documentation uses the CC-by-SA agreement which just lists contributors even if they were originally writing for other projects.  The

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

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 ob

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

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 e

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

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 ac

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

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 Gnu&Linux. 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: [MariaDB Announce] MariaDB 5.5.30 now available

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 tr

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

-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. B