from:"Girvin R. Herr"

Re: [libreoffice-users] where is that configuration file again?

2012-12-23 Thread Girvin R. Herr




Mirosław Zalewski wrote:

On 22/12/2012 at 23:07, "Girvin R. Herr"  wrote:

  
Apparently, I downloaded a pair of PowerPoint files that LO can't handle 
- they cause LO to pop up the "ASCII Filter Options" dialog and when I 
click on OK, LO goes out to lunch.



I have encountered similar problem with one certain PowerPoint file. It opened 
fine on LibreOffice 3.6.4. You may consider upgrade as possible way of solving 
this issue.
  
That worked!  I updated to LO 3.6.4.3 and loaded both powerpoint files 
without any problems. 
Thanks to Miroslaw and all who offered me help on this problem.

Girvin Herr

--
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] where is that configuration file again?

2012-12-22 Thread Girvin R. Herr


Tom,
Thanks.  That was what I was looking for.
Renaming the profile didn't help though.  I think I found a couple of 
Powerpoint files that LO can't handle.  It is either a first for me, or 
the files are corrupt.  I contacted the source to see if something can 
be done.

Thanks.
Girvin



Tom Davies wrote:

Hi :)
https://wiki.documentfoundation.org/Documentation/UserProfile

or look in 
Tools - Options - Paths
to see if you moved it somewhere unusual.  
Regards from
Tom :)  






  

____
From: Girvin R. Herr 
To: LibreOffice Users  
Sent: Saturday, 22 December 2012, 21:36

Subject: [libreoffice-users] where is that configuration file again?

Greetings,
I am having problems with importing a powerpoint file, causing LO to hang and 
crash, and wanted to try renaming the configuration file.  However, I can no 
longer find it.  Previous versions had it in my home directory, but it is no 
longer there.  Can someone point me to that help on finding the configuration 
file for LO 3.5.4?
Thanks.
Girvin Herr


-- 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] where is that configuration file again?

2012-12-22 Thread Girvin R. Herr




Mirosław Zalewski wrote:

On 22/12/2012 at 22:36, "Girvin R. Herr"  wrote:

  
Can someone point me to that help 
on finding the configuration file for LO 3.5.4?



It's ~/.config/libreoffice/ (if you are using Linux, which probably you do - but 
you could mention it in your message).
  

Oops!  You are correct in both - sorry.  I am running Linux.
I found the directory and renamed it, but it didn't solve my problem.  
Apparently, I downloaded a pair of PowerPoint files that LO can't handle 
- they cause LO to pop up the "ASCII Filter Options" dialog and when I 
click on OK, LO goes out to lunch.  Kpresenter can't handle them either.

Thanks.
Girvin


--
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] where is that configuration file again?

2012-12-22 Thread Girvin R. Herr


Greetings,
I am having problems with importing a powerpoint file, causing LO to 
hang and crash, and wanted to try renaming the configuration file.  
However, I can no longer find it.  Previous versions had it in my home 
directory, but it is no longer there.  Can someone point me to that help 
on finding the configuration file for LO 3.5.4?

Thanks.
Girvin Herr


--
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] Value '0000-00-00' can not be represented as java.sql.Date

2012-12-15 Thread Girvin R. Herr

receiver wrote:
I'm trying to create a LibreOffice (3.6.4) Base document which utilizes
a MySQL database. I have installed the MySQL Connector J (5.1.22) and
have good results with one significant exception. The subject error
prevents display of a table which does contain dates. I suspect that
this may be a problem with the JDBC connector and have reported it here
, however
it also seems possible that this is caused by LibreOffice Base.

Any advice on what I may have overlooked would be appreciated.

David ...

--
View this message in context:
http://nabble.documentfoundation.org/Value--00-00-can-not-be-represented-as-java-sql-Date-tp4024569.html
Sent from the Users mailing list archive at Nabble.com.

David,
Try this:
Edit -> Database -> Properties
Select the "Advanced Properties" tab.
Under "Name of the MySQL database", enter:

?zeroDateTimeBehavior=convertToNull

where is the name of your database. No spaces anywhere.
Then click OK.

You may have to close and reopen LO/Base for this to take effect. This
is the string that LO/Base passes to the MySQL connector to open the
database.

I had the same problem with zero dates and times when I read about this
workaround years ago. I was not sure if it is still a problem with the
later versions, but it sounds like it is by your posting.

LO 3.5.7.2, MySQL 5.0.67, mysql-connector-java-5.0.7

Hope this helps.
Girvin Herr

--
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: Pdf import. Was: Fw: Wiki quick guide page - see if this is a good format. . .

2012-12-05 Thread Girvin R. Herr




Tom Davies wrote:

Hi :)
I'm not sure what i did.  Something fairly hideous.  I think i might have used 
Gimp to make it into a Gif or Png image and then inserted that.  I'm kinda 
flailing around with Pdfs at the moment.
Regards from
Tom :)  

  

Tom,
That does sound painful! 
As a test, I was successful at Inserting a PDF as a Draw OLE object in a 
Writer document.  Here is what I did:


  1. Using the PDF importer, I opened the PDF file, which brings up Draw.
  2. While in Draw, I saved the PDF file as an ODF Draw file.
  3. I opened a new Writer document.
  4. Using Insert -> Object -> OLE Object -> LibreOffice 3.5 Drawing, I
 got a Draw window embedded in the Writer document.
  5. Double-click on the Draw object window to bring up the draw OLE.
  6. Open the ODF file saved in step #2.
  7. Click outside the Draw OLE window (anywhere in the document but
 the Draw OLE window) to get out of Draw.
  8. You should have the PDF image from step #1 now in Writer.

Note that the PDF importer does not seem to work if attempting to 
directly open the PDF file in step #6.  It seems to think it is opening 
the PDF in Writer, not the Draw OLE window.  There are many limitations 
to the Draw OLE that the Draw program itself does not have.
You may have to do some scaling or dragging the Draw window tags around 
to get the size you want.  Note that the Object properties dialog has a 
lot to do with formatting this object (right click on the Draw OLE -> 
select Object).

Hope this helps.
Girvin Herr





  

________
From: Girvin R. Herr 
To: Tom Davies  
Cc: Felmon Davis ; "users@global.libreoffice.org"  
Sent: Wednesday, 5 December 2012, 23:34

Subject: Re: [libreoffice-users] Re: Pdf import. Was: Fw: Wiki quick guide page 
- see if this is a good format. . .



Tom Davies wrote:


Hi :)
There are many different sorts of Pdfs (fdf "and what-not" as Amiko says in interviews on Nasa tele).  Sometimes forms can be filled out using a proper Pdf reader such as Foxit (a good Pdf reader in Windows) but sometimes people try to make things difficult so that you are forced into using Adobe's Pdf reader, or use a work-around as you did with the frst one in Draw (sounded like a Pita though).
  

Tom,
Actually, no.  I found it was fairly easy to do in Draw.


One company sent me a Pdf form to fill in and then complained that i returned it as a Pdf!  It had been a bit ilke a multiple choice in that it had one question per line but instead of the choices it just left the rest of the line empty.  I pulled the form into Writer, set it as the background, added a 2 column table on top and adjusted the row's widths to fit the form and then wrote on my layer and saved as Pdf.  I was really chuffed because it's the first time i had managed anything like it with Pdfs but then got a complaint!
  

That was their problem, not yours.  Sounds like they are in the last century.  Unless 
they wanted the ability to change your entries without your permission.  I hope you 
didn't sign it! How did you "pull" the PDF form into Writer?!


Girvin Herr


-- 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] Re: Pdf import. Was: Fw: Wiki quick guide page - see if this is a good format. . .

2012-12-05 Thread Girvin R. Herr

Tom Davies wrote:

Hi :)
There are many different sorts of Pdfs (fdf "and what-not" as Amiko says in interviews on Nasa tele). Sometimes forms can be filled out using a proper Pdf reader such as Foxit (a good Pdf reader in Windows) but sometimes people try to make things difficult so that you are forced into using Adobe's Pdf reader, or use a work-around as you did with the frst one in Draw (sounded like a Pita though).

Tom,
Actually, no. I found it was fairly easy to do in Draw.

One company sent me a Pdf form to fill in and then complained that i returned it as a Pdf! It had been a bit ilke a multiple choice in that it had one question per line but instead of the choices it just left the rest of the line empty. I pulled the form into Writer, set it as the background, added a 2 column table on top and adjusted the row's widths to fit the form and then wrote on my layer and saved as Pdf. I was really chuffed because it's the first time i had managed anything like it with Pdfs but then got a complaint!

That was their problem, not yours. Sounds like they are in the last
century. Unless they wanted the ability to change your entries without
your permission. I hope you didn't sign it!
How did you "pull" the PDF form into Writer?!

Girvin Herr

Re: [libreoffice-users] Re: Pdf import. Was: Fw: Wiki quick guide page - see if this is a good format. . .

2012-12-04 Thread Girvin R. Herr




Tom Davies wrote:

Hi :)
  


Although a lot of programs can now write Pdfs they seldom allow you to edit the 
text as freely as you would edit an Odt or Doc.  They do sometimes allow you to crop and rotate pages and do some fairly rough work like that.  
  



In the last 6 months or so, I had the task of completing two PDF forms 
that organizations sent me to fill out.  I decided to try the LO PDF 
import and use LO to fill out the forms.  In both cases, PDF import 
created a Draw file of pages conforming to each page of the PDF file.  
With the first PDF form, I was not able to modify any text or objects in 
the form.  It was if the original format was a picture.  However, I was 
able to add text boxes over the "picture" and get the form filled out.  
With the second PDF form, I was not only able to add text boxes as 
before, but I was also able to edit the original form text!  What was 
different between the two PDFs?  I haven't a clue.
So, it looks like PDF file editability in LO Draw depends on the 
particular PDF you are trying to edit.

Girvin Herr



--
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: [libreoffice-marketing] Good Article for LibreOffice

2012-11-25 Thread Girvin R. Herr

Tom Davies wrote:

Hi :)
It's interesting that there has been almost no posts about articles such as this one.

https://www.linux.com/news/software/applications/660608-libreoffice-a-continuing-tale-of-foss-success

There are some interesting stats that are very well presented in there and it's worth using to spread the word of how LibreOffice works.

For me one of the key things that no article seems to mention is that while many hefty companies are vanishing seemingly overnight it seems somewhat dangerous to rely on just one. It would be like not making back-ups of critical information!! If we can bear to think of LO and AOO as being similar enough that users can migrate from one to the other fairly easily and thus as being 2 prioducts supported by 1 community then that community is massive. Taken as being 1 product it is so robust that even if 1 or 2 companoes the size of IBM or Google (or RedHat or SUSE) were to simply vanish overnight then there would still be a good product out there. By sticking with MS people are risking everything they have by being so heavily dependant on just 1 company and that company is losing market share to mobile devices. Perhaps Win8 might help them recover the OS battle but it might not.

Regards from
Tom :)

Greetings,
My primary goal is to reduce, or preferably eliminate, risk to my data.
I learned the hard way many years ago that depending on M$ and other
proprietary software suppliers was way too risky. I then decided to
switch to Open Source software and take back control of my computer. I
have never regretted that decision. Even if LO/AOO go away, there are
still other applications, such as Koffice, that will still allow me to
read/maintain my documents & data. And, if it comes down to it, I can
always unzip my LO/OO files and get the data from the file(s) inside.
That allows me to sleep at night.

Girvin Herr

Re: [libreoffice-users] Collate print option not working

2012-11-23 Thread Girvin R. Herr


Greetings,
I finally got time to work on this problem.  As a result of some helpful 
replies to my original posting, I have made some progress with this 
subject problem and I am making this posting in case it may help others. 

I changed my CUPS printer driver from the "HP Laserjet 8150 Series 
Postscript (en)" to the "HP Laserjet 8150 - CUPS+Gutenprint v5.2.2" 
driver and now I can print the LO-generated PDF file of my 3-page 
document in Adobe Acrobat reader 9 perfectly.  Collation and number of 
copies (2) are correct.  Since Reader 9 now prints the correct number of 
copies and collation, the problem is no longer the CUPS driver. 

With that baseline said, LO printing now prints double the number of 
copies (4 in this case of specifying 2), but the collation is now 
correct (1-2-3-1-2-3-1-2-3-1-2-3).  So, there still seems to be 
something wrong with LO printing in this area.  I just tried specifying 
the number of copies at 3 and got 9 copies!!  So this is not merely 
doubling, it is squaring!!  In deference to the forests of the world, I 
am not going any higher in copies with this testing.


This problem is not a show-stopper for me.  I have other ways to print 
multiple copies.  I just found this LO printing action as something 
unexpected.


Thanks to everyone who replied to my original posting.
Girvin Herr



Girvin R. Herr wrote:


Webmaster,
See below for answers to your questions.

webmaster-Kracked_P_P wrote:

What version of Linux are you using?  Ubuntu, Linux Mint, Fedora, 
Opensuse, etc., etc.?

Slackware 12.2 (K2.6.27)


Since you run Linux, can you try creating a PDF file for your 
document and then use the "default viewer" package for PDF to open 
it.  Then go to your printer's options and try to print 2 or 3 copies 
of the document with the collate option.
Now that got interesting!  I tried this using Adobe Acrobat Reader to 
print the PDF file and although I selected 2 copies, collated, I got 
one copy!  I then tried 3 copies and still only got one copy.


What printer are your using?  Which driver set? 
Original-manufacture-style, CUPS-style or GhostScript-style? Manually 
installed or did the Linux version find the printer driver and 
installed it automatically?
I am using an HP Laserjet 8150DN, CUPS 1.3.11, on "AppSocket/HP 
JetDirect" and the "HP Laserjet 8150 Series Postscript (en)" driver.  
When I installed it, CUPS found the printer on my network 
automagically with the "Find New Printers" option, but I continued to 
install it manually using the CUPS "wizard".  I did not opt for the 
Foomatic or Gutenprint drivers, thinking they would not be needed, 
since the printer has Postscript emulation, and a simple Postscript 
driver should suffice.  Now I may go back and rethink that decision.  
I noticed there are two other drivers I may try: Foomatic and CUPS 
Gutenprint v5.2.2.



Try the Export to PDF for one copy of the document and then try and 
print the duplex and collated document that way.  If it works, then 
it is a LO printer option issue.  If it does not work properly, then 
it is a printer/driver issue.  My Epson has a problem with LO and my 
HP has a driver issue, the last time I tried it - which was a few 
months back when I was still running Ubuntu 10.04.


Thanks for the help.  You may be onto something with the driver.  I 
will try the other drivers and report back.

Girvin Herr




--
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: Adding .pdf Images to Document

2012-11-20 Thread Girvin R. Herr




NoOp wrote:

On 11/20/2012 06:08 AM, Rich Shepard wrote:
  

On Mon, 19 Nov 2012, Girvin R. Herr wrote:


Okay, I was incorrect.  I thought I did open a PDF in Writer.  But it must 
have been Draw, not Writer.  Sorry.
I just did some work on this problem and discovered a way to do it.  Here is 
what I did:


  In Writer,
  Insert -> Object -> OLE Object ->
  In the dialog that comes up, Click on "Create from file" at the top.
  In the dialog that comes up, Click on "Select..." to bring up the
  file browser.
  Select the PDF file you want to insert.
  Click on "Open".
  Click on OK.
  

