date:20130313



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 from here:

Introduction to LibreOffice - Writer and Calc: ODP 
http://www.jordanschool.com/wp-content/uploads/LO-Presentation.zip PPT 
http://www.jordanschool.com/wp-content/uploads/Jordan-LibreOffice-Presentation-11-28-2012.ppt 
PDF 
http://www.jordanschool.com/wp-content/uploads/Jordan-LibreOffice-Presentation-11-28-2012.pdf
Introduction to LibreOffice - Impress - By Aaron Johnson: ODP 
http://www.jordanschool.com/wp-content/uploads/LibreOffice_Impress_Presentation_Created_by_Aaron_Johnson.odp 
PPT 
http://www.jordanschool.com/wp-content/uploads/LibreOffice_Impress_Presentation_Created_by_Aaron_Johnson.ppt 
PDF 
http://www.jordanschool.com/wp-content/uploads/LibreOffice_Impress_Presentation_Created_by_Aaron_Johnson.pdf


Anyone is welcome to take these and modify them as you like, I just ask 
that if you change them that you take out my name (Aaron Johnson) and 
also remove Jordan Catholic School from the presentations as well... 
Credit for my work does not need to be given, you can claim it as your 
own if you desire :)




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 default this has indents and spacings of
 zero. When you past other text into the table, you also paste the
 other text style which may have the indents.

I think that is what I must have done because in some of the cells --
but not all of them -- I did paste text from elsewhere.

 You can highlight the table and select table contents as the style,
 or when you paste you can EditPaste SpecialUnformatted to paste
 without copying the style.

Useful to know that.

I also noticed another default paragraph style called Table Headers
which also has default indents and spacings of zero.  This one
defaults to centering any text in the cells; whereas Table Contents
starts text at the extreme left -- also useful to know.

Regards, Ken Heard


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAlFAQTcACgkQlNlJzOkJmTc+jgCfdRyQV0ZXK6DtjLoMSitrsWBq
d9kAn1jQDzwlW/uhGOQysgD7YNMLa/rO
=1fWx
-END PGP SIGNATURE-

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 tried it.


Last time I looked, the mariadb server and client programs and libraries 
were only available via the ports installation system. This is a no go 
area for me on my OSX server, which is the machine I was using to build 
LO and the native mysql connector. The ports system on my Macbook 
screwed up the LO build by installing libraries that conflict with the 
ones used by the LO build process, so I stopped using my Macbook for 
building LO ages ago.


As far as I know, there are no pre-compiled MariaDB binaries for OSX.

Irrespective of the above, the changes being made in the mysql connector 
code should allow the connector to be built on all platforms where LO 
can be built, even if libmariadb is not already present. If the builder 
wants to use a system-present libmariadb, then there is also a compile 
time option to enable that. Otherwise, the aim is for the libmariadb 
source code to be downloaded at compile time. This currently works on 
Linux (from my build log on a 32bit OS), but I am still awaiting the 
results of test compilations on my OSX server.


Alex




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 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 setup of the combination :


- web server (apache or lighttpd ?) ;

- mysql server ;

- PDO or PDI or mysqli PHP and/or apache modules ;

- phpmyadmin (which is called MyAdmin in PCLinuxOS - a dumbass name 
change for no apparently good reason IMHO, but hey)


Ian has established that he can access his mysql server from the command 
line, so the daemon is running.


However, what he has not shown us, and the following is directed to you, 
Ian :


- is the apache daemon (web server) running - my guess is yes, if the 
phpmyadmin login page actually loads ?


- which modules are installed in the web server ?

- which PHP version and libraries (modules/plugins) are installed ?

The error message that Ian posted is well known, a cursory search on 
Google brings up :


http://stackoverflow.com/questions/13357561/error-1045-cannot-log-in-to-mysql-server-phpmyadmin

and


http://forums.macrumors.com/showthread.php?t=1228893

just for starters.

Things to remember :

- phpmyadmin needs to have an id/pwd combo in order to be able to 
communicate with the mysql server. Usually, this is asked for by the 
post-installation scripts of the distrib you are using, but sometimes, 
this can go wrong, leading the user to think that phpmyadmin has been 
installed and configured successfully when in fact it has not. After 
all, the whole point of phpmyadmin is to be able to administer your 
mysql server via a web interface, so it generally requires extensive 
privileges at the mysql user account level ;


- the file config.inc.php, which is required in order to be able to 
log into the mysql server from the php scripts. Sometimes, this file 
does not get copied, or configured correctly, resulting in the inability 
to log in - the most frequent reason is that this file contains wrong or 
absent information for a default pwd/id combo (hence the links above 
explaining this point);


- as Girvin mentioned, the my.cnf options have changed in more recent 
versions of mysql with regard to network access, both locally and 
remotely, meaning that even on a locally hosted mysql server instance, 
it can be necessary to change the my.cnf file in order to get access via 
TCP, even from a local IP address such as 127.0.0.1




Alex







--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 access) to edit what is, after all, just a text file.



The problem is that the internal IDE is suitable for LO Basic only. At 
the time that Python support became available in OpenOffice.org, the 
developers at Sun deemed that there was no suitably available IDE that 
could be integrated into the program. Nowadays of course, there is a 
fairly large choice of Python IDEs, but even these are not generally 
installed by default in Linux distributions because they are considered 
developer tools, and thus the integration of any one choice into LO is 
rather moot (not to mention space considerations in the size of the 
download that such integration might cause).


Alex


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 
existence of macros in a structure (represented as a tree view in the UI 
under the macro management dialog) were not carried over when you 
upgraded to 4.0.x. I seem to recall that this is actually a known 
limitation (bug) of the migration tool used internally by LO to copy 
over the user configuration from the 3.5.x series to 4.0.x.


