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

2012-05-26 Thread Fernand Vanrie
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

Re: [libreoffice-users] right-clicking Font list options not showing all my installed fonts

2012-05-26 Thread Manfred J. Krause
Hi, On Sat, May 26, 2012 at 2:55 AM, webmaster-Kracked_P_P wrote: Font formatting issue You highlight your text, then right-click The you choose the Font option. For me, when I go down the list, I do not go out of the A's for the font names. How many fonts is that list designed to deal

[libreoffice-users] Open Type fonts

2012-05-26 Thread Guy Voets
Hello, For a magazine, the editor uses an Open Type font from Adobe. Are there any problems using such a font in LO on my Mac? He has a license for the font for me, but I first want to make sure I can use it in LO on my Mac. I ask this beacuse I have some doubts when MS and Adobe call something

Re: [libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-26 Thread Brian Barker
At 17:14 25/05/2012 +0200, MiguelAngel wrote: Maybe the mistake is in search for 0.000, it can't be found, because a 0.000 is always saved as 0, nonsignificant zeroes to the right/left of decimal point are never saved. Computers store numbers in a fixed-length format - however-many bytes.

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

2012-05-26 Thread Andreas Säger
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

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

2012-05-26 Thread Andreas Säger
Am 26.05.2012 12:40, Andreas Säger wrote: 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

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

2012-05-26 Thread Andreas Säger
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

[libreoffice-users] Re: Open Type fonts

2012-05-26 Thread Andreas Säger
Am 26.05.2012 11:59, Guy Voets wrote: Hello, For a magazine, the editor uses an Open Type font from Adobe. Are there any problems using such a font in LO on my Mac? He has a license for the font for me, but I first want to make sure I can use it in LO on my Mac. I ask this beacuse I have some

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

2012-05-26 Thread drew jensen
On Sat, 2012-05-26 at 12:53 +0200, 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

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

2012-05-26 Thread Andreas Säger
Am 26.05.2012 13:32, drew jensen wrote: On Sat, 2012-05-26 at 12:53 +0200, Andreas Säger wrote: You are running the combination of Linux, Base plus JDBC? Ah I missed that last bit - yup, those JDBC connections can suck - has the OP tried ODBC? //drew I was thinking of this problem

Re: [libreoffice-users] Re: Open Type fonts

2012-05-26 Thread Guy Voets
2012/5/26 Andreas Säger ville...@t-online.de Am 26.05.2012 11:59, Guy Voets wrote: Hello, For a magazine, the editor uses an Open Type font from Adobe. Are there any problems using such a font in LO on my Mac? He has a license for the font for me, but I first want to make sure I can use

Re: [libreoffice-users] Re: Open Type fonts

2012-05-26 Thread Guy Voets
2012/5/26 Guy Voets nimant...@gmail.com 2012/5/26 Andreas Säger ville...@t-online.de Am 26.05.2012 11:59, Guy Voets wrote: Hello, For a magazine, the editor uses an Open Type font from Adobe. Are there any problems using such a font in LO on my Mac? He has a license for the font for me,

Re: [libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-26 Thread MiguelAngel
El 26/05/12 12:41, Brian Barker escribió: At 17:14 25/05/2012 +0200, MiguelAngel wrote: Maybe the mistake is in search for 0.000, it can't be found, because a 0.000 is always saved as 0, nonsignificant zeroes to the right/left of decimal point are never saved. Computers store numbers in a

Re: [libreoffice-users] Re: Open Type fonts

2012-05-26 Thread webmaster-Kracked_P_P
On 05/26/2012 09:06 AM, Guy Voets wrote: 2012/5/26 Andreas Sägerville...@t-online.de Am 26.05.2012 11:59, Guy Voets wrote: Hello, For a magazine, the editor uses an Open Type font from Adobe. Are there any problems using such a font in LO on my Mac? He has a license for the font for me, but

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

2012-05-26 Thread Tom Davies
Hi :) I thought that the Calc route just read the data that is contained in the database?  I didn't think it converted it or export-imported it or dragged it in, i just thought it was another way of accessing the data.  Also i kinda had assumed that the Calc route would allow you to view

Re: [libreoffice-users] is there an Open office equivalent to Visio 2000

2012-05-26 Thread Fabian Rodriguez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12-05-25 12:23 PM, Tom Davies wrote: Hi :) Have you tried Draw in LibreOffice 3.5.3? I know it can handle some Visio Files Regards from Tom :) Related: http://www.pcpro.co.uk/news/374854/no-free-visual-studio-for-windows-8-desktop-developers

Re: [libreoffice-users] Re: Calc: Search Replace Within A Column

2012-05-26 Thread Brian Barker
At 15:43 26/05/2012 +0200, Miguel Angel wrote: El 26/05/12 12:41, Brian Barker escribió: At 17:14 25/05/2012 +0200, Miguel Angel wrote: Maybe the mistake is in search for 0.000, it can't be found, because a 0.000 is always saved as 0, nonsignificant zeroes to the right/left of decimal point

Re: [libreoffice-users] is there an Open office equivalent to Visio 2000

2012-05-26 Thread Tom Davies
Hi :) Oh, weird.  I thought they were keen on attracting developers and making it easier for talented people to write things for their platforms? http://www.youtube.com/watch?v=Vhh_GeBPOhs Promises, promises lol Regards from Tom :)  --- On Sat, 26/5/12, Fabian Rodriguez magic...@member.fsf.org