Girvin,

   Thank you. I think that converting .pdf to .eps will be quicker so I'll
try that first.


...

Just be aware of some EPS issue in LO (and AOO):

1. EPS images in LO will only show the 'image preview'. The thread from
this list is worth a read:
<http://listarchives.libreoffice.org/global/users/msg02032.html>

2. You will most likely experience serious scrolling issues in a
document with a large EPS. A simple example of this is:

<https://bugs.freedesktop.org/show_bug.cgi?id=37837>
Download and try the attachment:
<https://bugs.freedesktop.org/attachment.cgi?id=47445>
and you'll see what I mean. Open the TOP in a terminal & set to remain
on top. Open the attachment .odt and try to scroll to the bottom of page
2 (where the EPS is embedded). You'll see a significant delay & if you
watch TOP, you'll see that soffice first calls up gs (Ghost Script) &
then convert (ImageMagick), and then finally will display the image preview.

You can imagine what viewing the document will be like with multiple EPS
images...
  

NoOp,
I'll second that!  That was exactly my experience with many EPS images 
in a Writer document I was working on. 
I had anecdotal evidence, but you state factual evidence (the links).

Thanks.
Girvin Herr


--
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] Adding .pdf Images to Document

2012-11-20 Thread Girvin R. Herr

Tom Davies wrote:

Hi :)
Eps?? Are you sure? I seem to have trouble with my Epses but that is probably either my fault or some weirdness of the program producing the Eps (i think Adobe Creative something, an expensive product that tries to force other people into buying it.) So, is there somewhere i can test an Eps to see how well it conforms to what it should be?
Regards from
Tom :)

Tom et. al.,
Beware of inserting EPS images into a document! I was composing a
document with many images that I scanned in and used EPS because the
resulting files were smaller than Jpeg or PNG. As I was inserting the
EPS images, scrolling through these images got slower and slower. It
finally got unbearable and I was still not finished inserting images.
It seemed like the LO EPS renderer was inefficient or the file format
was inefficient and took a lot of system resources to render the
images. I tried increasing the LO graphics RAM allocation, but that did
not help. I finally switched to Jpeg versions and as I replaced the EPS
images with the Jpeg equivalents, scrolling through the document got
faster and faster.

Girvin Herr

Re: [libreoffice-users] Adding .pdf Images to Document

2012-11-19 Thread Girvin R. Herr




Girvin R. Herr wrote:



Rich Shepard wrote:

On Mon, 19 Nov 2012, Girvin R. Herr wrote:


Insert -> Picture -> From file
Hope this helps.


Girvin,

  That's what I kept trying but it would not open a file dialog box and
would not accept the file name in the text entry widget on the "picture"
tab.

Rich




Okay, I was incorrect.  I thought I did open a PDF in Writer.  But it 
must have been Draw, not Writer.  Sorry.
I just did some work on this problem and discovered a way to do it.  
Here is what I did:


   In Writer,
   Insert -> Object -> OLE Object ->
   In the dialog that comes up, Click on "Create from file" at the top.
   In the dialog that comes up, Click on "Select..." to bring up the
   file browser.
   Select the PDF file you want to insert.
   Click on "Open".
   Click on OK.

The PDF file should come up in Writer as an embedded Draw OLE object.  
You will most likely have to adjust the frame margins on the page if you 
want the PDF object to cover the full page.  You may be able to edit the 
PDF image by double clicking on the Draw window, which brings up Draw 
with the image.  I say "may", because from my experience, some PDFs 
allow editing in Draw and some do not.  I was not able to insert the PDF 
file directly into the Writer document.  If you open a PDF file, it will 
come up in Draw and if the PDF has multiple pages, Draw will have 
multiple pages, something like Impress.  Someone else suggested copying 
the image in Draw and pasting it into Writer, but when I tried that, it 
did not work.  If someone has done that successfully, I would like to 
know how.  Also, if the PDF is opened with Draw and saved as an odg 
file, one would think the odg could be inserted into a Writer document, 
but I was unsuccessful trying to do that.  That said, there may still be 
other ways to do this.  With enough time, those ways may be discovered.


Hope this helps.
Girvin Herr


--
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] Adding .pdf Images to Document

2012-11-19 Thread Girvin R. Herr




Rich Shepard wrote:

On Mon, 19 Nov 2012, Girvin R. Herr wrote:


Insert -> Picture -> From file
Hope this helps.


Girvin,

  That's what I kept trying but it would not open a file dialog box and
would not accept the file name in the text entry widget on the "picture"
tab.

Rich


Oops!  Sorry, I had so many windows up, I must have clicked on the wrong 
one and sent my incomplete reply.
As I was saying, check to see if you have the "PDF Import" extension.  
(Tools -> Extension manager) 
Other than that, I don't know why you are not getting the file open 
dialog.  I am running Linux LO 3.5.7.2 and it works fine for me.  Maybe 
someone else can explain that.

You might also give some more information, like OS and LO versions.
Girvin Herr


--
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] Adding .pdf Images to Document

2012-11-19 Thread Girvin R. Herr




Rich Shepard wrote:

On Mon, 19 Nov 2012, Girvin R. Herr wrote:


Insert -> Picture -> From file
Hope this helps.


Girvin,

  That's what I kept trying but it would not open a file dialog box and
would not accept the file name in the text entry widget on the "picture"
tab.

Rich



What version of OO are you using?
Check to see if you have the

--
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] Adding .pdf Images to Document

2012-11-19 Thread Girvin R. Herr




Rich Shepard wrote:

  I need to provide a client with a Word version of a report written in
LaTeX. Exporting the text to LO format works just fine, but all the 
images

in the document are .pdf files generated by GRASS or R. I'm having
difficulty finding how to insert these images in the LO document.

  Please point me in the right direction.


Insert -> Picture -> From file
Hope this helps.
Girvin Herr


TIA,

Rich




--
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: OpenOffice to be dumped in Freiburg ?

2012-11-19 Thread Girvin R. Herr




M Henri Day wrote:

2012/11/19 VA 

  

At the risk of getting political, the last thing I want is my government
dictating to me what kind of file format to use on my documents.

Virgil




At the risk of getting political, the last thing I want is a multi-national
corporation, responsible to no one save a few major shareholders and/or top
executives, which, due to its domination of the market, can effectively
render it manditory for me to use its proprietary file format

Regulation of markets, so that they remain as free and accessible as
possible, is one of the principle tasks of government

Henri

  

+2
Girvin Herr


--
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: OpenOffice to be dumped in Freiburg ?

2012-11-19 Thread Girvin R. Herr




Steven Bradley wrote:

I remember this discussion a few years back, when MSO was the defacto
standard, and a moving target. One of the most important things for any
agency, company government, or individual is backward compatibility. I have
many documents that are difficult for me to retrieve, and I wrote them less
than 20 years ago, using DOS programs.  I can only imagine what things will
be like in 30 years for those "old" files. I believe it's of paramount
importance, even in this age of rapid development and change, to realize
that electronic storage of documents is the wave of the future. They must
all be stored in a simple-to-access format that any program can read, not
just the latest flavor of the "big boy."  I am actually fairly concerned
about this, since the concept of proprietary file types has never been
addressed by any government agency (it would be easy, for example, for the
USGovt to mandate that all files be maintained with the formatting in a
separate file.  If a large govt (China, the US, EU) mandated that simple
change, then all files would cease to be proprietary, except for formatting
changes.  One might lose the formats, but the file itself would have a
permanence that most files do not now have.  I might also suggest that the
file formatting be subject to some sort of regulation (yes, they CAN do
that!), which makes all formatting retrievable, no matter how long it's
been since the file was created.
Otherwise, we'll all lose a huge amount of information.
That's my opinion.  YMMV
Steve Bradley

  

+10
Girvin Herr




--
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] LO Base Reports

2012-11-19 Thread Girvin R. Herr




Ian Whitfield wrote:

Hi All

Since I upgraded to LO 3.6.2.2 on my PCLOS 2012 system I find that 
Base no longer displays my Reports the way I need them!!


I used to get a single line of 'Field Names' followed my multiple 
lines of data.


What I get now is alternating lines of 'Field Names' and one row of 
data. (I've tried all the options given and they all do this!!)


How can I get back to my original layout??
I don't know how or why your report got changed, but you should be able 
to drag the fields back to where you want them in the report editor.  It 
sounds like your field names are now located in the detail section 
rather than the heading section.  You don't say what version you 
upgraded from, but lately, LO is bundling the Oracle Report Builder 
extension, which may have changed something if you weren't using it 
before the upgrade. 


Second problem - I have a need to produce a file, with the data in the 
format "Field_One|Field_Two". I was given the SQL Command of 
"PrefFirstName" || '|' || "Email" but failed to make a note of how I 
set this up in the Report.

(All I get now is a syntax error - whatever I try)

Have you looked at using the MySQL CONCAT_WS function in a query?  This 
function allows you to concatenate fields, and specify a field delimiter 
string, into a single line of text.  For example:


   CONCAT_WS('|',` Field_One`,`Field_Two`)

should result in the format you specified.  In my case, I am using it in 
a SELECT clause to format my supplier data inside a form listbox.  It 
displays the name, address, etc, separated by ' | ' strings so the 
fields are not all run together.  It isn't fixed columns, but it works 
well enough for me.

Can someone please put me right!!

Thanks a lot

IanW
Pretoria RSA.


Hope this helps.
Girvin Herr


--
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] Collate print option not working

2012-11-13 Thread Girvin R. Herr



Webmaster,
See below for answers to your questions.

webmaster-Kracked_P_P wrote:

What version of Linux are you using?  Ubuntu, Linux Mint, Fedora, 
Opensuse, etc., etc.?

Slackware 12.2 (K2.6.27)


Since you run Linux, can you try creating a PDF file for your document 
and then use the "default viewer" package for PDF to open it.  Then go 
to your printer's options and try to print 2 or 3 copies of the 
document with the collate option.
Now that got interesting!  I tried this using Adobe Acrobat Reader to 
print the PDF file and although I selected 2 copies, collated, I got one 
copy!  I then tried 3 copies and still only got one copy. 



What printer are your using?  Which driver set? 
Original-manufacture-style, CUPS-style or GhostScript-style? Manually 
installed or did the Linux version find the printer driver and 
installed it automatically?
I am using an HP Laserjet 8150DN, CUPS 1.3.11, on "AppSocket/HP 
JetDirect" and the "HP Laserjet 8150 Series Postscript (en)" driver.  
When I installed it, CUPS found the printer on my network automagically 
with the "Find New Printers" option, but I continued to install it 
manually using the CUPS "wizard".  I did not opt for the Foomatic or 
Gutenprint drivers, thinking they would not be needed, since the printer 
has Postscript emulation, and a simple Postscript driver should 
suffice.  Now I may go back and rethink that decision.  I noticed there 
are two other drivers I may try: Foomatic and CUPS Gutenprint v5.2.2.



Try the Export to PDF for one copy of the document and then try and 
print the duplex and collated document that way.  If it works, then it 
is a LO printer option issue.  If it does not work properly, then it 
is a printer/driver issue.  My Epson has a problem with LO and my HP 
has a driver issue, the last time I tried it - which was a few months 
back when I was still running Ubuntu 10.04.


Thanks for the help.  You may be onto something with the driver.  I will 
try the other drivers and report back.

Girvin Herr


--
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] Collate print option not working

2012-11-12 Thread Girvin R. Herr


Tom,
Actually, no, this is not the first time I have seen this behavior.  I 
rarely print multiple copies, but I have seen this happen before, within 
about 6 months.  That previous time, I was using LO 3.5.3.


Okay, this is really strange.  I just tried it again and got 
1,2,1,2,3,3!  I might add that I am printing duplex, which may 
complicate the LO algorithm.  I tried another 3-page document and it 
behaved the same way.  I then expanded it to 4 pages and got 
1,2,1,2,3,4,3,4.  Where 1 & 2 and 3 & 4 are on the same sheets, just 
opposite sides.  Weird.  I just tried doing the same thing with a Calc 
spreadsheet and got the same results.  So the problem is with LO, not 
just Writer.

Girvin



Tom Davies wrote:

Hi :)
I think i had a similar problem last week on Windows.  The next time i tried pritning it did collate but i have no idea why it didn't work or why it magically startedd workign again.  I thought it was just me stuffing-up that one time.  


So, it's interesting to hear it might be an intermittent problem.  I take it 
that this is the first time that collating has not worked?  Did work previously?
Regards from
Tom :)  







  

________
From: Girvin R. Herr 
To: LibreOffice Users  
Sent: Monday, 12 November 2012, 22:19

Subject: [libreoffice-users] Collate print option not working

Greetings,
Has anyone else noticed that the "Collate" option in the print dialog is not 
working?!
I wanted to print 2 copies of a 3-page document and I selected "Collate".  However, the 
pages came out 1,1,2,2,3,3 not the 1,2,3,1,2,3 that I expected.  So, I unselected 
"Collate" and it still came out 1,1,2,2,3,3!
Is there some other setting controlling this or is it a bug I should look into?
Running LO 3.5.7.2 under KDE 3 and Linux.
Thanks in advance.
Girvin Herr


-- 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] Collate print option not working

2012-11-12 Thread Girvin R. Herr


Greetings,
Has anyone else noticed that the "Collate" option in the print dialog is 
not working?!
I wanted to print 2 copies of a 3-page document and I selected 
"Collate".  However, the pages came out 1,1,2,2,3,3 not the 1,2,3,1,2,3 
that I expected.  So, I unselected "Collate" and it still came out 
1,1,2,2,3,3!
Is there some other setting controlling this or is it a bug I should 
look into?

Running LO 3.5.7.2 under KDE 3 and Linux.
Thanks in advance.
Girvin Herr


--
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] Connecting LO Base to an SQL DB [SOLVED]

2012-11-06 Thread Girvin R. Herr




Ian Whitfield wrote:

Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!)

You have all added some pieces to the Jigsaw and I'm pleased to say..

*I now have Base working with a MySQL Database (at last!!)*





IanW
Pretoria RSA.


Ian,
Glad to hear you got it working.

For importing your data, you might check the mysqlimport command.  I 
used it a long time ago when I needed to get data from some MS Access 
files.  In Access, I was able to save the data as a CSV file and then 
import the CSV file into my MySQL database tables.  Here are two scripts 
I used to perform that task:
This one I called msqnewimport which deletes any data in the table 
before loading the CSV file


   #!/bin/sh
   # Import a ".csv" data file into a mysql table of the same name.
   # Original database data is deleted first. This creates new data.
   # Usage: msqnewimport  <.csv>
   #
   mysqlimport --local --delete --fields-terminated-by=,
   --fields-enclosed-by='"' --lines-terminated-by='\r\n' \
   -p -u  $1 $2