You should look for files bearing a xla/xlb extension in your previous 
3.5.x installation and compare them with the ones in your current 4.0 
installation.


Alternatively, deleting your current 4.0 user profile and restarting LO 
to generate a new one, might do the trick as well.



Alex




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 obvious but this case is 
not.  

It would be nice to have a link somewhere about how to choose the right tools 
and what to look for, perhaps a recommendation somewhere like here
https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers
Good luck and happy hunting! 
Regards from
Tom :)  






 From: Alex Thurgood alex.thurg...@gmail.com
To: users@global.libreoffice.org 
Sent: Wednesday, 13 March 2013, 9:54
Subject: [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 access) to edit what is, after all, just a text file.
 

The problem is that the internal IDE is suitable for LO Basic only. At the 
time that Python support became available in OpenOffice.org, the developers at 
Sun deemed that there was no suitably available IDE that could be integrated 
into the program. Nowadays of course, there is a fairly large choice of Python 
IDEs, but even these are not generally installed by default in Linux 
distributions because they are considered developer tools, and thus the 
integration of any one choice into LO is rather moot (not to mention space 
considerations in the size of the download that such integration might cause).

Alex


-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted




-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 http://nabble.documentfoundation.org/file/n4043493/ASTest.ods  

Tests and comments please.

Tink.



--
View this message in context: 
http://nabble.documentfoundation.org/IF-Function-tp4043493.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 sharing!


Aaron C Johnson wrote
 Introduction to LibreOffice - Writer and Calc: 
 ODP
 http://www.jordanschool.com/wp-content/uploads/LO-Presentation.zip
 PPT
 http://www.jordanschool.com/wp-content/uploads/Jordan-LibreOffice-Presentation-11-28-2012.ppt
 PDF
 http://www.jordanschool.com/wp-content/uploads/Jordan-LibreOffice-Presentation-11-28-2012.pdf

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 there is an OLE icon in the
middle of the page.
This refers to the PDF files which should be embedded (or linked) but are
not.
In fact in my system (Windows XP SP3) clicking on those slides immediately
crashes LO (this is not a complain! I'm just trying to get this fixed in LO
;) )
The odd thing is that the links point to e.g.
xlink:href=../Jordan%20-%20LibreOffice%20-%20Standard%20Toolbar.pdf
which should refer to a one level up folder

So, I'm curious: do the slides in those pages look the same in the ppt file
in your computer? Are the PDFs with the toolbar button descriptions in the
same folder? Can you test with the ODP and PDF files in another PC (i.e. not
the one you usually use to present this)?


Aaron C Johnson wrote
 Anyone is welcome to take these and modify them as you like, I just ask 
 that if you change them that you take out my name (Aaron Johnson) and 
 also remove Jordan Catholic School from the presentations as well... 
 Credit for my work does not need to be given, you can claim it as your 
 own if you desire :)

I'm not sure about this but I think the CC license included in the last
slide requires people to ask your permission if they choose not to give you
any credit :)
Actually I would suggest that you included the same CC license on the last
slide of the Introduction to Impress

This will not make people good but at least it will morally press them to be
fair :)



--
View this message in context: 
http://nabble.documentfoundation.org/Intro-to-LibreOffice-Presentations-tp4043445p4043501.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 that is named only with a number, when clicked, 
takes you to the ROW NUMBER in the same sheet, instead of the desired sheet.


Steps to reproduce:

1. Create a new/blank worksheet

2. Create an additional sheet

3. Rename the sheet to any number

4. Add a hyperlink in sheet1, and make the target the other sheet that 
has a number for the name


5. Click the hyperlink

6. Instead of taking you to the desired sheet, you go to the ROW that 
has the same number as the sheet you are trying to go to.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 alex.thurg...@gmail.com 
wrote:


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 tried it.


Last time I looked, the mariadb server and client programs and libraries
were only available via the ports installation system. This is a no go
area for me on my OSX server, which is the machine I was using to build
LO and the native mysql connector. The ports system on my Macbook
screwed up the LO build by installing libraries that conflict with the
ones used by the LO build process, so I stopped using my Macbook for
building LO ages ago.

As far as I know, there are no pre-compiled MariaDB binaries for OSX.

Irrespective of the above, the changes being made in the mysql connector
code should allow the connector to be built on all platforms where LO
can be built, even if libmariadb is not already present. If the builder
wants to use a system-present libmariadb, then there is also a compile
time option to enable that. Otherwise, the aim is for the libmariadb
source code to be downloaded at compile time. This currently works on
Linux (from my build log on a 32bit OS), but I am still awaiting the
results of test compilations on my OSX server.

Alex







--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 both Ubuntu 12.04 and 12.10. I need others to test these on a 
variety of Linux distributions before I can have a final version 
available here.

 If you test one of these, please send an email to me with the results.

--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 to tell LibreOffice that this recovery is no longer needed?

Thanks,

Noel
--
Noel Lodge
lodg...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 insanely stupid, or is this a bug?
 Where I should get blank cells I am getting:   #DIV/O!

 ASTest.ods http://nabble.documentfoundation.org/file/n4043493/ASTest.ods  

 Tests and comments please.

 Tink.

Using the formula in G10 as an example:
=IF(C10*100/B100,C10*100/B10,)
C10 is empty (zero value)
B10 is empty (zero value)
So zero * 100 / zero = Divide by zero error.

One possible alternative (other tests could be added):
=IF(B10,(C10*100/B100,C10*100/B10,))

Dave

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 sheet/tab
 in the same workbook that is named only with a number, when clicked,
 takes you to the ROW NUMBER in the same sheet, instead of the desired
 sheet.
 
 Steps to reproduce:
 
 1. Create a new/blank worksheet
 
 2. Create an additional sheet
 
 3. Rename the sheet to any number
 
 4. Add a hyperlink in sheet1, and make the target the other sheet that
 has a number for the name
 
 5. Click the hyperlink
 
 6. Instead of taking you to the desired sheet, you go to the ROW that
 has the same number as the sheet you are trying to go to.
 

