Re: [libreoffice-users] Re: docx format troubles
Hi :) I completely disagree with that. From what i see of average users even 10% might be far too high and it's the same 10% not a different 10% for each person. A lot of secretaries and people that work with Word all day long consider the use of indent, tabs or tables rather than lots of spaces as scarily technical or over-complicated. Copypaste is beyond a lot of people, especially using keyboard short-cuts. I have seen a lot of people with a spreadsheet open on their machine yet they reach for a calculator to add up a list of figures and i am talking about office managers, senior executives, accountants, not dumb idiots! A person that takes a LOT of pictures with an iPhone was shocked when i turned it sideways to see landscape pictures fill the screen. Using Calc does not mean using 1/6th of the functionality of the entire Suite. It often means just typing in numbers and maybe looking at the results at the end of the row. Regards from Tom :) --- On Sun, 18/9/11, planas jsloz...@gmail.com wrote: From: planas jsloz...@gmail.com Subject: Re: [libreoffice-users] Re: docx format troubles To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 6:53 David, On Sat, 2011-09-17 at 08:30 -0400, David B Teague sr wrote: On 9/16/2011 6:56 AM, Tom Davies wrote: If you were able to ring-fence about 20% of the features of MS Office then about 80% of users never stray outside that. From what i see it's more like about 100% of users. Most users don't even use all of that 20%. I hope this isn't hijacking the thread, and if so, /please /say so, and I'll repost this in a new thread. The fact that 20% of the features of MS Office (and by implication, LO and OO.o) used almost exclusively by some 80% of the users suggests to me that OO.o should identify that 20% of features and modularize OO.o or LO or what have you to include that 20% and make the other 80% of the features available as extensions. I think you will actually find individuals use about 20 - 25% of the features regularly but I think you will find there is very little overlap. This means that LO needs to cover about 75 - 85% of the features as a minimum to cover the user base. You will find users who will use one or two components almost exclusively and very rarely use the others. For example I use Writer and Calc extensively, Base occasionally, and almost never use Impress or Draw. I'd like comments on this idea. David Teague -- nil significat nisi oscillat -- 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: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Hi :) Ahah, thanks Jay. I was hoping that HSql only dipped into using java for a few things. So, Don needs to have that java box ticked all the time he uses Base and can only avoid it when not using Base at all. Is it possible to edit short-cuts and stuff so that opening Base will enable java but opening java wont? I think it might be possible in GnuLinux by having 2 different short-cuts on the desktop or in the taskbar/panel. regards from Tom :) --- On Sun, 18/9/11, planas jsloz...@gmail.com wrote: From: planas jsloz...@gmail.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 6:58 Hi, On Sat, 2011-09-17 at 23:30 +0100, Tom Davies wrote: Hi :) Thanks Don. I think you might be able to convert/export/migrate your back-end to a different one. I don't think you have to stick with HSql. I'm not sure if it's possible to remove java dependence when using HSql, i thought it was but i could be wrong. Regards from Tom :) --- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote: From: Don Myers donmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 Hi All, I set up base shortly after it was added to Open Office. Apparently I am using the embedded database - HSQL database engine. If I turn off Java (I just tried it.), I get the following error message: The connection to the data source RE Database could not be established. No SDBC driver was found for the given URL. I cannot open my database without Java enabled. So using the database included with base will not work without Java. Don snip The HSQL engine is Java based. It may be possible to use Base as a front-end for something like MySQL or PostgreSQL, which do not use Java. On 09/17/2011 08:29 AM, Tom Davies wrote: Hi :) I think you can completely un-install all instances of java but i think that might create problems. Your web-browser might not be very happy without java. Generally i try to keep escape routes and back-up plans available = so i would just switch off java in LO so that i could switch it on again quite easily if i needed it. Tools - Options - LibreOffice/General - Java then UNtick the box at the very top Use a java runtime environment. I have only unticked this a few days ago and LO seems to start-up a lot faster. Regards from Tom :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 Hello again, Is there a misunderstanding somewhere? As I said, I use the ODBC-connection to MySQL on Linux (and a very well working native MySQL-connection under Windows). Like I posted in another message, ODBC also has problems (such as not showing default values for columns correctly on data entry, but - since the database is actually updated correctly - this doesn't really worry me much. So, like Tom suggests: can I get completely rid of Java if I don't conciously use it in any way that an end-user or programmer could cause? That would be more than alright for me... Regards H. Stoellinger (from a lovely early autumn sunny day here in Salzburg) P.S.: I have used the Java-connector in the past but don't do so anymore. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms. All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing. Am 16.09.2011 20:44, Heinrich Stoellinger wrote: Hello again, On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes this behaviour, could it have to to with backup copy creation? I find an aweful lot of backup files in /home/rainermusik/.libreoffice/3/user/backup. All of them have a filename something like rmodbc.odb_9777.odb and are of 0 (zero) size. I wonder what's wrong. Regards H. Stoellinger --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?
Re: [libreoffice-users] Re: docx format troubles
Hi :) I think everyone on this list, even a fresh 'clueless' noob, is in the top 10%. The very fact of knowing about and trying LibreOffice puts people in a very exclusive top percentage of office 'geeks'. Apparently it would not be trivial to remove features and make add-ons/extensions to add back that functionality if required. Even on low-spec machines there probably wouldn't be a dramatic increase in performance and it might complicate things too much. Regards from Tom :) --- On Sun, 18/9/11, Tim Deaton t...@timdeaton.org wrote: From: Tim Deaton t...@timdeaton.org Subject: Re: [libreoffice-users] Re: docx format troubles To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 3:13 It's very true that 80% of people only use 20% of the program. The problem is that my 20% is not your 20%. Now, if you could do in-depth tracking of thousands of random users, you might be able to isolate a certain set of features that almost nobody uses. Then those features could be removed if doing so would make enough difference (in performance or in resources used) to make it worth the effort. -- Tim Deaton On 9/17/2011 8:40 AM, Tom Davies wrote: Hi :) I really like that idea a lot but i have been told it's unfeasable. Even if we could clearly identify that 20% it would be tricky to slim the apps down that way. Regards from Tom :) --- On Sat, 17/9/11, David B Teague srdavidbtea...@comporium.net wrote: From: David B Teague srdavidbtea...@comporium.net Subject: Re: [libreoffice-users] Re: docx format troubles To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 13:30 On 9/16/2011 6:56 AM, Tom Davies wrote: If you were able to ring-fence about 20% of the features of MS Office then about 80% of users never stray outside that. From what i see it's more like about 100% of users. Most users don't even use all of that 20%. I hope this isn't hijacking the thread, and if so, /please /say so, and I'll repost this in a new thread. The fact that 20% of the features of MS Office (and by implication, LO and OO.o) used almost exclusively by some 80% of the users suggests to me that OO.o should identify that 20% of features and modularize OO.o or LO or what have you to include that 20% and make the other 80% of the features available as extensions. I'd like comments on this idea. David Teague -- nil significat nisi oscillat -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Persistent Restore Windows Window
Hello, I had the same problem on a MacBookPro - see thread 'annoying restore window' recently quote: Hello, Looked at the bug report. This is really what's happening on my MBP, but fortunately not on my iMac till now (both with Lion 7.1 and LibO 3.4.2 (probably)). I tried the solution via Terminal and it seems to work. Thanks NoOp for pointing in out - and for iago to provide the command. https://bugs.freedesktop.org/show_bug.cgi?id=39007 The eternal restore window has now gone... but I think it is an important bug, as others in the bug report said, and should be addressed if LibO wants to keep simple Mac users on board! Thanks. So take a look at the bug report and use the command in a Terminal window. It worked for me... -- Guy using LibO 3.4.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] LibreOffice-Base CPU usage
To be clear, Don only needs to have the Java box ticked when opening Base AND using a backend that requires Java, like HSQL. As for your second paragraph, I suspect you meant but opening WRITER won't... ? If so, the answer is probably no. LO isn't a collection of unrelated apps, it's a suite, at least inasmuch as it only has one set of options for some things, like using Java. It looks to me like these options are stored at the user level so he could set up a second user, bit of a nuisance but that could do it I think. Mark Stanton One small step for mankind... -- 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] A place to find .oxt dictionary files since OOo's site is down most times
Just to give people a reminder of a place to find dictionaries, with the OOo side down most of the time, or flaky when up [plus a few - at least 4 - not found there as well]: I have created a very large dictionary list for the original North American Community DVD site. http://libreoffice-na.us/English/dictionary.html [3.3.4 installs listed on that site, with 3.4.1 installs at http://libreoffice-na.us/English-3.4-installs/index.html] There are 199 dictionaries listed, which includes 26 localized Spanish ones. I also made an English dictionary with the most up-to-date en-US word list file, which is over a year newer than any other US English dictionary found on the original OOo dictionary list. Drew was working on the CMS version of the NA-DVD, but I have not heard any updates from him in a while. The Original version is still running. I have version for 3.3.4 Windows/Linux/Mac, and 3.3.4 Windows-only. Right now, the 3.4.x versions are using 3.4.1, but hopefully soon I will have it updated to the latest 3.4.x version out there. [I have not upgraded my Ubuntu system beyond 3.4.1 either]. The 3.3.4 site is in the same style of the CMS system, while 3.4.1 site is in the original version used before the CMS site was open to other projects other than the German language version of a DVD. -- 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: Fwd: Re: LibreOffice-Base CPU usage
Le 18/09/11 00:44, Don Myers a écrit : Hi Don, There is an old saying - if it ain't broke, don't fix it. The thing I dislike most about Base is to have to open three windows to get to my form in the database. Some time ago I left a post on an Open Office forum asking if there was a way to set up a macro so I could do it in one click. You can save your forms outside of the ODB file, and open them from that outside location. Save as... and then choose where you want to save your form. This then means that you have to manage an ODB file plus any forms you have saved elsewhere if you want to redistribute a working db solution. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LO Base 3.4.3 on Linux using ODBC
Le 17/09/11 22:14, Heinrich Stoellinger a écrit : Hello Alex, Seems like I unfortunately cannot get rid of the Java Runtime environment. The reason is that the report-generator needs it!!! :( Regards Heinrich Yes, absolutely, the Oracle Report Builder is Java based. Without Java it simply won't run. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: MySQL Native Connector
Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Why, well firstly because no one gives a damn, and second, to build the connector you have to rely on the mysql C connector library (even if you use mysql C++ library) and that library is GPL2, which means that the connector that links to it has to be released under the GPL (this is in fact what Sun did with the native connector extension). The LibO project releases under the LGPL/MPL and not the GPL. At the moment, the OOo mysql native connector is available for download from here : http://extensions.services.openoffice.org/en/project/mysql_connector My advice, get it while you can and keep a copy near to hand. How long that will remain the case now that this site is to integrated into the ApacheOOo project remains to be seen, because Apache can not accept GPLed code into its projects. I have built the native connector for MacOSX and put it on the LibreOffice extensions site, but as far as I know, no one has built it for Windows or Linux (on Linux the question is mostly irrelevant because the distribs provide it in most cases, however, that does mean you are tied to the distrib version of LibreOffice). Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: MySQL Native Connector
Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. -- 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: docx format troubles
On Sat, 2011-09-17 at 08:30 -0400, David B Teague sr wrote: The fact that 20% of the features of MS Office (and by implication, LO and OO.o) used almost exclusively by some 80% of the users suggests to me that OO.o should identify that 20% of features and modularize OO.o or LO or what have you to include that 20% and make the other 80% of the features available as extensions. One thing to remember is that in institutions, it will not be the user's job to install or upgrade software. Users should not be running as root/administrator and will not have access to any installation media. The efficient way to install software in such scenarios is to install everything and to provide hardware capable of operating it satisfactorily. There would be no advantage - indeed, considerable disadvantage - if IT departments had to hunt down a set of extensions to make up the package they needed. It would be another obstacle to change. 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: Does Libre Office have merge codes?
Merge fields are only the beginning. I found those. What I need is the ability to use code to do things with the data in the mail merge. I found conditional fields. But that isn't enough yet. I need to be able to do things like I described in the first post. Also, based upon the value of a field, add a specific graphic to the merge letter. -- View this message in context: http://nabble.documentfoundation.org/Does-Libre-Office-have-merge-codes-tp3343602p3346436.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: Does Libre Office have merge codes?
Am 18.09.2011 17:41, AMCooper63 wrote: Merge fields are only the beginning. I found those. What I need is the ability to use code to do things with the data in the mail merge. I found conditional fields. But that isn't enough yet. I need to be able to do things like I described in the first post. Also, based upon the value of a field, add a specific graphic to the merge letter. -- View this message in context: http://nabble.documentfoundation.org/Does-Libre-Office-have-merge-codes-tp3343602p3346436.html Sent from the Users mailing list archive at Nabble.com. SQL queries can calculate anything you want. Reports can display graphics. So you may collect all required concatenations, aggregates and calculations in a query and create a report from that query instead of a mail merge letter. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Where the option Active OLE Object outplace?
I generally use OpenOffice 3.2.1 only for one reason - it has Active OLE Object outplace feature. This makes my work more comfortable. But in the new version of OpenOffice this feature disappeared. Also it is apply to LibreOffice 3.4.3. So, it is possible to recover Active OLE Object outplace? -- 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] Remove Macros
I can't remove assigned macros from a sheet. Tools - Customize - Events - Remove - OK doe's not work. LibreOffice 3.4.3 Mac OS X 10.6.8 -- View this message in context: http://nabble.documentfoundation.org/Remove-Macros-tp3346273p3346273.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] storeToURL fails until machine is rebooted.
Below are 2 routines that print a sheet to paper and then to a .pdf file. After the machine is started in the morning, and then for x number of transactions, these routines work as expected. At some point however, an error occurs at the line below that says: thisComponent.storeToURL(pdfURL,args()) When I use the debug window to look at the fields being passes to the storeToURL, they are as expected. I have no idea why after a while the storeToURL fails and continues to fail until I reboot the machine. Getting out of LO does not work. I have to reboot the box to get it functioning again. After a reboot, the sheet that was to be printed and turned into a pdf again works as expected. Other executions work as expected until it stops working as expected some number of transactions later and I have no idea why. Because I have to bounce the box to correct this, I suspect the problem is in a loaded library that does not unload when LO is closed. Anyone have any insight? I think this is a real bug. sub receiptPrint(PrintOnPaper as boolean) dim printRange(0)as new com.sun.star.table.CellRangeAddress dim nullRange() as new com.sun.star.table.CellRangeAddress dim printOptions(1) as new com.sun.star.beans.PropertyValue dim doc as object dim sheetReceipt as object On Error goto errorRoutine doc = ThisComponent sheetReceipt=doc.sheets.getByName(Receipt) printOptions(0).Name=Wait printOptions(0).Value=True printOptions(1).Name=CopyCount printOptions(1).Value=1 printRange(0).sheet=sheetReceipt.RangeAddress.Sheet printRange(0).StartColumn=0 printRange(0).StartRow=0 printRange(0).EndColumn=9 printRange(0).EndRow=getEndRow(sheetReceipt) thisComponent.sheets(sheetReceipt.RangeAddress.Sheet).setPrintAreas(printRange()) if printOnPaper=True then thisComponent.Print(printOptions()) end if On error goto 0 printPDF(receipt) thisComponent.sheets(sheetReceipt.RangeAddress.Sheet).setPrintAreas(nullRange()) saveSpreadSheet() exit sub errorRoutine: dim message as string if Err0 then message=Error Number Err at line Erl chr$(10) Error() chr$(10) msgbox message,0,Error Occurred endif end sub ' receiptPrint sub printPDF(subDir as string) dim odsURL as string dim pdfURL as string dim strArray() as string dim x as integer DIM args(0) AS NEW com.sun.star.beans.PropertyValue 'exit sub odsURL=thisComponent.getURL() ' file:///bill/Desktop/WestEnd.ods ' Need file:///bill/Desktop/.pdf/YYMMDD/subDir/count#.pdf strArray=split(odsURL,/) for x=0 to ubound(strArray)-1 pdfURL=pdfURL strArray(x) / next x pdfURL=pdfURL .pdf if dir(pdfURL,16)= then mkdir pdfURL end if pdfURL=pdfURL / right(year(Date()),2) right(100 + month(Date()),2) right(100 + day(Date()),2) if dir(pdfURL,16)= then mkdir pdfURL end if pdfURL=pdfURL / subDir if dir(pdfURL,16)= then mkdir pdfURL end if pdfURL=pdfURL / x=1 while dir(pdfURL right(1000 + x,3) .pdf,16) x=x+1 wend pdfURL=pdfURL right(1000 + x,3) .pdf ' Save as PDF args(0).Name = FilterName args(0).Value = writer_pdf_Export thisComponent.storeToURL(pdfURL,args()) end sub -- 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: MySQL Native Connector
Hi Alex, As I have already mentioned in an earlier posting - I downloaded the connector from the site you mention. However, trying to then install/activate it in my LO 3.4.3 system fails. Heinrich On Sun, 18 Sep 2011 16:28:03 +0200, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Why, well firstly because no one gives a damn, and second, to build the connector you have to rely on the mysql C connector library (even if you use mysql C++ library) and that library is GPL2, which means that the connector that links to it has to be released under the GPL (this is in fact what Sun did with the native connector extension). The LibO project releases under the LGPL/MPL and not the GPL. At the moment, the OOo mysql native connector is available for download from here : http://extensions.services.openoffice.org/en/project/mysql_connector My advice, get it while you can and keep a copy near to hand. How long that will remain the case now that this site is to integrated into the ApacheOOo project remains to be seen, because Apache can not accept GPLed code into its projects. I have built the native connector for MacOSX and put it on the LibreOffice extensions site, but as far as I know, no one has built it for Windows or Linux (on Linux the question is mostly irrelevant because the distribs provide it in most cases, however, that does mean you are tied to the distrib version of LibreOffice). Alex -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: docx format troubles
Brian On Sun, 2011-09-18 at 16:17 +0100, Brian Barker wrote: On Sat, 2011-09-17 at 08:30 -0400, David B Teague sr wrote: The fact that 20% of the features of MS Office (and by implication, LO and OO.o) used almost exclusively by some 80% of the users suggests to me that OO.o should identify that 20% of features and modularize OO.o or LO or what have you to include that 20% and make the other 80% of the features available as extensions. One thing to remember is that in institutions, it will not be the user's job to install or upgrade software. Users should not be running as root/administrator and will not have access to any installation media. The efficient way to install software in such scenarios is to install everything and to provide hardware capable of operating it satisfactorily. There would be no advantage - indeed, considerable disadvantage - if IT departments had to hunt down a set of extensions to make up the package they needed. It would be another obstacle to change. Good point, there is a big difference between, home, home office, and small business users and large institutional or corporation users. Often the former are owner/operators and can tailor the installation, while the latter often have limited authority to modify their installation. Brian Barker -- 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
Re: [libreoffice-users] Re: MySQL Native Connector
Hi :) It might be a good idea to plan a move from MySql to MariaDb. MariaDb is a drop-in replacement for MySql. MariaDb is much faster at developing and bug-fixing so a bug-report to them might get a faster response and they might well be happy to work on a project such as the extension/add-on. It's almost all the MySql people except the ones paid by Oracle. Regards from Tom :) --- On Sun, 18/9/11, Andreas Säger saege...@t-online.de wrote: From: Andreas Säger saege...@t-online.de Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 15:54 Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MySQL Native Connector
On Sunday, September 18, 2011 07:48:09 PM Tom Davies wrote: Hi :) It might be a good idea to plan a move from MySql to MariaDb. MariaDb is a drop-in replacement for MySql. MariaDb is much faster at developing and bug-fixing so a bug-report to them might get a faster response and they might well be happy to work on a project such as the extension/add-on. It's almost all the MySql people except the ones paid by Oracle. Regards from Tom :) --- On Sun, 18/9/11, Andreas Säger saegerei@t- online.de wrote: From: Andreas Säger saege...@t-online.de Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 15:54 Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. Do you know if this will work in parallel with MySQl until things can be migrated? Also so phpMyAdmin or something simular work with it? Thats -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MariaDb / MySQL Native Connector
Hi :) I don't think it's urgent but it is worth researching http://mariadb.org/ I am not sure if you can have both on the same system at the same time. It might be worth setting up a virtual machine and testing it that way if possible. Regards from Tom :) --- On Sun, 18/9/11, upscope upsc...@nwi.net wrote: From: upscope upsc...@nwi.net Subject: Re: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 20:16 On Sunday, September 18, 2011 07:48:09 PM Tom Davies wrote: Hi :) It might be a good idea to plan a move from MySql to MariaDb. MariaDb is a drop-in replacement for MySql. MariaDb is much faster at developing and bug-fixing so a bug-report to them might get a faster response and they might well be happy to work on a project such as the extension/add-on. It's almost all the MySql people except the ones paid by Oracle. Regards from Tom :) --- On Sun, 18/9/11, Andreas Säger saegerei@t- online.de wrote: From: Andreas Säger saege...@t-online.de Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 15:54 Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. Do you know if this will work in parallel with MySQl until things can be migrated? Also so phpMyAdmin or something similar work with it? Thats -- 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: Digital Signature cannot validate (linux)
Yeah, it is quite possible to blame the Ubuntu Natty build. But the problem occurs just since my most recent Firefox update. So it would be nice to see if somebody can reproduce this before I file a bug. I'm looking into your links now. Ferry Op maandag 12-09-2011 om 11:30 uur [tijdzone -0700], schreef NoOp: On 09/12/2011 07:04 AM, Ferry Toth wrote: I think you missed the following points in my story: - the CA certificate is generated internally. This means we are CA for our own certificates. They are not blacklisted by FF. - to be validated we manually add the CA certificate ourselves to FF and windows certificate store). - FF shows the certificates are valid (linux) and so does IE (windows). The certificates are NOT blocked. - LO under ubuntu shows the user certificate is invalid because the CA is not in the path (this is new) - LO under windows works fine (yes with the security update installed that removes diginotar) I suggest you file a bug report on launchpad against Ubuntu's LO (ULO) version: https://bugs.launchpad.net/ubuntu/+source/libreoffice You might also install standard LO (you can do this without affecting ULO) and test to see if that is broken also. If so then you can file a bug report on bugzilla: http://wiki.documentfoundation.org/BugReport Perhaps you are experiencing this bug: https://bugs.freedesktop.org/show_bug.cgi?id=39825 [Does not find Firefox profile for digital certificate signing] The recent certificate bugs/updates are: http://www.ubuntu.com/usn/usn-1197-3 http://www.ubuntu.com/usn/usn-1197-1 https://launchpad.net/bugs/838322 http://www.ubuntu.com/usn/usn-1197-4 http://www.ubuntu.com/usn/usn-1197-1 http://www.ubuntu.com/usn/usn-1197-3, https://launchpad.net/bugs/837557 So it's quite possible that one (any) of those may have also cause breakage in ULO. Op maandag 12-09-2011 om 13:07 uur [tijdzone +0100], schreef Dave Sergeant: On 12 Sep 2011 at 10:52, Ferry Toth wrote: Since years we use digital signatures to sign our documents and protect them from inadvertent modifications. The CA certificate is one generated internally. Now on linux (ubuntu natty) the certificates are stored by firefox and since a recent upgrade to firefox 6.0.2 LO complains that the certificate cannot be validated. This happen even right after adding the signature. Apparently the root certificate cannot be found by LO. However, in firefox both personal and CA certificate validate fine. Switching to windows LO does validate the certificate fine (but there the certificates are stored elsewhere). It look like something changed in FF that broke the digital signing in LO. Or is it a configuration issue on my side? This one is easy to answer. Due to an issue with fraudulent certificates from the Dutch company Diginotar, Firefox has removed the Diginotar root certificate from its certificate store. Other browsers have acted similarly, ie there was a Windows update to achieve the same on IE. Since you are based in the Netherlands I guess your documents are validated against Diginotar certificates. See http://en.wikipedia.org/wiki/DigiNotar For many of us not in your country we have never encountered a Diginotar certificate and it was not even in my certificate store in Opera. Not sure what the answer is, but this seems to be a case of unexpected consequences of a fairy radical update to Firefox. Your internal certificates are clearly properly issued, and to block them because of a few fraudulent ones you are only going to encounter on dodgey sites seems a bit OTT. Dave http://www.davesergeant.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: Digital Signature cannot validate (linux)
Checking the links below I find: - they are all connected with the diginotar CA and have nothing to do with my issue - except https://bugs.freedesktop.org/show_bug.cgi?id=39825 However here it is described the dialog box comes up empty. This is not so in my case. I sign the document as always. Then when I check the signature it shows it can't validate (apparently because it can not find the root CA). I'm wandering if all types of certificates fail to validate or only the ones where the CA is on the 'software security device' (as opposed to the 'built-in object token') in Firefox. Ferry Op zondag 18-09-2011 om 22:32 uur [tijdzone +0200], schreef Ferry Toth: Yeah, it is quite possible to blame the Ubuntu Natty build. But the problem occurs just since my most recent Firefox update. So it would be nice to see if somebody can reproduce this before I file a bug. I'm looking into your links now. Ferry Op maandag 12-09-2011 om 11:30 uur [tijdzone -0700], schreef NoOp: On 09/12/2011 07:04 AM, Ferry Toth wrote: I think you missed the following points in my story: - the CA certificate is generated internally. This means we are CA for our own certificates. They are not blacklisted by FF. - to be validated we manually add the CA certificate ourselves to FF and windows certificate store). - FF shows the certificates are valid (linux) and so does IE (windows). The certificates are NOT blocked. - LO under ubuntu shows the user certificate is invalid because the CA is not in the path (this is new) - LO under windows works fine (yes with the security update installed that removes diginotar) I suggest you file a bug report on launchpad against Ubuntu's LO (ULO) version: https://bugs.launchpad.net/ubuntu/+source/libreoffice You might also install standard LO (you can do this without affecting ULO) and test to see if that is broken also. If so then you can file a bug report on bugzilla: http://wiki.documentfoundation.org/BugReport Perhaps you are experiencing this bug: https://bugs.freedesktop.org/show_bug.cgi?id=39825 [Does not find Firefox profile for digital certificate signing] The recent certificate bugs/updates are: http://www.ubuntu.com/usn/usn-1197-3 http://www.ubuntu.com/usn/usn-1197-1 https://launchpad.net/bugs/838322 http://www.ubuntu.com/usn/usn-1197-4 http://www.ubuntu.com/usn/usn-1197-1 http://www.ubuntu.com/usn/usn-1197-3, https://launchpad.net/bugs/837557 So it's quite possible that one (any) of those may have also cause breakage in ULO. Op maandag 12-09-2011 om 13:07 uur [tijdzone +0100], schreef Dave Sergeant: On 12 Sep 2011 at 10:52, Ferry Toth wrote: Since years we use digital signatures to sign our documents and protect them from inadvertent modifications. The CA certificate is one generated internally. Now on linux (ubuntu natty) the certificates are stored by firefox and since a recent upgrade to firefox 6.0.2 LO complains that the certificate cannot be validated. This happen even right after adding the signature. Apparently the root certificate cannot be found by LO. However, in firefox both personal and CA certificate validate fine. Switching to windows LO does validate the certificate fine (but there the certificates are stored elsewhere). It look like something changed in FF that broke the digital signing in LO. Or is it a configuration issue on my side? This one is easy to answer. Due to an issue with fraudulent certificates from the Dutch company Diginotar, Firefox has removed the Diginotar root certificate from its certificate store. Other browsers have acted similarly, ie there was a Windows update to achieve the same on IE. Since you are based in the Netherlands I guess your documents are validated against Diginotar certificates. See http://en.wikipedia.org/wiki/DigiNotar For many of us not in your country we have never encountered a Diginotar certificate and it was not even in my certificate store in Opera. Not sure what the answer is, but this seems to be a case of unexpected consequences of a fairy radical update to Firefox. Your internal certificates are clearly properly issued, and to block them because of a few fraudulent ones you are only going to encounter on dodgey sites seems a bit OTT. Dave http://www.davesergeant.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
Re: [libreoffice-users] Re: MariaDb / MySQL Native Connector
Hi On Sun, 2011-09-18 at 21:19 +0100, Tom Davies wrote: Hi :) I don't think it's urgent but it is worth researching http://mariadb.org/ I am not sure if you can have both on the same system at the same time. It might be worth setting up a virtual machine and testing it that way if possible. Regards from Tom :) I believe you can only have one MySQL/Mariadb installation. --- On Sun, 18/9/11, upscope upsc...@nwi.net wrote: From: upscope upsc...@nwi.net Subject: Re: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 20:16 On Sunday, September 18, 2011 07:48:09 PM Tom Davies wrote: Hi :) It might be a good idea to plan a move from MySql to MariaDb. MariaDb is a drop-in replacement for MySql. MariaDb is much faster at developing and bug-fixing so a bug-report to them might get a faster response and they might well be happy to work on a project such as the extension/add-on. It's almost all the MySql people except the ones paid by Oracle. Regards from Tom :) --- On Sun, 18/9/11, Andreas Säger saegerei@t- online.de wrote: From: Andreas Säger saege...@t-online.de Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 15:54 Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. There is a third MySQL connection available in Linux that works very well. However if the distro supports 3.3.x like Ubuntu it can be difficult to install and get working with 3.4.x Do you know if this will work in parallel with MySQl until things can be migrated? Also so phpMyAdmin or something similar work with it? I know MySQL Workbench works with Mariadb in Linux. In Windows, Mariadb installs another GUI, Heidi I believe. My understanding is if something works with MySQL it will work with Mariadb. Mariadb uses the some names for the files as does MySQL so you can use the MySQL documentation. Thats -- 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 -- 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