This one I called msqimport and it appends the CSV file data to the 
existing data in the table.


   #!/bin/sh
   # Import a ".csv" data file into a mysql table of the same name.
   # Original database data is preserved.The new data is appended.
   # Usage: msqimport  <.csv>
   #
   mysqlimport --local --fields-terminated-by=,
   --fields-enclosed-by='"' --lines-terminated-by='\r\n' \
   -p -u  $1 $2

Replace  with your MySQL user name.
For more information on mysqlimport, see the manpage.

You may be interested in the MySQL database backup process as well.  
MySQL has a program, mysqldump, that writes an SQL file which can be 
used to restore a database later.For example:


   mysqldump --user=root -p --opt  > .sql

To restore, use:

   mysql --user=root -p  < .sql

Note the "<" and ">" redirection characters.  These programs use stdio 
for output and input, respectively.


It has been my experience that recreating forms and reports is a time 
consuming problem when changing database clients.  I am very reluctant 
to change a database client for this very reason.  It has also been my 
experience that for reports, Base's Oracle Report Builder (ORB) is 
problematic.  For small tables, ORB works fairly well and generates 
reports at a reasonable speed.  For large tables, however, it bogs 
down.  I have a table with over 5000 records and still growing.  My 
latest try with this table and LO 3.5.7/ORB 1.2.1 generated over 500 
writer pages.  That bogged ORB down, although it is working better with 
LO 3.5.7 than LO 3.5.3.  3.5.3 was so slow as to be unusable.  I have 
even tried a 3rd party report builder called DataVision, which has its 
own set of problems, is immature, and seemingly no longer active (last 
release was in 2008).  There are also proprietary (and not free) report 
builders out there that are reported to be mature and work fine. (No pun 
intended).

Hope this helps.
Girvin





--
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] Installation of Help Pack For LibreOffice 3.6.2

2012-11-04 Thread Girvin R. Herr

Tiziano,
Good.  I am glad you got it working.
Yes, the help is out-dated.  But it comes in handy now and then.
Girvin

Tiziano Bianchi wrote:

Thanks for the offer, Girvin.
I was able to successfully install the Help Pack using the command 
"rpm2txz", so everything is ok.  (However, Tom is right in saying that 
the Help Pack is quite outdated...)

--
tb

    *From:* Girvin R. Herr 
*To:* Tiziano Bianchi 
*Cc:* "users@global.libreoffice.org" 
*Sent:* Sunday, November 4, 2012 2:48 PM
*Subject:* Re: [libreoffice-users] Installation of Help Pack For
LibreOffice 3.6.2

Tiziano Bianchi wrote:
> I am using Linux Slackware 13.37, 32-bit.  I am fairly novice
with Linux.
>
> I have installed LibreOffice 3.6.2 using the SlackBuilds.com
<http://slackbuilds.com/> script (I modified the line which starts
with VERSION).
> Now I would like to also install the corresponding Help Pack,
available here:
> 
http://www.libreoffice.org/download/?type=rpm-x86&lang=en-US&version=3.6.2

>
> Does anyone know how to do it?  There is no SlackBuilds.com
script that I
>  could find and Google did not turn up anything helpful in this
respect...
> I will post the same question on LinuxQuestions.org (Slackware
forum).
> 
Tiziano,

Have you resolved this problem?
I have created a SlackBuild script to repackage both LO and the
helppack into a single Slackware installation package.  However, I
was reluctant to send it to you because it is not tested with
Slack 13+.  I am using Slack 12.2.  I can tweek it for 13+ for
you, but I still can't test it, so it may still need a bit of work
to get it to work on your system.  If you want to try it, let me
know and I can tarball it and the other files I use to repackage
LO for Slack and send it to you. Note: My SlackBuild script does a
lot more than the usual SlackBuild scripts, but it is commented
fairly well.
Girvin Herr

--
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] Installation of Help Pack For LibreOffice 3.6.2

2012-11-04 Thread Girvin R. Herr

Tiziano Bianchi wrote:

I am using Linux Slackware 13.37, 32-bit. I am fairly novice with Linux.

I have installed LibreOffice 3.6.2 using the SlackBuilds.com script (I modified the line which starts with VERSION).

Now I would like to also install the corresponding Help Pack, available here:
http://www.libreoffice.org/download/?type=rpm-x86&lang=en-US&version=3.6.2

Does anyone know how to do it? There is no SlackBuilds.com script that I
could find and Google did not turn up anything helpful in this
respect...

I will post the same question on LinuxQuestions.org (Slackware forum).

Tiziano,
Have you resolved this problem?
I have created a SlackBuild script to repackage both LO and the helppack
into a single Slackware installation package. However, I was reluctant
to send it to you because it is not tested with Slack 13+. I am using
Slack 12.2. I can tweek it for 13+ for you, but I still can't test it,
so it may still need a bit of work to get it to work on your system. If
you want to try it, let me know and I can tarball it and the other files
I use to repackage LO for Slack and send it to you.
Note: My SlackBuild script does a lot more than the usual SlackBuild
scripts, but it is commented fairly well.

Girvin Herr

Re: [libreoffice-users] Connecting LO Base to an SQL DB

2012-11-03 Thread Girvin R. Herr


Ian,
It sounds like you are getting close, but there is still something 
blocking your access to the MySQL server (mysqld).  All of these 
symptoms sure sound like the server is not looking at the localhost port.


Ian Whitfield wrote:



I do _NOT_ have this file in my system. I did a search and found this ...

# Shorewall version 4 - MySQL Macro
#


I am not familiar with your "Shorewall" system. I doubt this is 
related.  There are many distributions of Linux and each one has its own 
way of configuring the processes.  What I described is from Slackware 
Linux.  Your's must be different, but I included the Slackware files in 
case they may point you in a good direction.

Here are some things to try:

  1. Look at "/etc/my.cfg", the mysqld configuration file.  The mysqld
 server reads this file for configuration information when it boots
 up.  If there is a "skip-networking" entry in there, comment it
 out with a "#" in column 1.  Then restart mysqld or reboot.  If
 you can't find the my.cfg file in /etc, then search for it
 elsewhere on your system.

  2. ping localhost
 You should get responses.  (Ctrl-c will stop ping.)  If you get
 something like "destination unreachable" or "unknown host", then
 localhost is not configured on your system.  That could hang up
 Base.  Linux installation should do this for you, but maybe your
 distro does not.  If it isn't there, you could add it to "/etc/hosts":

 127.0.0.1   localhost

 Your system may need a reboot.  You could try pinging localhost
 again after you add it to /etc/hosts to determine if you need to
 reboot.

I highly recommend reading the Section "Post-Installation Setup and 
Testing" in the MySQL Reference Manual.  This document is a good source 
for configuring and testing MySQL.  http://dev.mysql.com/doc/



Started Base and selected my old DB to get to the Edit screen - BUT 
when I go there "Connection Type" is grayed out!!
Tried again selecting the new SQL DB but again the "Connection Type" 
is grayed out!!
I don't understand what you mean by "new SQL DB"?  Did you try creating 
a new Base database connection with the wizard?


Is edit -> database -> Properties grayed out too?
You can set up the connection host and port in edit -> database -> 
Properties -> Additional Settings.


   Host name should be localhost.
   Port number should be 3306
   MySQL JDBC driver class should be com.mysql.jdbc.Driver if you are
   using JDBC. 

For reference, I am using  mysql-connector-java-5.0.7 with MySQL 5.0.67 
and LO 3.5.3 .  Not the latest, but it works.
Under edit -> database -> Properties -> "Advanced Properties", you can 
set up the database name and authentication:


   "Name of the MySQL database" is the name of the database you used in
   the CREATE DATABASE mysql statement.
   "User name" is the user name you used in the GRANT statement
   "Password required" should be checked if you set up a password in
   the GRANT statement.

If you made any changes from the above suggestions, can you now go 
through the Base database installation again without any problems?
Carried on with the Base page and put in all the details - 'Test 
Class' gives me "Succesful"

But 'Test Connection' still gives me the "Communication Failure"!!

This sounds like Base still can't talk to the server through localhost.
The var/lib/mysql Folder is there but is EMPTY(??)! (and has no 
permissions) and I can not delete it.
Are you looking at /var/lib/mysql as "root"?   If not, it will look 
empty and if you try to enter the directory, err, folder, you should get 
a permission error if not root.  There should at least be entries in the 
log from your use of mysql-secure-installation and mysql_install_db.  
Oops!  I don't think I told you about "mysql_install_db"?  If not, 
that's my bad.  I am sorry I left it out.  That needs to be run before 
anything else, including the mysqld server.  Here is the correct 
sequence of configuration:


   (set up my.cfg)
   mysql_install_db --user=mysql #creates the databsae structures.
   mysqld_safe  --user=mysql &   #script to run the mysqld server.
   NOTE: sometimes called safe_mysqld
   mysql_secure_installation #removes insecure
   files/structures.
   mysql --user=root -p mysql  #Allows you to create your
   databases, user names, permissions, etc.
   (set up Base)

This is documented in the Section "Post-Installation Setup and Testing" 
in the MySQL Reference Manual.
After running this sequence, the /var/lib/mysql directory should contain 
your database files, the error log, and other mysql internal files.  
Since these are sensitive files, only root can see/access them. 

I know this is a lot to take in, but not being at your system means I 
have to throw out a lot of possibilities and suggestions.
Installing MySQL and getting Base working with it is not trivial, as you 
have seen.  As far as I know, there is no one document to describe the 
pro

Re: [libreoffice-users] Connecting LO Base to an SQL DB

2012-11-02 Thread Girvin R. Herr




Ian Whitfield wrote:

On 11/01/2012 11:14 PM, Girvin R. Herr wrote:

Ian,
Are you starting mysqld with "--skip-networking"?
If so, then remove it for "localhost" access.  LO Base uses localhost 
to access mysqld and will give a failed to connect error if it can't 
connect via localhost.  MyAdmin does not use localhost to connect, so 
it would work fine while Base will not.


No Gavin I am not!! MySQL starts automatically at Boot.




IanW
Pretoria RSA.


Ian,
If mysqld starts automatically at boot, then, like my Slackware system, 
you probably have a system script somewhere that starts mysqld.  The 
--skip-networking may be in that script.  In Slackware, it is 
"/etc/rc.d/rc.mysql" which has a macro definition in the beginning: 
"SKIP=--skip-networking".  Simply commenting that line out with a # in 
column one enables network (localhost) access.  You might check for 
something like that on your system.


In case it will help, here are the commands I use to configure MySQL and 
create my databases:


   *

 Before first MySQL use, at the shell enter:
 "mysql_secure_installation" to set the root password, remove the
 "test" database, and remove network root access. This program will
 prompt for these items.  Note that removing network root access
 only applies to remote root MySQL logins, it does not disable all
 network access as in --skip-networking.

   *

 At the shell, enter: "mysql --user=root -p mysql" to bring up the
 MySQL monitor program. While in this program, the prompt will
 change to "MySQL> ". Enter the following commands, terminated by a
 semicolon (;):

 GRANT ALL PRIVILEGES ON *.* TO @localhost IDENTIFIED BY
 '' WITH GRANT OPTION;

 GRANT ALL PRIVILEGES ON *.* TO @"%" IDENTIFIED BY
 '' WITH GRANT OPTION;

 GRANT ALL PRIVILEGES ON *.* TO admin@localhost IDENTIFIED BY
 '' WITH GRANT OPTION;

 GRANT RELOAD,PROCESS ON *.* TO admin@localhost ;

 CREATE DATABASE ;
 CREATE DATABASE ;
 .
 .
 exit

These installation & setup instructions are in the MySQL Reference 
Manual on the MySQL website or in the documentation directory of your 
computer (should be installed when MySQL is installed).


You should then do the following tests:
Assuming LO Base is already setup, in Base drill down as:

   Edit -> Database -> Connection Type  -> Next -> Test Connection
   (enter your password when asked)

   You should get the message: "...connection was established successfully"

Then continue:

   OK -> Next -> Test Class

   You should get the message: "JDBC driver loaded successfully"
   (This assumes you are using JDBC)

If either of these tests do not work, then there is still something 
wrong in your configuration.
If the first test fails, then the problem may be the --skip-networking 
issue.
If the first test is okay but the second test fails, then it is most 
likely your JDBC driver configuration.


You might also check the MySQL error log in 
"/var/lib/mysql/.err".  You might find something useful there.
Also, verify "/var/lib/mysql" has owner and group settings of 
"mysql:mysql", although if you can access your database with the mysql 
or myadmin program, this is probably okay.  If you used 
mysql_secure_installation, then this should have been set up properly by 
mysql_secure_installation.  You can start fresh with this by renaming or 
deleting the "/var/lib/mysql" directory.


Of course, all of this assumes you have root access on your computer.  
Note that MySQL root is different from system root, and they _should_ 
_not_ share passwords!


Hope this helps.
Girvin Herr


--
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] Connecting LO Base to an SQL DB

2012-11-01 Thread Girvin R. Herr




Ian Whitfield wrote:

Thanks Heinz

Well I even went off this morning looking at 'other' solutions for 
this and it seems to be - Use Base or go and learn PHP or Ruby or 
something like that!!


So I got into Base again and found an interesting fact - Base had 
_NOT_ stored the link in it's Driver Class!! After a couple of 
re-tries it now seems to have done that and I can now get past the 
'Test Class' stage OK!!!


The next screen is 'Authentication' - I enter the User Name and select 
"Test Connection" and I get


   Communication Link Failure
   The last packet sent successfully to the Server was 0 milliseconds 
ago.

   The driver has not received any packets from the Server.

OK - Now I'm stuck again.. My Database (Schema) was called 
'federals_Members.sql' when I first created it but last week I had to 
re-install my OpSys and to get it back into MyAdmin I had to import it 
and it's now there called 'Test'!! Neither of the above two file names 
make any difference to the error message.


Next the User Name - In My Admin it is 'root', when I set-up the 
Database I used 'Ianw' and my System login is 'Ianw' also. Again 
neither of these changes the error message.


To check I started MyAdmin and it connects fine with the Database and 
displays the table structure just fine.


So why wont Base connect to it???

Thanks

IanW


Ian,
Are you starting mysqld with "--skip-networking"?
If so, then remove it for "localhost" access.  LO Base uses localhost to 
access mysqld and will give a failed to connect error if it can't 
connect via localhost.  MyAdmin does not use localhost to connect, so it 
would work fine while Base will not.

Hope this helps.
Girvin Herr


--
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] Inserting a code for today's date

2012-10-21 Thread Girvin R. Herr




upscope wrote:

On Friday, October 19, 2012 10:29:32 AM Girvin R. Herr wrote:
  

Joel Madero wrote:


Ah, yes my mistake for assuming what you were using. I'll have to look
into
writer. I just tried inserting a table (1x1) and putting the formula, no
good.


Regards,
Joel
  



   1. Place the cursor where you want the date.
   2. Select Insert -> Fields -> Other
   3. Select the "Document" tab
   4. Select "Date" for "Type"
   5. Select "Date" for "Select"
   6. Choose your date format under "Format".
   7. Click on "Insert".

If in step #5 you select "Date (Fixed)", I think that will insert
today's date but it will not update in future edits.  Even this
procedure may not work in a template.  More investigation is needed.
Hope this helps.
Girvin Herr