Confirmed.
Version 4.0.1.2 (Build ID: 84102822e3d61eb989ddd325abf1ac077904985)

Dave


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 there is an OLE icon in the
middle of the page.
This refers to the PDF files which should be embedded (or linked) but are
not.
In fact in my system (Windows XP SP3) clicking on those slides immediately
crashes LO (this is not a complain! I'm just trying to get this fixed in LO
;) )
The odd thing is that the links point to e.g.
xlink:href=../Jordan%20-%20LibreOffice%20-%20Standard%20Toolbar.pdf
which should refer to a one level up folder
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 the odp file it worked fine...

So, I'm curious: do the slides in those pages look the same in the ppt file
in your computer? Are the PDFs with the toolbar button descriptions in the
same folder? Can you test with the ODP and PDF files in another PC (i.e. not
the one you usually use to present this)?
I always assumed that this was a native feature to odp and would not 
work properly in ppt format. When I open the ppt version it does not 
work properly, and yes the pdf just shows the OLE icon because a pdf 
isn't dynamic enough to handle something like that.


You're right, I justed tried to open it in LibreOffice 4 and it doesn't 
crash but the embedded pdf's do not load either... I'll have to try it 
on another computer with an older version of LibreOffice but I assure 
you it worked before and I was even able to extract the zip and open it 
on multiple computers running similar versions of LibreOffice so it must 
be some sort of regression bug...

I'm not sure about this but I think the CC license included in the last
slide requires people to ask your permission if they choose not to give you
any credit :)
Actually I would suggest that you included the same CC license on the last
slide of the Introduction to Impress

This will not make people good but at least it will morally press them to be
fair :)
Honestly, I didn't even pay attention that the CC license was even there 
:). That was obviously put there by the LibreOffice guy who made the 
template and posted it to the LibreOffice Templates website...


So I guess if that means it needs to be attributed then that is fine, I 
just didn't want someone to alter it significantly and leave the parts 
in that says 'Jordan Catholic School' and 'Presented By Aaron Johnson' 
but really it's not even that big of a deal...



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 (I do not seem to have a 
config.sample.inc.php file that I can rename!!) and this is what it 
contains ...


/?php//
///* vim: set expandtab sw=4 ts=4 sts=4: *///
///**//
// * Config file view and save screen//
// *//
// * @package PhpMyAdmin-setup//
// *///
//
//if (!defined('PHPMYADMIN')) {//
//exit;//
//}//
//
///**//
// * Core libraries.//
// *///
//require_once './libraries/config/FormDisplay.class.php';//
//require_once './setup/lib/index.lib.php';//
//require_once './setup/lib/ConfigGenerator.class.php';//
//
//$config_readable = false;//
//$config_writable = false;//
//$config_exists = false;//
//check_config_rw($config_readable, $config_writable, $config_exists);//
//?//
//h2?php echo __('Configuration file') ?/h2//
//?php display_form_top('config.php'); ?//
//input type=hidden name=eol value=?php echo 
htmlspecialchars(PMA_ifSetOr($_GET['eol'], 'unix')) ? ///

//?php display_fieldset_top('', '', null, array('class' = 'simple')); ?//
//tr//
//td//
//textarea cols=50 rows=20 name=textconfig 
id=textconfig spellcheck=false?php//

//echo htmlspecialchars(ConfigGenerator::getConfigFile())//
//?/textarea//
///td//
///tr//
//tr//
//td class=lastrow style=text-align: left//
//input type=submit name=submit_download value=?php echo 
__('Download') ? class=green ///
//input type=submit name=submit_save value=?php echo 
__('Save') ??php if (!$config_writable) echo ' disabled=disabled' 
? ///

///td//
///tr//
//?php//
//display_fieldset_bottom_simple();//
//display_form_bottom();//
//?/

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 'x' as the Password but still get 
the same error (1045)!!


