Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
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] right-clicking Font list options not showing all my installed fonts
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 with? 100 (max.), see: OOo-Bug 61775 - Too Many Fonts in Context Menu; also context menu can take many seconds to appear with too many fonts installed → https://issues.apache.org/ooo/show_bug.cgi?id=61775 With all of the variations [bold, italic, bold italic, etc.] of the fonts and their file names, I have over 500 fonts installed on my default desktop computer. So I was wondering about how to show more fonts in that list. For people that have a lot of fonts installed on their desktop, it looks like you are not able to see all of their font names in that shortened list. So, it there some reason there is a shortened ability there when the Font list pull down box allows all of the fonts I have does show up? It seems like there is a possible problem here for some people. It can cause me problems if I follow the instructions for doing font formatting in certain ways. That right-click options show some options for font displaying, like overlines and other non-standard things that are not shown in the taskbar options for font formatting. So if one part of that formatting system is limited, then can I trust that the other options will not cause issues later on for my documents? I did find that if I formatted a text with the right-clicked overline and shadowed, I need to use the same right-clicking to remove it instead of using the normal taskbar formatting options. You may add a comment to Bug 34085 - [EDITING] [UI] List of fonts incomplete in context menu → https://bugs.freedesktop.org/show_bug.cgi?id=34085 mjk -- New and changed functions; you can experience and test them … now! http://blog.documentfoundation.org/2012/05/11/new-and-changed-functions-you-can-experience-and-test-them-now/ -- 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] Open Type fonts
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 'open'... -- Guy using LibO 3.5.3 on a iMac Intel DualCore Lion -- please reply only to users@global.libreoffice.org -- Dodoes can't afford to have headaches -- 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: Calc: Search Replace Within A Column
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. So there are always the same number of binary digits stored - which equates to a different but similarly (approximately) fixed number of decimal digits stored (unless you choose multiple precision, of course). So surely what you may think of as nonsignificant zeroes are not never but *always* stored? Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Extremely Slow Base Report Builder
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 -- 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 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:DataDefine... 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. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Extremely Slow Base Report Builder
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 ranges. A feature that does not exist with a pure spreadsheet. Tons of silly macro code have been written for this. I forgot: All references in formulas, conditional formatting, validation and charts dynamically adjust to the resized data range. A reference A2:A99 becomes A2:A100 when the import range grows by one row after refresh. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Extremely Slow Base Report Builder
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? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Open Type fonts
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 doubts when MS and Adobe call something 'open'... You are the one to find out. It costs you nothing to download this software and give a try. We don't have the Open Type fonts you are talking about. -- 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
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 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? Ah I missed that last bit - yup, those JDBC connections can suck - has the OP tried ODBC? //drew -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Extremely Slow Base Report Builder
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 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. -- 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: Open Type fonts
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 it in LO on my Mac. I ask this beacuse I have some doubts when MS and Adobe call something 'open'... You are the one to find out. It costs you nothing to download this software and give a try. We don't have the Open Type fonts you are talking about. Thanks, Andrea, but they're not exactly free. A single font costs 26 $, the whole family 280 $. I'm talking about the Avenir and ITC Stone families. Anybody knows how they behave on Mac LO? -- Guy using LibO 3.5.2 on a iMac Intel DualCore Lion -- please reply only to users@global.libreoffice.org -- Dodoes can't afford to have headaches -- 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: Open Type fonts
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, 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 'open'... You are the one to find out. It costs you nothing to download this software and give a try. We don't have the Open Type fonts you are talking about. Thanks, Andrea, but they're not exactly free. A single font costs 26 $, the whole family 280 $. I'm talking about the Avenir and ITC Stone families. Anybody knows how they behave on Mac LO? Sorry, Andreas... with S -- Guy using LibO 3.5.2 on a iMac Intel DualCore Lion -- please reply only to users@global.libreoffice.org -- Dodoes can't afford to have headaches -- Guy using LibO 3.5.2 on a iMac Intel DualCore Lion -- please reply only to users@global.libreoffice.org -- Dodoes can't afford to have headaches -- 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: Calc: Search Replace Within A Column
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 fixed-length format - however-many bytes. So there are always the same number of binary digits stored - which equates to a different but similarly (approximately) fixed number of decimal digits stored (unless you choose multiple precision, of course). So surely what you may think of as nonsignificant zeroes are not never but *always* stored? Brian Barker I think not a fixed format, but a fixed length with eight bytes used to store the number in memory, as result fourteen significant numbers. In any case the user can't find 0. or 000.00, we can search for 0. In content.xml file one of the files in .ods file, we can see the saved values in office:value tag and the representation of the value in text:p tag. - table:table table:name=Sheet1 table:style-name=ta1 table:table-column table:style-name=co2 table:default-cell-style-name=Default / - table:table-row table:style-name=ro2 - table:table-cell table:style-name=ce1 office:value-type=float office:value=0 text:p000,000/text:p /table:table-cell /table:table-row - table:table-row table:style-name=ro2 - table:table-cell office:value-type=float office:value=12345 text:p12345/text:p /table:table-cell /table:table-row - table:table-row table:style-name=ro2 - table:table-cell office:value-type=float office:value=0.12345 text:p0,12/text:p /table:table-cell /table:table-row - table:table-row table:style-name=ro2 - table:table-cell office:value-type=float office:value=123.123 text:p123,12/text:p /table:table-cell /table:table-row - table:table-row table:style-name=ro2 - table:table-cell table:style-name=ce2 office:value-type=float office:value=1.23456578901234E+015 text:p1,23E+015/text:p /table:table-cell /table:table-row - table:table-row table:style-name=ro2 - table:table-cell table:style-name=ce3 office:value-type=float office:value=1.23456578901234E+015 text:p1234565789012340/text:p /table:table-cell /table:table-row /table:table Miguel Ángel. * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano javascript:void(0); -- 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: Open Type fonts
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 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 'open'... You are the one to find out. It costs you nothing to download this software and give a try. We don't have the Open Type fonts you are talking about. Thanks, Andrea, but they're not exactly free. A single font costs 26 $, the whole family 280 $. I'm talking about the Avenir and ITC Stone families. Anybody knows how they behave on Mac LO? You are talking about the .OTF font files - right. It there any reason you are not using .TTF files? As for .OTF fonts from Adobe, Avenir 45 Book and Stone Sans; I went to my Adobe collection extracted one fonts from those names and installed then on my Ubuntu 10.04 system. Then I looked for them in LO. They showed up and seemed to work fine. I do not own a Mac, so I cannot say for that OS, but it does show up in LO with my system. I have Adobe fonts that have a file date of 2006, so I do not know if Adobe changed anything since then. I have [I believe] their complete font set in my collection. I have the TTF and OTF fonts stored in different zipped files. TTF - 191 MB zipped file, and OTF - 137 MB zipped file. -- 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
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 Queries in the same way as you access normal tables. I don't really understand everything in Andreas' links but it seemed to fit in with what Girvin was asking for. Quite a few people here have been extremely helpful to people using Base but i only remember Andreas going on about the alternatives to the Report Builder. Possibly Alex, Drew, Dan and others have mentioned things too but i just hadn't remembered anything i could find reliably. It would be really good if a few of you experts in Base could write it up, maybe help Dan or expand on the work he has done. In response to Andreas' How would you write a guide for hammer, chisel, plow, saw and file? http://www.wikihow.com/Use-a-Hammer-Safely It is estimated that some 50,000 Americans seek treatment every year as a result of a hammer injury. I guess it's similar in other countries but rant [deleted] /rant] http://artofmanliness.com/2009/09/29/how-to-use-a-hammer/ A lot of men today are clueless when it comes to tools. rant re:sexist [deleted] /rant http://www.instructables.com/id/How-to-use-Vavles-Hammer-Editor/ http://www.hammernet.com/tips.htm I'll ignore the bladed weaponry and activities that most people have no idea about (eg how many people really plow these days?! lol) http://www.wikihow.com/Organize-Files http://zenhabits.net/how-to-simplify-your-filing-system-or-why-stacking-just-doesnt-work/ http://www.realsimple.com/beauty-fashion/skincare/hands-feet/file-shape-nails-002331/index.html http://www.ehow.com/how_2034410_file-nails.html http://www.nailsmag.com/article/474/getting-nails-into-shape http://www.wikihow.com/File-Metal Just because you know something so thoroughly well that it seems easier than falling off a bike doesn't mean that anyone else can cope with any of it. Usually people that make something look easy have broken it down and worked hard at each step to make it smoother and less liable to break or go wrong or streamlined for speed. Regards from Tom :) --- On Sat, 26/5/12, drew jensen drewjensen.in...@gmail.com wrote: From: drew jensen drewjensen.in...@gmail.com Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder To: users@global.libreoffice.org Date: Saturday, 26 May, 2012, 4:50 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
Re: [libreoffice-users] is there an Open office equivalent to Visio 2000
-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 F. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: PGP/Mime available upon request Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk/A+a4ACgkQfUcTXFrypNW/uACfaDvzZjVytr6rC3BET5DPglOH w9cAnRbP4fKU8vrdkQRJjO4MB1HcbcNS =ddZO -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Calc: Search Replace Within A Column
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 are never saved. Computers store numbers in a fixed-length format - however-many bytes. So there are always the same number of binary digits stored - which equates to a different but similarly (approximately) fixed number of decimal digits stored (unless you choose multiple precision, of course). So surely what you may think of as nonsignificant zeroes are not never but *always* stored? I think not a fixed format, but a fixed length with eight bytes used to store the number in memory, as result fourteen significant numbers. There has to be a format in which the numbers are stored, of course (however many bytes are used): fourteen significant decimal digits maps to about 47 binary digits - just under six bytes. The rest of the space is used for an exponent and for signs for both the exponent and the number itself. There are many possible formats, but there has to be a fixed one in each computer or system. In content.xml file one of the files in .ods file, we can see the saved values in office:value tag and the representation of the value in text:p tag. Thanks for this. I confess I was thinking (as you were above) of storage in the sense of representation in the program itself - during processing. You are right, of course, that storage in document files is in decimal, not binary, and apparently omits insignificant trailing zeroes. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] is there an Open office equivalent to Visio 2000
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 wrote: From: Fabian Rodriguez magic...@member.fsf.org Subject: Re: [libreoffice-users] is there an Open office equivalent to Visio 2000 To: users@global.libreoffice.org Date: Saturday, 26 May, 2012, 16:41 -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 F. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: PGP/Mime available upon request Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk/A+a4ACgkQfUcTXFrypNW/uACfaDvzZjVytr6rC3BET5DPglOH w9cAnRbP4fKU8vrdkQRJjO4MB1HcbcNS =ddZO -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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] is there an Open office equivalent to Visio 2000
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: http://www.pcpro.co.uk/news/374854/no-free-visual-studio-for-windows-8-desktop-developers F. Also, you will have to pay for the options to play a DVD or other related media files, according to an article last month. Win8 should be a dead-on-arrival OS. You have to pay for most of the things you normally get for free with WinXP/Vista/Win7. I really do not want my desktop to look like a tablet, the way MS wants. They want people to be able to use the exactly same desktop look/feel for both their tablet, laptop, and desktop. They make it hard to figure out how to use it, and it looks worse than Unity does. There is an article comparing Ubuntu 12.04/Unity and Win8. So you really do not want to buy into Win8. -- 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
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
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
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 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:DataDefine... 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
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] Open Type fonts
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 some doubts when MS and Adobe call something 'open'... 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. Grx HdV -- 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
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 girvin.h...@sbcglobal.net wrote: From: Girvin R. Herr girvin.h...@sbcglobal.net 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 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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?
Re: [libreoffice-users] Open Type fonts
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. Should have read better. The code to support those typefaces apparently is available in LibreOffice, so I don't expect any trouble coming from that angle. However I know just about nothing about Mac, so I don't know if that platform supports OTF at all. I guess it should, because Adobe has always targetted that platform as one of their main markets. Grx HdV -- 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
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
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. 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
[libreoffice-users] Re: Extremely Slow Base Report Builder
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. -- 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] Documents do strange things
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 wrote: From: Jay Lozier jsloz...@gmail.com Subject: Re: [libreoffice-users] Documents do strange things To: users@global.libreoffice.org Date: Friday, 25 May, 2012, 22:34 Wanda On 05/25/2012 04:36 PM, Wanda Moore wrote: I write simple documents all the time, but my preferences don't seem to matter to LO. I choose a font, but it changes on me. I cut or copy and paste, and the font changes, even though I copy the exact same thing. Times New Roman seems to be the dictator here. And the size always changes. Lines will suddenly become a 24 pt rather than 11 that I usually use. What paste method are you using? The spaces between lines and paragraphs will change, and I can't change them back. Most of the time I can't even use the backspace to move a word up to the last line. And I can't move the first word (indent it). If I click on a word that starts in the wrong place, there are no little triangles up in the top ruler, so I can't move the line or paragraph. There are other things, too, but if you can help with this, maybe all will be fixed. You may want to modify the styles used and update the default template I understand that I may have done something unawares, so I thank you beforehand. Wanda Moore Just for reference please advise the LO version and your OS. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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] Open Type fonts
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 have that OS at hand. I am sorry. You were asking about Mac. Should have read better. The code to support those typefaces apparently is available in LibreOffice, so I don't expect any trouble coming from that angle. However I know just about nothing about Mac, so I don't know if that platform supports OTF at all. I guess it should, because Adobe has always targetted that platform as one of their main markets. Grx HdV I just entered install opentype fonts mac os x in a web search. One of the links was from the Adobe website. This website should tell you what you need to know. --Dan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
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 girvin.h...@sbcglobal.net wrote: From: Girvin R. Herr girvin.h...@sbcglobal.net 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 using Calc to
Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
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
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 girvin.h...@sbcglobal.net wrote: From: Girvin R. Herr girvin.h...@sbcglobal.net 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
[libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file
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 this posting. Sorry for the delay. On Mon, 2012-05-21 at 14:40 -0700, Jonathan Ryshpan wrote: ... the database doesn't look like what I had expected it to: sqlite databases contain within themselves the names and data types of all the entries, but when libreOffice opens the database, there is no such data visible. Am I missing something. A dump of the database using $ sqlite3 archive.sdb .dump looks fine. Is this what I should expect, or is something wrong, or am I missing something? On Tue, 2012-05-22 On Tue, 22 May 2012 at 00:43 +0200, Andreas Säger wrote: Am 21.05.2012 23:40, Jonathan Ryshpan wrote: blah Ask your question on a SQLite forum with some _technical_ information about your operating system, SQLite version of the creating application, driver version, configuration file, connection URL of the client (Base menu:EditDatabaseProperties). Wow! This is enough to singe my beard. Nevertheless I am grateful for all replies, even beard singeing ones. I fear that I put in too much technical detail, rather than too little. As you see, I am a complete newbie to LibreOffice base (oobase), and am only trying to find out whether I have succeeded in getting oobase to open my database properly. I don't think a posting to an sqlite forum would be useful, since this is really a question about oobase. If oobase has connected properly to the database, it is useless for my purpose and I will give up on it and do what needs done with a bunch of shell scripts. If oobase has not opened the database properly, I will persevere. Here is the technical info that Mr. Säger desires: All my systems run Fedora-16. The database was generated on an i686 system. LibreOffice runs on an x86_64 system. The database is contained in a file named wview-archive.sdb generated on the i686 system and copied to the x86_64 system. The database was generated by wview, which can be downloaded at http://www.wviewweather.com/ My running version of wview is accessible (in case you want to know the weather here) at: http://oaklandweather.no-ip.org/index.html/ The archive file is not visible from the web, but extracts from it are at: http://oaklandweather.no-ip.org/index.html/Archive The version of sqlite is included in sqlite-devel-3.7.7.1-1.fc16rpm The library is: /usr/lib/libsqlite3.so.0.8.6 The drivers are in: unixODBC-2.2.14-13.fc15.x86_64 You might want to use a GUI configure tool. On debian it is unixodbc-bin - Graphical tools for ODBC management and browsing $ ODBConfig Makes it much easier to configure. On Fedora I think it might be unixODBC-gui-qt https://admin.fedoraproject.org/pkgdb/acls/list/?searchwords=*odbc* and as specified in its initialization file (which follows) $ cat ~/.odbc [ODBC Data Sources] mysqlitedb=SQLite [mysqlitedb] Driver=/usr/lib64/libsqlite3odbc.so Description=My SQLite test database Database=/home/jonrysh/src/wview/archive/nullWindSpeed/wview-archive.sdb # optional lock timeout in milliseconds Timeout=2000 My initial tests (successful as I can see all the date in the tables) used the places.sqlite files for Firefox SeaMonkey. (They are easy to look at with an sqlite viewer to verify). I also have the old microsoft Nwind.mdb as well. 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 = /home/gl/.mozilla/seamonkey/snipped.default/places.sqlite Timeout = 10 StepAPI = No ShortNames = No NoCreat = No SyncPragma = NORMAL LoadExt = [NWTest] Description = mdbtools Driver = mdbtools Database= /home/gl/Documents/MyDocuments/Nwind.mdb [PlacesFirefox] Description = SQLite3 Driver = SQLite3 Database= /home/gl/.mozilla/firefox/snipped.default/places.sqlite Timeout = 10 StepAPI = No ShortNames = No NoCreat = No SyncPragma = NORMAL LoadExt = Note the difference in the SQLite drivers (I simply use use SQLite3). I'll give your database a try this weekend also try to find my notes/links on how I got mine working (should be a post in this list IIRC). The start of a dump of the database is appended to this message. I.e. the output of $ sqlite3 archive.sdb .dump If anyone else wants to know more about my struggles with oobase and sqlite, email me or post to the list. All the best - jon -- For unsubscribe
[libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file
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 = /home/gl/.mozilla/seamonkey/snipped.default/places.sqlite Timeout = 10 StepAPI = No ShortNames = No NoCreat = No SyncPragma = NORMAL LoadExt = [NWTest] Description = mdbtools Driver= mdbtools Database= /home/gl/Documents/MyDocuments/Nwind.mdb [PlacesFirefox] Description = SQLite3 Driver= SQLite3 Database = /home/gl/.mozilla/firefox/snipped.default/places.sqlite Timeout = 10 StepAPI = No ShortNames= No NoCreat = No SyncPragma= NORMAL LoadExt = Note the difference in the SQLite drivers (I simply use use SQLite3). I'll give your database a try this weekend also try to find my notes/links on how I got mine working (should be a post in this list IIRC). Found the links: http://kiwinc.itgo.com/ian/TechBlog.html#OpenOffice_SQLlite http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org#ODBC-setup_of_new_database and https://en.wikibooks.org/wiki/MySQL/Databases_manipulation HTH -- 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
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 girvin.h...@sbcglobal.net wrote: From: Girvin R. Herr girvin.h...@sbcglobal.net 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
[libreoffice-users] Re: Documents do strange things
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 never used styles or templates, as I don't really understand them, and just want to be able to take notes and write things down for myself and my kids. (I homeschool, so I'm always writing something and printing them out.) I have LO 3.4.4 and Mac OS X 10.6.8Hope this helps. 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. If you are pasting from the another document which has its own font, etc. try using EDITPASTE SPECIAL and select unformatted text. LO will use the document default for the text formatting. When you use the normal PASTE LO assumes the formatting of the text to be pasted should override the document defaults. We like to know version and OS for reference and in case the issue is specific to a version or OS; normally the issues are not. Wanda On Fri, May 25, 2012 at 2:34 PM, Jay Lozier lt;jslozier@gt; wrote: Wanda On 05/25/2012 04:36 PM, Wanda Moore wrote: I write simple documents all the time, but my preferences don't seem to matter to LO. I choose a font, but it changes on me. I cut or copy and paste, and the font changes, even though I copy the exact same thing. Times New Roman seems to be the dictator here. And the size always changes. Lines will suddenly become a 24 pt rather than 11 that I usually use. What paste method are you using? The spaces between lines and paragraphs will change, and I can't change them back. Most of the time I can't even use the backspace to move a word up to the last line. And I can't move the first word (indent it). If I click on a word that starts in the wrong place, there are no little triangles up in the top ruler, so I can't move the line or paragraph. There are other things, too, but if you can help with this, maybe all will be fixed. You may want to modify the styles used and update the default template I understand that I may have done something unawares, so I thank you beforehand. Wanda Moore Just for reference please advise the LO version and your OS. -- Jay Lozier jslozier@ 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. As you are using a Mac system this is incorrect. You need Libre Office Preferences Writer -- For unsubscribe instructions e-mail to: users+help@.libreoffice 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 -- View this message in context: http://nabble.documentfoundation.org/Documents-do-strange-things-tp3986080p3986213.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Documents do strange things
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: http://nabble.documentfoundation.org/Documents-do-strange-things-tp3986080p3986214.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] modifying existing labels/cards
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 Microsoft. There are also table style templates available (or at least used to be available) as an extension for OpenOffice. I have found them very easy to adjust, and they print perfectly for both business cards and labels for me. They are available at: http://www.worldlabel.com/Pages/openoffice-template.htm or probably as an extension for OpenOffice. Don Don, Thanks for the information. I'll look into it. However, I think it's an omission - or an oversight - of the developers to not give the opportunity to adjust the dimensions of a once made buseness-card template. Joep -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file
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 headers for both columns. 2. Open SQLite Manger imported the .csv. Saved as an SQLite file. 3. Registered the new SQLite3 file using ODBConfig. 4. Opened LO 3.5 Base (Database from the menu), selected 'Connect to an existing database', choose ODBC, and select Weather2. Table shows all data from the archive file. Files are here if anyone cares to view/use. http://www.2shared.com/file/k8C-0SXm/Weather.html (Weather.odb) http://www.2shared.com/file/Fiddx6IL/weatherNoOp.html (SQLite file) http://www.2shared.com/file/1pj44lW9/weather.html weather.csv http://www.2shared.com/file/T9pvKz3y/weather.html weather.ods -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: modifying existing labels/cards
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 anywhere and page formatting is not the correct way (it completely changes all dimensions). I'm still working with 3.4 (but will only change to 3.5 when it is reasonably bug-free. Thanks in advance, Joep The Business card label templates use frames (instead of a table). If you were lucky you rememeberd to select 'syncronize' when you created it so that you can easily sync the rest of the cards/label. Anyway, to modify, I highly recommend that you keep a backup of your original, and then: 'View|Text boundries'. You'll then be able to see the frame outlines. Right-click on the frame boarder and select 'Frame|Options' untick the Protect items 'Position' and 'Size'. You can then modify the frame as you wish by using the 'Type' tab, or exiting the Frame function and then move/resize the frame with the mouse. When finished, don't forget to go back and retick the Protect items 'Position' and 'Size' so that you lock the frames back down. However, IMO it's easier just to create a new one, adjust the sizes that you need, and then copy the data from the first frame over to the new one. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Open Type fonts
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 have some doubts when MS and Adobe call something 'open'... https://bugs.freedesktop.org/show_bug.cgi?id=35538 [Writer does not remember formatting (font selection) with complex font families] More: https://bugs.freedesktop.org/buglist.cgi?query_format=specificorder=relevance+descbug_status=__all__product=LibreOfficecontent=OpenType Recommend that you test at least one before you lay out too much money. Note: you can always convert to ttf - but test to ensure you do not have additional litgature issues. -- 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