When I last used it, the "Date (Fixed)" inserted the date on the day its set 
up and does not update the date. If you select "Date" it changes the date 
everytime the document is opened, also changes it when person recieving the 
document recieves it, I'm told. 

I send out a newletter each month and the date is changed each time I update 
it before I send it and then when it goes out.
  

upscope,
Yes, this is true.  That is why I personally don't use "Date" as opposed 
to "Date (Fixed)" on my documents.  If the document is a one-time simple 
document, such as a letter where the date is used once and not 
throughout a multi-page document, I usually just type the date in and 
edit it each time I revise the document.  That way it doesn't 
unexpectedly change on me. Using the auto change date form caused me 
headaches in this respect. 

Another option I use is the document properties feature.  I create a 
custom version date property


   File -> Properties
   "Custom Properties" tab

and then insert that property as a field. 


   Insert -> Fields -> Other
   "DocInformation" tab
   "Custom" type

Then I only need to change the one property to change any and all 
instances in the document.  Works for me.  It also works in headers and 
footers.


While verifying this just now, I noticed some other fields in the 
Docinformation" tab I will have to investigate: "Last Printed" and 
"Modified" may be of interest to this thread.

Hope this helps.
Girvin Herr


--
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] Cannot add primary key after saving without primary key.

2012-10-21 Thread Girvin R. Herr




David Smith wrote:

Software: Libreoffice base
Version: 3.5.4.2 (Debian Wheezy)
Subject: Cannot add primary key after saving without primary key.

I've got a problem.  I'm trying to test some different table designs.
Whenever I create a table without a primary key, I find that I cannot
go back and add a primary key later.  When I first save the table,
Libreoffice asks me if I want to create a primary key now.  I choose
"no" because I'm experimenting with some different table designs and
didn't want to commit to anything just yet.
1. Create table without primary key.
2. Save table.
3. Libreoffice asks if I want to create a primary key now.
4. I choose no.
5. I later then open the table and set the primary key.
6. I save the table.
7.  I open the table again and the primary key that I chose was not saved!

I've never had this kind of problem with a database before. Is this a
bug or a missing feature?

  

David,
I am using the MySQL server for my database and have seen similar 
problems.  I recently created a new table, selected the key, but forgot 
to set the "Autoincrement" attribute on the key before my first save of 
the table structure.  I tried several things, such as moving the key to 
a temporary field, but nothing allowed me to make the original key field 
autoincrement.  Every time I saved the table, the autoincrement 
selection on the key would revert to "No".  Since this was a new table 
and no data was in it yet, I ended up deleting the table and recreating 
it with the autoincrement set on the key before I first saved it.  I had 
similar things happen to me with table structure key definitions 
before.  Once, I had to use the MySQL Monitor program and some SQL 
statements to change key definitions on existing database tables.  Not 
fun and error prone, but it worked.  The odd thing is that there is no 
error message from the server when these things happen, which makes me 
suspicious of Base or the JDBC driver - even more so since you are using 
a different server.  The bottom line is that as far as Base table keys 
go, you must set them up properly before you do that first save of the 
new table structure.  In my experience, non-key fields may be changed or 
added after the first save.  The key field is special.

Hope this helps.
Girvin Herr

--
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] Inserting a code for today's date

2012-10-19 Thread Girvin R. Herr




Joel Madero wrote:

Ah, yes my mistake for assuming what you were using. I'll have to look into
writer. I just tried inserting a table (1x1) and putting the formula, no
good.


Regards,
Joel
  



Joel et al,
Curious, I tried "=TODAY()" as a field variable formula and it doesn't 
work, with or without the "=".  Inserting a table is a brute force 
method, but as you say, it doesn't seem to work either.  Writer's tables 
are a subset of Calc tables and "=TODAY()" may not be a supported 
formula.  A better approach might be to:


  1. Place the cursor where you want the date.
  2. Select Insert -> Fields -> Other
  3. Select the "Document" tab
  4. Select "Date" for "Type"
  5. Select "Date" for "Select"
  6. Choose your date format under "Format".
  7. Click on "Insert".

If in step #5 you select "Date (Fixed)", I think that will insert 
today's date but it will not update in future edits.  Even this 
procedure may not work in a template.  More investigation is needed.

Hope this helps.
Girvin Herr




--
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 - need to re-point a form

2012-10-17 Thread Girvin R. Herr




John Clegg wrote:

I have a base file attached to a MySQL database on a remote server. I have
a form that I use to view and edit the data in one table.

Others also access the database, and I need to experiment with the data in
that table without molesting the master copy.

One solution would be to make a complete copy of the database, but as I
want to make copies of the main table many times a day that would be a
laborious solution

It is easy to make a duplicate of the main table within the database, and
also easy to make a copy of the form in the base file, but what I need to
do now is point the copy of the form at the copy of the table.

I thought it might be possible to open the odb file as a zip file and find
the form data containing the table name somewhere in it, and edit it to the
copy table name, but I haven't succeeded yet.

Does anybody know if this is possible - or even if there is a much easier
way?

  

John,
I am assuming you need to change the table that your form points to.  
You can do this by:


  1. Bring up your form in edit mode (right click on form name and
 select "Edit".)
  2. Select the "Form Properties" window (this is the icon that looks
 like a window with 2 buttons with an arrow pointing to it, and
 with a help balloon that says "Form".
  3. In the popup window, select the "Data" tab.
  4. Change the "Content" box to the table you want to use from the list.

If the new table's column (control) names are different, you will have 
to change those too in the form editor.  You do that by 
Ctrl-left-clicking on the form's control box and selecting its "Data" 
tab and selecting the new name from the list derived from your new 
table.  Do that for each control that has a different name from your old 
table.

Hope this helps.
Girvin Herr


--
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: MS raised prices so people will now start renting their office products instead

2012-10-07 Thread Girvin R. Herr


Greetings,
This thread has been ongoing for a relatively long time now and IMHO it 
has forked many times and veared off of its original message: that MS 
was to start renting their software and the lock on users that that 
implies.  Well, as we have been debating all these forked threads, there 
are other mainstream software suppliers that have also signed on to the 
software rental business model.  Although this is not directly 
competitive with LO, it is related to the subject and may interest 
office suite users.  I see today in our local big-box office supplies 
outlet advertisement that Adobe is now renting their mainstream software 
such as Adobe Photoshop, Adobe Dreamweaver and Adobe Create Cloud.  They 
call it a "subscription", but it looks like rental to me.  On one 
listing for example, the "subscription" for Adobe Photoshop is listed at 
$59.99 (US) and the rental period is only 3 months!  I don't know what 
Photoshop is selling for since I don't use it, but that seems expensive 
to me.  Maybe I am just cheap or unrealistic in today's market.  In all 
cases, I am *never* going to put my data at the mercy of a corporation - 
whether it be "the cloud" or limited-usage rented maintenance tools.  I 
still have the scars from doing that in the past.

I'm getting off my soapbox now...
Girvin Herr

--
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] attempting to find an answer and instead ...

2012-10-04 Thread Girvin R. Herr




Joel Madero wrote:



A ping is just a quick email (or IRC message, etc...) that says "hey, any
updates", some users even just say "ping" in IRC basically saying "hey, you
around?"

  


Joel,
"ping", another overloaded word:

   https://en.wikipedia.org/wiki/Ping

But those of us in the computer networking field assume:

   Ping, a computer network tool used to test whether a particular host
   is reachable across an IP network

Colloquially, it is used as you define it - to send a quick message to 
someone to see what's going on in their life. As in
"I haven't heard from him for a while - I'm going to ping him to see 
what he's up to."

Girvin Herr


--
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: MS raised prices so people will now start renting their office products instead

2012-10-03 Thread Girvin R. Herr




Jay Lozier wrote:

On 10/02/2012 07:19 PM, Girvin R. Herr wrote:
  





Girvin,

Most people I have talked to about databases find them less intuitive
than other typical office and general software.


  

Jay,
Yes, I can agree to that.  Working with databases is not plug-n-play.  
It doesn't help when there are strangenesses in SQL that I don't 
understand the reason why they are there.  For example, a while back I 
ran into a Join problem with at least MySQL joins that if any joined 
field of a record is null, the join will fail and that record, even 
though the other fields are valid, will not be in the result set.  No 
warnings or errors are given - it is just missing.  That causes missing 
data, which IMHO is a bad thing.  As I said, I am not an SQL expert and 
maybe there is a way around that action, but I could not find a way by 
trial and error.  I had to go back into all of my records and make sure 
I had a default value in all the fields that were part of any join. 

It is my understanding that an expanded version of the Base manual is 
coming out soon.  That will be a help too.  With the exception of the 
Report Builder, Base works quite well as far as I use it, but the 
documentation is sparse and there is a lot of trial and error involved 
to get what I want.  I am looking forward to the new version.


Of course, it is not within the scope of a Base manual to teach SQL, but 
since Base relies heavily on SQL and some Base functions require some 
SQL writing, some simple examples of how to use those Base features 
would be appreciated by all users.  There are some examples in the 
manuals already, but it could use some expansion.  Otherwise, the Base 
user base will continue to be minimal.  Users need help to understand 
the concepts and make Base usable for them and their projects.  
Otherwise, they will continue to use Calc.  I am sure the frustration 
level can be high for newbies and many would give up on Base, even 
though it would be the correct tool for them to use.  I might have done 
so too, if it were not that I have a lot invested in my databases and I 
am now "locked in" to maintaining them.


Another good idea might be to add to the manual a "Further Reference" 
list of recommended books to read for more information.  I would start a 
MySQL list with the "MySQL Reference Manual", which comes with most 
MySQL packages and is on the MySQL website and is available in paper 
from O'Reilly Community Press.  That should be mandatory reading for all 
new MySQL users.  Also, I have found the "Teach Yourself SQL in 24 
Hours" book by Ryan Stephens and Ron Plew of value.  (I have no 
affiliation with either of these authors or publishers.)

Girvin

--
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: MS raised prices so people will now start renting their office products instead

2012-10-02 Thread Girvin R. Herr




Jay Lozier wrote:


>From the comments on the list, the weakest part of LO is Base. However,
my observation is most people find learning any true database daunting
and thus do not learn how to use any database. Compounding this is the
fact many MSO packages do not include Access. Many thus use a
spreadsheet as a poor man's substitute for a proper database.



  

Jay,
I use Base as a MySQL client to access my databases, which are mostly 
inventories.  I started with MS Access years ago and switched to MySQL 
c. 2004, when a MySQL Open Source client (Rekall) finally appeared for 
Linux.  But Rekall stopped being supported a few years later and the 
version I had still had a few bugs that should have been worked on.  
When Base started being a general database server client (interfaced to 
MySQL, etc.) rather than that proprietary database thing that StarOffice 
used (and may still do so), I looked into switching from Rekall to 
Base.  Doing so was not a trivial task, since all the work I had done on 
data entry forms and reports in Rekall had to be discarded and that work 
redone for Base.  After recreating all my data entry forms and reports, 
I got Base to work reasonably well within my requirements.  However, the 
latest version (1.2.1) of Oracle Report Builder (ORB) is a basket case.  
When it doesn't crash LO, it is dog slow at creating my reports.  Too 
slow to be used.  I have just this week, downloaded an Open Source 
report generator program called DataVision  
http://datavision.sourceforge.net/ and got it to work on my Slackware 
Linux system with MySQL.  This version, 1.2.0, is rough, many features 
are not working yet and it does not seem to be supported any more 
either, since this latest version is dated 2008.  However, unlike ORB, 
it does do what I want a report generator to do - without crashing and 
at a reasonably fast speed.  Since it is an Open Source JAVA program 
using an Apache license, if any of the Base devs are listening, I 
suggest they look into taking over DataVision as an addition to Base.  
Base without a report generator is like a computer program that accepts 
inputs but does not output anything - useless.  Akin to Writer or Calc 
not printing!


Was all my database work, including learning a bit of SQL "daunting"?  
Yes, I suppose it was, but it was and is a learning experience and I 
don't mind learning something new.  I am not in the least a SQL master, 
but I do understand it enough to get by.  If not, I hit the books 
again.  There are those who can't or won't learn anything new.  For 
them, there is the Calc tool, which fits their hands better, but maybe 
isn't quite the best tool for the job.

Girvin Herr

--
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: Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Girvin R. Herr




Alexander Thurgood wrote:

Le 28/09/12 14:43, Mark Stanton a écrit :

Hi Mark,

  
My query couldn't use the query wizard (Andreas won't be surprised).  
In coding the query I wrote the field names in camelcase (eg 
"Address1", "PersonName"), the actual database fields are all in 
lowercase.  Changing this made the mailmerge show data.
However, the query worked prior to that, and in fact the hidden 
paragraph conditions worked correctly, even though they were also in 
camelcase.



I seem to recall reading that somewhere on the French user list a while ago.

  

8><...


Alex
  

Alex,
This may not help nor apply to your particular problem, but it may help 
point you to the problem.
I am working on with program called DataVision as a replacement for the 
broken Base report builder.  Reading your message reminded me of seeing 
something about column naming in the DataVision manual.  Here is a 
snippet (my comments in <>).
start 
snippet


   Database Name Case Sensitivity
   Some databases support case-sensitive names. In those databases, the
   column named "mycol" is different from the column named "MyCol".
   Unfortunately, the programs that access databases, such as JDBC
   drivers and command line tools like PostgreSQL's psql, often confuse
   the issue by changing all names to lower case or upper case
   internally, before sending the query to the database.  When you type
   "select MyCol from MyTable", it sends "select mycol from mytable" to
   the database .
   If your database was created using names with only lower case (or
   upper case) letters, you may not see any problem. Your queries
   always work because no matter what case you use, the names are
   converted to all lower case (or upper case) and everything is fine.
   In order to access a column named "MyCol" using a tool that converts
   the names, you have to quote the mixed-case names. For example, the
   query "select MyCol from MyTable" must be entered as

   select "MyCol" from "MyTable"

   The quotes go around the parts of the name that need them, not the
   whole name . For example, the quotes don't go around
   the entire name "MyTable.MyCol". Instead, you would need to type

   select "MyTable"."MyCol"

End snippet 
-


The manual then goes on to talk about DataVision-specific things.
So, your problem may not be Base, but your JDBC driver.  Then again, 
maybe a change in Base has broken this communication to your JDBC 
driver.  That would take more investigation.  If, however, you are 
writing your own SQL, then you may check for this quoting requirement.

HTH
Girvin Herr



--
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 Scoring Bi-nominal Responses

2012-09-22 Thread Girvin R. Herr




Tom Davies wrote:
Hi :)  
Don't self referencing equations usually tend towards chaos and have fractal dimensions?  It's a bit beyond the scope of a spreadsheet!  Is there a way of limiting the number of iterations or does Calc just protect it self (and the cpu) from calculations running away towards chaos?  
  

Tom,
Open a Calc file and...
See Tools -> Options -> LibreOffice Calc -> Calculate - Iterations
Mine is blank (unchecked) but once checked, then the maximum iterations 
and value change limit can be set.