I've re-read all the links you sent me but other than renaming the 
sample file (which I don't have) I can see no other suggestion.


Thanks Guys.

IanW
Pretoria RSA




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 the odp file it worked fine...

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.

Aaron C Johnson wrote
I always assumed that this was a native feature to odp and would not
work properly in ppt format. When I open the ppt version it does not
work properly, and yes the pdf just shows the OLE icon because a pdf
isn't dynamic enough to handle something like that.

Agreed for the PDF. But then what is the point of also distributing a PPT
file which you know is incomplete/not functional?

Aaron C Johnson wrote
You're right, I justed tried to open it in LibreOffice 4 and it doesn't
crash but the embedded pdf's do not load either... I'll have to try it
on another computer with an older version of LibreOffice but I assure
you it worked before and I was even able to extract the zip and open it
on multiple computers running similar versions of LibreOffice so it must
be some sort of regression bug...

It doesn't seem to be a regression because it happens in all versions I
tested.
Did the computers you refer to run Windows or another OS?

--
View this message in context:
http://nabble.documentfoundation.org/Intro-to-LibreOffice-Presentations-tp4043445p4043536.html
Sent from the Users mailing list archive at Nabble.com.

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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.  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 tell LibreOffice that this recovery is no longer needed?

Thanks,

Noel
--
Noel Lodge
lodg...@gmail.com




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 offering to recover the damaged database.

Where do I go to tell LibreOffice that this recovery is no longer needed?

Thanks,

Noel
--
Noel Lodge
lodg...@gmail.com

 You should have a folder that contains all your backup files for 
LibreOffice. They should be in
.../libreoffice/3/user/backup or .../libreoffice/4/user/backup depending 
upon your version of LO. I'm not certain where they would be in windows 
other than the path would include these same folders with the back slash 
instead of slash: ...\libreoffice\3\user\backup.
 Deleting all the files in the backup folder could take care of the 
problem. Also, when LO offers to recover the Base file, you should click 
Cancel. You will then have another similar message to which you reply 
accordingly. Finally, you might be give a chance to save the backup file 
(do not do it). After all of that, LO should stop reminding you to 
restore the Base file.


--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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.documentfoundation.org/IF-Function-tp4043493p4043543.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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_ExtensiongetCompatibility=any
Is this correct?
Regards
Heinz

On Wed, 13 Mar 2013 14:05:39 +0100, Dan Lewis elderdanle...@gmail.com wrote:


  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 both Ubuntu 12.04 and 12.10. I need others to test these on a
variety of Linux distributions before I can have a final version
available here.
  If you test one of these, please send an email to me with the results.

--Dan




--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 below Version to get to the download page.

A direct link to the downloads:
http://extensions.libreoffice.org/extension-center/mysql-native-connector/releases/1.0.

--Dan

On 03/13/2013 11:27 AM, Heinrich Stoellinger wrote:

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
elderdanle...@gmail.com wrote:

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 both Ubuntu 12.04 and 12.10. I need others to test these on a
variety of Linux distributions before I can have a final version
available here.
If you test one of these, please send an email to me with the
results.

--Dan

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 elderdanle...@gmail.com wrote:

--Dan

On 03/13/2013 11:27 AM, Heinrich Stoellinger wrote:

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
elderdanle...@gmail.com wrote:

--Dan

--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

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 the coming days and report on the results to you.
I wonder about ONE thing: Even though I specify the name of the database for
the connector, LO-Base displays ALL the additional databases that are defined
on the server. This is unlike JDBC/ODBC where only the ONE DB mentioned in the
definition of the LO-odb-file is shown in the list. Of course one can always
specify MySQL-GRANT-statements as required. But somehow I would prefer to only
see the intended DB.

Kind regards,
Heinz

On Wed, 13 Mar 2013 16:56:41 +0100, Dan Lewis elderdanle...@gmail.com wrote:

--Dan

On 03/13/2013 11:27 AM, Heinrich Stoellinger wrote:

Is this correct?
Regards
Heinz

On Wed, 13 Mar 2013 14:05:39 +0100, Dan Lewis
elderdanle...@gmail.com wrote:

--Dan

--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

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 elderdanle...@gmail.com wrote:


  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 both Ubuntu 12.04 and 12.10. I need others to test these on a
variety of Linux distributions before I can have a final version
available here.
  If you test one of these, please send an email to me with the results.

--Dan




--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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. Auto-filter pop-up arrows and 
column headings were mixed up and wouldn't revert to the proper display.


After closing with a save, when I re-opened, the last sheet I worked on 
opens, file says there are 4 sheets, but I can't access the sheet tabs 
to navigate to the other tabs.  I've opened Calc options/prefs and made 
sure it was set to display sheet tabs in the window.  No luck.


I've spent 8-10 hours on this file with some complicated vlookups, 
formulas, etc. (most of which have been converted to data by now), and I 
need to complete it today or tomorrow and am a bit panicked. Can't think 
of anything else that would cause this, nor how to access the other 
sheets.  Help please!


Thanks!
Carl

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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, hiding the sheet tabs.  I simply clicked the left edge of the 
bottom scroll bar and dragged to the right to uncover the tabs.  Not 
sure how that happened, but it's working now.  Whew!


Thanks,
Carl


On 3/13/13 1:07 PM, Carl Paulsen wrote:

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. Auto-filter pop-up 
arrows and column headings were mixed up and wouldn't revert to the 
proper display.


After closing with a save, when I re-opened, the last sheet I worked 
on opens, file says there are 4 sheets, but I can't access the sheet 
tabs to navigate to the other tabs.  I've opened Calc options/prefs 
and made sure it was set to display sheet tabs in the window.  No luck.


I've spent 8-10 hours on this file with some complicated vlookups, 
formulas, etc. (most of which have been converted to data by now), and 
I need to complete it today or tomorrow and am a bit panicked. Can't 
think of anything else that would cause this, nor how to access the 
other sheets.  Help please!


Thanks!
Carl



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 
transition, so I have no direct experience with this and cannot 
corroborate it.  If it is true, then a warning about this should be 
included with LO documentation referring to using Mariadb.

Girvin Herr


Dan Lewis wrote:
There is development work on a mysql/mariadb connector that Alex 
discovered requiring some changes in how the connecter is built. When 
working with the leading edge source code, I had to install MariaDB. 
Then I was informed that I needed to work with the 4.0 source code. 
That is when I had to re-install Ubuntu. But after that, I was able to 
build two mysql-connector-ooo.oxt: x86 for 32 bit AND x86-64 for 64 
bit. As soon as I can finish everything within these files, I will 
upload them to the Extension section of the LO website. The working 
parts of these files work, but the documentation part is not what it 
should be yet.


--Dan

On 03/12/2013 04:16 PM, Tom Davies wrote:

 Hi :)
Thanks Dan.  That sounds like a bit of a nightmare.  I tend to prefer 
testing new things on a spare machine or on a spare partition but 
it's not always possible.


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 tried it.

Regards from
Tom :)





*From:* Dan Lewis elderdanle...@gmail.com
*To:* users@global.libreoffice.org
*Sent:* Tuesday, 12 March 2013, 18:53
*Subject:* Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB
5.5.30 now available

  But if you should change your mind, you might find it
difficult to
go back to MySQL. I had to re-install Ubuntu 12.04 LST to remove
all of
the MariaDB files. Something similar happened when I tried MariaDB
a few
years ago.

--Dan :-(


On 03/12/2013 01:46 PM, Tom Davies wrote:
 Hi :)
 Just thought a few people here might be interested in the new