Re: [libreoffice-users] is there an Open office equivalent to Visio 2000

2012-05-26 Thread webmaster-Kracked_P_P
On 05/26/2012 11:41 AM, Fabian Rodriguez wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12-05-25 12:23 PM, Tom Davies wrote: Hi :) Have you tried Draw in LibreOffice 3.5.3? I know it can handle some Visio Files Regards from Tom :) Related:

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 -

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

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:DataRefresh to refresh the link. -- When you drag selected row selectors you get a copy of selected rows. The top-left

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

Re: [libreoffice-users] Open Type fonts

2012-05-26 Thread J.A. de Vries
On 2012-05-26 11:59, Guy Voets wrote: Hello, For a magazine, the editor uses an Open Type font from Adobe. Are there any problems using such a font in LO on my Mac? He has a license for the font for me, but I first want to make sure I can use it in LO on my Mac. I ask this beacuse I have

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

2012-05-26 Thread Tom Davies
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 :)

Re: [libreoffice-users] Open Type fonts

2012-05-26 Thread J.A. de Vries
Hi Guy, I use lots of OpenType Fonts (.otf files)) in LibreOffice on my Debian system. Never had any trouble with them at all. I figure you shouldn't have a problem under Windows either, but I can't verify that for you as I don't have that OS at hand. I am sorry. You were asking about Mac.

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

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=125253highlight=java+linux The problem has gone with LibreOffice 3.5 and it did not exist under operating systems other than Linux.

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

2012-05-26 Thread Andreas Säger
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

Re: [libreoffice-users] Documents do strange things

2012-05-26 Thread Tom Davies
Hi :) Is it something to do with Styles and templates?  Chapter 3 https://wiki.documentfoundation.org/Documentation/Publications#Getting_Started_with_LibreOffice Even if not then it still might make formatting much easier Regards from Tom :)  --- On Fri, 25/5/12, Jay Lozier jsloz...@gmail.com

Re: [libreoffice-users] Open Type fonts

2012-05-26 Thread Dan Lewis
On Sat, 2012-05-26 at 22:25 +0200, J.A. de Vries wrote: Hi Guy, I use lots of OpenType Fonts (.otf files)) in LibreOffice on my Debian system. Never had any trouble with them at all. I figure you shouldn't have a problem under Windows either, but I can't verify that for you as I don't

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

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

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

2012-05-26 Thread Tom Davies
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

[libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file

2012-05-26 Thread NoOp
On 05/25/2012 07:16 AM, Jonathan Ryshpan wrote: I have been attempting to send this posting for a while, and have only recently noticed that the list does not accept attachments. This has (apparently) caused it to be silently rejected. I have appended what had been attached to the end of

[libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file

2012-05-26 Thread NoOp
On 05/26/2012 02:56 PM, NoOp wrote: ... Mine is installed on Ubuntu/Debian - (I'd need to fire up Fedora in a VM to test that distro). Here is my .odbc.ini file (configured with OBDConfig): $ cat /home/gl/.odbc.ini [SeaMonkeyPlaces.sqlite] Description = SQLite3 Driver = SQLite3 Database =

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

[libreoffice-users] Re: Documents do strange things

2012-05-26 Thread Tinkerer
Wanda you can set the default fonts for LO documents using TOOLSOPTIONSLibreOffice WriterBasic Fonts (Western). You can select any installed Western font as the default font. Jay Lozier wrote On 05/25/2012 05:55 PM, Wanda Moore wrote: I use the right click menu or edit in the toolbar. I've

[libreoffice-users] Re: Documents do strange things

2012-05-26 Thread Tinkerer
Something went wrong there. I should have said: There is no Tools Options for LO in the Mac system. To make the correction you need: Libre Office Preferences Writer etc. Tink. -- View this message in context:

Re: [libreoffice-users] modifying existing labels/cards

2012-05-26 Thread Joep L. Blom
On 26-05-12 05:05, Don Myers wrote: Hi Joep, The standard label formats included with LibreOffice and OpenOffice are the same type as Microsoft uses with fixed blocks. These tend to not to be accurate if the card/label is relatively full as you get toward the bottom of the page, even in

[libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file

2012-05-26 Thread NoOp
On 05/26/2012 03:04 PM, NoOp wrote: ... I'll give your database a try this weekend also try to find my ... SQlite database created by: 1. Opening the archive .txt file in Calc then saving as a .csv. Note: I modified the first header slightly from 'Timestamp' to 'Date Time' so that I'd have

[libreoffice-users] Re: modifying existing labels/cards

2012-05-26 Thread NoOp
On 05/25/2012 03:48 AM, Joep L. Blom wrote: I have a simple question: I have a sheet with business cards (made with the correct template, etc.) but as I have a different printer I want to adjust the dimensions as to fit them perfectly. How is that done? I can not find a modify button

[libreoffice-users] Re: Open Type fonts

2012-05-26 Thread NoOp
On 05/26/2012 02:59 AM, Guy Voets wrote: Hello, For a magazine, the editor uses an Open Type font from Adobe. Are there any problems using such a font in LO on my Mac? He has a license for the font for me, but I first want to make sure I can use it in LO on my Mac. I ask this beacuse I