Hope this helps.
Girvin Herr


--
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] Draw object selection problem

2012-09-15 Thread Girvin R. Herr



Regina,

Regina Henschel wrote:

Hi Girvin,

you have sent me a private mail, therefore I answer private too. But 
that is not good. Please use the mailing list next time.


Yep!  My bad.  I reflexively used "Reply" instead of "Reply All" and 
didn't realize it until I already sent the reply.  The new list 
configuration is aggravating.  Given how many private replies I am 
getting since the change, I am not alone in the group.  As you hint at, 
the real problem is deciding if the private reply was really a private 
reply or just a miss-click like I did with this one.  It is an etiquette 
problem...

Girvin R. Herr schrieb:
[..]

Thanks very much for the hint.  I didn't know Draw had layers.  I see
now what you are talking about and I can create additional layers, like
adding sheets to Calc.


Apart from using a "tab" they are totally different.

  I will try that as soon as I can get back to

it.   No matter which layer I select, the same objects are displayed in
the drawing window.  I see I can make layers invisible, but that is
about it.  Is there a way to tell which layer an object is on, other
than trying to select it layer by layer?


Please have a look at chapter 8 "Splitting drawings in multiple 
layers" in the Draw guide [1], and therein the section "Changing the 
layer of a drawing object".
I read that section of Chapter 8 last night, just to see if the guide 
did explain layers.  There are two pages referring to layers and that is 
mostly taken up by figures.  I will have to work with Draw to get the 
feel of how to apply this new layer technique.


I know the guide is not verbose, so don't hesitate to ask again, but 
please on the list, so that all others can learn from the answers too.



Done!

[1] http://www.libreoffice.org/get-help/documentation/

Kind regards
Regina

Thanks for your help.
Girvin


--
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] Draw object selection problem

2012-09-14 Thread Girvin R. Herr


Greetings,
LO 3.5.3.2 on Linux.

I am trying to edit a Jpeg picture in Draw by drawing objects on top of 
the picture.  However, I am having a problem selecting my objects.  Draw 
keeps selecting the larger underlaying picture instead of the object I 
want it to select.  I tried to select an area, but as soon as I make the 
first click at the first corner, it selects the underlying picture.  I 
tried protecting the underlying picture using the procedure in help.  
That keeps the picture from being modified, but it still gets selected.  
I "Sent it to Back", but that does not work either.  Is there a way to 
keep a draw object from being selected or to select overlying objects only?

Thanks.
Girvin Herr


--
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: dBASE file access

2012-09-12 Thread Girvin R. Herr


Hi Alexander,

Alexander Thurgood wrote:

Le 12/09/12 01:25, Girvin R. Herr a écrit :

Hi Girvin,

  

8><...

blank page with no structure entries.  Opening the table produces the
SQL errors: "The data content can not be loaded.  The query can not be
executed. It contains no valid table.".  If I click on "More", I get the
errors: "The data content could not be loaded.", "SQL Status: HY000  The
query can not be executed. It contains no valid table." and the
information: "The SQL command leading to this error is:  SELECT * FROM
"pintosw""  (where "pintosw" is my dBASE database file "pintosw.dbf").



You might find that you actually have to save the ODB file, shut down LO
and restart it completely (including any quickstarter if you are on
Windows). The refresh button doesn't seem to perpertuate the refreshed
table schema to the ODB configuration file, which is why you then get an
error.
  
That is good to know.  I will have to check that out, since it is a new 
day/boot here - Nope!  Everything for the table is still blank, but I no 
longer get the error popups when I try to "open" a table.  I guess 
that's progress.

Additionally, LO only supports DBF from dbf III+ and dbf IV from what I
recall, but Andreas might know more about that than I do, so if your
DBFs use an earlier version, then they probably won't be recognised by LO.


Alex
  

Ahh!  Now that is what I am thinking.
I did some further research on dBASE file formats since my last posting 
and yes, the file formats changed considerably since my dBASE II files 
were created - Especially between dBASE II and III.  I have now given up 
using Base to read these old files.  The good thing is that, as a result 
of my further research, I now know the file format and I have begun 
writing a program to read these DBF files and write their data out to a 
new Comma Separated Value (CSV) file, which can be read by many 
programs, including Calc.  What I didn't mention in my posting is that I 
also have dBASE II command files (.CMD) which manipulate the data in 
these DBF files.  If LO can't read the old DBF files, I have no hope of 
LO actually executing the .CMD programs as dBASE II did.  At least now I 
know some of LO's limitations with dBASE files.

Thanks again for the help.
Girvin


--
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: dBASE file access

2012-09-11 Thread Girvin R. Herr




Andreas Säger wrote:

Am 11.09.2012 22:34, Girvin R. Herr wrote:

Greetings,
I have several real old dBASE data files from 1985 that I would like to
get the data from and convert to LO Base.  I keep reading about LO being
able to access a dBASE file, but I am having trouble doing so.  I tried
the new database wizard and although it created the new Base database
structures, when I tried to open one of the dBASE files, it opens in
writer, not Base.  There are no tables listed in the new Base database.
The wizard did not allow me to select the actual files, just the
directory they are in.  It didn't list any of the ".DBF" files.  Maybe I
am asking too much of LO, but I was hoping the dBASE data would show up
in a Base table.  Any help would be appreciated.
Running: LO 3.5.3.2 under Linux.
Thanks in advance.
Girvin Herr




Base is a mere database frontend. It opens its own .odb files only. An 
.odb file can be connected to various types of databases.


Open Writer or Calc.
Hit F4.
Right-click "Bibliography" -> Edit Database
This loads the .odb file which is connected to the dBase Bibliography 
with one table named "biblio".
dBase is a database in a directory, so this .odb file is connected to 
a directory. The status bar of that database reads: "dBase" and the 
path to the connected directory having the file biblio.dbf.

menu:Edit>Database lets you modify the connection parameters.


Yes, this works as you describe it.

Put your own dBase in a dedicated directory.
File>New>Database...
[X] Connect to existing db
Type: dBase
Specify the directory.
Check the register option (never harms).
Save the database.

So far - so good.  That's what I have done.

Drag the table icons from this database into the embedded HSQLDB.

How do I drag it into HSQLDB?
Warning: embedded HSQLDB must not be used with anything important. 
It's OK for educational demos and for your DVD. Base works best (fast, 
reliably and multi-user) with HSQL as stand-alone backend database. 
Embedded databases are just a caricature of a database. They are slow, 
single-user, limited and unsafe.
That may be true, but all I am trying to do is extract the dBASE file 
data so I can put it somewhere useful.  I don't intend to continue using 
HSQLDB once it has extracted my data.


I did discover that LO requires the dBASE filename to end in ".dbf", not 
".DBF" as I started with.  So, LO is case sensitive in this instance.


I started to look at the Base options and discovered View -> Refresh 
Tables.  Clicking on it produces my dBASE database namess in the Tables 
section.  I looked up "refresh tables" in help, but all it says is 
"Refreshes the tables".  Duh!  However, editing the table produces a 
blank page with no structure entries.  Opening the table produces the 
SQL errors: "The data content can not be loaded.  The query can not be 
executed. It contains no valid table.".  If I click on "More", I get the 
errors: "The data content could not be loaded.", "SQL Status: HY000  The 
query can not be executed. It contains no valid table." and the 
information: "The SQL command leading to this error is:  SELECT * FROM 
"pintosw""  (where "pintosw" is my dBASE database file "pintosw.dbf").


Now that I have the "tables", how do I drag them to HSQLDB?
Maybe that is the key.

It seems to me that Base is attempting to create the new database, but 
it isn't importing the table structure or data from the dBASE file.

Thanks for any help.
Girvin




--
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] dBASE file access

2012-09-11 Thread Girvin R. Herr


Greetings,
I have several real old dBASE data files from 1985 that I would like to 
get the data from and convert to LO Base.  I keep reading about LO being 
able to access a dBASE file, but I am having trouble doing so.  I tried 
the new database wizard and although it created the new Base database 
structures, when I tried to open one of the dBASE files, it opens in 
writer, not Base.  There are no tables listed in the new Base database.  
The wizard did not allow me to select the actual files, just the 
directory they are in.  It didn't list any of the ".DBF" files.  Maybe I 
am asking too much of LO, but I was hoping the dBASE data would show up 
in a Base table.  Any help would be appreciated.

Running: LO 3.5.3.2 under Linux.
Thanks in advance.
Girvin Herr


--
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: Another question concerning Base

2012-08-20 Thread Girvin R. Herr




Alexander Thurgood wrote:

Le 16/08/12 00:56, Thomas Taylor a Ã©crit :

Hi Thomas,
  

8><..


- AOOo has moved its hsqldb engine to an improved version 2, whereas LO
is still stuck on version 1.8 ;

- AOOo has removed direct support for the mysql native connector due to
licensing issues, it is still provided as a download for older versions
of OOo, but is no longer being actively supported ;

- LO no longer has any actively supported native mysql connector either,
but for the moment, an attempt to not break the existing external
extension is being maintained ;

- LO has read/write native connector support for postgresql - this, I
believe, is a major improvement over AOOo, which only had read support,
and the postgres native connector is no longer even offered with AOOo
due to licensing issues ;

- both AOOo and LO support JDBC driver connections to postgresql and
mysql databases ;

- both AOOo and LO are supposed to support ODBC driver connections -
however, this is very dependent on OS, bit version architecture (32/64)
and buggy behaviours of the 3rd party drivers ;

- LO support of MS Access databases on Windows is variable according to
LO version and Access mdb/accdb version - one day it works with one
version of LO, the next it doesn't, so your mileage may vary - I can't
speak for AOOo here as I haven't tested that bit ;

- Access databases are not supported in either LO or AOOo on other OSes
(i.e. Linux/Mac), to my knowledge - these are usually dealt with by 3rd
party programs.

This is only a short comparison, I'm sure there are other points that
could be mentioned, but on the whole, the basic DB functionality between
the two is pretty much the same. That situation is likely to change with
the switch to LO version 4 development, where it has already been
decided that backwards version (ABI) compatibility for all
functionalities of the LO suite will not be guaranteed. At the moment, I
have no idea how that will affect Base, but it will almost certainly
affect any extensions that are currently available.


Alex


  

Alexander,
Thanks for this information.  It is very enlightening, so I shouldn't be 
too surprised in the future.  I use Base extensively as a client to MySQL.

Girvin Herr


--
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] Reply settings on this list have changed

2012-08-13 Thread Girvin R. Herr




webmaster-Kracked_P_P wrote:

On 08/13/2012 07:36 PM, Mark LaPierre wrote:

On 08/12/2012 12:31 PM, Florian Effenberger wrote:

Hello,

this is to inform you that the reply settings on this list have changed
(so-called "Reply to mangling" has been disabled).

So far, e-mails had set a reply-to the mailing list address. In other
words, with any e-mail client, replies to e-mails on the list were
automatically sent directly to the list.

In the past, this lead to two major problems:

1. Several times, people have sent direct replies to the public list,
where deleting them is nearly impossible. I remember at least one case
where confidential information has been sent out that caused lots of
worries for the sender and his employer. This happened because people
hit "reply" and thought it would reply to the sender only.

2. I have heard complaints in the past from people, stating that 
working

with the non-developer lists of LibreOffice is a pain for them, because
of reply-to mangling, resulting in a lack of communication. This also
led to the fact that numerous tasks were done by the same people, who
needed to spend more and more time, instead of sharing the work burden
with others. While I do not fully believe this argument, there's just
one way to find out...

Therefore, I have applied a change:

Replies to e-mails from the list now only go to the original sender. 
You
either need to use the "reply to all" feature of your e-mail 
program, or

- preferably - the "reply to list"/"reply to group" feature, which will
direct replies directly to the list.

This is common practice on most mailing lists, and even the default
setting for our mailing list software, so we did not re-invent the 
wheel

here. Those seeking for details should have a look at
http://www.unicom.com/pw/reply-to-harmful.html

I know we had numerous discussions on this topic in the past, but the
outcome was that roughly 50% were for this change, and 50% refused it,
so I am really sitting between two chairs here, for which I beg for 
your
understanding. On the one hand, those complaining the lists are 
unusable

with reply-to mangling, on the other hand, those complaining the lists
are unusable without reply-to mangling. Unfortunately, combining those
two, even on a per-recipient basis, is not possible, so they are
mutually exclusive to each other.

In order to find out the real impact, I simply changed the setting, and
again, I beg for your understanding.

Do not worry: The mailing lists are for the community, so it's the
community deciding how they should work. What I'd like to ask all of 
you

is to try out for a few days if that change is good for each list or
not. Should we find out it is more harmful than it helps, I will
immediately switch back to the old behaviour.

Sorry for this short notice, and I beg for your understanding that I'm
somehow sitting between two chairs here.

Florian



Hey All,

Not trying to be rude.  All of you should be smart enough to run an 
email tool.  After all you're all Linux users who administer at least 
one Linux installation.


For those of you having trouble with email filters try filtering on 
"libreoffice-users" in the subject line.  That should get all your 
email to the right folder.




I filter on email address.

LibreO - Website folder gets 
LibreO - Projects Global folder gets 
LibreO - Marketing US folder gets 
LibreO - Marketing Global folder gets 
LibreO - Users Global folder gets 

So each list goes into its own folder in Thunderbird.

I also have different folders for newsletters, friends, family, 
organizations I deal with, domain related, purchases via Amazon and 
PayPal accounts, etc., etc..  All of these folders are based on email 
address filtering and not subject line filtering.  So, once I get an 
email from a "proper source", then I get to decide which folder that 
email address will go into.  Subject lines and other filtering methods 
do not work as well for me.  Every email that gets left in the general 
"inbox", that I am sharing with 12 email addresses I check with 
Thunderbird, could be potential SPAM or missed valid emails from known 
people.  Some of the emails I receive that come from addresses that 
are automatically forwarded to my TRASH folder without me ever seeing 
any emails from those "known" SPAM sites/addresses.  95% of the all 
the daily emails I receive will go into a folder instead of the 
"default inbox".  Most of those that come into that inbox are from 
people or companies I have not received from before.  So, I get only a 
few "unknown" emails to go through myself.  Works for me.





Webmaster...,
That's sort of what I do.  I think I discovered the secret.  In this 
group now, it appears when someone "Reply-All"s to a posting, The "To:" 
comes from the "From:" posting header entry, which is the poster's 
address and not practical to filter on in this case.  However, the group 
address (users@global.libreoffice.org) is inserted into the "Cc:" 
field.  So, tr

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

2012-08-13 Thread Girvin R. Herr


Greetings,
I hope this gets to the right place.  I used "Reply All" in 
Thunderbird.  The header looks correct, but people are going to get 
duplicate messages.

Here is another side-effect of this change:
Florian,
Right!  Yesterday, your changes broke my email filter which puts 
libreoffice user group messages in a specific folder. But then I changed 
the filter from looking at "Reply-To:" to "To:" and thought that would 
suffice.  Now, this morning I got 7 libreoffice messages in my correct 
folder via my filter change, and 4 messages direct from members in my 
main inbox, which my filter did not catch.  Your change may make it easy 
for you, but it is a nightmare for me.  There is no way I can create 
filters for all users who use their address.