release of the drop-in replacement for MySql.  It's especially
good for those wanting to move away from Oracle products.

 Regards from

 Tom :)




 From: MariaDB Announce List annou...@mariadb.org
mailto:annou...@mariadb.org
 To: annou...@mariadb.org mailto:annou...@mariadb.org
 Sent: Tuesday, 12 March 2013, 16:30
 Subject: [MariaDB Announce] MariaDB 5.5.30 now available

 The MariaDB project is pleased to announce the immediate
availability
 of MariaDB 5.5.30.

 This is a bug-fix release. See the Release Notes and Changelog 
for

 details.


 - - Links  - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - -

 MariaDB 5.5.30 Stable (GA)
 - Release Notes:
https://kb.askmonty.org/en/mariadb-5530-release-notes
 - Changelog: https://kb.askmonty.org/en/mariadb-5530-changelog
 - Downloads: https://downloads.mariadb.org/mariadb/5.5.30

 Overview of MariaDB 5.5:
https://kb.askmonty.org/en/what-is-mariadb-55

 APT and YUM Repository Configuration Generator:
 https://downloads.mariadb.org/mariadb/repositories/








--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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
database backup. That is scary - lost data.

I just went searching again for where I read this caveat and came up
with this posting by ppr:kut to LinuxQuestions.org on 1-31-13:

I'm not sure what problems you imagine, but I'm not aware of any
issues. You wouldn't be able to switch easily from MariaDB back to
MySQL once you start using MariaDB specific features, but that's
clear from the start.

You can find this message and others on:

http://www.linuxquestions.org/questions/slackware-14/replace-mysql-with-mariadb-in-slackware-4175447832/

Now that I read it again, it sounds like they might be talking about
Mariadb user features, not database compatibility. Kind of like someone
who moves from msoffice to LO can't go back because they like the LO
features. I would like to know if anyone has tried to go back to MySQL
from using Mariadb and how *physically* successful it was.

Sorry about the confusion.
Girvin

Dan Lewis wrote:
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 config files. Then when I tried to reinstall MySQL,
synaptic insisted on installing a mariadb file instead of the mysql
file. So, I reinstalled Ubuntu 12.04. Now I have MySQL back.

--Dan

On 03/13/2013 02:08 PM, Girvin R. Herr wrote:

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 transition, so I have no direct experience with this
and cannot corroborate it. If it is true, then a warning about this
should be included with LO documentation referring to using Mariadb.

Girvin Herr

Dan Lewis wrote:
There is development work on a mysql/mariadb connector that Alex
discovered requiring some changes in how the connecter is built.
When working with the leading edge source code, I had to install
MariaDB. Then I was informed that I needed to work with the 4.0
source code. That is when I had to re-install Ubuntu. But after
that, I was able to build two mysql-connector-ooo.oxt: x86 for 32
bit AND x86-64 for 64 bit. As soon as I can finish everything within
these files, I will upload them to the Extension section of the LO
website. The working parts of these files work, but the
documentation part is not what it should be yet.

--Dan

On 03/12/2013 04:16 PM, Tom Davies wrote:

Hi :)
Thanks Dan. That sounds like a bit of a nightmare. I tend to
prefer testing new things on a spare machine or on a spare
partition but it's not always possible.

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 tried it.

Regards from
Tom :)

*From:* Dan Lewis elderdanle...@gmail.com
*To:* users@global.libreoffice.org
*Sent:* Tuesday, 12 March 2013, 18:53
*Subject:* Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB
5.5.30 now available

But if you should change your mind, you might find it
difficult to
go back to MySQL. I had to re-install Ubuntu 12.04 LST to remove
all of
the MariaDB files. Something similar happened when I tried MariaDB
a few
years ago.

--Dan :-(

On 03/12/2013 01:46 PM, Tom Davies wrote:
Hi :)
Just thought a few people here might be interested in the new
release of the drop-in replacement for MySql. It's especially
good for those wanting to move away from Oracle products.

Regards from

Tom :)

From: MariaDB Announce List annou...@mariadb.org
mailto:annou...@mariadb.org
To: annou...@mariadb.org mailto:annou...@mariadb.org
Sent: Tuesday, 12 March 2013, 16:30
Subject: [MariaDB Announce] MariaDB 5.5.30 now available

The MariaDB project is pleased to announce the immediate
availability
of MariaDB 5.5.30.

This is a bug-fix release. See the Release Notes and
Changelog for

details.

- - Links - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - -

MariaDB 5.5.30 Stable (GA)
- Release Notes:
https://kb.askmonty.org/en/mariadb-5530-release-notes
-

[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 into the box on page 1 would automatically flow into the box on
the next page but again i just do a manual cutpaste which is annoying and
also never quite works properly.  

Text-box,_how?.odt
http://nabble.documentfoundation.org/file/n4043625/Text-box%2C_how%3F.odt  

Many thanks and regards from 
Tom :)  





--
View this message in context: 
http://nabble.documentfoundation.org/Text-boxes-How-to-set-up-tp4043625.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 looks great.

Tink.



--
View this message in context: 
http://nabble.documentfoundation.org/Intro-to-LibreOffice-Presentations-tp4043445p4043632.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 (new installation) with 
LibreOffice 4.0.1.2 and it did not crash, neither when I extracted the 
zip, nor when I opened the odp directly from the archive without 
extracting (which is not the right way to open it obviously but I wanted 
to cover all bases...)


However, the embedded pdf pages did not load the pdf files like they are 
supposed to... Also, I tried moving the pdf files up one level but it 
did make any difference...



Agreed for the PDF. But then what is the point of also distributing a PPT
file which you know is incomplete/not functional?


The only reason why I created the ppt was for Microsoft Office users, 
and to demonstrate that a presentation in LibreOffice Impress can be 
saved in ppt format and work (almost) perfectly.



It doesn't seem to be a regression because it happens in all versions I
tested.
Did the computers you refer to run Windows or another OS?
When I created the Writer and Calc LibreOffice presentation I actually 
started to create it in LibreOffice 3.5 (or 3.6) in Ubuntu 12.04 and 
then I finished the presentation on LibreOffice 3.5 (or 3.6) on a 
Windows XP SP3 machine at our school.


I am not having very good luck getting the embedded pdfs to load at all 
on any versions of LibreOffice, but I still am not having any crashes 
either... I would suggest that you try to rename Documents and 
Settings\username\Application Data\LibreOffice and try it again since 
this will restore all settings back to default.


I need to try to load the odp version of the presentation on the 
computer that I made the presentation on and report back to you.


Sorry for all of the headache. It's been awhile since I created it and I 
really just wanted to post it somewhere for people at least as a 
starting point if nothing else.


Aaron Johnson

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 connector for
MySQL, group the type of databases contained in it according to use.
Then allow one or a few users access to each group.
With JDBC/ODBC, you have to have a Base file for each database.
Or, you can right click in the list section of the database window to
select Database Properties. There you can change the database you want
to view.
To view only one database at a time using the native connector,
you would have to set the permissions so that only one user can access a
given database other than the administrator. Then you can have base
connected to MySQL and change the user name doing what I mentioned in
the previous paragraph.
Maybe you have a different method of switching databases when you
need to do so.

--Dan

On 03/13/2013 12:46 PM, Heinrich Stoellinger wrote:

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 the coming days and report on the results to you.
I wonder about ONE thing: Even though I specify the name of the
database for
the connector, LO-Base displays ALL the additional databases that are
defined
on the server. This is unlike JDBC/ODBC where only the ONE DB
mentioned in the
definition of the LO-odb-file is shown in the list. Of course one can
always
specify MySQL-GRANT-statements as required. But somehow I would prefer
to only

see the intended DB.

Kind regards,
Heinz

On Wed, 13 Mar 2013 16:56:41 +0100, Dan Lewis
elderdanle...@gmail.com wrote:

--Dan

On 03/13/2013 11:27 AM, Heinrich Stoellinger wrote:

Is this correct?
Regards
Heinz

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 difficulty
reading.
The finished result looks great.

Tink.

Thank you for the awesome feedback :)


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 the curves in the 
background, you might need to have several paragraph styles for 
differences in indentation.


--Dan


On 03/13/2013 03:05 PM, Tom wrote:

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 into the box on page 1 would automatically flow into the box on
the next page but again i just do a manual cutpaste which is annoying and
also never quite works properly.

Text-box,_how?.odt
http://nabble.documentfoundation.org/file/n4043625/Text-box%2C_how%3F.odt

Many thanks and regards from
Tom :)



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 'x' as the Password but still get
 the same error (1045)!!
 