My vote is to return the list to the way it behaved before you made this 
change.  This is "Anne-ology"'s Poll option #1.


I might also add, that the mis-addressed private message issue did 
happen to me many years ago, when I sent what I thought was a private 
joke message and discovered to my chagrin after sending it, that 
Netscape also added a newsgroup address to the header without my 
blessing.  You can imagine the impact of that.  It was not funny and I 
am still, after over 20 years, seeing that association come up now and 
then.  Since then, I verify where my email client is sending my messages 
before sending them.  Anyone who does not do so, is taking a chance and 
should not persecute others for their mistakes.

Girvin Herr


webmaster-Kracked_P_P wrote:


I just posted a reply to a thread to the last poster instead of the 
thread by mistake.  I am so use to pressing "Reply" and the next 
button being "Reply All", that I now have to remember to skip the 
"Reply" button and remember that the "Reply All" button has been 
replaced with "Reply List".  This may cause some problems, if too many 
of our list users get the reply posting that were meant to go to the 
lists instead.


Christian L. just sent me a notice that my posting went to him instead 
the "How can I know which one is a spam?" thread in the Website list.


I nearly sent this posting to "anne-ology" instead of the User list.  
This is going to be a problem, maybe.



On 08/13/2012 01:06 PM, anne-ology wrote:
exactly, therefore to change the default, you're changing 
this list
to where folks will now be corresponding privately rather than 
allowing the

list to hear what's new and learn from others.



On Mon, Aug 13, 2012 at 11:47 AM, Felmon Davis  wrote:

On Mon, 13 Aug 2012, webmaster-Kracked_P_P wrote:


I did not know that you could "make" the email client state "Reply 
List"
instead of the text on the "Reply All" button.  I run Thunderbird 
14.0.


I have to get use to using the "Reply List" instead of "Reply" to 
post a
message to the thread.  It could be confusing to people, but does 
make it
easier to send a message to the poster, off list.  I use to copy 
the email
address of the poster and then paste it to my "To:" section.  This 
will be
easier to do that, but hopefully not too many people will forget to 
use the

"new" "Reply List" button instead of the "Reply" button.


myself, I am not so clear why people are interested in sending private
email to people on a public list. I did it yesterday but only 
because I had

trouble posting to the list and was overeager to get my word
('hucksterism') in.

the default mode on a list of replying to the list made sense to me. 
not a

big deal for me since I mostly lurk.

F.


--
Felmon Davis







--
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: No help in LO

2012-07-13 Thread Girvin R. Herr


Tom, et al,
I might also add that I have read a few of the manuals, such as Writer, 
Calc, Base and Draw and, although it is very good compared to, say, the 
OO 2.4 era, it sometimes states to use Help for more information or 
details. So, Help is needed to be complete. I have used Help 
occasionally and you are right in that sometimes it is incomplete or 
downright incorrect, but it is better than trial and error.

Girvin Herr


Tom Davies wrote:

Hi :)
Lol, that is not complete disagreement! I agree it's handy to have both but if you are missing the built-in help then "view it as a feature not a bug".Â  Afaik the Help was last updated for the 3.3.0 and there have been quite a few changes since then.Â  
Regards from
Tom :)Â  



--- On Fri, 13/7/12, Pedro  wrote:

From: Pedro 
Subject: [libreoffice-users] Re: No help in LO
To: users@global.libreoffice.org
Date: Friday, 13 July, 2012, 10:53


Tom wrote
  
Forget the help.Â 
...

The help is growing a bit ragged around the edges as it is getting
out-dated quite fast.




I disagree completely. Do get the offline help. It is a quite efficient and
handy quick reference for LibreOffice even if it is(?) outdated.

http://www.libreoffice.org/download/?type=win-x86âŒ©=en-GB&version=3.5.5

(notice the second button)

I agree with Tom the Publications are VERY good, but it's not exactly the
same as pressing F1

--
View this message in context: 
http://nabble.documentfoundation.org/No-help-in-LO-tp3995206p3995232.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: stubborn macro security

2012-06-30 Thread Girvin R. Herr


Dennis,
That helped a lot.  I found the "UpdateFromTemplate" definition in the 
settings.xml file as you suggested.  I was able to change the assignment 
from "false" to "true" and tried it, but it didn't seem to pick up on 
the changed template.  I will have to do some more work on this but I 
wanted to let you know your help was appreciated and opened a door for 
me to fix this problem.  Maybe I can write a shell script to make the 
change to the settings.xml directly instead of using the suggested macro 
approach.  I have a lot of files that need this change.

Thanks much.
Girvin



Dennis E. Hamilton wrote:

From what Andreas says, it appears that the flag you care about is in 
settings.xml within the Zipped .odt package.

It is generally benign to simply delete the settings.xml file.  Try it on a 
copy to see if it accomplishes what you want.

 - Dennis

-Original Message-
From: Girvin R. Herr [mailto:girvin.h...@sbcglobal.net] 
Sent: Saturday, June 30, 2012 14:45

To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: stubborn macro security

Andreas,

Andreas SÃ¤ger wrote:
  
Where is the macro stored? Obviously you store it in the template and 
all resulting documents from that template inherit the macro.
When you store a new document from that template in some untrusted 
location, the macro can not be trusted anymore.



I assume the macro is stored in the particular document I wanted to 
change.  I used the process in the 3.4 Writer Guide, "Updating a 
Document From a Changed Template" attempting to change that document's 
template update flag.  In this document and some others, in the past I 
must have clicked on "Keep Old Styles" in the popup and according to the 
Writer Guide, that sets a flag to never allow template updates again for 
the document.  Apparently, the only way to re-enable it is to run this 
BASIC Macro to set the "oDocSettings.UpdateFromTemplate" flag to 
"True".  It is supposed to cancel the "Keep Old Styles" selection.  The 
macro function is called "FixDocV3" if that helps.


I just realized that this is a *BASIC* macro, not the usual keystroke 
type macro.  That difference may have confused you and other users when 
reading my message.  Does a BASIC macro have a different security option 
somewhere?


Not knowing what the file format is, is it possible to unzip the 
document and search for "UpdateFromTemplate" and edit it to "True", as 
an alternate to the BASIC macro?
If "UpdateFromTemplate" is hard-coded into the document rather than the 
symbolic name, I would need to know where it is in the document to 
change it, which I don't know.

Thanks.
Girvin


  


--
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: stubborn macro security

2012-06-30 Thread Girvin R. Herr


Andreas,

Andreas Säger wrote:
Where is the macro stored? Obviously you store it in the template and 
all resulting documents from that template inherit the macro.
When you store a new document from that template in some untrusted 
location, the macro can not be trusted anymore.


I assume the macro is stored in the particular document I wanted to 
change.  I used the process in the 3.4 Writer Guide, "Updating a 
Document From a Changed Template" attempting to change that document's 
template update flag.  In this document and some others, in the past I 
must have clicked on "Keep Old Styles" in the popup and according to the 
Writer Guide, that sets a flag to never allow template updates again for 
the document.  Apparently, the only way to re-enable it is to run this 
BASIC Macro to set the "oDocSettings.UpdateFromTemplate" flag to 
"True".  It is supposed to cancel the "Keep Old Styles" selection.  The 
macro function is called "FixDocV3" if that helps.


I just realized that this is a *BASIC* macro, not the usual keystroke 
type macro.  That difference may have confused you and other users when 
reading my message.  Does a BASIC macro have a different security option 
somewhere?


Not knowing what the file format is, is it possible to unzip the 
document and search for "UpdateFromTemplate" and edit it to "True", as 
an alternate to the BASIC macro?
If "UpdateFromTemplate" is hard-coded into the document rather than the 
symbolic name, I would need to know where it is in the document to 
change it, which I don't know.

Thanks.
Girvin


--
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] stubborn macro security

2012-06-29 Thread Girvin R. Herr


Greetings,
I am trying to run the macro from the LibreOffice 3.4 Writer Guide, page 
293, "Note: To re-enable updating from a template:".  However, every 
time I try to run it, I get a security message saying I can't do that.  
I even used the Tools -> Options -> Security -> Macro Security... -> Low 
(not recommended) to try to unlock this, to no avail.

What is the secret to allowing local macros to execute?

If any of the developers are listening, IMHO this is something that 
should be done other than requiring the user to write and execute a 
macro.  There should be a radio button in Writer, possibly in document 
properties, to re-enable updating from a template without going through 
this complex process.


Thanks in advance.
Linux LO 3.5.3
Girvin Herr


--
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] LibreOffice crashes after updating template

2012-06-28 Thread Girvin R. Herr


Greetings,
I see that LibreOffice 3.5.3 still has the document template update 
crash problem that OpenOffice 3.3 had.  Here is the scenario:
I open a document and get the popup window (LibreOffice 3.4 Writer Guide 
p293, Figure 294, "Updating a document from a changed template") asking 
to update or keep the document template.  If I then select "Update 
Styles",  LibreOffice will crash.  It usually does not happen 
immediately, but it will crash sometime during the session.  Note that 
if I optionally select "Keep Old Styles" LibreOffice will not crash.


The workaround I have developed is to immediately save and close the 
updated document after the template update, then re-open the document. 
That sequence seems to prevent the crash.  Has anyone else seen this and 
have a fix or is this a known problem that hasn't gotten fixed yet?


LibreOffice 3.5.3, Slackware Linux K2.6.17, KDE 3.5.10.
Girvin Herr


--
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] Screen goes dark gray, Libreoffice stops

2012-06-23 Thread Girvin R. Herr


Tom,
For the record, I just checked my Mozilla Firefox add-ons and it 
reported my Java 1.6.0_30 has bad security vulnerabilities.  So, stay 
away from it.  Your _32 suggestion is a good one.

Girvin


Tom Davies wrote:

Hi :)
Sorry, just noticed that java version is fairly old already.  I don't think it usually creates problems in LO 3.5.x but it used to in 3.3.x and i think in 3.4.x.  It might be worth upgrading your version of java if you do want to use java with LO.  I think the _32 is probably the most recent version that is reasonably easy to get  in your Ubuntu.  
Regards from
Tom :)  



--- On Sat, 23/6/12, John R. Sowden  wrote:



java 1.6.0_26.
I now have the monitor up in a corner I watch it as activity occurs in 
thunderbird.  I haven't tried it in LO yet.  I thought LO was written in 
Java, so turning it off I thought was not an option.

What do I loose when I turn it off, and how do I do that?

John


  


--
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] last edit position

2012-06-18 Thread Girvin R. Herr


Thomas,
You could do what I do in plain text editors when editing software 
source files.  I insert a string of "at" signs: "" where I want a 
"tag".  I then can do a search for "" and go to where I want.  
Multiple numbers of "at" signs or different strings can allow multiple 
"tags" to search for.  This is not the single-key function you would 
prefer, but it does work and is not very complex.


I maintain documents larger than 60 pages and I generally use the 
vertical scroll bar while looking at paragraph numbers or the page 
number in the bottom status bar zooming by.  I may have to scroll back 
and forth a bit to home in to the area I want, but this process is 
reasonably fast to me.


You probably already know that LO will open a file and place the cursor 
where it last was when the file was saved.

Hope this helps.
Girvin Herr


Thomas Blasejewicz wrote:

Good evening
I would ***LOVE*** to have a CONVENIENT function for jumping to the last
edit position.

I believe this and/or similar questions have been asked before:
http://ask.libreoffice.org/question/1144/cursor-position-not-saved-in-writer#1147

But this does not work.
I do have my personal data entered under Tools and yet the software
ALWAYS opens the document at the top.
Once I am working in the document, there is the "Navigator", but despite
of having all sorts of items/functions,
there is NONE, that would bring me back to the last position the cursor
was, when I was last editing the document.

Right now I am working on a 60-page document and it is really a nuisance
having to scroll (one way or other) through
dozens of pages to get back to that last editing position, once I left
it for whatever reasons.

In the past I used WordPerfect (not any more). This had a very
convenient function called "quick mark".
Every time you save the document (Ctrl+S), the software automatically
enters a mark and you can jump to that position
from whereever you are with a keyboard shortcut.

Although under Tools -> Customize -> Keyboard -> Navigate
there are millions of things you can choose to go to, but nowhere
something like "last (edit) position".
You CAN insert a bookmark and then jump to that bookmark, but to my mind
this is a rather clumsy way of
achieving what was so elegant in Wordperfect.

Is there a trick to it?
Something that would make this action quick and easy (preferrably
automatic)?

Thank you.


  


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

[Fwd: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder]

2012-05-28 Thread Girvin R. Herr



Alexander Thurgood wrote:

Le 26/05/12 22:30, Girvin R. Herr a écrit :

Hi Girvin,


  

If you have links to LO/OOo configuration documentation for ODBC
connection to MySQL, I would be willing to try it.
Thanks.



I wrote a tutorial for this very purpose many years ago for OOo, but it
would equally apply to LO today, things really haven't changed that much
(if at all) insofar as getting ODBC connections set up are concerned. I
can't actually find my English version at the moment, only the French
one I wrote, but note that John McCreesh also provided one that is still
available here :


http://www.unixodbc.org/doc/OOoMySQL9.pdf

Alex


  

Alex,
Thanks for replying with this valuable information.  I printed the 
document and I will try it sometime.  It is always good to have a backup 
solution.
I don't think my problem is with Java.  The main reason is that I am 
using the same database query to get my data with Oracle Report Builder 
(ORB) and with Calc import.  The Calc import runs at a reasonable speed, 
about 15 seconds or less for about 1800 records, where ORB takes over an 
hour to process the same data.  I think the problem is definitely with 
the ORB interfaces.  Yesterday, under this subject, I posted additional 
LO/ORB error data from tests I ran.  Today, I want to go back to 
OpenOffice 3.3 and run the same tests to see if OOo/ORB produces the 
same errors and runs slow.  I have used ORB with OOo 3.3 in the past 
and, as I remember it, although it wasn't fast, it didn't take nearly as 
long as this LO/ORB takes.  If the OOo 3.3 tests are not as slow, then 
that indicates there may be something wrong with the ORB bundled with 
LO.  I will have to do more work in that area to try to narrow it down.

Thanks again for your help.
Girvin




--
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: Extremely Slow Base Report Builder

2012-05-27 Thread Girvin R. Herr




Andreas Säger wrote:

Am 26.05.2012 22:13, Girvin R. Herr wrote:



Andreas,
Yes! Plus the "com.mysql.jdbc.Driver" class and the "MySQL (JDBC)"
connection type option.
And I am using the "MySQL-connector-java-5.0.7-bin.jar" in the class
path and the MySQL 5.0.67 server.
Sun (Oracle) Java version 1.6.0_30
All test okay, of course.
Thanks.
Girvin




Install Java 1.6.0_22 or LibreOffice 3.5.x and things will run with 
normal speed.




Andreas,
Here is some more data on the subject.  I opened LO in a shell so I 
could catch any LO errors and then started my report build.  The 
following enclosure was then displayed in the shell.
Note that the first 2 errors regarding library version information come 
up when I invoke LO, before I open ORB.  My research informed me that 
these version errors are not fatal, despite the "required" tag. They are 
just a minor mismatch between my libraries and the ones compiled with 
LO.  However, the "pentaho" errors, whatever pentaho is,  may be 
significant, especially the Null Pointer errors.


- Start of enclosure
501:$libreoffice3.5
/opt/libreoffice3.5/program/../ure-link/bin/javaldx: 
/usr/lib/libxml2.so.2: no version information available (required by 
/opt/libreoffice3.5/ure/bin/../lib/libjvmfwk.so.3)
/opt/libreoffice3.5/program/soffice.bin: /usr/lib/libpng12.so.0: no 
version information available (required by 
/opt/libreoffice3.5/program/libcairo.so.2)
May 27, 2012 12:36:40 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start

INFO: LibSerializer 1.1.6.10682 started.
May 27, 2012 12:36:40 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start

INFO: LibBase 1.1.6.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start

INFO: LibLoader 1.1.6.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start

INFO: LibRepository 1.1.6.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start

INFO: LibFonts 1.1.6.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start

INFO: LibLayout null started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start

INFO: LibFormula 1.1.7.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start

INFO: LibXML 1.1.7.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module: 
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.common.SwingCommonModule}

java.lang.NullPointerException
   at 
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
   at 
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
   at 
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
   at 
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)

   at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
   at 
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
   at 
com.sun.star.report.pentaho.PentahoReportEngine.(PentahoReportEngine.java:45)
   at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
   at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module: 
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.html.SwingHtmlModule}

java.lang.NullPointerException
   at 
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
   at 
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
   at 
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
   at 
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)

   at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
   at 
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
   at 
com.sun.star.report.pentaho.PentahoReportEngine.(PentahoReportEngine.java:45)
   at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
   at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.PackageM

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr


Tom,
Well, yes.  But I remember the wise words of Adam Osborne, the 
entrepreneur who made the Osborne computer back in the 80s: "He, who 
lives on the cutting edge of technology, gets sliced to bits!"

I also am a firm believer in "if it ain't broke, don't fix it!"
Then there is "Never use a software program that has a version ending in 
zero!"  That one has bitten me many times, such as OpenOffice 3.3.0 - 
very buggy.  Now here we are with LO 3.5.3.2 (no zero) and it seems to 
work fine, other than the Oracle Report Builder extension, which is 
version 1.2.0 (zero again).


Usually, the only reason I update something is that something else 
requires the update and that something else has a compelling reason to 
need it.  Or, as you say, it is a security bug fix.

Take care.
Girvin



Tom Davies wrote:

Hi :)
The java version you have should be ok.  We used to have a lot of trouble with the newer versions of java but with the 3.5.x branch that seemed to get sorted out.  So, it is better to try to stick with the newer versions of java.  

Of course we will soon probably have to upgrade or patch due to some new and 'unforeseen' security flaw in java.  Some other programs almost never have security issues at all and only upgrade to add new features but with java it's just to fix whatever they broke or didn't fix last time.  
Regards from

Tom :)



--- On Sat, 26/5/12, Girvin R. Herr  wrote:

From: Girvin R. Herr 
Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
To: users@global.libreoffice.org
Date: Saturday, 26 May, 2012, 22:34



Andreas Säger wrote:
  

Am 26.05.2012 22:13, Girvin R. Herr wrote:


Andreas,
Yes! Plus the "com.mysql.jdbc.Driver" class and the "MySQL (JDBC)"
connection type option.
And I am using the "MySQL-connector-java-5.0.7-bin.jar" in the class
path and the MySQL 5.0.67 server.
Sun (Oracle) Java version 1.6.0_30
All test okay, of course.
Thanks.
Girvin


  

Install Java 1.6.0_22 or LibreOffice 3.5.x and things will run with normal 
speed.




Andreas,
I hate to tell you this, but I am already using LibreOffice 3.5.3.2.  Or did you mean 
"and", not "or"?
Please don't make me go back to Oracle and try to open an account on their 
website just to download an archived Java version.  I already tried that and 
when I goofed, thinking I entered 8 chars for the password and only entered 7, 
a bug in their system would not allow me to change my goof.  Arrgh!
Thanks.
Girvin


-- 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] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr




Andreas Säger wrote:

Am 26.05.2012 22:13, Girvin R. Herr wrote:



Andreas,
Yes! Plus the "com.mysql.jdbc.Driver" class and the "MySQL (JDBC)"
connection type option.
And I am using the "MySQL-connector-java-5.0.7-bin.jar" in the class
path and the MySQL 5.0.67 server.
Sun (Oracle) Java version 1.6.0_30
All test okay, of course.
Thanks.
Girvin




Install Java 1.6.0_22 or LibreOffice 3.5.x and things will run with 
normal speed.




Andreas,
I hate to tell you this, but I am already using LibreOffice 3.5.3.2.  Or 
did you mean "and", not "or"?
Please don't make me go back to Oracle and try to open an account on 
their website just to download an archived Java version.  I already 
tried that and when I goofed, thinking I entered 8 chars for the 
password and only entered 7, a bug in their system would not allow me to 
change my goof.  Arrgh!

Thanks.
Girvin


--
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: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr


Tom,
No, I did not compile from source.  I just repackaged the RPM binaries 
into the Slackware package format for installation.


I assume you are talking about Patrick Volkerding, the Slackware guru.  
I am not sure what his position is with the Slackware organization.  He 
was very sick a few years ago and he may be cutting back.  Slackware is 
still not bundling *Office in their Linux distros.  It is a long story, 
but I am not using the latest and greatest Slackware, so I am pretty 
much on my own for the latest packages.  That is why I package my own 
Slackware packages.  Besides, it takes hours to compile OOo/LO.  I would 
rather just re-package the binaries.  I might note that I have done so 
for many years, since about OOo 2.4, without any known problems with the 
binaries - until AOO 3.4.0.


As far as compiling from Source goes, I tried that with OOo (AOO?) 3.4.0 
and it was a disaster. Apache has dependency requirements that are, 
again, too new for my older versions.  They even tossed GNU make for yet 
another make: "dmake", which looks like another PHD thesis result - not 
a major improvement on GNU make.  For instance, they now require a newer 
glibc than I have.  Since just about every piece of Linux software 
depends on glibc, the core library, I was not willing to bring my system 
down when something went wrong with the new glibc interface, just to be 
able to update AOO.  That was the main reason I switched to LO.  This 
latest version of LO (3.5.3.2) still runs with my older glibc.  IMHO, 
that was a smart move on the Document Foundation's part.  I could go on 
and on, but I digress.


Thanks for the help.
Girvin



Tom Davies wrote:

Hi :)
If you are re-compiling from Rpms then why not just compile from the original source code?  Is Patrick still involved with packaging things for the slackware repos?  If so then he might be worth contacting.  Apparently he used to be very helpful and approachable.  
Regards from

Tom :)


--- On Sat, 26/5/12, Girvin R. Herr  wrote:

From: Girvin R. Herr 
Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
To: users@global.libreoffice.org
Date: Saturday, 26 May, 2012, 20:43



drew jensen wrote:
  

On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote:
   


drew jensen wrote:
8><...
 
  

Hi Tom

Really - you seem to know a lot, are you writing a manual?

@Girvin - there is no place that I've seen the report builder be that
slow and not have an installation problem - not saying it is impossible
but sounds really odd. 1500 records in a tabular report, 49 seconds is a
long time for that actually. There is one exception to that, graphics -
is your report including graphics stored in data fields?

On the other hand Calc, as has been pointed out, might be your preferred
path.

Best,

//drew

 


8><...

Hello Drew,
I understand what you are saying, but I installed the LO 3.5.2 binary (RPM) 
packages from the LO website.  I repackaged them for Slackware, but that does 
not change the 1s and 0s, just unpacks the RPMs and re-packages the files into 
a Slackware package for installation.  Therefore, if there is an installation 
problem, it seems to be in the LO packages.  Note that I am using the Report 
Builder bundled into LO, not the version from the extensions website.  I do 
believe the newest is 1.2.1 rev 2, and the one in LO is still 1.0-something.  I 
have not tried to replace the bundled version with the 1.2 version.

I could live with 49 _"seconds"_.  However, it is taking 49 _minutes_ for my 
report.  My database is nothing special, just text and integer values.  Nine elements 
plus the key per record.  No graphics.  So, yes, this problem does sound unusual.  
However, I have not been able to pin down the problem yet.  In the meantime, I am looking 
into using Calc to print my data.  It looks good and will do until I can get RB working.

BTW: The report is a simple text page header, Detail, and page footer, no 
graphics there either.  I do have the date and time fields in the header, but 
that shouldn't bring it down.  Actually, I do have some separator lines 
inserted at the bottom of the header and the bottom of each Detail line.  Page 
number at the bottom of the footer.  That's it.
Thanks for the help.
 
  

Hi Girvin

Sounds like it aught to run lickity-split...hmm

Anyway - looks like you are off to use Cacl.

You might want to do this.

When you open the data window under Calc, instead of copy/paste from the
data grid - grad, drag and drop the actual query name from the left side
of the data window. This will create a named range, you can set options
on the range to _not_ save the data in the spreadsheet, jut the
connection information...then when you open the spreadsheet again it
will re-run the query and update the data anew..

Best wishes,

//drew
   


Drew,
Yes!  Your procedure worked fine!  Thanks much.  It will make usi

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr




Andreas Säger wrote:
8><...


I was thinking of this problem which affects Linux+Java-DB+LibO before 
3.5:
http://www.oooforum.org/forum/viewtopic.phtml?t=125253&highlight=java+linux 



The problem has gone with LibreOffice 3.5 and it did not exist under 
operating systems other than Linux.




Andreas,
Yes, this is the very problem I had a few months ago with OOo 3.3.0 when 
I updated my 1.6.0_11 JRE to 1.6.0.30 and brought Base to its knees.  
Someone on the OOo users forum told me about this one and suggested I 
back up to 1.6.0_22, the last Java known to work with 3.3.0.  Note that 
the trouble i am having with ORB this time around is not quite the 
same.  I am not having any speed problems with normal Base form data 
entry and searching.  My problem seems to be limited to ORB.  So, 
indeed, it seems to be fixed for Base, but maybe not for ORB.

Thanks for the help.
Girvin


--
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: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr




drew jensen wrote:

8><...

Ah I missed that last bit - yup, those JDBC connections can suck - has
the OP tried ODBC?

//drew

  

Drew,
I am the OP.
No, I have not tried ODBC.  The only configuration documentation I have 
been able to get for MySQL and Base, used JDBC.  At the time, that 
documentation was not in the OOo/LO manuals.  I had to search the web 
for it.
If you have links to LO/OOo configuration documentation for ODBC 
connection to MySQL, I would be willing to try it.

Thanks.
Girvin



--
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: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr




Andreas Säger wrote:

Am 26.05.2012 00:47, Girvin R. Herr wrote:


As an update to my problem with Report Builder, my 1500+ record database
takes 94 pages of a Report Builder / Writer document. I put on my
patience hat and timed how long it takes to format the report, ready for
printing. As a baseline, it takes about 49 minutes to create the
original document. I cleared my preferences and re-entered them, using
mostly defaults and timed it again: 49 minutes. So it is not preference
corruption from previous versions. I then updated my java to 1.6u30 and
timed it again: 49 minutes. So, it doesn't look like Java is the
problem. I then went back to my original use of SQL from when I created
the report with the wizard, rather than using a query for the data and
timed it: 49 minutes! No matter what I do, it takes about the same
excruciatingly long time to build my report. What is really frustrating
is that there is no status popup to inform me of what it is doing. It
just goes out to lunch. Actually, it seems to initially create 128 pages
with header and footer, but no data, at the end of the first "sleep".
When the page status at the bottom of the writer window drops to 94
pages, I know it is done. Every so many pages, it does come back alive
for a second or two and then goes out to lunch again for several
minutes. Each time it returns, a few more pages are populated with data.
Girvin




Every time when there is a performance problem with this office suite, 
Tom blames Java. It has to be Java just because Java is evil.


Now this may be related to the one and only Java related performance 
problem and Tom does not even notice.


You are running the combination of Linux, Base plus JDBC?



Andreas,
Yes!  
Plus the "com.mysql.jdbc.Driver" class and the "MySQL (JDBC)" connection 
type option.
And I am using the "MySQL-connector-java-5.0.7-bin.jar" in the class 
path and the MySQL 5.0.67 server.

Sun (Oracle) Java version 1.6.0_30
All test okay, of course.
Thanks.
Girvin


--
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: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr




Andreas Säger wrote:

8><...


-- When you drag the query icon from the left pane of the data source 
window onto a Calc cell you will get a semi-automatic link. Call 
menu:Data>Refresh to refresh the link.
-- When you drag selected row selectors you get a copy of selected 
rows. The top-left corner of a row set selects all rows. Same with 
queries, views and tables opened from some database window.
-- Dragging a query icon from the database window creates a 
refreshable link as well but the link breaks when the connection 
closes. Bug or not bug? Who cares?
-- From a form you can copy from the additional grid view. Hit the 
last button on the navigation tool bar.


The linked data range resizes dynamically with every refresh.
Any formula cells directly adjacent to the import range will expand 
and shrink with the resized data range. So the clearly defined row 
sets of a database enable dynamically resizing formula ranges. A 
feature that does not exist with a pure spreadsheet. Tons of silly 
macro code have been written for this.


Its properties are accessible via menu:Data>Define...
Below [More Options] we have 4 widely unknown options:
1) Contains column labels (always true for database imports)
2) Keep formatting: spreadsheet formatting overrides any Base 
formatting. Should be true by default.
3) Insert/remove cells: Do not overwrite/clear cells when the database 
range expands/shrinks. Should be true by default, particularly with 
resizing formula ranges.
4) Don't save imported data. Useful with very large row sets and when 
you want to refresh on open. Prompts for refresh when opening the file.




Andreas,
Wow!  You gave me a lot to think about.  I will have to experiment a bit 
with these suggestions.

Thank you very much for your help.
Girvin


--
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: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr


Fernand,
I am assuming you are talking about the "Data" tab for the report where 
there are "Content Type" and "Content" option lists.  I tried it both 
ways with the same results.  Originally, I was using the SQL command(s) 
the wizard created when I first created the report.  Those SQL commands 
accessed the data directly without using a query.  I then changed it to 
use the Query I created, so I could calculate the total cost based on 
the quantity and unit cost data and pass it to the report for printing.  
Both versions of the report performed about the same.


I am using the same query for my Calc version of the report and it 
imports the data in a few seconds.  So, I don't think that is the 
bottleneck.

Thanks for your help.
Girvin



Fernand Vanrie wrote:

 Girvin ,

You must know that ORB , when openning a report, first  execute the 
SQL commands "saved" with the report, this can surrly takes some time, 
then you can give a new 'actual)set off SQL commands. Therefore we 
never safe the reports with real SQL commands, we just make a dummy 
command and so the reports are comming up match quicker.

Hope its helps

Fernand