You need to have a mysql user account where the user is root and the
password is x (or whatever password you have declared for the root
user in your mysql server privilege tables.


I was also thinking back to something you mentioned in an earlier mail.
You said you started the mysqld server with --skip-privileges, but did
you then set up the various user accounts and privileges and restart the
mysql server in normal mode (i.e. without skipping privileges) ?

If you start the mysql server with --skip-privileges, then the user
permissions table is ignored, but then I don't think that will work with
phpmyadmin.


Alex




-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 Mariadb was lost from the last
MySQL-compatible database backup. That is scary - lost data.

I just went searching again for where I read this caveat and came up
with this posting by ppr:kut to LinuxQuestions.org on 1-31-13:

You can find this message and others on:

http://www.linuxquestions.org/questions/slackware-14/replace-mysql-with-mariadb-in-slackware-4175447832/

Now that I read it again, it sounds like they might be talking about
Mariadb user features, not database compatibility. Kind of like
someone who moves from msoffice to LO can't go back because they like
the LO features. I would like to know if anyone has tried to go back
to MySQL from using Mariadb and how *physically* successful it was.

Sorry about the confusion.
Girvin

Girvin, Dan

I once updated from MariaDB 5.5.x to MySQL 5.5.y then to MariaDB
5.5.y. I use MariaDB via localhost and found that the permissions are
different. MariaDB default allows apps like MySQL Workbench to do bulk
data inserts from files while MySQL does not. With MySQL I had to use
the CLI version to do the inserts. I was unable to set the permissions
in MySQL to allow MySQL Workbench to do bulk data inserts.

I am using Linux Mint Maya / 13. 64 bit. I have not yet tried the MySQL
Connector and Base (LO 4.0.0.3). This might be an issue between the two
forks.

Jay

Dan Lewis wrote:
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 config files. Then when I tried to reinstall
MySQL, synaptic insisted on installing a mariadb file instead of the
mysql file. So, I reinstalled Ubuntu 12.04. Now I have MySQL back.

--Dan

--
Jay Lozier
jsloz...@gmail.com

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 done on it with Mariadb was lost from the
last MySQL-compatible database backup. That is scary - lost data.

I just went searching again for where I read this caveat and came up
with this posting by ppr:kut to LinuxQuestions.org on 1-31-13:

You can find this message and others on:

http://www.linuxquestions.org/questions/slackware-14/replace-mysql-with-mariadb-in-slackware-4175447832/

Now that I read it again, it sounds like they might be talking about
Mariadb user features, not database compatibility. Kind of like
someone who moves from msoffice to LO can't go back because they like
the LO features. I would like to know if anyone has tried to go back
to MySQL from using Mariadb and how *physically* successful it was.

Sorry about the confusion.
Girvin

Girvin, Dan

I am using Linux Mint Maya / 13. 64 bit. I have not yet tried the
MySQL Connector and Base (LO 4.0.0.3). This might be an issue between
the two forks.

Jay

Jay,
Thanks for the information. I will file it away for the time I migrate
to mariadb.
So, let me get this straight - the mariadb server allows the MySQL apps
to work better than with the MySQL server?! That is amusing.
For the record, I am using Slackware 12.2 32-bit and the
mysql-connector-java with LO 3.6.4.3.

Thanks again.
Girvin

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. Thus, all the work done on it with Mariadb was lost from the
last MySQL-compatible database backup. That is scary - lost data.

I just went searching again for where I read this caveat and came up
with this posting by ppr:kut to LinuxQuestions.org on 1-31-13:

You can find this message and others on:

http://www.linuxquestions.org/questions/slackware-14/replace-mysql-with-mariadb-in-slackware-4175447832/

Now that I read it again, it sounds like they might be talking about
Mariadb user features, not database compatibility. Kind of like
someone who moves from msoffice to LO can't go back because they like
the LO features. I would like to know if anyone has tried to go back
to MySQL from using Mariadb and how *physically* successful it was.

Sorry about the confusion.
Girvin

Girvin, Dan

I am using Linux Mint Maya / 13. 64 bit. I have not yet tried the
MySQL Connector and Base (LO 4.0.0.3). This might be an issue between
the two forks.

Jay

Bulk data inserts: Are you using this to append data to a table?
(Add the data to a table that already contains data) I am not sure I
understand.
I understand importing databases and their data as well as
exporting them. Somehow I do not think that you were talking about
importing databases or exporting them.

--Dan

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 incompatible with
MySQL. Thus, all the work done on it with Mariadb was lost from the
last MySQL-compatible database backup. That is scary - lost data.

I just went searching again for where I read this caveat and came up
with this posting by ppr:kut to LinuxQuestions.org on 1-31-13:

You can find this message and others on:

http://www.linuxquestions.org/questions/slackware-14/replace-mysql-with-mariadb-in-slackware-4175447832/

Now that I read it again, it sounds like they might be talking about
Mariadb user features, not database compatibility. Kind of like
someone who moves from msoffice to LO can't go back because they
like the LO features. I would like to know if anyone has tried to
go back to MySQL from using Mariadb and how *physically* successful
it was.

Sorry about the confusion.
Girvin

Girvin, Dan

I once updated from MariaDB 5.5.x to MySQL 5.5.y then to MariaDB
5.5.y. I use MariaDB via localhost and found that the permissions are
different. MariaDB default allows apps like MySQL Workbench to do
bulk data inserts from files while MySQL does not. With MySQL I had
to use the CLI version to do the inserts. I was unable to set the
permissions in MySQL to allow MySQL Workbench to do bulk data inserts.

I am using Linux Mint Maya / 13. 64 bit. I have not yet tried the
MySQL Connector and Base (LO 4.0.0.3). This might be an issue between
the two forks.

Jay

Jay,
Thanks for the information. I will file it away for the time I
migrate to mariadb. So, let me get this straight - the mariadb server
allows the MySQL apps to work better than with the MySQL server?!
That is amusing.
For the record, I am using Slackware 12.2 32-bit and the
mysql-connector-java with LO 3.6.4.3.

Thanks again.
Girvin

I remember seeing (MySQL website?) where the change was made by MySQL to
not allow this by default for security reasons while MariaDB maintained
the old permissions. What is puzzling to me is that many who use MySQL
or MariaDB via localhost are doing development or off-line database work
and are not using remote access. I understand requiring tighter
permissions if the database can be manipulated remotely to avoid major
problems.

What was odd, I could issue TRUNCATE database but INSERT LOCAL FILE
'sdf.csv' etc would fail. I would think the opposite would be preferable.

--
Jay Lozier
jsloz...@gmail.com

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 somehow, making it incompatible with
MySQL. Thus, all the work done on it with Mariadb was lost from the
last MySQL-compatible database backup. That is scary - lost data.

I just went searching again for where I read this caveat and came up
with this posting by ppr:kut to LinuxQuestions.org on 1-31-13:

You can find this message and others on:

http://www.linuxquestions.org/questions/slackware-14/replace-mysql-with-mariadb-in-slackware-4175447832/

Now that I read it again, it sounds like they might be talking about
Mariadb user features, not database compatibility. Kind of like
someone who moves from msoffice to LO can't go back because they
like the LO features. I would like to know if anyone has tried to
go back to MySQL from using Mariadb and how *physically* successful
it was.

Sorry about the confusion.
Girvin

Girvin, Dan

I once updated from MariaDB 5.5.x to MySQL 5.5.y then to MariaDB
5.5.y. I use MariaDB via localhost and found that the permissions are
different. MariaDB default allows apps like MySQL Workbench to do
bulk data inserts from files while MySQL does not. With MySQL I had
to use the CLI version to do the inserts. I was unable to set the
permissions in MySQL to allow MySQL Workbench to do bulk data inserts.

I am using Linux Mint Maya / 13. 64 bit. I have not yet tried the
MySQL Connector and Base (LO 4.0.0.3). This might be an issue between
the two forks.

Jay

--Dan

Dan

I am importing data into an empty or truncated database. I am not
appending data. I am using INSERT DATA LOCAL FILE etc. for the import.

--
Jay Lozier
jsloz...@gmail.com

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 e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 ( 
http://nabble.documentfoundation.org/Install-path-for-LibreOffice-under-Windows-tp4041530.html
 ) but as we're asking to expedite this adjustment for a 4.0.3 build. solicit 
users and devs lists for any substantive reasons NOT to proceed.

Advantage of placing into a non-versioned installation folder for Windows OS is 
that established configurations and function of 3rd party extensions will 
remain intact across version upgrades.

Expect minimal impact on installation or bundled extensions and Windows 
registry and LibreOffice registry and user profile.  Potential impact on 
migrating user profiles during upgrade, and possibly on 3rd party extensions.

Comments? Substantive objections?



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 string.
The second field contains a plain text string which may occasionally
contain fancy symbols. The third field contains a list of ethnicities
relevant to the organization, delimited by double percent signs (%%). Here
is an example record:

70f9d2,Acme Inc.,Mexican%%Chinese

I have been trying to sort this file by selecting everything and clicking
Data - Sort... When the sort dialog comes up I select column A and
column B as sort keys 1 and 2, respectively. In the options tab, I am
checking the box next to Range contains column labels because my file
does include a header column.

I am getting very strange results when I try to execute the sort. For some
reason, a large number of records are disappearing as a result of the sort.
I am saving a separate file containing the sorted version of the records.
See command log below comparing the line count of both the original and
sorted versions:

$ wc -l company-ethnicities.csv
   55261 company-ethnicities.csv
$ wc -l company-ethnicities-sorted.csv
   30815 company-ethnicities-sorted.csv

A whopping 24446 records are being deleted somehow... why is this? Does
LibreOffice Calc's sort feature also remove duplicates?

FYI: The reason I am not using the sort shell command instead is because it
is also giving me problems (for some reason it's mangling the CSV file and
putting a ton of records into a single field and yes, I did try setting
LC_ALL to C)

Does anyone know what might be causing this? I appreciate any help I can
get on this one.

Thanks.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 ( 
http://nabble.documentfoundation.org/Install-path-for-LibreOffice-under-Windows-tp4041530.html
 ) but as we're asking to expedite this adjustment for a 4.0.3 build. solicit 
users and devs lists for any substantive reasons NOT to proceed.

Advantage of placing into a non-versioned installation folder for Windows OS is 
that established configurations and function of 3rd party extensions will 
remain intact across version upgrades.

Expect minimal impact on installation or bundled extensions and Windows 
registry and LibreOffice registry and user profile.  Potential impact on 
migrating user profiles during upgrade, and possibly on 3rd party extensions.

Comments? Substantive objections?
 Just a question: How will this change affect installing multiple 
versions of LibreOffice?


--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 fully integrated 
/Administrative installations. Just as it has been.

Stuart

From: Dan Lewis [elderdanle...@gmail.com]
Sent: Wednesday, March 13, 2013 10:07 PM
To: users@global.libreoffice.org
Subject: 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 ( 
 http://nabble.documentfoundation.org/Install-path-for-LibreOffice-under-Windows-tp4041530.html
  ) but as we're asking to expedite this adjustment for a 4.0.3 build. solicit 
 users and devs lists for any substantive reasons NOT to proceed.

 Advantage of placing into a non-versioned installation folder for Windows OS 
 is that established configurations and function of 3rd party extensions will 
 remain intact across version upgrades.

 Expect minimal impact on installation or bundled extensions and Windows 
 registry and LibreOffice registry and user profile.  Potential impact on 
 migrating user profiles during upgrade, and possibly on 3rd party extensions.

 Comments? Substantive objections?
  Just a question: How will this change affect installing multiple
versions of LibreOffice?

--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted





-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 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 string.
The second field contains a plain text string which may occasionally
contain fancy symbols. The third field contains a list of ethnicities
relevant to the organization, delimited by double percent signs (%%). Here
is an example record:

70f9d2,Acme Inc.,Mexican%%Chinese

I have been trying to sort this file by selecting everything and clicking
Data - Sort... When the sort dialog comes up I select column A and
column B as sort keys 1 and 2, respectively. In the options tab, I am
checking the box next to Range contains column labels because my file
does include a header column.

I am getting very strange results when I try to execute the sort. For some
reason, a large number of records are disappearing as a result of the sort.
I am saving a separate file containing the sorted version of the records.
See command log below comparing the line count of both the original and
sorted versions:

$ wc -l company-ethnicities.csv
55261 company-ethnicities.csv
$ wc -l company-ethnicities-sorted.csv
30815 company-ethnicities-sorted.csv

A whopping 24446 records are being deleted somehow... why is this? Does
LibreOffice Calc's sort feature also remove duplicates?

FYI: The reason I am not using the sort shell command instead is because it
is also giving me problems (for some reason it's mangling the CSV file and
putting a ton of records into a single field and yes, I did try setting
LC_ALL to C)

Does anyone know what might be causing this? I appreciate any help I can
get on this one.

Thanks.




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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.

https://wiki.documentfoundation.org/Installing_in_parallel#Administrativ_Installation:

Florian will have to address any issues of a non-versioned default installation 
folder on his installer extension. But should not be much of a problem.

Stuart

From: V Stuart Foote
Sent: Wednesday, March 13, 2013 10:15 PM
To: users@global.libreoffice.org
Subject: 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 fully integrated 
/Administrative installations. Just as it has been.

Stuart

From: Dan Lewis [elderdanle...@gmail.com]
Sent: Wednesday, March 13, 2013 10:07 PM
To: users@global.libreoffice.org
Subject: 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 ( 
 http://nabble.documentfoundation.org/Install-path-for-LibreOffice-under-Windows-tp4041530.html
  ) but as we're asking to expedite this adjustment for a 4.0.3 build. solicit 
 users and devs lists for any substantive reasons NOT to proceed.

 Advantage of placing into a non-versioned installation folder for Windows OS 
 is that established configurations and function of 3rd party extensions will 
 remain intact across version upgrades.

 Expect minimal impact on installation or bundled extensions and Windows 
 registry and LibreOffice registry and user profile.  Potential impact on 
 migrating user profiles during upgrade, and possibly on 3rd party extensions.

 Comments? Substantive objections?
  Just a question: How will this change affect installing multiple
versions of LibreOffice?

--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted





-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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