Andreas Säger wrote:
With LibO 3.5 under Linux I can use any recent Java version without 
any issues. I tested 1.6.22, 1.6.31 and 1.7. Any of these simply 
work with my Java databases.
I avoid the report builder like illness. If you feel the need to 
dance with this software diva then you should do all calculations, 
filtering, grouping and sorting in SQL leaving the only good looking 
stuff up to the beast.




Andreas,
Thanks for your reply.  Report Builder (RB) has always been a "beast" 
to me too, but it is the only option I know of for printing my 
database data in a human readable form.  So, I have to live with it, 
at least until I find something better.  Before Base, I was using 
Rekall, which had some nice features.  But that Open Source version 
is no longer supported, so that option is dead.
I am using a SQL query to sort and provide all the data to Report 
Builder.  I am not using any RB grouping or filtering either.  It is 
just a "flat" data set for RB to pretty up for printing.  That is why 
I don't see why it is so slow.  All the real time consumers, such as 
sorting, are being done by MySQL.  Also, after writer displays my 
first page or two, it goes out to lunch again, as if it is 
recalculating everything all over again.  That is frustrating, since 
it locks up and I have to wait several more minutes for another 
couple-second window where I can scroll or kill it before it goes off 
again.
I will certainly take your experience to heart and your 
recommendation to update my Java.

Thanks again.
Girvin







--
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: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr




drew jensen wrote:

On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote:
  

drew jensen wrote:
8><...


Hi Tom

Really - you seem to know a lot, are you writing a manual?

@Girvin - there is no place that I've seen the report builder be that
slow and not have an installation problem - not saying it is impossible
but sounds really odd. 1500 records in a tabular report, 49 seconds is a
long time for that actually. There is one exception to that, graphics -
is your report including graphics stored in data fields?

On the other hand Calc, as has been pointed out, might be your preferred
path.

Best,

//drew

  
  

8><...

Hello Drew,
I understand what you are saying, but I installed the LO 3.5.2 binary 
(RPM) packages from the LO website.  I repackaged them for Slackware, 
but that does not change the 1s and 0s, just unpacks the RPMs and 
re-packages the files into a Slackware package for installation.  
Therefore, if there is an installation problem, it seems to be in the LO 
packages.  Note that I am using the Report Builder bundled into LO, not 
the version from the extensions website.  I do believe the newest is 
1.2.1 rev 2, and the one in LO is still 1.0-something.  I have not tried 
to replace the bundled version with the 1.2 version.


I could live with 49 _"seconds"_.  However, it is taking 49 _minutes_ 
for my report.  My database is nothing special, just text and integer 
values.  Nine elements plus the key per record.  No graphics.  So, yes, 
this problem does sound unusual.  However, I have not been able to pin 
down the problem yet.  In the meantime, I am looking into using Calc to 
print my data.  It looks good and will do until I can get RB working.


BTW: The report is a simple text page header, Detail, and page footer, 
no graphics there either.  I do have the date and time fields in the 
header, but that shouldn't bring it down.  Actually, I do have some 
separator lines inserted at the bottom of the header and the bottom of 
each Detail line.  Page number at the bottom of the footer.  That's it.

Thanks for the help.


Hi Girvin

Sounds like it aught to run lickity-split...hmm

Anyway - looks like you are off to use Cacl.

You might want to do this.

When you open the data window under Calc, instead of copy/paste from the
data grid - grad, drag and drop the actual query name from the left side
of the data window. This will create a named range, you can set options
on the range to _not_ save the data in the spreadsheet, jut the
connection information...then when you open the spreadsheet again it
will re-run the query and update the data anew..

Best wishes,

//drew
  

Drew,
Yes!  Your procedure worked fine!  Thanks much.  It will make using Calc 
to produce my reports a lot more error free.  I have not tested the 
dynamic importation of the data yet, but even if it doesn't work, which 
I am sure it will, this procedure is much better than my copy-paste 
procedure.  Another benefit of using Calc will be to save paper.  
Whereas the ORB output used 94+ pages, the Calc output, being more 
compressed, even with the separation grid, produces about half that 
number - 47 pages.


Your suggestion of an installation problem causing ORB to fail for me 
got me thinking and I realized I did modify one aspect of the LO 
distribution package.  I moved the 2 executable files in "/usr/bin" to 
"/opt/bin".  Just in case ORB was relying on these files being in 
"/usr/bin", the first thing I did today was to restore those 2 files in 
"/usr/bin" and try ORB again.  No joy.  It is now taking 66 minutes.  
However, since my last tests, I entered more data and now my database is 
1800+ records.  So that accounts for the increase in time.  Note that it 
does not take anywhere near this amount of time to import the data into 
Calc.  Calc does it in a few seconds, not tens of minutes.


Thanks very much for your help.
Girvin


--
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: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr




drew jensen wrote:
8><...


Hi Tom

Really - you seem to know a lot, are you writing a manual?

@Girvin - there is no place that I've seen the report builder be that
slow and not have an installation problem - not saying it is impossible
but sounds really odd. 1500 records in a tabular report, 49 seconds is a
long time for that actually. There is one exception to that, graphics -
is your report including graphics stored in data fields?

On the other hand Calc, as has been pointed out, might be your preferred
path.

Best,

//drew

  

8><...

Hello Drew,
I understand what you are saying, but I installed the LO 3.5.2 binary 
(RPM) packages from the LO website.  I repackaged them for Slackware, 
but that does not change the 1s and 0s, just unpacks the RPMs and 
re-packages the files into a Slackware package for installation.  
Therefore, if there is an installation problem, it seems to be in the LO 
packages.  Note that I am using the Report Builder bundled into LO, not 
the version from the extensions website.  I do believe the newest is 
1.2.1 rev 2, and the one in LO is still 1.0-something.  I have not tried 
to replace the bundled version with the 1.2 version.


I could live with 49 _"seconds"_.  However, it is taking 49 _minutes_ 
for my report.  My database is nothing special, just text and integer 
values.  Nine elements plus the key per record.  No graphics.  So, yes, 
this problem does sound unusual.  However, I have not been able to pin 
down the problem yet.  In the meantime, I am looking into using Calc to 
print my data.  It looks good and will do until I can get RB working.


BTW: The report is a simple text page header, Detail, and page footer, 
no graphics there either.  I do have the date and time fields in the 
header, but that shouldn't bring it down.  Actually, I do have some 
separator lines inserted at the bottom of the header and the bottom of 
each Detail line.  Page number at the bottom of the footer.  That's it.

Thanks for the help.
Girvin


--
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: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr




Dan Lewis wrote:



 Yes, you can link to a Base query with Calc. With Cal open, use the
F4 key to open the Data Source window. (You will have to register the
database before it will appear in this window.) The left side is the
name of the registered databases. Click the arrow in front of the
database to see that you can get data from from a table or query. When
you select one of these, its data appears in table form on the right
side.

--Dan



  

Dan,
Wow!  That worked fine.  Thanks.
However, I had to copy and paste the database data from the Data Source 
window into the Calc spreadsheet.  Is there a way to dynamically get the 
current data to the spreadsheet so I don't have to cut and paste every 
time I have new data?
If so, it would be a lot less error-prone (and easier).  However, I can 
see that not being able to do so, is not a show-stopper for using Calc 
to do my reports.
Note that the data copy, although it took a little time, was *much* 
faster than Report Builder!  :-)

I am going to have to play with this some more...
Thanks very much.
Girvin



--
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: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr

Tom Davies wrote:

Hi :)
I have just done a bit of digging around.

Looking back through Andreas' answers
http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodes&user=254826&i=80

I found this but i'm not sure it's much help for you
http://nabble.documentfoundation.org/database-td3926217i20.html#a3928210

This one seems to expand on the useful line at the end there
http://nabble.documentfoundation.org/Base-3-5-2-2-hangs-td3910280.html#a3911654

This one is a bit of an overview with nothing specific but might be useful to
skim through for ideas
http://nabble.documentfoundation.org/Address-Books-td3829696.html#a3832514

This one looks brilliant to me
http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3819387

There is some documentation at
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
and an FAQ (translated from the French team's) at
https://wiki.documentfoundation.org/Faq

Sadly most of the people that know a lot about the ins-and-outs of Base are unwilling to help write the Base guide so it's down to 1 person who is desperately busy with a lot of other projects.

Regards from
Tom :)

Tom,
Your "brilliant" link looks interesting. I knew Calc and Base have some
similarities internally, but I wasn't aware that my data could be
imported into Calc from my MySQL server. All of my reports are tabular
in format anyway, so Calc could be an option, if it could get my data.
One limit to using Calc would be Calc's row limit. I think I read that
LO just raised the maximum rows, but if there are more database records
than available Calc rows, then...

Can Calc be linked to a Base query to get its data?
If so, then all my sorting can be done in the query. I do not do any
grouping in my reports at this time.

As an update to my problem with Report Builder, my 1500+ record database
takes 94 pages of a Report Builder / Writer document. I put on my
patience hat and timed how long it takes to format the report, ready for
printing. As a baseline, it takes about 49 minutes to create the
original document. I cleared my preferences and re-entered them, using
mostly defaults and timed it again: 49 minutes. So it is not preference
corruption from previous versions. I then updated my java to 1.6u30 and
timed it again: 49 minutes. So, it doesn't look like Java is the
problem. I then went back to my original use of SQL from when I created
the report with the wizard, rather than using a query for the data and
timed it: 49 minutes! No matter what I do, it takes about the same
excruciatingly long time to build my report. What is really frustrating
is that there is no status popup to inform me of what it is doing. It
just goes out to lunch. Actually, it seems to initially create 128
pages with header and footer, but no data, at the end of the first
"sleep". When the page status at the bottom of the writer window drops
to 94 pages, I know it is done. Every so many pages, it does come back
alive for a second or two and then goes out to lunch again for several
minutes. Each time it returns, a few more pages are populated with data.

Girvin

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-24 Thread Girvin R. Herr




Alexander Thurgood wrote:

Le 24/05/12 00:01, Girvin R. Herr a écrit :

Hi Girvin,

  

   MySQL 5.0.67
   MySQL-connector-java-5.0.7-bin.jar
   Sun Java  1.6.0u11



Oooh, very old and potentially highly exploitable version of Java there.


  

Is my current Report Builder problem caused by this Java problem again?



Yes.


  

Unlike OOo 3.3, will LO 3.5.3 work with the later Java versions and
should I try updating my Java again?



I have whatever version of Java Apple have grudgingly agreed to give me
(u31, apparently), and apart from the usual flakiness of the whole ORB
reporter extension, it works, but I won't even bother for large datasets
because on the Mac it regularly crashes. However, it does seem to be
more stable on other OSes. I would try upgrading the Java version to
something more recent first though.

It has been said, and I certainly found on Linux that u22 was still
pretty fast, although it too, had some nasty security issues. Much has
been written on this list in the past about how to keep several versions
of the JDK on your system at the same time, and then use only the one
you need with the best performance for LO.

Alex

  

Alex,
Thanks for your reply.
I will take your recommendation to update my Java to heart and do so.
My datasets (tables) are typically over 1000 records.  The dataset I am 
working on now, a parts inventory, is over 1500 records and I am only, 
maybe, 10% done with it.  So I still have a long way to go.  This is the 
first time I have seen Report Builder brought to its knees.   It has 
always been a bit slow, but this is ridiculous.  I have had other 
datasets with even more records, that RB has processed with reasonable 
speed in the past.  That is what makes this problem so strange.  It is 
like I reached some sort of threshold or something.
I wouldn't think keeping more than one Java version on my machine at 
once would be a problem.  I know Sun/Oracle recommends removing any old 
versions, but it should work without doing that.  Especially *Office, 
which allows a specific version to be selected.  I also have a copy of 
the Free Software Foundation Java, and it seems to co-reside with the 
"Sun" Java.  However, I don't know what app on my machine is using it.


Thanks again for your help.
Girvin


--
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: Extremely Slow Base Report Builder

2012-05-24 Thread Girvin R. Herr




Andreas Säger wrote:
With LibO 3.5 under Linux I can use any recent Java version without 
any issues. I tested 1.6.22, 1.6.31 and 1.7. Any of these simply work 
with my Java databases.
I avoid the report builder like illness. If you feel the need to dance 
with this software diva then you should do all calculations, 
filtering, grouping and sorting in SQL leaving the only good looking 
stuff up to the beast.




Andreas,
Thanks for your reply.  Report Builder (RB) has always been a "beast" to 
me too, but it is the only option I know of for printing my database 
data in a human readable form.  So, I have to live with it, at least 
until I find something better.  Before Base, I was using Rekall, which 
had some nice features.  But that Open Source version is no longer 
supported, so that option is dead.
I am using a SQL query to sort and provide all the data to Report 
Builder.  I am not using any RB grouping or filtering either.  It is 
just a "flat" data set for RB to pretty up for printing.  That is why I 
don't see why it is so slow.  All the real time consumers, such as 
sorting, are being done by MySQL.  Also, after writer displays my first 
page or two, it goes out to lunch again, as if it is recalculating 
everything all over again.  That is frustrating, since it locks up and I 
have to wait several more minutes for another couple-second window where 
I can scroll or kill it before it goes off again.
I will certainly take your experience to heart and your recommendation 
to update my Java.

Thanks again.
Girvin


--
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] Extremely Slow Base Report Builder

2012-05-23 Thread Girvin R. Herr


Greetings,
I have installed LibreOffice (LO) 3.5.3.2 and I am quite pleased with 
it.  I am a long-time OpenOffice (OOo) user going back to 1.0 and even 
Star Office before that and after not being able to install the latest 
Apache OpenOffice (AOO) version, I switched to LibreOffice.  I say that 
to confirm I am a new user to LO, but somewhat experienced with the 
*Office tree.


I used Oracle Report Builder 1.2.1-rev2 on my OOo 3.3.0 for some time 
and expected the LO Report Builder to be fine, especially since 
configuring & importing my MySQL databases, forms, queries, etc. worked 
great.  Report Builder does seem to work - sort of- but it is extremely 
slow when executing the report.  So slow, it is unusable; taking minutes 
to display a report in Writer.  Then it keeps repeatedly going out to 
lunch for long periods so I cannot do anything with the report in 
Writer, such as scrolling down to examine the report.  I am using the 
following database server:


   MySQL 5.0.67
   MySQL-connector-java-5.0.7-bin.jar
   Sun Java  1.6.0u11

A few months ago, I had a similar problem with OOo 3.3.0 after I updated 
my Java RE to 1.6.0u30.  I posted my problem on the OOo Users forum and 
was told OOo 3.3.0 will only work with Java up to u22.  That problem did 
not just affect Report Builder, but the entire Base functionality.  This 
time with LO, the non-Report Builder Base functions work fine, at 
"normal" speed.  I do not see any hesitation with Base form data entry.


Is my current Report Builder problem caused by this Java problem again?
Unlike OOo 3.3, will LO 3.5.3 work with the later Java versions and 
should I try updating my Java again?
I also have a Free Software Foundation Java 1.4.2 installed, but I think 
I read somewhere not to use it with LO.

Any suggestions where to look would be appreciated.  Thanks in advance.
Girvin Herr




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

< 1 2

101 - 170 of 170 matches

Mail list logo