Re: [libreoffice-users] print drivers?
LO 3.6.7, Slackware 14.0, KDE 4.8.5, Linux k3.2.29. I have never seen the quickstarter installed. However, in the past, I have left LO running with many open files when I shut down for the day. The next time I start up, LO and the left-open files were reloaded as it was when I shut down. This may be a KDE thing. That said, I am now having a problem with this feature and am going to open a new thread on it to see if anyone on this forum has an idea how to solve it. Girvin Herr On 08/20/2013 12:32 PM, Tom Davies wrote: Hi :) The Microsquish thing is Quick Launcher and i think they copied it from KDE. Could be wrong though. The Quick Starter puts OpenOffice/LibreOffice open in the system tray (in Windows). Not completely sure what, if anything, it does in GnuLinux or Mac Regards from Tom :) From: Robert Holtzm hol...@cox.net To: users@global.libreoffice.org Sent: Tuesday, 20 August 2013, 20:06 Subject: Re: [libreoffice-users] print drivers? On Tue, Aug 20, 2013 at 03:16:25PM +0100, Tom Davies wrote: Hi :) Yes, LO can be installed alongside AOO but not by a straight forwards install of both. You need to make sure the QuickStarter is switched off and that they are not opened at the same time as each other. Various other technical issues also need to be taken care of. QuickStarter? Isn't that M$ or am I wrong? There is a guide https://wiki.documentfoundation.org/Installing_in_parallel Much obliged for the link. -- Bob Holtzman Your mail is being read by tight lipped NSA agents who fail to see humor in Doctor Strangelove Key ID 8D549279 -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] LO and Linux/KDE shutdown
Greetings. LO 3.6.6.2, Slackware 14.0, KDE 4.8.5, Linux k3.2.29. In the past, with KDE3, I was able to leave LO and many files open when I shut down the desktop for the day. Then when I started up the next time, LO ran and opened all the files I left open when I shut down. This was very handy for keeping oft-used files active on the desktop. Once in a while, when starting up, the restore manager would insist on restoring these files, but it wasn't the norm. I have upgraded to KDE4 and ever since, *every* time I start up again, the restore manager wants to restore all these once-open files, which can take a while to process, since some are a bit lengthy. I just tried to cancel the restoration, since I knew all of the files were saved when I shut down. In the past, this worked and LO continued to open the files as when they were shut down. However, this time, none of the files were opened and I had to manually go through the list in my mind and open them. Hopefully, I didn't miss any. It seems to be connected with the auto-save process, since starting up, shutting down immediately, and restarting, does not bring up the restore manager. That implies that some time must elapse before the restore manager flag is set, which is probably one or more auto-saves. The most obvious possible solution is to disable the auto-save process. But that seems radical for such a worthwhile process. Is this a configuration issue, a known problem, a bug with KDE4, or what? Thanks in advance. Girvin Herr -- To unsubscribe e-mail to: users+unsubscr...@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] MS file compatibility in 4.0+ - comments in .doc
On 08/13/2013 05:27 AM, Tom Davies wrote: Hi :) It's quite likely. A bug-report is a good idea. An example file might help. Btw i assume your MSO users have stuck with some ancient version of MSO, such as 2007 or something? I think the compatibility with 2013 is better and that is likely to create problems with compatibility with older versions of MSO. This implication concerns me! If LO is going to drop .doc as a standard, then my advice to others to use .doc instead of .docx as a common interchange standard is in jeopardy. I hope LO never drops .doc as a standard. That said, I had to open a .docx form I received the other week and LO opened it fine, with the exception of the usual font size problems that ran text off the right margin. That was easily fixed by changing the font size. Regards. Girvin Herr Are you sure it's .Doc rather than .DocX that is causing the problem? Most MSO users have no idea how to save in anything other than DocX so it's FAR more likely they are sending you DocX files and not even realising it or even believing they are sending Doc because they just don't really know what they are using and just jumping on the last name they vaguely recognise. Windows tries to hide the endings so they really don't know what they are using most of the time. Doc itself is being deprecated in order to push people into using the newer DocX and thus forcing people to buy newer versions of MSO even if it's to do exactly the same work that MSO 2003 and earlier could do. Regards from Tom :) From: Rogier F. van Vlissingen vlisc...@gmail.com To: users@global.libreoffice.org Sent: Tuesday, 13 August 2013, 12:27 Subject: [libreoffice-users] MS file compatibility in 4.0+ - comments in .doc Ever since 4.0 I have had increasing problems with file compatibility with MSO... Currently I am working on a project with MSO users and when I open a .doc which contains any comments, what happens is the last character BEFORE the comment anchor is reduced in font size, and therefore when you delete the comment, you now have to go into the text to fix the font size. Anyone had the same? I think it's time for a bug report. -- *Rogier Fentener van Vlissingen http://viz.me/vliscony/t/7* *About Me* http://about.me/vliscony -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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: Including code example in documents
Eric, I use Kate in KDE to do my source coding and it does color syntax highlighting. I am sure there are other Linux plain text editors that do it too. However, those colors are only in Kate and do not exist in the edited file. One thing you might try is to capture the screen and insert it into your LO document as an image. I have done that to print something and the colors do exist in the LO document. However, if your source file is long, that could get tedious fast. Another nice feature of Kate is that you can define projects, Kate calls them sessions, which may include several files. Opening a saved session, opens all the files and they can be listed in a hierarchical list in a left window pane. This makes copying and pasting from one file to another simple. Hope this helps. Girvin Herr On 08/12/2013 03:30 PM, aihaike wrote: Dear all, Thank for all your suggestion. I use Linux and Notepad++ or NoteTab are available on widows only. I think I'll try the RTF generation option. Thanks again. Éric.. -- View this message in context: http://nabble.documentfoundation.org/Including-code-example-in-documents-tp4069680p4069788.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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] MS file compatibility in 4.0+ - comments in .doc
Whew! That eases my mind. The only problem is that when MSO no longer supports .doc format as an option, then MSO users will no longer have that interchange standard format and we will be at the mercy of whatever proprietary format M$ chooses - again. I am sure that is by design. Thanks. Girvin Herr On 08/13/2013 11:30 AM, Tom Davies wrote: Hi :) Oops, no i meant the Doc format compatibility is kinda fixed now and can be gently improved on without worrying about what MS are going to do to it. The Doc is safe. It's only DocX that is constantly changing to the point where being more compatible with one version of MSO seems to mean being less compatible with another. But even there, maybe it is possible to be more compatible with all of them? It's often a LibreOffice or OpenOffice users in the office that helps people using different versions of MSO to arrive at something both of them can read happily. Rogier did get me worried for a moment that maybe Doc was not working quite as well as i hoped but then i realised it's more likely to be some sort of user-error by one or more of his colleagues. I find i suffer from user error quite a bit myself so i can easily imagine how it happens. I suspect that LO will keep supporting Doc long after MS drop it completely themselves and i don't think that is likely to happen any time soon. Regards from Tom :) *From:* Girvin R. Herr girvin.h...@sbcglobal.net *To:* Tom Davies tomdavie...@yahoo.co.uk *Cc:* Rogier F. van Vlissingen vlisc...@gmail.com; users@global.libreoffice.org users@global.libreoffice.org *Sent:* Tuesday, 13 August 2013, 18:53 *Subject:* Re: [libreoffice-users] MS file compatibility in 4.0+ - comments in .doc On 08/13/2013 05:27 AM, Tom Davies wrote: Hi :) It's quite likely. A bug-report is a good idea. An example file might help. Btw i assume your MSO users have stuck with some ancient version of MSO, such as 2007 or something? I think the compatibility with 2013 is better and that is likely to create problems with compatibility with older versions of MSO. This implication concerns me! If LO is going to drop .doc as a standard, then my advice to others to use .doc instead of .docx as a common interchange standard is in jeopardy. I hope LO never drops .doc as a standard. That said, I had to open a .docx form I received the other week and LO opened it fine, with the exception of the usual font size problems that ran text off the right margin. That was easily fixed by changing the font size. Regards. Girvin Herr Are you sure it's .Doc rather than .DocX that is causing the problem? Most MSO users have no idea how to save in anything other than DocX so it's FAR more likely they are sending you DocX files and not even realising it or even believing they are sending Doc because they just don't really know what they are using and just jumping on the last name they vaguely recognise. Windows tries to hide the endings so they really don't know what they are using most of the time. Doc itself is being deprecated in order to push people into using the newer DocX and thus forcing people to buy newer versions of MSO even if it's to do exactly the same work that MSO 2003 and earlier could do. Regards from Tom :) From: Rogier F. van Vlissingen vlisc...@gmail.com mailto:vlisc...@gmail.com To: users@global.libreoffice.org mailto:users@global.libreoffice.org Sent: Tuesday, 13 August 2013, 12:27 Subject: [libreoffice-users] MS file compatibility in 4.0+ - comments in .doc Ever since 4.0 I have had increasing problems with file compatibility with MSO... Currently I am working on a project with MSO users and when I open a .doc which contains any comments, what happens is the last character BEFORE the comment anchor is reduced in font size, and therefore when you delete the comment, you now have to go into the text to fix the font size. Anyone had the same? I think it's time for a bug report. -- *Rogier Fentener van Vlissingen http://viz.me/vliscony/t/7* *About Me* http://about.me/vliscony -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto:unsubscr...@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] Feature Request
John, In Linux X/KDE, and I suppose Ubuntu too, you can use Alt-left-button to drag windows beyond the desktop boundaries. Therefore, if your window is outside the desktop at the bottom and you cannot get to that lower right corner, place the mouse cursor anywhere in the window you wish to move and use the alt-left-button to drag the whole window into the desktop where you can get to that corner. Then you should be able re-size the window as you need. The pixel sensitivity sounds more like a desktop problem than an LO problem. I don't know what desktop you or Ubuntu uses, but there should be an desktop settings option to adjust that mouse pointer sensitivity to a number of pixels. I just checked my KDE settings for the mouse and it is set to 4 pixels. Hope this helps. Girvin Herr On 08/08/2013 03:28 PM, John R. Sowden wrote: Similar to gedit (ubuntu), it would be nice if I could point my mouse _near_ the lower right corner to adjust the size of a libre office window, as opposed to placing the tip of the mouse pointer arrow on the pixel where the vertical and horizontal lines meet. Usually I cannot even get to the bottom, as it will ofter be off the screen. This is most obvious when attempting to bring the right side of the window in to the left. The pointer is pixel sensitive. As the source for this is 'open' (as in gedit), I assume that this would not be a big deal. John -- To unsubscribe e-mail to: users+unsubscr...@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: Most stable version right now Fw: [libreoffice-users] stable vs new
I still abide by a statement attributed to Adam Osborne back in the 80s: He, who lives on the cutting edge of technology, gets sliced to bits. Since the 3.6 series works fine for me, I will wait until the knife edge dulls a bit before I make the leap to 4.1. Girvin Herr On 08/04/2013 02:08 PM, Tom Davies wrote: Hi :) I would only go with the 3.6.7 if you are currently on the 3.6.x branch and need to stay there or if you have need of staying with the accessibility java-bridge, older version for other programs. I think everyone else is better off with 4.0.4 and perhaps update in that branch as it steadily marches onwards. On the other hand i still have plenty of machines on 3.5.something and it's a free world so you can do as you please. Regards from Tom :) - Forwarded Message - From: Girvin R. Herr girvin.h...@sbcglobal.net To: Tom Davies tomdavie...@yahoo.co.uk Cc: V Stuart Foote vstuart.fo...@utsa.edu; users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, 4 August 2013, 21:23 Subject: Re: [libreoffice-users] stable vs new Tom, To me: stability = productivity But I am just a lowly user. Nice description! I saved it for future reference. Now I know why I keep getting 3.x update notices when 4.x has been released some time ago. That surprised, but pleased, me. As a result of your description, I will have to repackage and install 3.6.7 after my monthly backup today. Girvin Herr On 08/04/2013 10:35 AM, Tom Davies wrote: Hi :) Yes, i was trying to keep it simple and practical by avoiding side issues or detail. Even so my post turned out to be a lot longer than planned! For some projects stability = stagnation ie that the 3.0.0 could be considered stable because pretty much all the bugs are known issues and mostly written-up somewhere. That has never been considered good enough in LO. The earlier releases in a branch are not considered more stable after the branch reaches .3 or .4. It's only the .3 or .4 and onwards that are considered more stable. Time-based releases vs release when ready. Whichever methodology is used it's only after initial proper release that the thing gets used on the mad set-ups out in the real world that most problems surface and get fixed. With MS products many corporates wouldn't consider installing before Service Pack 1 got released, which means it's only after SP 1 that many problems come to light! So, i agree with Stuart and most of the rest of the project on this issue. I'm sure the arguments about which is best will continue for another 7 years in most projects (and possibly longer). We all get to play ginea pig but we would with proprietary software too. The difference is that if a problem we reported does get fixed we get the fix for free along with all the updates that we didn't help with. There is no paying for upgrades or being pushed into buying a different bundle by some salesman. Regards from Tom :) From: V Stuart Foote vstuart.fo...@utsa.edu To: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, 4 August 2013, 16:58 Subject: RE: [libreoffice-users] stable vs new Folks, In opening this thread ( Nabble http://nabble.documentfoundation.org/stable-vs-new-tp4068750.html ) Tom is correct in a practical sense. Stability is an inherent component of a mature product. And testing during the development cycles by more potential user willing to invest a little time in QA is essential to the health of the project. But a key aspect Tom omits is that LibreOffice development and release stages are tightly timed--and by proxy so is its support. Nor does he mention that the project has stayed on schedule since inception--synchronizing to a six month minor release cycle implemented in a broader ecosystem of Free and Open Source Software. The Release Plan for LibreOffice publishes the release schedule, current status and a historical record of the project, worth a read: https://wiki.documentfoundation.org/Release_Plan Keeping to the time based release plan means that the delay between initial release on a minor version and the next minor version release is just six months. And that the delay between the x.x.0 release and each bug fix release has been and will continue to be just one month. So, while I don't completely agree Toms' assessment of how far along each bug fix takes things--it is just not the way the user feedback, QA,and development work proceeds--but it is not unreasonable practical advise. Support has kept to the same cycle--for the most part--user documentation (static HTML or wiki based, and published) can always use more active contributors and lags a bit as a result. This is not just development churn, there is solid User eXperience, QA and development work at every tick of the release cycle. And as a minor release nears end of its development life it gets less and less development attention
Re: [libreoffice-users] Re: stable vs new
Stuart, Thanks for taking the time to explain this. You are correct, I tend to be in the late recommended to early conservative category. I also believe in if it ain't broke, don't fix it. and LO 3.6 is currently working fine for what I expect of it. I also have another rule that unless there is a really, really compelling reason to, I never install software with a version ending in zero, like 4.0 or 4.1.0. Therefore, I am holding out for the 4.1.3+ release. Thanks again. Girvin On 08/04/2013 02:03 PM, V Stuart Foote wrote: Girvin, Girvin R. Herr wrote Now I know why I keep getting 3.x update notices when 4.x has been released some time ago. That surprised, but pleased, me. As a result of your description, I will have to repackage and install 3.6.7 after my monthly backup today. Absolutely, there is nothing wrong with continuing to use the earlier releases. Just be aware that the 3.6.x minor release will be designated EOL development status the 15th of this month. Meaning, it is a final release (for the minor and 3.6 major branch) No further patches will be accepted for the release and no project effort to fix compatibility or security issues. Support will continue in the mail list forum and the Ask site as well as Bugzilla issue tracking---but quality of that support will slack off as fewer users maintain a 3.6.x branch install. LibOReleaseLifecycle.png https://wiki.documentfoundation.org/images/2/2c/LibOReleaseLifecycle.png This graphic from the release plan presents a concise view of the project. With work on the master branch extending into the future, each minor release branch is categorized as release canidate, for Early adopters, for Recommended use, for Conservative use. With its EOL eminent, using 3.6.7 you would be well in the Conservative category--meaning simply that it is not the Project recommended category, which has shifted to the 4.0 major release--a 4.0.4 build. Please note, that when released at the end of the month--the 4.0.5 build will also transition to a conservative category. But as you say, what ever works best for your productivity, we just want you and others to understand the project infrastructure and how best they can contribute. Stuart -- View this message in context: http://nabble.documentfoundation.org/stable-vs-new-tp4068750p4068822.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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: Most stable version right now Fw: [libreoffice-users] stable vs new
Andrew, Ouch! Just thinking about that one makes me wince! Take care. Girvin On 08/06/2013 12:36 PM, Andrew Brown wrote: Heh! Heh! nice one Girvin. I will have to sensor my saying my late military father used to drum into me. Similiar to Adam Osbourne and applied in a military vein, and I take no credit from it, or know who the original author is etc. The pain and frustration of living on the cutting edge, is like being an ant sliding down a 20 foot razor blade using your (part of the male anatomy, rhymes with many golf balls) as brakes Regards Andrew Brown On 06/08/2013 09:05 PM, Virgil Arrington wrote: On 08/06/2013 02:07 PM, Girvin R. Herr wrote: I still abide by a statement attributed to Adam Osborne back in the 80s: He, who lives on the cutting edge of technology, gets sliced to bits. Since the 3.6 series works fine for me, I will wait until the knife edge dulls a bit before I make the leap to 4.1. Girvin Herr I'm with you on this. 3.6.7 works just fine for me. Virgil -- To unsubscribe e-mail to: users+unsubscr...@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] stable vs new
Tom, To me: stability = productivity But I am just a lowly user. Nice description! I saved it for future reference. Now I know why I keep getting 3.x update notices when 4.x has been released some time ago. That surprised, but pleased, me. As a result of your description, I will have to repackage and install 3.6.7 after my monthly backup today. Girvin Herr On 08/04/2013 10:35 AM, Tom Davies wrote: Hi :) Yes, i was trying to keep it simple and practical by avoiding side issues or detail. Even so my post turned out to be a lot longer than planned! For some projects stability = stagnation ie that the 3.0.0 could be considered stable because pretty much all the bugs are known issues and mostly written-up somewhere. That has never been considered good enough in LO. The earlier releases in a branch are not considered more stable after the branch reaches .3 or .4. It's only the .3 or .4 and onwards that are considered more stable. Time-based releases vs release when ready. Whichever methodology is used it's only after initial proper release that the thing gets used on the mad set-ups out in the real world that most problems surface and get fixed. With MS products many corporates wouldn't consider installing before Service Pack 1 got released, which means it's only after SP 1 that many problems come to light! So, i agree with Stuart and most of the rest of the project on this issue. I'm sure the arguments about which is best will continue for another 7 years in most projects (and possibly longer). We all get to play ginea pig but we would with proprietary software too. The difference is that if a problem we reported does get fixed we get the fix for free along with all the updates that we didn't help with. There is no paying for upgrades or being pushed into buying a different bundle by some salesman. Regards from Tom :) From: V Stuart Foote vstuart.fo...@utsa.edu To: users@global.libreoffice.org users@global.libreoffice.org Sent: Sunday, 4 August 2013, 16:58 Subject: RE: [libreoffice-users] stable vs new Folks, In opening this thread ( Nabble http://nabble.documentfoundation.org/stable-vs-new-tp4068750.html ) Tom is correct in a practical sense. Stability is an inherent component of a mature product. And testing during the development cycles by more potential user willing to invest a little time in QA is essential to the health of the project. But a key aspect Tom omits is that LibreOffice development and release stages are tightly timed--and by proxy so is its support. Nor does he mention that the project has stayed on schedule since inception--synchronizing to a six month minor release cycle implemented in a broader ecosystem of Free and Open Source Software. The Release Plan for LibreOffice publishes the release schedule, current status and a historical record of the project, worth a read: https://wiki.documentfoundation.org/Release_Plan Keeping to the time based release plan means that the delay between initial release on a minor version and the next minor version release is just six months. And that the delay between the x.x.0 release and each bug fix release has been and will continue to be just one month. So, while I don't completely agree Toms' assessment of how far along each bug fix takes things--it is just not the way the user feedback, QA,and development work proceeds--but it is not unreasonable practical advise. Support has kept to the same cycle--for the most part--user documentation (static HTML or wiki based, and published) can always use more active contributors and lags a bit as a result. This is not just development churn, there is solid User eXperience, QA and development work at every tick of the release cycle. And as a minor release nears end of its development life it gets less and less development attention--QA and development resources long since shifted to new development and bug fixes. Enhancements and bug fixes become more and more costly to push backward with each tick in development cycle--so less likely to occur. In a sense that also is stability, or maybe stagnation. The project is on sound footings as a time based release, that is not going to change so no sense in debating it here. Rather, if you have specific questions or comments about its implementation or how best to make use of software from time based release managed project that would be a worthwhile discussion. Stuart a LibreOffice QA volunteer, focusing on accessibility issues. p.s. For use Accessibility and Assistive Technology tools the use of a Java 7, Java Runtime Environment and the Java Access Bridge v2.0.3 was not ported backward to the 3.6.x branch. It was included in the 4.1.0 release, and has been patched for the upcoming 4.0.5 release. Users of 3.6.x must continue to use a Java 6 JRE (e.g. 1.6u45) and manual install of Java Access Bridge v2.0.2. -- To unsubscribe
Re: [libreoffice-users] 4.0.3
When you get a new hammer, do you make the new hammer look like the old hammer? No! LibreOffice does not need to be micro$oft office, a bloated application that tries to be all things to all people and does none of them well. LO is a good office suite in its own right. People need to stop being lazy and learn something new for a change. Girvin Herr P.S. - Nice metaphor! On 08/04/2013 12:19 PM, Tom Davies wrote: Hi :) This kinda reminds me of the story about 2 bulls on top of a hill both looking down at a herd of cows. The younger one says Lets race down the hill and dance with one of those ladies. The older one replies Lets walk down and dance with them all. If we follow MS's lead in keeping up with their latest formats then we might get short-term gains but we really stuff ourselves up in the longer term. Plus we end up trailing a long way behind MS. We need to work towards getting ahead of them in more and more ways. At the moment we already beat them in quite a few ways but we need more in order for more people to take notice. Regards from Tom :) From: Amit Choudhary contact.amit.choudhary.in...@gmail.com To: Tom Davies tomdavie...@yahoo.co.uk Cc: la10...@iperbole.bologna.it la10...@iperbole.bologna.it; users@global.libreoffice.org users@global.libreoffice.org Sent: Saturday, 27 July 2013, 11:46 Subject: Re: [libreoffice-users] 4.0.3 If we have to beat Microsoft then we need to focus only on what Microsoft provides and not on .odt format, etc. We cannot beat Microsoft by introducing a new format and expecting customers to use new formats (I use Microsoft formats only and whatever other formats is suported by Microsoft). We need to beat Microsoft at its own game by doing what they are doing in office suite. A new format is not going to change the game but being totally compatible and stable with the formats that Micorosoft supports (xls, xlsx, doc, docx, save as pdf, text, etc.) is going to change the game. Amit On Sat, Jul 27, 2013 at 3:21 PM, Amit Choudhary contact.amit.choudhary.in...@gmail.com wrote: Hi Tom, I have been programming since 1987. I have all my degrees in computer science/networking. I have worked for companies like Cisco systems, Juniper networks and have turned down offers from companies like Google and Microsoft for one reason or other. This whole software industry is going in the wrong direction. Actually, by now we should have been done by all the software (all the necessary software developed and installed and used, no bugs, etc. We need to beat Microsoft because we do not want to pay for Office suite. The best way of doing this is to release stable versions only and this can be done by increasing the QA cycle period. I do not release buggy software unless it has been approved by management. And I have not released any software that's gonna hurt the customer even if I have to get into discussions with managers, directors, etc. This whole idea of releasing software frequently is a scam, because work doesn't get done properly in a small time window. No one gets any time for innovation and everyone is just interested in the release. And in the end, the software dies down because the frequent release does not fix things properly and introduces new bugs and over time all these quickfixes kill the product. THERE IS NO DEMAND FROM CUSTOMERS FOR FREQUENT RELEASES. THE DEMAND IS FROM PEOPLE WHO ARE SOFTWARE ANALYSTS AND THEY WANT SOMETHING TO DO AND HENCE THEY WANT FREQUENT RELEASES. IT IS A BIG SCAM. I use around 5-6 external softwares and if everyone is releasing something every month then it becomes a headache to me. RELEASING ONLY TWICE A YEAR IS VERY FOOD. THE BIGGEST RISK OF RELEASING FREQUENTLY IS THAT ORIGINAL PROBLEMS ARE NOT SOLVED PROPERLY AND QUICKFIXES MAKE MANAGING THE SOFTWARE COMPLICATED AND IN THE END THE DEVELOPERS GIVE UP AND THE PRODUCT IS SHELVED. AND ALL THIS HAPPENS WITH PAID SOFTWARE TOO. Amit On Fri, Jul 26, 2013 at 4:07 PM, Tom Davies tomdavie...@yahoo.co.ukwrote: Hi :) I think with Base it's better to stay with older branches. The 3.6.7 might be better. if the 4.0.3 works for you then stick with that. Sadly there are still not many devs working on Base. It's not flashy enough! Regards from Tom :) From: la10...@iperbole.bologna.it la10...@iperbole.bologna.it To: users@global.libreoffice.org Sent: Friday, 26 July 2013, 10:31 Subject: Re: [libreoffice-users] 4.0.3 Unfortunately, the 3rd digit rule doesn't work as goog as expected... I use report builder in base, 4.0.3.3 version. Download 4.0.4 and report builder no more works (crash in opening). thanks anyway for developers work, I remember this is a free sw, at the end Federico Quadri Tom Davies tomdavie...@yahoo.co.uk ha scritto: Hi :) That 3rd digit is roughly the equivalent of Service pack. So usually the higher it is the more stable it is. Of
Re: [libreoffice-users] Attempting to open any Microsoft XML document causes General I/O error after upgrade to 4.1
FWIW: I do not know the correlation of versions between LO and AOO, but today I got the following two security reports from the AOO users forum: --- CVE-2013-2189 OpenOffice DOC Memory Corruption Vulnerability Severity: Important Vendor: The Apache Software Foundation Versions Affected: Apache OpenOffice 3.4.0 to 3.4.1 on all platforms. Predecessor versions of OpenOffice.org may be also affected. Description: The vulnerability is caused by operating on invalid PLCF (Plex of Character Positions in File) data when parsing a malformed DOC document file. Specially crafted documents can be used for denial-of-service attacks. Further exploits are possible but have not been verified. Mitigation: Apache OpenOffice 3.4 users are advised to upgrade to Apache OpenOffice 4.0. Users who are unable to upgrade immediately should be cautious when opening untrusted documents. Credits: The Apache OpenOffice Security Team credits Jeremy Brown of Microsoft Vulnerability Research as the discoverer of this flaw. Herbert Dürr Member of the Apache OpenOffice Security Team --- CVE-2013-4156 OpenOffice DOCM Memory Corruption Vulnerability Severity: Important Vendor: The Apache Software Foundation Versions Affected: Apache OpenOffice 3.4.0 and 3.4.1, on all platforms. Predecessor versions of OpenOffice.org may be also affected. Description: The vulnerability is caused by mishandling of unknown XML elements when parsing a OOXML document file. Specially crafted documents can be used for memory-corruption attacks. Further exploits are possible but have not been verified. Mitigation Apache OpenOffice 3.4.0 and 3.4.1 users are advised to upgrade to Apache OpenOffice 4.0. Users who are unable to upgrade immediately should be cautious when opening untrusted documents. Credits The Apache OpenOffice Security Team credits Jeremy Brown of Microsoft Vulnerability Research as the discoverer of this flaw. Herbert Dürr Member of the Apache OpenOffice Security Team -- Could this be related, in that now LO 4.1 rejects such files where LO 4.0 did not? Just a messenger. Girvin Herr Tom Davies wrote: Hi :) I sometimes get that from files on the network but when i copy them to local desktop machine they work fine. I've not really been tracking which versions it happens with. There seems to be something about the memory settings as higher spec machines with memory settings radically bumped right up seem to suffer this a lot less. They still get it occasionally tho. I thought it was my inexperience with networking or something Regard from Tom :) From: Tanstaafl tansta...@libertytrek.org To: users@global.libreoffice.org Sent: Friday, 26 July 2013, 11:33 Subject: [libreoffice-users] Attempting to open any Microsoft XML document causes General I/O error after upgrade to 4.1 Just wanted to check here before I go open a bug... I just upgraded to 4.1, everything seemed fine, but I encountered a .docx document this morning, and got the dreaded 'General I/O' error. I then tried a bunch of different XML documents (.docx, .xslx, and .pptx), and every one resulted in the same error. These are all docs that opened fine in 4.0.4 Will go back to 4.0.4 and confirm it resolves the problem... -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Draw printing of large plans MORE
doug wrote: On 07/24/2013 11:21 AM, doug wrote: On 07/24/2013 06:41 AM, John R. Sowden wrote: We have created a floor plan, using LO Draw with a scale of 1/8 = 1'. Now we want to take it to Kinko's (Fed Ex) and have it printed for about $4.00 per page. Problem is they cannot print it. A few questions: 1) What is the standard file format (description and file type) for professional drafting? The AutoCad file formats should be supported: .dxf and .dwg. 2) Does LO Draw support this format? Probably not. 3) If not, is there a work around? You might see if QCad can import your drawing format. I seem to remember that it can output .dwg. 4) Can I print multiple parts of the drawing onto 8.5 x 11.0 paper, then tape them together for a preliminary draft? (I know I can do the taping part, its the printing that is an issue :) )? You mentioned .pdf. If you can get your file into .pdf, you can select pieces of a pdf file to print--at least you can in AdobeReader. I don't know if any of the freebies can. 5) And , finally, Does the PDF format fit into this issue at all? See last answer. tia, John --doug Did some research: QCad wants dxf input. You might want to go thru QCad to check on the drawing and make sure that the conversion worked properly. (And fix it, if necessary. Next time do the drawing in QCad in the first place.) Anyway, you can almost surely get a dxf file printed by some custom printing place that has a plotter. You probably want D-size or E-size output, and you should get at least two copies--one to submit to the permit-issuing entity, and one for the builder. Be careful of the drawings--they will have been done in ink, most probably, and will smear if wet. (There is probably an E-size laser printer somewhere, but i don't know.) A Linux program that converts pdf to dxf is pstoedit. See information on the PCLinuxOS forum, here: http://www.pclinuxos.com/forum/index.php?topic=89825.0 Here's the skinny on x-size drawings: A-size is 8½ x 11 inches B-size is 11 x 17 inches C-size is 17 x 22 inches D-size is 22 x 34 inches E-size is 34 x 44 inches I imagine you see the pattern, so if you forget the sizes, you can re-create them by following the pattern up from standard letter-size of 8½ x 11. --doug To keep the record straight and with experience in the aerospace industry, those measurements are fine for engineering mechanical drawings (ANSI/ASME Y14.1 ( https://en.wikipedia.org/wiki/ANSI/ASME_Y14.1 )), but architectural drawing sizes are different. The OP's 24 x 36 is an architectural size. http://www.engineersedge.com/engineering_drawing_formats/engineering_drawing_format_sizes.shtml Note that the ANSI sizes do not stop at E. They are currently up to K. I remember using the J size which was the E height by up to 176 inches wide (long), with continuation title blocks spaced down the length (width) every 55 inches or so. Hope this helps. Girvin Herr -- To unsubscribe e-mail to: users+unsubscr...@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] desktop-integration
Heinrich, I am sorry. I misunderstood your intent. Yes, it does seem like a bug and should be addressed. I cannot shed any light on this specific subject, since I am not using any 4.x LO version. I am keeping with the stable 3.6+ series until 4.1.4+ is released. Then I may try it, depending on the complaints I see on this forum. That is just my computer policy. As for desktop integration (DI) being kde-specific, I don't think that is the case. Yes, there were, and still are in the 3.6 series, several versions of desktop integration for the different desktop environments (DEs). However, I just checked my 3.6.6.2 version and there are now only three: freedesktop, mandriva, and suse. There is no kde or gnome-specific version and the freedesktop DI seems to be the coming standard http://www.freedesktop.org/wiki/ , with mandriva and suse the final holdouts in the 3.6.6.2 case. So, I suspect if you select freedesktop for your gnome DE, it should work for you. It works for my KDE DE. In fact, gnome and kde are now so similar in API (Application Programming Interface) that they will run each others' apps (kde and gtk) and share the desktop directories/links, if not the menus. You may have also read the reply to this thread that the LO 4.1 series no longer has separate DI rpm package files, but has the DI integrated into the main package. I suspect that integration is the freedesktop DI, but that is just a guess. The bottom line is that this problem you are experiencing - not being able to run the main LO program or any of the sub-apps - does seem like a bug to me. Not being able to select a particular DI, may not be a bug, but just evolution. Hope this helps. Girvin Herr sun shine wrote: Girvin This is a topic I have some interest in and have been following. While I am aware of the capacity to run the soffice script from the terminal and even creating a custom launcher for the Gnome, XFCE4 and in Mint, Mate panels, what I am curious about is exactly why doing so is even necessary in the first place? This will have been the first time in my experience of using OOo and now LibO that doing this manually is necessary, and it makes me wonder what value the desktop-integration package has if the user still needs to do this customised approach to get the application to work. Are you able to shine any light on the matter? Is this an oversight from the 4.1. beta developers, a bug, or - a feature? Similarly, any ideas about why this desktop integration (which doesn't) is only geared for the KDE and not for Gnome (and Gnome-like) DEs? Thanks for any insights you can share. On 21/07/13 20:47, Girvin R. Herr wrote: Heinrich, Have you tried bringing LibreOffice up with soffice in a terminal shell, or unambiguously, /opt/libreoffice4.1/program/soffice (less quotes, of course)? If that works, then you could manually add a link in your menu or at least an icon on your desktop. soffice is the main libreoffice program or, more accurately, script, that invokes the other programs (Writer, Calc, etc.). If that program is not run first, then the others may not be initialized properly to run. You could also run writer, calc, etc. from a terminal and see what messages are output from it. They may give you a clue as to why it isn't running properly. But my bet is on soffice. FYI: soffice is a legacy name from the StarOffice days. Maybe some day the devs will get around to changing that - unless it would break something. Hope this helps. Girvin Herr snip -- To unsubscribe e-mail to: users+unsubscr...@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] desktop-integration
Heinrich, Have you tried bringing LibreOffice up with soffice in a terminal shell, or unambiguously, /opt/libreoffice4.1/program/soffice (less quotes, of course)? If that works, then you could manually add a link in your menu or at least an icon on your desktop. soffice is the main libreoffice program or, more accurately, script, that invokes the other programs (Writer, Calc, etc.). If that program is not run first, then the others may not be initialized properly to run. You could also run writer, calc, etc. from a terminal and see what messages are output from it. They may give you a clue as to why it isn't running properly. But my bet is on soffice. FYI: soffice is a legacy name from the StarOffice days. Maybe some day the devs will get around to changing that - unless it would break something. Hope this helps. Girvin Herr Heinrich Stoellinger wrote: Hello, The system on which I am trying to get LO 4.1-RC3 to run is: Linux Debian Wheezy with KDE 4.10, latest software levels. I first removed LO 3.6.2 using apt-get remove libreoffice* and then installed 4.1-RC3 using dpkg- i *deb from within all three directories in the correct sequence. The installation went smoothly - no hick-ups! Now I find LO 4.1 within the programme start menu of KDE (under office applications). To be precise - everything is there (base, writer, impress, etc.) except the icon for LibreOffice itself (like it used to be under 3.6). When I now try to start Writer, nothing at all happens. The same is true when trying to start the other components... Any help is appreciated. Regards from sunny and hot Salzburg H. Stoellinger On Sat, 20 Jul 2013 20:22:08 +0200, sun shine phaedr...@gmail.com wrote: On 20/07/13 19:06, Mirosław Zalewski wrote: On 20/07/2013 at 19:51, Kracked_P_P---webmaster webmas...@krackedpress.com wrote: So we no longer have to do a separate install command for installing the desktop menus? So one sudo dpkg -i *.deb is all we need? Yes, this is how it is supposed to work. (There are some bugs in rc3 that causes package conflicts with earlier version of LO, so running this command might run you into trouble.) On the other hand: if you are like me and you keep different LO versions installed for testing purposes, then you must take extra care to not install desktop-menus and not pollute your working environment with unnecessary menu entries. But since this is not use-case for most of users, I believe change is for good. In which case the installation notes for the 4.1 for *.deb need to be updated since they still give the two separate commands, the second suggesting cd to the desktop-integration directory before issuing the second sudo dpkg -i *.deb command. Cheers -- To unsubscribe e-mail to: users+unsubscr...@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] Pull-down styles menu
Seamas, If I understand you correctly, you don't like the font preview pull-down when selecting a font in the toolbar? Have you tried: Tools - Options - Libreoffice - View And under Font Lists, uncheck Show preview of fonts This is in 3.6.6, so 4.x may be different. I tested this and unchecking this option presents a list of fonts in plain text, not in their actual style. Hope this helps. Girvin Herr Séamas Ó Brógáin wrote: My version of Libre Office (4.0.2.2) on GNU/Linux (Ubuntu 13.04) has a feature that I decidedly don’t want: illustrating the styles in the pull-down style menu in the actual typeface and size (some huge, some tiny). I’ve searched everywhere for the option of turning it off, but with no success. Any hints gratefully received. -- To unsubscribe e-mail to: users+unsubscr...@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] HSLQLDB syntax
To keep the record straight, Stardivision's StarOffice did not use HSQLDB. Unless the name has been changed, Stardivision used the ADABASE D database engine in their StarOffice. As far as I can research, Sun dropped the proprietary Adabase D engine in favor of HSQLDB after it took over the StarOffice code from Stardivision. I never was able to get Adabase D working for me back then, but I was ignorant of real (non-Access) databases then and the StarOffice Adabase D database documentation was terrible. Girvin Herr V Stuart Foote wrote: STOP! Anne, glad you're back but seriously? HSQLDB is the short title and Web address for HyperSQL, the Java language based SQL relational database that StarOffice then Sun chose as the imbedded database for the project. Currently we include the 1.8 release, and efforts will either see that ripped out of LibreOffice to be replaced, or the version of HSQLDB will be upgraded to a current 2.3 release. Mark, et al., all the details you could ever want are on the project webpage at hsqldb.org, just mind the version differences. Stuart From: Tom Davies [tomdavie...@yahoo.co.uk] Sent: Monday, July 15, 2013 11:15 AM To: anne-ology; Mark LaPierre Cc: Mail List LibreOffice Subject: Re: [libreoffice-users] HSLQLDB syntax Hi :) My guess is that he meant H Sql Db SQL = the standard language used by most database programs. Most add a little bit (few extra commands and stuff) to the basic language to help ensure that people can't easily switch to another program even though they all ostensibly use Sql. Db = Database H is the only bit that distinguishes exactly which program is being talked about. Note that other programs also use Sql or Db in their name. For example MySql/MariaDb, Postgresql. Only Access doesn't have any of that in it's name. Of course MS make many claims that Access does use Sql but it's such a heavily tweaked version of Sql that it's almost unrecognisable. If you learn Access then you need to forgetre-learn if you want to switch to anything else. The others tend to just have a few differences so it's not so tough to move between them. At least, so i have heard. Regards from Tom :) From: anne-ology lagin...@gmail.com To: Mark LaPierre marklap...@aol.com Cc: Mail List LibreOffice users@global.libreoffice.org Sent: Monday, 15 July 2013, 16:38 Subject: Re: [libreoffice-users] HSLQLDB syntax And just what is HSLQLDB ;-) oh, memorizing acronyms seems to me a mighty complicated way to organize one's thoughts ... wouldn't it be simpler - easier - to just state the object(s) rather than leaving the listener trying to interpret what's being meant by what's being said ;-) see - http://www.merriam-webster.com/dictionary/acronym AND - did you happen to notice in that URL, this phenomenon only started in 1943 ;-) before then communication was simply speaking to be understood ;-) BTW - many of these acronyms are duplicated - which causes even more confusion to the listener ;-) On Sat, Jul 13, 2013 at 1:07 PM, Mark LaPierre marklap...@aol.com wrote: On 07/13/2013 05:36 AM, Alexander Thurgood wrote: HSLQLDB is a bit picky about the syntax Does anyone know where I can find a good reference on HSLQLDB syntax? -- To unsubscribe e-mail to: users+unsubscr...@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 no mail client.
Correct me if I am wrong and I am not that familiar with Opera, but I seem to remember that Opera uses the Mozilla engine, just like Firefox and several other open source web browsers. So, who benefited from Opera's battle with MS again? We, the people, all did; which is apropos for the day! Girvin Tom Davies wrote: Hi :) Errr, allegedly. I might have a few facts a bit wonky but that's the way i heard it Regards form Tom :) From: Tom Davies tomdavie...@yahoo.co.uk To: Johnny Rosenberg gurus.knu...@gmail.com; Sajan Parikh sa...@noppix.com Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Wednesday, 3 July 2013, 23:38 Subject: Re: [libreoffice-users] Libreoffice no mail client. Hi :) It's good to hear people are using it more and more nowadays. They won a good fight against IE and deserve the credit for many of the freedoms we have today to be able to choose Firefox, Chrome and others that kept themselves out of the legal fight against MS but still profited from the results. Top marks to anyone that does use Opera though Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: Sajan Parikh sa...@noppix.com Cc: users@global.libreoffice.org Sent: Wednesday, 3 July 2013, 11:32 Subject: Re: [libreoffice-users] Libreoffice no mail client. 2013/7/2 Sajan Parikh sa...@noppix.com: Opera have also just announced recently that they will be releasing a standalone mail client as well, with Linux support. Then I hope they will remove the built in one from the browser to make it less bloated. I just hate those dialogues that pop up sometimes when I close Opera, telling me that Opera needs to do something with my email database (which doesn't exist anyway since I only use the web interfaces for my email) or whatever… Johnny Rosenberg At the time of announcement early builds for Windows and Macs were available and Linux was coming soon. I haven't checked in a couple weeks, but there might be some progress on that. Sajan Parikh /Owner, Noppix LLC/ e: sa...@noppix.com p: (563) 726-0371 Noppix LLC Logo On 07/02/2013 06:28 AM, James Knott wrote: wsadm...@hep-tech.com.tw wrote: Hi All!   Libreoffice will the development of mail client? Foxmail isn't open source. Many people use Thunderbird. -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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 no mail client.
I stand corrected. In case you are not joking, today, July 4th, is our Independence Day, a national holiday in the US. Maybe you Brits try to forget that day, July 4, 1776. ;-) https://en.wikipedia.org/wiki/Independence_Day_(United_States) Girvin Tom Davies wrote: Hi :) I think Opera uses a completely different back-end/engine. We, the people, did benefit. Is today Bruce Springsteen's birthday or something? I'm not in the US so i don't keep up with all these things. Regards from Tom :) From: Girvin R. Herr girvin.h...@sbcglobal.net To: Tom Davies tomdavie...@yahoo.co.uk Cc: Johnny Rosenberg gurus.knu...@gmail.com; Sajan Parikh sa...@noppix.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 4 July 2013, 18:39 Subject: Re: [libreoffice-users] Libreoffice no mail client. Correct me if I am wrong and I am not that familiar with Opera, but I seem to remember that Opera uses the Mozilla engine, just like Firefox and several other open source web browsers. So, who benefited from Opera's battle with MS again? We, the people, all did; which is apropos for the day! Girvin Tom Davies wrote: Hi :) Errr, allegedly. I might have a few facts a bit wonky but that's the way i heard it Regards form Tom :)  From: Tom Davies tomdavie...@yahoo.co.uk To: Johnny Rosenberg gurus.knu...@gmail.com; Sajan Parikh sa...@noppix.com Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Wednesday, 3 July 2013, 23:38 Subject: Re: [libreoffice-users] Libreoffice no mail client. Hi :) It's good to hear people are using it more and more nowadays. They won a good fight against IE and deserve the credit for many of the freedoms we have today to be able to choose Firefox, Chrome and others that kept themselves out of the legal fight against MS but still profited from the results. Top marks to anyone that does use Opera though Regards from Tom :)   From: Johnny Rosenberg gurus.knu...@gmail.com To: Sajan Parikh sa...@noppix.com Cc: users@global.libreoffice.org Sent: Wednesday, 3 July 2013, 11:32 Subject: Re: [libreoffice-users] Libreoffice no mail client. 2013/7/2 Sajan Parikh sa...@noppix.com:    Opera have also just announced recently that they will be releasing a standalone mail client as well, with Linux support.     Then I hope they will remove the built in one from the browser to make it less bloated. I just hate those dialogues that pop up sometimes when I close Opera, telling me that Opera needs to do something with my email database (which     doesn't exist anyway since I only use the web  interfaces for my email) or whatever… Johnny Rosenberg    At the time of announcement early builds for Windows and Macs were available and Linux was coming soon. I haven't checked in a couple weeks, but there might be some progress on that. Sajan Parikh /Owner, Noppix LLC/ e: sa...@noppix.com p: (563) 726-0371 Noppix LLC Logo On 07/02/2013 06:28 AM, James Knott wrote:     wsadm...@hep-tech.com.tw wrote:      Hi All!   Libreoffice will the development of mail client? Foxmail isn't open        source.  Many people use Thunderbird.      -- To unsubscribe e-mail to: users+unsubscr...@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     -- To unsubscribe e-mail to: users+unsubscr...@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      -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] constant crashes
When this odd mailist behavior was instituted a while back, many people complained and it was decided by the instituter that there was to be a poll about it and if most people in the poll complained, they would return to the standard behavior. What ever happened to that? All I see are complaints about this behavior. I don't remember anyone saying they loved it. Like the other poster, I find it mildly annoying - especially after sending, I realize I used the wrong method and have to do it all over again. That's not very productive. Girvin Herr Tom Davies wrote: Hi :) That is weird. It might still be a User Profile issue on all the machines. Most likely is a particular Extension/Add-on that you have on all machines. Do you have anything like that? If you rename the User Profile on just 1 machine as a test rather than doing it on all machines. https://wiki.documentfoundation.org/UserProfile wrt to replying to the list you are not the only one. I didn't even realise your reply didn't go to the list and was wondering why no-one else responded to my post. We have to use Reply to all or Group reply rather than just the normal Reply to. It is annoying a few of us but there doesn't seem to be anything any of us can do about it. Apols and regards from Tom :) From: Thomas Blasejewicz tho...@s7.dion.ne.jp To: users@global.libreoffice.org Sent: Tuesday, 2 July 2013, 16:39 Subject: Re: [libreoffice-users] constant crashes I am sorry, I responded (again) only to Mr. Davies and not the list. There seems to be a trick to it ... (2013/07/02 18:26), Tom Davies wrote: Hi Also try Tools - Options - Memory and increase the various sizes. I have it set at something like 20Mb/object and above the Use for LibreOffice set a LOT higher than i expect the final documents to be. Around 50Mb might be a good idea. However, crashes are usually a result of Java behaving badly. You can probably switch Java off completely or just switch it off for LIbreOffice Tools - Options - Advanced The top tick-box lets you switch it off. The next most common cause is some problem in your User Profile so you might want to temporarily get back to factory defaults by renaming your User Profile https://wiki.documentfoundation.org/UserProfile Well, I run LO on Win XP SP3, 2.5 GB RAM Turned off ALL other software Set memory per object to 20 MB memory for LO to 50 MB changed version of JAVA turned JAVA off so far no improvement. reset user profile? not yet. Iif I do that, I suppose I loose all my styles, templates, autotext, macros etc., right? Or will they remain available? Anyway, that is an adventure I may try when I am at leisure after dinner or so ... One more thing: the exact same thing happens exactly in the same way on three different computers. Two running Windows XP, one Win 7. Can this still be problem with the user profile? One person found that upgrading to a more recent version of LibreOffice solved a crashing problem There is another rare and intermittent bug to do with images. It's been around since OOo 2.(something) but is very rare and difficult to pin-down because it is not easy to reproduce conditions reliably. Best work-arounds are 1. Switch off the auto-back-up! But then you have to keep making sure you do save regularly and fairly frequently, perhaps incrementing versions occasionally to ensure you can easily go back to a previous state. 2. to keep a copy of all the images in a sub-folder in the same folder as the document, or elsewhere that is easy to get to so that if images do vanish from the document then it's easy to replace them 3. Work on your document locally and then upload back to the network or Cloud or usb-stick or where-ever you keep it. Regards from Tom   *From:* Dries Feys dries.f...@tvh.com   *To:* Thomas Blasejewicz tho...@s7.dion.ne.jp   *Cc:* users@global.libreoffice.org users@global.libreoffice.org   *Sent:* Tuesday, 2 July 2013, 8:45   *Subject:* Re: [libreoffice-users] constant crashes   You could try version 3.6.6 or 4.0.4.   Do you have enough ram? On what OS are you working?   Met vriendelijke groeten, Salutations distinguées, Kind Regards,   DRIES FEYS   CORPORATE SERVICES • Specialist Software Developer   T +32 56 43 42 45 • F +32 56 43 44 46 • dries.f...@tvh.com mailto:dries.f...@tvh.com   TVH GROUP NV   Brabantstraat 15 • BE-8790 WAREGEM   T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com   On 2 July 2013 09:15, Thomas Blasejewicz tho...@s7.dion.ne.jp mailto:tho...@s7.dion.ne.jp wrote:  ÂGood afternoon  ÂI do have an ordinary ODF Writer file, about 14 MB in size   because of  Âabout 60 monochrome pictures (writing a book).  ÂThis
Re: [libreoffice-users] Re: Database field on top of PDF document
Alex Thurgood wrote: Le 21/06/2013 20:46, howellsilverman a écrit : That is correct. These are forms that are available to me as pdf's without fillable fields. Even if the fields were fillable - I want to fill them from a database. I'm not the creator of these forms so I have to work backward from what I receive. OK, then Girvin's advice about using Draw is probably the best thing, or else invest in a specific PDF converter software that will turn your PDF image form into an editable one. Alex Maybe. Except for the OP's comment: ...I want to fill them from a database. That implies that the OP wants to do something like mailmerge, where database record data fields are inserted into the Draw text blocks. I am not sure Draw supports that. I suppose the Draw image of the pdf form could be inserted into a Writer document as a background (something like a watermark) and then mailmerge type fields could be put on top of the Draw image with frames, but I have never done that. BTW: I have never used mailmerge, so this is all speculation on my part. It is something I would try if I were having the OP's problem. Girvin -- To unsubscribe e-mail to: users+unsubscr...@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: Database field on top of PDF document
Piece of cake with Draw. I've done it. Now if the OP wants automation, I can't help there. Girvin Tom Davies wrote: Hi :) I think he is trying to fill in a form that has been sent to him as a Pdf. Either that or trying to fill in a form that has been scanned in as a Pdf. Regards from Tom :) From: Alexander Thurgood alex.thurg...@gmail.com To: users@global.libreoffice.org Sent: Friday, 21 June 2013, 17:58 Subject: [libreoffice-users] Re: Database field on top of PDF document Le 21/06/13 17:12, howellsilverman a écrit : Hi Howell, Ok thanks. I tried that. It worked. You need a form with a transparent background which took a little work with gimp ( http://www.ehow.com/how_8422694_remove-white-gimp.html). Then I used a table to place the fields where I wanted them.. So I can see a method to get this handled. I am a bit lost as to what it is exactly you are trying to achieve. You don't say what it is you want as your PDF document and what that has to do with Writer ? For example, in Base, you can create a database form with a background image that will have some degree of transparency. You can also do this independently as a Writer document, into which you insert your fields from your database. It is possible to insert and image in this Writer document which can be set to be a watermark, i.e. with a degree of transparency. Where does the PDF come in ? Are you exporting your form to FPDF ? Sorry, but I guess I'm missing something. Alex -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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: Database field on top of PDF document
I have only done it 1 or 2 times myself, but that has not been my experience. Yes, there are different types of pdf files out there. Some, the pdf form could actually be modified, the others, not. However, just positioning text fields in the form blanks was easy enough. Once I got one text block formatted to what I wanted, I just copy-pasted it into the other fields and edited the text. Making the text field bigger or smaller to account for different sizes of form fields was not a problem for me in Draw - just grab the tags. I even was able to scan my signature in as a graphic and paste it in the proper place. That took a bit of technique, since the graphic was not transparent and if it were not small enough to fit in the space allotted, it would blank out parts of the form around it. I recommend just keeping the scan edges close to the script and it should be okay. Why did I do it? My handwriting is not what it once was and I wanted the reader to be able to read my entries without mistakes. As it turned out in one case, they messed it up anyway! :-( Girvin Tom Davies wrote: Hi :) Hmmm, i always struggle with it quite a lot. Not that i have done it much. Only tried 1 or 2 times tbh but both times it was a pita. Regards from Tom :) *From:* Girvin R. Herr girvin.h...@sbcglobal.net *To:* Tom Davies tomdavie...@yahoo.co.uk *Cc:* users@global.libreoffice.org users@global.libreoffice.org *Sent:* Friday, 21 June 2013, 19:16 *Subject:* Re: [libreoffice-users] Re: Database field on top of PDF document Piece of cake with Draw. I've done it. Now if the OP wants automation, I can't help there. Girvin Tom Davies wrote: Hi :) I think he is trying to fill in a form that has been sent to him as a Pdf. Either that or trying to fill in a form that has been scanned in as a Pdf. Regards from Tom :) From: Alexander Thurgood alex.thurg...@gmail.com mailto:alex.thurg...@gmail.com To: users@global.libreoffice.org mailto:users@global.libreoffice.org Sent: Friday, 21 June 2013, 17:58 Subject: [libreoffice-users] Re: Database field on top of PDF document Le 21/06/13 17:12, howellsilverman a écrit : Hi Howell, Ok thanks. I tried that. It worked. You need a form with a transparent background which took a little work with gimp ( http://www.ehow.com/how_8422694_remove-white-gimp.html). Then I used a table to place the fields where I wanted them.. So I can see a method to get this handled. I am a bit lost as to what it is exactly you are trying to achieve. You don't say what it is you want as your PDF document and what that has to do with Writer ? For example, in Base, you can create a database form with a background image that will have some degree of transparency. You can also do this independently as a Writer document, into which you insert your fields from your database. It is possible to insert and image in this Writer document which can be set to be a watermark, i.e. with a degree of transparency. Where does the PDF come in ? Are you exporting your form to FPDF ? Sorry, but I guess I'm missing something. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto:unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto:unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] CNET is claiming the best free MSO alternative is not LO
And I remember when car owner's manuals were 1/4 thick at the most, and large (readable) print. My 2008 Toyota Prius owner's manual is 3/4 thick, small print, and spattered with dire paragraphs about everything causing injury or death! Made me want to turn in my license! It is not a good read and, like your experience, information is not easy to find in it. Oh, and the owner's maintenance manual is a separate manual - equally obtuse and with more dire warnings. Usually, when I get a new car, I go to the dealer's parts counter and order the factory shop manual for correct maintenance and understanding of what is under the hood. When I did so for the Prius, the parts counter guy recommended not, saying the shop manual is intricately tied to the shop diagnostic computer system ($) and by itself, is not very helpful. So, i saved $100+ for the first time in my shadetree-mechanic career and, also for the first time in my decades of car-ownership, take it to the dealer for maintenance. Girvin Herr anne-ology wrote: ah, yes, a good book ... a readable manual ... ... ... I've tried at various times to read these supposed helpful manuals only to discover more confusion ... it's like reading a foreign language yet there's no dictionary to use for help; and if they happen to have sketches ... well, these tend not to correspond with the written document. Automobiles, since becoming computerized, supposedly have these helpful manuals - but reading them for something as simple as changing the clock [an inane idea anyway] is next to impossible ... the trained mechanics even have trouble with this one - it took 3 of them about 1/2 hour to finally figure out that one vehicle's settings were tied into the radio dials but only if the engine was running and the gear was in park ;-) crazy is as crazy does On Fri, Jun 7, 2013 at 2:50 PM, Girvin R. Herr girvin.h...@sbcglobal.net mailto:girvin.h...@sbcglobal.net wrote: Ahh! The Gimp. Great program and I do have some use for it. However, learning it has a _steep_ learning curve for me and, frankly, sitting at the screen and reading the online manual is not what I would prefer using my limited time for. There are several learning books out there, but which one is the best one I need to learn The Gimp? That is my problem with it. Once or twice I fiddled with it and got it to do somewhat what I wanted, but it wasn't very intuitive and I feel it could do so much more for me. If I could just get a good book on it and sit down and play with it... Girvin Herr -- To unsubscribe e-mail to: users+unsubscr...@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] CNET is claiming the best free MSO alternative is not LO
I have downloaded the 3.6 guides some time back and printed them out for future reference. I occasionally refer to them when I need to find out how to do something new or how something works. They are certainly better than Help or scanning through online docs. The table of contents and indexes are my friends. Yes, they are okay as far as they go. Girvin Herr Tom Davies wrote: Hi :) Has anyone read the Published Guides for LibreOffice? or used them to look up the odd thing or few? They are kinda ok aren't they? Regards from Tom :) From: Doug dmcgarr...@optonline.net To: users@global.libreoffice.org Sent: Monday, 10 June 2013, 20:21 Subject: Re: [libreoffice-users] CNET is claiming the best free MSO alternative is not LO On 06/10/2013 02:14 PM, les wrote: /snip/ I go to the dealer's parts counter and order the factory shop manual for correct maintenance and understanding of what is under the hood. When I did so for the Prius, the parts counter guy recommended not, saying the shop manual is intricately tied to the shop diagnostic computer system ($) and by itself, is not very helpful. So, i saved $100+ for the first time in my shadetree-mechanic career and, also for the first time in my decades of car-ownership, take it to the dealer for maintenance. Girvin Herr Also most mechanics are used to pure gasoline or diesel engines. I think many of them inherently distrust the electronics, so it has been a real uphill battle for them to port some of their existing knowledge to these new systems. /snip/ I don't know, but I would be willing to bet large sums that the manual that goes with the computer diagnostics is far easier to read and understand than anything written for diagnostics or setup of an actual computer! (Still waiting for a networking treatise written in humanly understood terms! Just for the home user, not for someone setting up an IBM facility!) --doug -- Blessed are the peacemakers..for they shall be shot at from both sides. --A.M.Greeley -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] GIMP - was: CNET is claiming the best free MSO alternative is not LO
Kracked_P_P---webmaster wrote: On 06/07/2013 03:50 PM, Girvin R. Herr wrote: Kracked_P_P---webmaster wrote: snip I need to relearn the interface for Paint Shop Pro X5, when I used version 5 since the XP days. But since I can not get v5 to install on Win7 Home Premium that my laptop has, I had to upgrade it and relearn the new interface. Same with PSP 5 or X5 vs. GIMP. The time it takes to relearn how to do the things that comes very easily to me with the old interface, well it is very frustrating to say the least and has taken 2 to 5 times longer to do the things I want/need to do. Ahh! The Gimp. Great program and I do have some use for it. However, learning it has a _steep_ learning curve for me and, frankly, sitting at the screen and reading the online manual is not what I would prefer using my limited time for. There are several learning books out there, but which one is the best one I need to learn The Gimp? That is my problem with it. Once or twice I fiddled with it and got it to do somewhat what I wanted, but it wasn't very intuitive and I feel it could do so much more for me. If I could just get a good book on it and sit down and play with it... Girvin Herr snip Yes GIMP has a steep learning curve. As for learning curves, ever try to use Photoshop? No. Now that has a steep learning curve if you have not dealt with such a package before. PSP5 was so easy to use and learn, plus it had everything I wanted or needed for my work. Also GIMP does not have all of the filters that I had with Paint Shop Pro 5 [or the new X5]. If there was an easier and/or better graphics program that I could use with Ubuntu 12.05, then I would give it a try. Sometimes the books I have seen in the stores, or online, seem to be written by and for the graphic artist, and not those of us who need it for the more simple things, like repairing old photos or dealing with simple pixel-based graphics. Right on! That's all I need it for. A while back I tried to add arrow lines to a photo as an experiment to document where components were on a project. I couldn't get The Gimp to do it, though I was sure it could. In The Gimp, I could add the lines, but since it was not a vector (two end points), I could not move those lines if I needed to squeeze in another line beside it, unless I erased each and every pixel. I ended up using LO Draw, which is a vector drawing program, not a bitmap drawing program like The Gimp! It did a fine job and I was even able to add an underlying, slightly wider white line to enhance the readability of the black line over dark photo imagery. How many Gimp books must I buy and dispose of before I get one that is basic enough for me (i.e. Gimp for Dummies?) for all [most] vector-based graphics, I use Inkscape. I have not really sat down and learned Draw for these things, yet. I am so use to Corel Draw 11, Inkscape is similar enough to use, is I am using Ubuntu. I have Corel Draw 11 on a Win7 laptop. I am very familiar with LO Draw. I use it a lot to draw diagrams in technical manuals. Draw does have some quirks, but it is fairly easy to use and productive. I am still learning things about it, such as freezing areas by putting them on a separate layer and making it unchangeable (unselectable?). That is required to allow inner objects to be selected without selecting a larger outer object. I generally use it as an embedded object in a Writer document, which has even more quirks. For some reason, the embedded Draw is a subset of the stand-alone Draw. For instance, zoom is not supported in the embedded version, so it gets difficult sometimes to work on a small object or grid. I have also found some quirks about scaling and adjusting locations in the embedded version. It can get really squirrelly sometimes. For example, if I try to enlarge the drawing in the embedded Draw by dragging the tags, nothing will happen. Then all of a sudden, the drawing will greatly enlarge, clipping the edges, and I cannot get it back to full extents again. As I said, squirrelly. I discovered the adjustments in the object frame properties to be helpful there. I just wish I really had the time to sit down and play with the packages, GIMP, Draw, and others, with a good book of instructions to help walk me through the processes. Ahh! There's the rub. I have the same problem. I usually start reading up on something to address a need, get distracted by something of higher priority, and then never get back to the book. Sometimes the original need goes away and it isn't so bad. Other times, I just don't get back to the problem. For example, I started reading up on Java a few months ago in order to learn enough about it to fix some non-fatal bugs in a database Report Generator (RG) I am using instead of the LO Base Oracle Report Builder (ORB), which I find too buggy to use. I got into chapter 2, got torn away from
Re: [libreoffice-users] CNET is claiming the best free MSO alternative is not LO
Kracked_P_P---webmaster wrote: snip I was talking to a professor a few days ago. He does not like the newer versions due in part to the way they keep changing the interface and how to do things. I made sure he know about LO. He loved the multi language part as well. I did not like the ribbon menu system either. Sure, the type of interface that LO uses has been around for years, but that does not mean you need to change it. Refreshing or redesigning the interface, just because you can, is not a reason to. One of the good things about LO as it went from 3.3 though 4.0 is the way the interface does not change, or has a slow change so it does not stand up and slap your face with the changes. Once you learn what is where and how to do things, changing that will cause problems. Sure the interface could use some enhancements, like the persona addition, but to keep our users happy, you must not make the users relearn how to do things or where are the menu options are now located. I have been using the OO/LO office suite since OO.o 1.x and now I am using LO 3.6.6. (I have not tried LO 4.0.x, since I am still waiting for that less-buggy 4.1.5+ version to be released.) However, I have found the incremental changes to the user interface refreshing. OO.o and now LO, have made great improvements in this area with each release. Nothing to make me go back to school to get my degree on how to use it, but the changes made the functions much easier to use and more intuitive. To me, that is a big plus. I want to be productive, not have to re-learn user interfaces with each new release. Although I am a retired electronics engineer, I am _not_ a techno-geek who has to have the latest and greatest all the time. You won't find me waiting for hours outside an Apple store to buy the latest iPhone. If it works, don't fix it is my motto. Girvin Herr snip -- To unsubscribe e-mail to: users+unsubscr...@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] Problem solving
Tom, You might add: Bad news always gets more exposure than good news. The more sensational and shocking, the louder. Its all human nature. Your first quote is a included in Murphy's Law, I suspect. Girvin Herr Tom Davies wrote: Hi :) I thought people might like these quotes Just proving that the quickest way to solve the problem is to post a whine to the newsgroups: within moments the solution presents itself to me, and meanwhile my ass is hanging out on the Net... *sigh*... -- Dave Phillips, dlph...@bright.net, about problem solving via news-groups [like mailing lists] (thanks to Thomas Hackert of the translators list for having that in his sig) The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. -- Bertrand Russell (errr, another sig from the same person) There used to be someone else on this list that had something like Friends argue. Enemies don't care enough Regards from Tom :) -- To unsubscribe e-mail to: users+unsubscr...@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] CNET is claiming the best free MSO alternative is not LO
Kracked_P_P---webmaster wrote: snip I need to relearn the interface for Paint Shop Pro X5, when I used version 5 since the XP days. But since I can not get v5 to install on Win7 Home Premium that my laptop has, I had to upgrade it and relearn the new interface. Same with PSP 5 or X5 vs. GIMP. The time it takes to relearn how to do the things that comes very easily to me with the old interface, well it is very frustrating to say the least and has taken 2 to 5 times longer to do the things I want/need to do. Ahh! The Gimp. Great program and I do have some use for it. However, learning it has a _steep_ learning curve for me and, frankly, sitting at the screen and reading the online manual is not what I would prefer using my limited time for. There are several learning books out there, but which one is the best one I need to learn The Gimp? That is my problem with it. Once or twice I fiddled with it and got it to do somewhat what I wanted, but it wasn't very intuitive and I feel it could do so much more for me. If I could just get a good book on it and sit down and play with it... Girvin Herr snip -- To unsubscribe e-mail to: users+unsubscr...@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] Default Superscript and Subscript size
Is this the same bug that prevents things from working when the Tools - Options - LibreOffice - User Data section is not filled in? As a retired Electronic/Software engineer, I think that bug is silly and sounds deliberate - especially since it has been known and not fixed for a long time. But that may just be my paranoia showing. Girvin Tom Davies wrote: Hi :) No worries about the duplicates to me. Pressing Delete 3 times instead of 2 is pretty easy for me. There is some weird bug that means a certain setting keeps getting forgotten when there is nothing in File - Properties - Descriptions but you don't need to fill it in substantially. Even just a word per section is more than enough. I don't think that is likely to be the problem because someone else would have picked it up by now. So, i think starting a bug-report would be a good plan. Regards from Tom :) From: Tim Vivian-Griffiths timv...@gmail.com To: Tom Davies tomdavie...@yahoo.co.uk Cc: Steve Edmonds steve.edmo...@ptglobal.com; LibreOffice users@global.libreoffice.org Sent: Sunday, 2 June 2013, 14:20 Subject: Re: [libreoffice-users] Default Superscript and Subscript size Hi Tom Sorry for the later reply on this. Thank you for this information, really useful as I have never done it before. I'll also fill in that information to see if it helps at all. Thanks again, Tim PS, sorry for duplicating this Tom... I pressed Reply instead of Reply-to-all the first time! On 31/05/13 10:40, Tom Davies wrote: Hi :) Given the answers in the thread at AOO i suspect it is a bug. Here is a guide to help post a bug-report. Don't take it all too seriously. They ask for a lot but if it's not easy to give all that straight away just post anyway. Later on you can add comments so you can get all the required information together in the report in a few posts at your own pace. It might be that they are able to help without even having all the info straight away anyway. https://wiki.documentfoundation.org/BugReport If this list does solve the problem you can always close the report and let people know how and that might help those people over at AOO too. Just out of curiosity do you have any of the general information, such as user-name and stuff 'filled in'? There was something that only worked if you had at least 1 or 2 characters, even empty spaces in there. Aaargh, i'm at a Windows machine that doesn't have LibreOffice or even OpenOffice, yet. I might have to make sure i get the portable version worked out in case i'm ever here again! Apols and regards from Tom :) *From:* Tim Vivian-Griffiths timv...@gmail.com *To:* Steve Edmonds steve.edmo...@ptglobal.com *Cc:* Tom Davies tomdavie...@yahoo.co.uk; LibreOffice users@global.libreoffice.org *Sent:* Friday, 31 May 2013, 10:15 *Subject:* Re: [libreoffice-users] Default Superscript and Subscript size Hi all, Actually none of these things are happening Tom. The only way that I can get what I want is by selecting every instance individually which is just impractical. Steve, I can do exactly the same as well but once the changes are selected there is no difference at all when I start typing. I select my desired size and click Apply, then when I reopen the document... the changes are still there. However, when I press Ctrl-Shift-P to get superscript (or Ctrl-Shift-B for subscript) the size is back to 58%. As I said before, I can change it after I have typed it by selecting it and then going to Format - Character and changing it to 70%. I just cannot find a way so that whenever I toggle super/sub-script on... I get the desired size. I've followed the directions in the writer guide, and this seems to me to be intuitively what should be done... but no effect takes place. That's why I thought it could be a bug. Tim On 31/05/13 09:48, Steve Edmonds wrote: Hi. I have Default showing as my style (dropdown above and to left of the typing area), just typed some letters on a page, right clicked, Edit Paragraph Style There I change the superscript and subscript values to say 40%. I apply and exit. If I exit LO and then start a new document the superscript and subscript are still 40%. This is in LO3.6 and 4.1. The automatic box is ticked. Does this describe what you are wanting to do. steve On 31/05/13 10:41 AM, Tim Vivian-Griffiths wrote: Dear all, Thank you very much for your replies. Here is the link to my post in the forum: http://forum.openoffice.org/en/forum/viewtopic.php?f=7t=61594 I have put a fair bit of description of the issue there, but let me know if I can give any more information. I
Re: [libreoffice-users] Re: no answers to my question
Tom Davies wrote: Hi :) Not all our devs are volunteers. Some are paid by various companies, notably SUSE but also Redhat and others to work on LibreOffice. Such companies might normally attempt to create their own in house product but instead choose to collaborate on creating something shared. Macs are based on Bsd, which in turn is unix-based. GnuLinux are also unix-based. So Bsd and GnuLinux share the same parent but do have differences. Just to keep the record straight, on Linux day #1, Linus Torvalds based his Linux on Minix https://en.wikipedia.org/wiki/MINIX , which in turn was based on Unix. I do believe the Minix disk filesystem is still included with today's Linux. Yes, I just checked and it is (man mkfs.minix). Then GNU had a bunch of *nix utilities, such as ls, tar, gcc, etc. which Linus merged into Linux. Linux grew from that grafting ever since. That is why Linux is referred to as GNU/Linux. To be accurate, the term Linux only refers to the kernel operating system, not the GNU tools. GNU/Linux is not Unix, but it is very close and the philosophy is very similar. BSD and GNU/Linux are two branches of the same Unix tree. Although a bit dated (the Linux kernel is now up to 3.x), here is a nice chart I just found: https://en.wikipedia.org/wiki/File:Unix_history.svg Clearing the air... Girvin Herr Apparently a lot of Raspberry Pis are used to play around with hardware experimentation such as control's for various types of robots. One chap put quite a few together to create a super-server. So significant numbers are not being used as desktop machines at all. Regards from Tom :) snip -- To unsubscribe e-mail to: users+unsubscr...@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] What happened to autoformat option?
Brian Barker wrote: At 18:21 30/05/2013 -0700, Girvin R. Herr wrote: ... Calc keeps changing the 1st character of a filename in a text cell to upper case. ... the autoformat option in the Format menu is grayed out no matter what I do. ... the autoformat option is the same - grayed out! No-one seems to have answered the question in your Subject header: What happened to autoformat option? The answer is that it is probably alive and well and fulfilling its proper purpose - which is to apply cell formats quickly to a table of cells. It makes no sense for a single cell: that is why it is greyed out. Since it seems to expect column and row headings as well as a line of totals in each direction, a minimum of a three-by-three cell range appears to be appropriate. If you select such a cell range, the AutoFormat menu item will leap into black and white. ... since I usually turn off all autoformatting. That would be AutoCorrection. Oops! My bad. For some reason, I wasn't seeing that option under Tools, and I looked more than once. My only excuse is that it was late in the day. Thanks, Brian. That resolved my problem. Girvin I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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: How to insert a row between current fields?
Alexander Thurgood wrote: Le 31/05/13 02:42, minhsien0330 a écrit : Hi, Dear all: When editing field names in Design View in Libreoffice Base, I cannot insert a new row between current fields. If I click the Insert Rows, Base will add a new row at the end of this table, but not the current site. Does Base not support insert a new field that just like Calc does? Thanks. No. Base is, well, a database program. Calc is...a spreadsheet, not a database program. The two are constructed differently, behave differently and have different code, which is as it should be. However, I would agree with you that if the user is provided a user interface which leads the user to believe that he/she can do such a things as graphically insert a new field definition, then that functionality should actually work. As you have noticed from your attempts, it does not. This is one of the older limitations of Base, that has been around for a very long time. The solution to your problem is to use a SQL command via the Tools SQL menu : http://www.oooforum.org/forum/viewtopic.phtml?t=70021 If this doesn't work in the version of LibreOffice you are using, then this is a bug, because with the post above, it worked in OpenOffice.org back in 2008. Alex The Insert Rows function threw me at first also. Maybe it should be renamed Add row(s) rather than Insert Rows. That should be an easy menu change and much less confusing for the users. Another option may be to display the Base data in a spreadsheet and move the columns around? I use a question mark, since I have never actually tried to do that. Girvin Herr -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO Base/MySQL Backup??
Sajan Steve, Thanks. I will have to look at this as an alternate possibility. I didn't mean to criticize, but I take computer security seriously and when I see a vulnerability, I tend to bring it to the person's attention. There are far too many people out there who take computer security nonchalantly and can be bitten. Girvin Sajan Parikh wrote: I don't see the security issue in mysqldump using a cron. You can throw your password in a mysqldump.cnf file and make it only readable by your user. You can combine that with what Steve said and use a special MySQL user as well. -- *Sajan Parikh* *Web Consultant, Noppix LLC* *Work* - 563.726.0371 *Cell *- 563.447.0822 *Fax* - 563.726.0122 *Email *- sa...@noppix.com On Tue, May 28, 2013 at 4:06 PM, Steve Edmonds steve.edmo...@ptglobal.comwrote: Hi Girvin. For security I created a mysql user 'backup' with read only access for backup. I make the cron script readable by root only -rwxr-x--- 1 root root 586 2012-12-05 16:19 /etc/cron.backup/dailytmp.bu MYSQL_PWD=*** mysqldump -ubackup --all-databases --add-drop-database | gzip -9 /home/bu/mysql.sql.gz Steve On 2013-05-29 06:57, Girvin R. Herr wrote: Sajan, The only problem I see with a cron job is a security issue. I assume you are putting your MySQL password(s) in your cron job script, since mysqldump requires it. I would not recommend doing that. I have a system backup script which I manually run monthly. It does not include the passwords. When that script runs, mysqldump prompts me for the password, I enter it, and off it goes. I might add that I have been using mysqldump for several years and I have not had any problems with it or with retrieving the database data from its backup files. I need to retrieve the backup when I upgrade MySQL, in order to restore my databases in the new version. It works fine, even when I upgraded from MySQL 5.0.67 to 5.5.29. Girvin Herr Sajan Parikh wrote: Someone mentioned mysqldump, this is definitely the way to go. Set it up on a cron and have it dump files to a backup directory. -- *Sajan Parikh* *Web Consultant, Noppix LLC* *Work* - 563.726.0371 *Cell *- 563.447.0822 *Fax* - 563.726.0122 *Email *- sa...@noppix.com On Tue, May 28, 2013 at 11:08 AM, Wolfgang Keller felip...@gmx.net wrote: My question now is - Where does MySQL store the Database and how do I track it down to make a backup?? You'll have to use the MySQL administration tool for that. LO only sees a server running at an IP address listening to a specific port. It has no means to know where the data is. And I still recommend PostgreSQL over MySQL. ;-) Among others, it allows backing up a database while live. Sincerely, Wolfgang -- To unsubscribe e-mail to: users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@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] What happened to autoformat option?
Greetings, I upgraded to LO 3.6.6.2 and just installed it on my HP laptop. However, Calc keeps changing the 1st character of a filename in a text cell to upper case. If I go back and edit it back to lower case, it sticks. However, it is a pain to have to do this every entry and the autoformat option in the Format menu is grayed out no matter what I do. Anyone know the trick to get this option back so I can remove this aggravating formatting permanently? I just checked on my desktop and the autoformat option is the same - grayed out! That is going to be a big hindrance to me, since I usually turn off all autoformatting. Thanks in advance. Girvin Herr -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO Base/MySQL Backup??
Sajan, The only problem I see with a cron job is a security issue. I assume you are putting your MySQL password(s) in your cron job script, since mysqldump requires it. I would not recommend doing that. I have a system backup script which I manually run monthly. It does not include the passwords. When that script runs, mysqldump prompts me for the password, I enter it, and off it goes. I might add that I have been using mysqldump for several years and I have not had any problems with it or with retrieving the database data from its backup files. I need to retrieve the backup when I upgrade MySQL, in order to restore my databases in the new version. It works fine, even when I upgraded from MySQL 5.0.67 to 5.5.29. Girvin Herr Sajan Parikh wrote: Someone mentioned mysqldump, this is definitely the way to go. Set it up on a cron and have it dump files to a backup directory. -- *Sajan Parikh* *Web Consultant, Noppix LLC* *Work* - 563.726.0371 *Cell *- 563.447.0822 *Fax* - 563.726.0122 *Email *- sa...@noppix.com On Tue, May 28, 2013 at 11:08 AM, Wolfgang Keller felip...@gmx.net wrote: My question now is - Where does MySQL store the Database and how do I track it down to make a backup?? You'll have to use the MySQL administration tool for that. LO only sees a server running at an IP address listening to a specific port. It has no means to know where the data is. And I still recommend PostgreSQL over MySQL. ;-) Among others, it allows backing up a database while live. Sincerely, Wolfgang -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] How to unprotect readonly parts of a document?
Alan Stern wrote:
snip
Here's another odd thing I encountered. Moving the cursor one
character at a time (using the right-arrow key), I find what appears to
be two hidden characters: one at the beginning of the readonly field
and one at its end.
That is, start with the cursor just to the left of the blank space
before the (9) field. Pressing right-arrow advances the cursor to
the right of the space, leaving it on the left-hand edge of the '('.
Pressing right-arrow again doesn't move the cursor at all. Pressing it
once more advances the cursor between the '(' and '9'.
Alan Stern
Alan,
Did you try viewing hidden objects?
Check the following:
View - Field Names
View - Nonprinting Characters
View - Hidden Paragraphs
Maybe one of those will make your hidden characters visible and give
you a clue as to what it is doing.
Another more painful option could be to unzip the file and look at the
text to see what is there at these hidden characters, optionally
editing it out manually.
Third, maybe another ODF processor, such as KDE's editor, Kword, may not
support this readonly attribute and allow you to edit it normally.
Hope these suggestions help.
Girvin Herr
--
To unsubscribe e-mail to: users+unsubscr...@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] How to unprotect readonly parts of a document?
Alan Stern wrote:
On Fri, 17 May 2013, Girvin R. Herr wrote:
Alan Stern wrote:
snip
Here's another odd thing I encountered. Moving the cursor one
character at a time (using the right-arrow key), I find what appears to
be two hidden characters: one at the beginning of the readonly field
and one at its end.
That is, start with the cursor just to the left of the blank space
before the (9) field. Pressing right-arrow advances the cursor to
the right of the space, leaving it on the left-hand edge of the '('.
Pressing right-arrow again doesn't move the cursor at all. Pressing it
once more advances the cursor between the '(' and '9'.
Alan Stern
Alan,
Did you try viewing hidden objects?
Check the following:
View - Field Names
View - Nonprinting Characters
View - Hidden Paragraphs
I have tried these. They make no difference.
Maybe one of those will make your hidden characters visible and give
you a clue as to what it is doing.
Nope.
Another more painful option could be to unzip the file and look at the
text to see what is there at these hidden characters, optionally
editing it out manually.
Interesting; I didn't know one could do that. The content.xml file
shows the following (the ... part is where I erased a lot of
irrelevant material; I also wrapped a couple of long lines):
Normal/text:span
text:span text:style-name=T3 /text:span
field:fieldmark-start text:name=__Fieldmark__24_1596095481
field:type=vnd.oasis.opendocument.field.UNHANDLED
field:param field:name=vnd.oasis.opendocument.field.code
field:value= ADDIN EN.CITE lt;EndNotegt; ... /
field:param field:name=vnd.oasis.opendocument.field.id field:value=81/
/field:fieldmark-start
text:span text:style-name=T5(9)/text:span
field:fieldmark-end/
text:span text:style-name=T1 /text:span
text:span text:style-name=T2Normal again.
I don't know enough to interpret all that, but clearly there is a field
of a sort that LibreOffice isn't ready to handle.
Is there some way to get this information from within LibreOffice
itself? I would that the field name and/or value should be accessible.
Third, maybe another ODF processor, such as KDE's editor, Kword, may not
support this readonly attribute and allow you to edit it normally.
Maybe. I don't see where in there the field is marked as readonly.
Alan Stern
Alan,
I am not an expert in decoding the XML for LO. Maybe someone else on
the list can explain that. Even though there is no smoking gun
reference to a readonly attribute, there do seem to be a lot of
numbers in your snippet above that could mean something to LO. On the
other hand, I am not sure what LO would do when it encounters something
it doesn't understand. One option for it is to protect the information
just to be sure, and that could be what you are seeing. I am guessing.
Of course, you could make a test copy of this file and just try changing
suspicious things on the copy and see what LO does. Painful, but
instructive.
Didn't you say this file had been converted from MSWORD? If so, and LO
did the conversion, there may indeed be a bug in the converter that
needs to be brought to the attention of the devs.
Girvin
--
To unsubscribe e-mail to: users+unsubscr...@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] I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API.
Steven Friedrich wrote: I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API. Is this the right place? To save a little time, let me explain my question. I have a Base Form that uses a ListBox based on a SQL query. When a record is updated, I want the ListBox to requery. In Microsoft Access, I just said Requery and I didn't even need to specify the control. How do I get a Form to requery in LibreOffice? Steven, I am not sure I understand your question, so I may be offbase here (no pun intended). What you call requerying sounds like it may be the same as Refreshing in Base Forms. Have you tried the Refresh icon(s)? At the bottom of my forms, just about in the middle of the top toolbar, there are two refresh icons. The left one looks like a rotating arrow and has a Refresh help popup. The icon to the right of that icon looks like a radio button and a rectangle with two rotating arrows, one out of the radio button and one into the button. This icon has a help popup of Refresh Control. Whenever I change a table that a listbox is referring to, that change does not immediately get reflected in my form's listbox entries. I must click on the listbox (not the pulldown list, just highlight the listbox control itself), then click on the Refresh Control icon. Then the listbox should update. Clicking on the Refresh icon will refresh (reload?) the entire database and restart you back to record #1 again, as if you reopened the form. Refresh Control will just refresh the control that is selected. Hope this helps. Girvin Herr -- To unsubscribe e-mail to: users+unsubscr...@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: colour printing bug in Writer?
Steve Edmonds wrote: On 2013-05-13 17:09, Marc Paré wrote: Le 11/05/13 04:17 PM, Steve Edmonds a écrit : On 2013-05-12 07:18, Marc Paré wrote: Le 05/05/13 07:04 PM, Steve Edmonds a écrit : Do you see controls for Landscape? What does it do if you choose it It is some dicky issue with the Brother driver and LO on Linux. I have seen some discussion and it is just as easy to print to PDF and print that. Actually, I also have a Brother printer and the same fix is to choose the correct device drive with through LibreOffice. Print-Properties-Device and choose PostScript Level 3. This fixes the problem. Cheers, Marc Thanks. It does too. But I can't set this permanently. The settings in spadmin won't stick. Steve Yes, Tim and I are not sure if this is a problem with LibreOffice or with our systems. The device sticks until you exit out of LibreOffice. If you open LibreOffice again, you have to change the device again. I wonder if anyone else has this problem where the device defaults to the wrong one and you have to manually change it each time you open a fresh version of LibreOffice. Cheers, Marc Hi. It's a widely discussed issue for some time. Steve I don't know what OS is being used here, but if Linux, then CUPS allows a default printer to be selected. When selected in CUPS, this printer should be the default printer that is highlighted in the LO print dialog. Optionally, printer and printer settings can be changed on a per-document basis by using the File - Printer Settings option in LO. Once that is set and the document saved, all subsequent loading of that document should have the same printer settings as when last saved. Oh, one must also select Tools - Options - Load Save - General and select Load printer settings with the document to enable this behavior. One downside of this is if the document is sent to someone else, it will still try to print on the now-nonexistent printer, or the wrong printer if still on the same LAN. In that case, the settings could be changed or use Ctrl-P to bring up the print dialog and change the printer/settings. I use this feature for printing envelopes repeatedly, which require different printer settings than documents. Works for me. If the save icon is grayed out when you try to save the document printer settings, just add and delete something anywhere in the document and it should be enabled again. Hope this helps. Girvin Herr -- To unsubscribe e-mail to: users+unsubscr...@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 Draw destroys odg files
Alaak wrote: Hi, I drew two graphics using Draw today. I saved them and closed Libreoffice. Now I wanted to open them again, but Libreoffice crashes directly from the splash screen without any additional information. I am still capable of opening other drawings, so it seems something is wrong with those two I created today. My version is: 4.0.2.2 (Build ID: 400m0(Build:2)) Can someone give me a clue how to diagnose this problem? Regards Alaak Alaak, I don't know what Operating Sysytem you are using (I am running Linux/KDE) but I found it helpful in those types of circumstances to bring up LibreOffice from a command prompt (shell/terminal, etc.). From that terminal window, LO may spit out some error/diagnostic messages before it crashes. You may get some idea of where the problem may be from those messages. Good luck. Girvin Herr -- To unsubscribe e-mail to: users+unsubscr...@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] PDF to ODF conversion
Gary, There is a PDF converter built-in to LO. This used to be an extension, but it is now bundled into LO. However, it imports a PDF file into a LO Draw session. Each page of the PDF file becomes a Draw page, much like a viewfoil page in Impress. Draw does allow additional elements to be added to the result, but editing the existing objects in the PDF is not always available. I guess it depends on how the PDF was created with the Adobe tools. There have been long threads of postings on this group regarding how to import a PDF into a Writer document. This is problematic, especially for PDFs with many pages. If you are in Writer and are trying to import a PDF directly, that cannot be accomplished at this time. Your best shot is to import your PDF into Draw, save it as a draw file and then import that Draw file into writer. Yes, it is labor intensive, but more than nothing. I have been somewhat successful at importing a PDF form which needs to be filled out, into Draw, and using the text tool, filling out the form, re-saving it as a PDF and returning it to the sender. I have even scanned my signature and inserted that picture object into the form at the blank signature location. I have not had any complaints from the senders. Hope this helps. Girvin Herr Gary Roach wrote: Hi I'm using Debian testing on Linux with LibreOffice version 3.5.4.2. According to the LibreOffice web site there is a extension that converts PDF to ODF. I can't seem to find it. There is some indication that the capability is built in to versions 3.5 and above but, if it is, I have not been able to fine it. Am I missing something or is there a Debian package problem or what? Any help will be sincerely appreciated Gary R -- 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] Importing PDF problem
David, LibreOffice allows graphics to have placeholders in case rendering such takes a lot of time when scrolling. Maybe yours are turned off. Try Tools - Options - LibreOffice Writer - View Under Display, there should be a checkbox titled Graphics and objects. Make sure this is checked. Hope this helps. Girvin Herr David Ronis wrote: When I open the PDF file and try to export it, all I see are graphics formats (e.g., .bpm, .jpeg, .wfm etc.). I've tried several and they are importable into my document (as a picture), but it seems that only one page was exported, which is more complicated than copying and pasting from each page of the draw object. In the mean time, I've discovered a free conversion site, www.zamzar.com, and they were able to convert the PDF files to odt (with the images as bitmaps. Now here's another strange thing: I can use LO to open the converted file and the document looks as I expect; however, when I insert the file (insert-file) into my larger document, only the text is picked up, leaving blank spaces where the images should go. This sounds like a bug, but perhaps there is some setting that controls this. One other thing: when I open the single/converted pdf-odt document, the navigator shows draw objects and graphics objects as 0. On Sat, 2013-04-06 at 08:36 +0200, Fernand Vanrie wrote: Op 05/04/2013 22:18, David Ronis schreef: I'm currently working on a large project that requires me to import many documents from my colleagues, some in word or PDF formats, into a single file. Libreoffice doesn't work if I try Insert-File... on a PDF file (I get an error popup saying Error rereading the file). I can open the PDF file (in draw) and cut and paste each PDF page into the document, but that is painful. Is there a way to make File-Insert work, perhaps via a macro? it can surly been automated, import the PDF in draw and then export the elements to a writerdoc, you will find a lot of code in the Gimmicks library (gettextsgetdrawstrings) hope it helps Fernand If not, consider this a feature request. David -- 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: Oracle Report Builder - Text field overflow and a N.aN problem
Alex Thurgood wrote: Le 05/04/2013 01:29, Girvin R. Herr a écrit : Hi all, I just checked and the Apache Open Office extensions site is still calling it Oracle Report Builder, version 1.2.1. I also checked my LibreOffice 3.6.4.3 extension (built-in) and it is just called Report Builder version 1.2.3. So, it appears some modification to the ORB 1.2.1 has been made to the LO bundled Report Builder. Maybe I should try it again... The version number was bumped up a notch in LO to avoid conflict with the Apache ORB extension so that users could in theory install both, and also to reflect some name changes in API service implementations within the LO code. The actual ORB code used in LO has not changed significantly as far as I know. Alex Alex, Thanks for saving me from wasting my time. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Oracle Report Builder - Text field overflow and N.aN problem
Noel, I don't think you should have a problem between 3.5 and 3.6 installation. The files, at least on my Linux machine, are in separate directories. LO 3.5 is in libreoffice3.5, LO 3.6 is in libreoffice3.6, and even openoffice 3.x is in openoffice.org3. So, these versions should co-exist on the same computer without conflict. There has been much discussion about this very subject in past postings on this forum. However, the same is not true for your personal configuration (options, etc.). On my Linux machine, the configuration files are in /home/user/.config/libreoffice/3. So, both 3.5 and 3.6 will use the same configuration directory. User-installed extensions seem to be registered in this directory also. So, the bottom line is that you may indeed have to uninstall your ORB extension prior to installing LO 3.6, if only just to ensure a clean start on 3.6. Alternately, you could rename this directory to something else temporarily, such as 3.5. That way, if 3.6 doesn't gain you anything, you can always go back to 3.5 by renaming the directory back to 3 again. (Make sure LO is not running when you do this.) Someone else in this forum may be able to specify exactly when Report Builder was first bundled into LibreOfiice, but I first noticed it around 3.5.3. Hope this helps. Girvin Herr Marion Noel Lodge wrote: Thanks for the replies. I'm away for the next couple of days, so I won't be able to try the suggestions till I get back. I take it that Report Builder is part of the download of LO 3.6.5, (which I tried a while ago but ran into problems that I didn't have time to investigate fully, so I went back to LO 3.5.6.2). If I try LO 3.6.5, should I remove Oracle Report Builder 1.2.1 before installing 3.6.5? I'm running Windows 7 64 Bit. Thanks, Noel -- Noel Lodge lodg...@gmail.com On 5 April 2013 10:54, Girvin R. Herr girvin.h...@sbcglobal.net wrote: Marion Noel Lodge wrote: Sorry about my previous post. Hit the wrong button and sent it prematurely! With Oracle Report Builder it does not seem to be possible to have a text field overflow into the next line and push everything below that down a line. (I'm porting an application from an old Paradox system and this was possible in Paradox reports.) If I make the text box double height in Report Builder, then the second line appears OK, but most of the records don't need a second line and end up being double spaced. Is there any work around for this? What I have tried is to use a macro to check the length of each text string , and if it exceeds 40 characters then I create a second record to contain the excess characters. I've almost got it working as shown below - Date Details ReferenceAmount 01/01/2013 Dick Smith - 3.5mm Plug 14.94, 25 CD 1363649.92 Dr Cases $9.98, Headphones $25.00 N.aN Dr The problem is the N.aN in the amount column. In the Table this field is blank, but Report Builder displays it as N.aN which I understand means 'Not a Number'. I want it to be blank in the Report. I've tried all sort of possibilities in Conditional Print in the General Tab for that field, but nothing seems to work. Has anyone found a solution to this problem? One final question - is there a better alternative to Oracle Report Builder? I am running LibreOffice 3.5.6.2, Oracle Report Builder 1.2.1 and Windows 7 64 Bit Thanks, Noel -- Noel Lodge lodg...@gmail.com I am running LO 3.6.4.3 (Linux) and it has Report Builder version 1.2.3 bundled in. So something has been changed. You might try that upgrade. Note that Oracle Report Builder is a term that Apache Open Office still uses for their report builder extension. However, LibreOffice uses just Report Builder when referring to their bundled report builder extension. So your use of the ORB term is confusing, since theoretically you could install the Oracle Report Builder over top of the LO-bundled Report Builder. You need to inform this forum just which RB you are using. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Exclude page numbers from TOC
Thomas, I can tell you how to remove the page number, but I have no idea how to insert a link in its place. To remove the page number from the TOC: 1. Right click on the TOC with the unwanted page numbers and select the edit option. 2. In the dialog, select the Entries tab at the top. 3. In the Structure line, there is a [ # ] item (for Page number) on the right end. Select this item and press Delete. 4. Click OK. 5. Right click on the TOC again and select Update index/table. 6. The page numbers should disappear. (I say should, because I have never actually needed to do this.) Note that there is a Hyperlink button on the Entries tab which may be what you want. Maybe someone else on this forum can help you with that. Note also, that you may wish to remove the hanging tab [ T ] on the right end now, which would remove the ellipses () on the end of the TOC entry. Hope this helps. Girvin Herr Thomas Blasejewicz wrote: Good morning I am trying (still!) to createsomething for Kindle. Amazon requires to have a Table of Contents with working links, but NO page numbers. I have been reading to the official LO documentation and searched the net, but all I can find is, how to INCLUDE, maybe set, page numbers. So far I was not able to find out the trick required to exclude page numbers. I would appreciate, if someone could point me into the right direction. Thank you, Thomas -- 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] Exclude page numbers from TOC
Virgil, That's weird. I just tried the process on one of my documents with a relatively large TOC and it worked fine. I did notice one thing I failed to mention: The Structure format is not global, it is by TOC level (the list to the left of the Structure line). Make sure you are changing the level that you are using in your TOC. For example, if TOC level 1 is assigned to Heading1 style and you only change that level, the other levels (i.e. Heading2...n) remain unchanged and will still have page numbers. If you are basing your TOC on multiple heading levels or styles, you must do this page number deletion on each one. Maybe that is what happened. Another thing you might try is to verify the change. If you change the level and re-generate the TOC and nothing has changed, then go back into edit and verify the change is still there. If not, then something went wrong with saving/applying the change. If it is still changed, then maybe the level was incorrect or there is something else that is not in sync, such as TOC level to style mapping. I agree with you about the un-intuitiveness of the TOC/Index process. A while back, I wanted an alphabetical index of the Heading style, in other words an alphabetical-sorted TOC, but the TOC function does not allow sorting and the index function, which can sort, did not allow indexing on styles. I had hundreds of entries, so it was impractical to add index marks for each entry. Arrgh! The good thing is that the LO TOC/Index process has and is improving over the years. The OpenOffice 2.x TOC process was much worse than we have now. I am using LO 3.6.4.3 on Linux. Hope this helps. Girvin Herr Virgil Arrington wrote: This wasn't my problem to begin with, but I just tried Girvin's suggestion for fun and it didn't work for me. I deleted both the tab and page number entries. Updating the TOC did nothing. I tried deleting the TOC and starting from scratch, this time not including the dot leader tab or the page number. When I generated the TOC, it gave me both page numbers and dot leaders anyway. I imagine I'm doing something wrong as I generally blame myself before blaming the program. But This is one feature of LO (and OO before it) that I've always despised. There has to be a better, more intuitive way to generate a TOC. I would recommend that the LO developers take a look at Atlantis (www.atlantiswordprocessor.com). It generates TOC's much more easily. I'm still using LO 3.6.5.2 with Win7. Virgil -Original Message- From: Girvin R. Herr Sent: Friday, April 05, 2013 3:06 PM To: Thomas Blasejewicz Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Exclude page numbers from TOC Thomas, I can tell you how to remove the page number, but I have no idea how to insert a link in its place. To remove the page number from the TOC: 1. Right click on the TOC with the unwanted page numbers and select the edit option. 2. In the dialog, select the Entries tab at the top. 3. In the Structure line, there is a [ # ] item (for Page number) on the right end. Select this item and press Delete. 4. Click OK. 5. Right click on the TOC again and select Update index/table. 6. The page numbers should disappear. (I say should, because I have never actually needed to do this.) Note that there is a Hyperlink button on the Entries tab which may be what you want. Maybe someone else on this forum can help you with that. Note also, that you may wish to remove the hanging tab [ T ] on the right end now, which would remove the ellipses () on the end of the TOC entry. Hope this helps. Girvin Herr Thomas Blasejewicz wrote: Good morning I am trying (still!) to createsomething for Kindle. Amazon requires to have a Table of Contents with working links, but NO page numbers. I have been reading to the official LO documentation and searched the net, but all I can find is, how to INCLUDE, maybe set, page numbers. So far I was not able to find out the trick required to exclude page numbers. I would appreciate, if someone could point me into the right direction. Thank you, Thomas -- 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] Oracle Report Builder - Text field overflow and a N.aN problem
Kracked_P_P---webmaster wrote: On 04/04/2013 04:44 AM, Marion Noel Lodge wrote: With Oracle Report Builder it does not seem to be possible to have a text field overflow into the next line and push everything below that down a line. (I'm porting an application from an old Paradox system and this was possible in Paradox reports.) If I make the text box double height in Report Builder, then the second line appears OK, but most of the records don't need a second line and end up being double spaced. Is there any work around for this. What I have tried is to use a macro to check the length of each text string and if it exceeds 40 characters then I create a second record to contain the excess characters. snip -- Noel Lodge lodg...@gmail.com Are you using Oracle Report Builder or the included Report Builder extension? Which version of LO are you using, and which OS and version of Oracle Report Builder are you using? It would be helpful to know these things for the people here that know that type of package inside and out. Are we still using Oracle Report Builder for the extension, or did someone modify it for TDF/LO and changed the name to Report Builder? I know that Report Builder not Oracle. . . is a installed and locked extension that has been a part of LO installs for months now. I just checked and the Apache Open Office extensions site is still calling it Oracle Report Builder, version 1.2.1. I also checked my LibreOffice 3.6.4.3 extension (built-in) and it is just called Report Builder version 1.2.3. So, it appears some modification to the ORB 1.2.1 has been made to the LO bundled Report Builder. Maybe I should try it again... Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Oracle Report Builder - Text field overflow and N.aN problem
Marion Noel Lodge wrote: Sorry about my previous post. Hit the wrong button and sent it prematurely! With Oracle Report Builder it does not seem to be possible to have a text field overflow into the next line and push everything below that down a line. (I'm porting an application from an old Paradox system and this was possible in Paradox reports.) If I make the text box double height in Report Builder, then the second line appears OK, but most of the records don't need a second line and end up being double spaced. Is there any work around for this? What I have tried is to use a macro to check the length of each text string , and if it exceeds 40 characters then I create a second record to contain the excess characters. I've almost got it working as shown below - Date Details ReferenceAmount 01/01/2013 Dick Smith - 3.5mm Plug 14.94, 25 CD 1363649.92 Dr Cases $9.98, Headphones $25.00 N.aN Dr The problem is the N.aN in the amount column. In the Table this field is blank, but Report Builder displays it as N.aN which I understand means 'Not a Number'. I want it to be blank in the Report. I've tried all sort of possibilities in Conditional Print in the General Tab for that field, but nothing seems to work. Has anyone found a solution to this problem? One final question - is there a better alternative to Oracle Report Builder? I am running LibreOffice 3.5.6.2, Oracle Report Builder 1.2.1 and Windows 7 64 Bit Thanks, Noel -- Noel Lodge lodg...@gmail.com I am running LO 3.6.4.3 (Linux) and it has Report Builder version 1.2.3 bundled in. So something has been changed. You might try that upgrade. Note that Oracle Report Builder is a term that Apache Open Office still uses for their report builder extension. However, LibreOffice uses just Report Builder when referring to their bundled report builder extension. So your use of the ORB term is confusing, since theoretically you could install the Oracle Report Builder over top of the LO-bundled Report Builder. You need to inform this forum just which RB you are using. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Inserting an empty string in Base
Dan, You need to specify that NULLs are allowed in _both_ the table edit and the form control edit for that particular field in your database, if you allow Nulls. If you want an empty string instead of a NULL, you should be able to set the default field value to (note the space, a may be interpreted as a NULL by the server). This can be done in either the table edit or the form edit, but one takes precedence over the other. I have never done this, so some experimentation may be in order. Why not use NULLs? I use them all the time when a field is unknown. The only places I do not allow NULLs are the primary and foreign keys and maybe some fields that are in calculated field formulas, such as: price * quantity. Hope this helps. Girvin Herr Dan Lewis wrote: I have a form that requires first name, middle initial, and last name. Some of the people do not have a middle initial. For such people I want the field for the middle initial to contain an empty string. How do I accomplish this? (For this field, I have set the Data property, Set empty string to NULL to No.) --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] Java
I disabled Java (not Javascript) in my Firefox with no apparent consequences. I may also note that Slackware Linux no longer packages Java with their latest release (14.0), as they have done in the past. I read from the S14.0 Changes and Hints.txt file: jre - removed due to licensing issues. (jre is Java Runtime Environment.) Not supplying Java is a sign to me that it is not needed. Slackware has always been strict about bundling Open Source GPL software with their Linux distributions. Girvin Herr Tom Davies wrote: Hi :) I think Dan's point is key. If you don't seem to need it then don't use it. I thik that's a good general rule. A bit like if no-one is in the kitchen then why have the lights on in there? Micheal Meeks was saying that it's still ok to write Extensions in Java but you are not writing Extensions. You are like me, just a normal user. His advice does seem to contradict everything i am hearing about Java at the moment. The devs seem to have put a lot of effort into reducing the amount of Java to the point where most users are unlikely to ever need it. However, Micheal is one of the lead devs and well respected so he is much more likely to really know what is really going on whereas my information is 2nd or 3rd hand and i'm not a dev so i could easily be missing some crucial points. I think maybe i was a bit too harsh about blaming Oracle for all of Java's problems. Maybe it was horribly broken before or that currrent problems were inevitable or maybe reported problems are over-stated. I switched Java off months ago and had no problems so i finally uninstalled it around December and still had no problems. I think that is the best route. Removing Java completely could be troublesome so it's best to have a trial-period of seeing if you can do without it before uninstalling it. You probably wouldn't take the bulb out of the kitchen light just because you didn't think you would go into the kitchen at night. It appears that Homeland Security in the US are recommending people uninstall it but that could be a bogus report and even if not then it seems they may not have considered the implications for normal or corporate users. A couple of machines at my place where Java is still installed grumble when i open Firefox now, roughly since the Homeland Security report apparently. Firefox now offers to update various plugins and things such as Adobe Flash-Player, Adobe Reader(?!) and Java but then tells me it's automatically blocked Java for me anyway. Regards from Tom :) --- On Fri, 22/3/13, anne-ology lagin...@gmail.com wrote: From: anne-ology lagin...@gmail.com Subject: Re: [libreoffice-users] Java To: Dan elderdanle...@gmail.com Cc: users@global.libreoffice.org Date: Friday, 22 March, 2013, 17:56 Well, I guess I don't need it/them since any program I open seems to work fine - except the A-V program every so often pops up stating my system is in-secure due to some items not being up-dated ;-) [I click to see to what they're referring - it's the disabled java - maybe its not completely disabled, huh ;-) ] On Fri, Mar 22, 2013 at 11:25 AM, Dan Lewis elderdanle...@gmail.com wrote: What are you using in LibreOffice that requires Java? Is there something that you would like to use that requires Java? If so, by all means update and enable it. Otherwise don't do anything about it. I have Java enabled because I work with Base much of the time. (It requires Java.) Otherwise, I probably would not need it myself. --Dan On 03/22/2013 11:06 AM, anne-ology wrote: Yikes, now I'm confused; yes, again ;-) I've had java disabled on this machine; but maybe its time to re-enable it - updating it ;-) Tom, do you know more re. java ... or Michael, do you know something more re. this. Eagerly awaiting to hear what to do re. this java; and please remember I don't comprehend computerese ;-) On Fri, Mar 22, 2013 at 8:26 AM, Michael Meeks michael.me...@suse.com wrote: Hi Tom, On Wed, 2013-03-20 at 11:27 +, Tom Davies wrote: Now that Oracle are in charge of developing it Java seems to be increasing as a security risk. You're smoking some good stuff here Tom ;- Oracle are no doubt improving the situation they inherited in Java just fine. Last I heard rumour that RedHat were stepping up to support older versions too. It's a sensible thing to use Java for writing cross-platform LibreOffice extensions. The only problem we have is with writing core functionality in Java - since we can't be sure
Re: [libreoffice-users] Filtered html document
anne-ology wrote: snip I think I belong in a previous generation - where horsepower meant using horses ... where communication meant face to face ... where reading was holding the actual book in a comfortable chair ... ... ... +2 Its not a generation, it is a state of mind. Girvin Herr snip -- 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: Fonts in Report-Writer
Alexander Thurgood wrote: Le 18/03/13 16:04, Heinrich Stoellinger a écrit : Hi Heinrich, After installing LO 4.0 I have the following weird behaviour in Report Writer: While the fonts for page headings as well as group headings are used as specified by me when defining a report, detail lines are printed in (my guess) Times New Roman, except for bold Arial in three fields which contain numbers. Altogether the report contains some 400 lines on 13 pages. I am sorry that all this sounds somewhat funny, but it corresponds to reality. Sounds like a(nother) bug that affects the ReportWriter yet again. Can't remember now if this is already known. Robert might know better than I, I'm taking a back seat with regard to Base at the moment and looking at alternatives to using the provided as-is tools, some of which have already been mentioned on this list. Alex Alex, Is Datavision on your list? http://datavision.sourceforge.net/ I have been using it, but its development is dormant (nothing since mid-2008) and it still has some bugs. What there is of documentation is pretty disorganized and has plenty of gaps. Even so, for me it is much more productive than ORB. I also understand KDE4's Calligra office suite has a database report builder. I am working on upgrading now and when I am done with that, I plan to investigate Calligra's report builder. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] [4.0.1.2/Win/Writer] Printing labels with odd sheets?
Rather than test print on the back of the labels, which could mess up the printer (that's why most printers don't want you to print on partially populated label sheets - the hot fuser could melt the backing coating and gum up the works), I print on a paper page, align it on the back of the label sheet and look at it with the sun (don't look directly at the sun!) or a bright light behind it. I can see if the text is lined up inside the label boundaries by doing that. Girvin Herr Tom Davies wrote: Hi :) Is it easier just to use a table? Each label corresponding to 1 cell. Perhaps rows and columns between printable labels in order to create a margin? The labels editor looks like it has a steep learning curve but might be more effective and elegant in the longer term but you might get quicker results with just a table even if those results are just not so great. Btw i tend to do a test print onto the back of a sheet of labels before daring to print on the front surface. Something always goes a bit wrong and needs tidying. Regards from Tom :) From: Gilles codecompl...@free.fr To: users@global.libreoffice.org Sent: Monday, 18 March 2013, 15:07 Subject: [libreoffice-users] [4.0.1.2/Win/Writer] Printing labels with odd sheets? Hello I bought the following sheets of labels that have some pitches/margins: http://bagofiles.free.fr/libreoffice.labels/microapp.labels.sheet.jpg I tried Writers' File New Labels, and used user-specific settings, but the preview doesn't look like what I expected: http://bagofiles.free.fr/libreoffice.labels/libreoffice.labels.params.jpg http://bagofiles.free.fr/libreoffice.labels/libreoffice.labels.output.jpg Before I ditch the pack and find some labels that have no pitch/margins, has someone successfully printed labels with LO that look like that? Thank you. -- View this message in context: http://nabble.documentfoundation.org/4-0-1-2-Win-Writer-Printing-labels-with-odd-sheets-tp4044517.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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available
Jay Lozier wrote: On 03/13/2013 07:12 PM, Girvin R. Herr wrote: Jay Lozier wrote: On 03/13/2013 02:47 PM, Girvin R. Herr wrote: Dan, That is another issue. It is good that you were able to get MySQL back when you needed it. I think what I read was that Mariadb changed the database itself somehow, making it incompatible with MySQL. Thus, all the work done on it with Mariadb was lost from the last MySQL-compatible database backup. That is scary - lost data. I just went searching again for where I read this caveat and came up with this posting by ppr:kut to LinuxQuestions.org on 1-31-13: I'm not sure what problems you imagine, but I'm not aware of any issues. You wouldn't be able to switch easily from MariaDB back to MySQL once you start using MariaDB specific features, but that's clear from the start. You can find this message and others on: http://www.linuxquestions.org/questions/slackware-14/replace-mysql-with-mariadb-in-slackware-4175447832/ Now that I read it again, it sounds like they might be talking about Mariadb user features, not database compatibility. Kind of like someone who moves from msoffice to LO can't go back because they like the LO features. I would like to know if anyone has tried to go back to MySQL from using Mariadb and how *physically* successful it was. Sorry about the confusion. Girvin Girvin, Dan I once updated from MariaDB 5.5.x to MySQL 5.5.y then to MariaDB 5.5.y. I use MariaDB via localhost and found that the permissions are different. MariaDB default allows apps like MySQL Workbench to do bulk data inserts from files while MySQL does not. With MySQL I had to use the CLI version to do the inserts. I was unable to set the permissions in MySQL to allow MySQL Workbench to do bulk data inserts. I am using Linux Mint Maya / 13. 64 bit. I have not yet tried the MySQL Connector and Base (LO 4.0.0.3). This might be an issue between the two forks. Jay Jay, Thanks for the information. I will file it away for the time I migrate to mariadb. So, let me get this straight - the mariadb server allows the MySQL apps to work better than with the MySQL server?! That is amusing. For the record, I am using Slackware 12.2 32-bit and the mysql-connector-java with LO 3.6.4.3. Thanks again. Girvin I remember seeing (MySQL website?) where the change was made by MySQL to not allow this by default for security reasons while MariaDB maintained the old permissions. What is puzzling to me is that many who use MySQL or MariaDB via localhost are doing development or off-line database work and are not using remote access. I understand requiring tighter permissions if the database can be manipulated remotely to avoid major problems. What was odd, I could issue TRUNCATE database but INSERT LOCAL FILE 'sdf.csv' etc would fail. I would think the opposite would be preferable. I have been noticing how paranoid MySQL has been getting. That paranoia has a place, but for those of us who have local-only databases on a firewalled LAN, it would be nice to ease up on that paranoia and get more functionality. Now I hear that MySQL 5.5+ no longer uses localhost as the older versions did. It virtually takes over localhost bind functionality, all in the name of greater security. Good grief! I will find out soon. I am in the process of upgrading to Slackware 14.0 which comes with MySQL 5.5. 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: [MariaDB Announce] MariaDB 5.5.30 now available
Jay Lozier wrote: On 03/14/2013 02:08 PM, Girvin R. Herr wrote: Jay Lozier wrote: Let's do some snipping here I have been noticing how paranoid MySQL has been getting. That paranoia has a place, but for those of us who have local-only databases on a firewalled LAN, it would be nice to ease up on that paranoia and get more functionality. Now I hear that MySQL 5.5+ no longer uses localhost as the older versions did. It virtually takes over localhost bind functionality, all in the name of greater security. Good grief! I will find out soon. I am in the process of upgrading to Slackware 14.0 which comes with MySQL 5.5. Girvin I base my system upgrades (whichever 'buntu I decide to use) based on the MariaDB releases. I find the MySQL paranoia aggravating. It is almost as if Oracle is trying to break the community edition of MySQL while forgetting there are couple of very good forks available. I am keeping an eye on this. Slackware is very pro open source. There are many software packages that Slackware does not bundle due to the Open Source pedigree being tainted. With MySQL going the way it is, I would not be surprised if some day in the near future, Slackware will change to Mariadb. I generally update when I start having obsolescence problems that would be difficult to resolve. Right now, I am even getting complaints from ebay about my old Firefox, but upgrading it would require major core library changes and I am not willing to do that. Also, my current Slackware, 12.2, is now at the bottom of the security updates list. Soon it will no longer be supported. So, it is time. 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: [MariaDB Announce] MariaDB 5.5.30 now available
Dan, I don't know where I read this warning, in this forum or some other, but there should be a warning to users who convert to Mariadb from MySQL. Yes, they can convert to Mariadb, but they may not be able to go back to MySQL once they used Mariadb on the database. I have not yet made that transition, so I have no direct experience with this and cannot corroborate it. If it is true, then a warning about this should be included with LO documentation referring to using Mariadb. Girvin Herr Dan Lewis wrote: There is development work on a mysql/mariadb connector that Alex discovered requiring some changes in how the connecter is built. When working with the leading edge source code, I had to install MariaDB. Then I was informed that I needed to work with the 4.0 source code. That is when I had to re-install Ubuntu. But after that, I was able to build two mysql-connector-ooo.oxt: x86 for 32 bit AND x86-64 for 64 bit. As soon as I can finish everything within these files, I will upload them to the Extension section of the LO website. The working parts of these files work, but the documentation part is not what it should be yet. --Dan On 03/12/2013 04:16 PM, Tom Davies wrote: Hi :) Thanks Dan. That sounds like a bit of a nightmare. I tend to prefer testing new things on a spare machine or on a spare partition but it's not always possible. Apparently it also doesn't work on Macs although i'm entirely certain how far that goes. For example could Base as a front-end on a Mac read MariaDb as a back-end on a Debian server. Presumably it does but i don't know of anyone that has tried it. Regards from Tom :) *From:* Dan Lewis elderdanle...@gmail.com *To:* users@global.libreoffice.org *Sent:* Tuesday, 12 March 2013, 18:53 *Subject:* Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available But if you should change your mind, you might find it difficult to go back to MySQL. I had to re-install Ubuntu 12.04 LST to remove all of the MariaDB files. Something similar happened when I tried MariaDB a few years ago. --Dan :-( On 03/12/2013 01:46 PM, Tom Davies wrote: Hi :) Just thought a few people here might be interested in the new release of the drop-in replacement for MySql. It's especially good for those wanting to move away from Oracle products. Regards from Tom :) From: MariaDB Announce List annou...@mariadb.org mailto:annou...@mariadb.org To: annou...@mariadb.org mailto:annou...@mariadb.org Sent: Tuesday, 12 March 2013, 16:30 Subject: [MariaDB Announce] MariaDB 5.5.30 now available The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.30. This is a bug-fix release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.30 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5530-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5530-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.30 Overview of MariaDB 5.5: https://kb.askmonty.org/en/what-is-mariadb-55 APT and YUM Repository Configuration Generator: https://downloads.mariadb.org/mariadb/repositories/ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available
Dan, That is another issue. It is good that you were able to get MySQL back when you needed it. I think what I read was that Mariadb changed the database itself somehow, making it incompatible with MySQL. Thus, all the work done on it with Mariadb was lost from the last MySQL-compatible database backup. That is scary - lost data. I just went searching again for where I read this caveat and came up with this posting by ppr:kut to LinuxQuestions.org on 1-31-13: I'm not sure what problems you imagine, but I'm not aware of any issues. You wouldn't be able to switch easily from MariaDB back to MySQL once you start using MariaDB specific features, but that's clear from the start. You can find this message and others on: http://www.linuxquestions.org/questions/slackware-14/replace-mysql-with-mariadb-in-slackware-4175447832/ Now that I read it again, it sounds like they might be talking about Mariadb user features, not database compatibility. Kind of like someone who moves from msoffice to LO can't go back because they like the LO features. I would like to know if anyone has tried to go back to MySQL from using Mariadb and how *physically* successful it was. Sorry about the confusion. Girvin Dan Lewis wrote: I agree. That will go into the chapter on using Base to connect to various data sources. I think that was originally scheduled to be chapter 8 or 9, but I think this chapter should be moved up to chapter 5. Personal experience: I used synaptic to completely remove mariadb including the config files. Then when I tried to reinstall MySQL, synaptic insisted on installing a mariadb file instead of the mysql file. So, I reinstalled Ubuntu 12.04. Now I have MySQL back. --Dan On 03/13/2013 02:08 PM, Girvin R. Herr wrote: Dan, I don't know where I read this warning, in this forum or some other, but there should be a warning to users who convert to Mariadb from MySQL. Yes, they can convert to Mariadb, but they may not be able to go back to MySQL once they used Mariadb on the database. I have not yet made that transition, so I have no direct experience with this and cannot corroborate it. If it is true, then a warning about this should be included with LO documentation referring to using Mariadb. Girvin Herr Dan Lewis wrote: There is development work on a mysql/mariadb connector that Alex discovered requiring some changes in how the connecter is built. When working with the leading edge source code, I had to install MariaDB. Then I was informed that I needed to work with the 4.0 source code. That is when I had to re-install Ubuntu. But after that, I was able to build two mysql-connector-ooo.oxt: x86 for 32 bit AND x86-64 for 64 bit. As soon as I can finish everything within these files, I will upload them to the Extension section of the LO website. The working parts of these files work, but the documentation part is not what it should be yet. --Dan On 03/12/2013 04:16 PM, Tom Davies wrote: Hi :) Thanks Dan. That sounds like a bit of a nightmare. I tend to prefer testing new things on a spare machine or on a spare partition but it's not always possible. Apparently it also doesn't work on Macs although i'm entirely certain how far that goes. For example could Base as a front-end on a Mac read MariaDb as a back-end on a Debian server. Presumably it does but i don't know of anyone that has tried it. Regards from Tom :) *From:* Dan Lewis elderdanle...@gmail.com *To:* users@global.libreoffice.org *Sent:* Tuesday, 12 March 2013, 18:53 *Subject:* Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available But if you should change your mind, you might find it difficult to go back to MySQL. I had to re-install Ubuntu 12.04 LST to remove all of the MariaDB files. Something similar happened when I tried MariaDB a few years ago. --Dan :-( On 03/12/2013 01:46 PM, Tom Davies wrote: Hi :) Just thought a few people here might be interested in the new release of the drop-in replacement for MySql. It's especially good for those wanting to move away from Oracle products. Regards from Tom :) From: MariaDB Announce List annou...@mariadb.org mailto:annou...@mariadb.org To: annou...@mariadb.org mailto:annou...@mariadb.org Sent: Tuesday, 12 March 2013, 16:30 Subject: [MariaDB Announce] MariaDB 5.5.30 now available The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.30. This is a bug-fix release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.30 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5530-release-notes
Re: [libreoffice-users] Re: [MariaDB Announce] MariaDB 5.5.30 now available
Jay Lozier wrote: On 03/13/2013 02:47 PM, Girvin R. Herr wrote: Dan, That is another issue. It is good that you were able to get MySQL back when you needed it. I think what I read was that Mariadb changed the database itself somehow, making it incompatible with MySQL. Thus, all the work done on it with Mariadb was lost from the last MySQL-compatible database backup. That is scary - lost data. I just went searching again for where I read this caveat and came up with this posting by ppr:kut to LinuxQuestions.org on 1-31-13: I'm not sure what problems you imagine, but I'm not aware of any issues. You wouldn't be able to switch easily from MariaDB back to MySQL once you start using MariaDB specific features, but that's clear from the start. You can find this message and others on: http://www.linuxquestions.org/questions/slackware-14/replace-mysql-with-mariadb-in-slackware-4175447832/ Now that I read it again, it sounds like they might be talking about Mariadb user features, not database compatibility. Kind of like someone who moves from msoffice to LO can't go back because they like the LO features. I would like to know if anyone has tried to go back to MySQL from using Mariadb and how *physically* successful it was. Sorry about the confusion. Girvin Girvin, Dan I once updated from MariaDB 5.5.x to MySQL 5.5.y then to MariaDB 5.5.y. I use MariaDB via localhost and found that the permissions are different. MariaDB default allows apps like MySQL Workbench to do bulk data inserts from files while MySQL does not. With MySQL I had to use the CLI version to do the inserts. I was unable to set the permissions in MySQL to allow MySQL Workbench to do bulk data inserts. I am using Linux Mint Maya / 13. 64 bit. I have not yet tried the MySQL Connector and Base (LO 4.0.0.3). This might be an issue between the two forks. Jay Jay, Thanks for the information. I will file it away for the time I migrate to mariadb. So, let me get this straight - the mariadb server allows the MySQL apps to work better than with the MySQL server?! That is amusing. For the record, I am using Slackware 12.2 32-bit and the mysql-connector-java with LO 3.6.4.3. Thanks again. Girvin -- 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] Problem with MySQL after upgrading OpSys
Ian,
You give the versions for LO and MySQL-connector-java, but I don't see
which version of MySQL itself you are using. MySQL made some
configurations changes in the name of security between 5.1 and 5.5,
especially with how localhost is handled. I participated in such a
thread a while back. The mysql configuration file changes differ between
the versions. Make sure you are using the proper configuration for
localhost based on the MySQL version.
Hope this helps.
Girvin Herr
Ian Whitfield wrote:
Hi All
Been busy for a few days with my monthly Journal so had to put this
problem on the 'Back-Burner'.
I have been using Base for a few years now and finally got fed up with
all the crashes and lost data. So late last year - with a LOT of very
appreciated help from the Forum - I managed to get MySQL working 100%
with Base as the front end.
At the beginning of March I upgraded my OpSys to the latest version
(PClinuxOS 2013.02) and my LibreOffice to 4.0.0.3. I tried this first
on a Test Computer I have here and all worked well, including
MySQL!! So I upgraded my main machine.
I have everything working fine _EXCEPT_ for MySQL on this machine!!
(Rather strange that one computer works and the other does not!! Both
have Intel Motherboards and CPUs).
I seem to be at the stage that I can not get phpMyAdmin to run because
of httpd, which I am unable to set to run at boot.
When I try to log in to phpMyAdmin I get the error #1045 Cannot log
in to the MySQL server
I really need to crack this one urgently and I'm hoping Alex,
Gervin, Dan, Heinz or some of our other MySQL/Base Boffins will be
able to help me. As I said previously I posted this problem on the
PCLOS Forum and one guy - YouCanToo - came back to me a few times
but we were not able to crack it and he has no disappeared!!
This is what I did in setting up the system ...
_*INSTALL THE FOLLOWING*_-
*
*MySQL*– Database. /(//now //Installs automatically)/
*
*MyAdmin*- Database Manager. (*'**phpMyAdmin**'*through Synaptic)
*
*MySQL **C**onnector.*- Download
*'**mysql-connector-java-5.1.2**3.tar.gz**' *from the MySQL Download
page,**un-tar it, then inLO go to Options - Advanced. There you
specify the directory into which you put the .jar-file of the
connector in the 'Class Path' under 'Add Archives'.
*
*mysqli Extension *download*'php-mysqli' *via Synaptic.
*_SET-UP STEPS_ ...*
*A **.*Check*my.cnf*file in /etc and comment out the line “skip
networking” by putting a # at the front of it. Thisenables network
(localhost) access.
*B. *Start*MyAdmin **- **(**For **F**irst-**T**ime **U**se**)*- STOP
the MySQL Server in PCC and reset the MySQL root password. Enter the
following lines in your terminal.
1.
Start the mysqld configuration *as SU*.
mysqld --skip-grant-tables
2.
Login to MySQL as root.
mysql -u root mysql
3.
Replace YOURNEWPASSWORD with your new password!
UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE
User='root'; FLUSH PRIVILEGES; exit;
Re-start MyAdmin in the PCC.
*
C. *Start*MyAdmin* as 'root' with your new password. ** *[_THIS IS
WHEN I GET THE ERROR_**]*
Someone mentioned that there are other options to MyAdmin but do not
know about these.
What are your suggestions for me to crack this one please.
Regards
IanW
Pretoria RSA
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [libreoffice-marketing] Java dependencies
Your description is my understanding. I just did a quick look on the download website and I cannot find any such information. Why are these dependencies not prominently spelled out in the System Requirements or somewhere else on the download website page? If they were, then the users would know what is needed for what. You haven't mentioned the age-old need of Java for the Accessibility options. Are these no longer dependent on Java? Girvin Herr Tom Davies wrote: Hi :) It's still Base and some Wizards and some Extensions. Something like 12% of the code is written in Java but it's in those areas that people rarely use. Base can mostly be used without needing Java but only if you use an external back-end rather than the in-built one. I think the Report builder still would need it but Base experts seem to be advising people to avoid that anyway. The internal back-end is HsqlDb which runs on Java even if you use the much more up-to-date version from their website as an external back-end. There are other smaller faster ones for small amounts of data. HsqlDb seems to be the best of those even though it depends on Java. Non-java ones tend to be better for large amounts of data and include Postgresql and MySql / MariaDb. These last 3 seem to be the most frequently recommended by the Base Experts. I've forwarded this to the Users List because there are quite a few Base Experts there that might be able to correct me if i'm wrong or just generally be a bit more helpful than i've been. Regards from Tom :) From: Florian Effenberger flo...@documentfoundation.org To: market...@global.libreoffice.org Sent: Monday, 11 March 2013, 13:59 Subject: [libreoffice-marketing] Java dependencies Hello, I have a journalist's inquiry on Java dependencies in LibreOffice. Anyone can tell the exact components that do not work without Java installed in 4.0? From what I recall, Base and some wizards, but I'm not really up to date here... Thanks, Florian -- Unsubscribe instructions: E-mail to marketing+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/marketing/ 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] LibreOffice 3.6 work with KDE 4.8?
Joel Madero wrote: On Wed, Mar 6, 2013 at 2:27 PM, Girvin R. Herr girvin.h...@sbcglobal.netwrote: Greetings, I am contemplating upgrading my Slackware 12.2 Linux to 14.0. I am currently using LO 3.6.4.3 under KDE 3.5.10. I would like to know if anyone has LO 3.6, especially the standard binary download, working with KDE 4.8+? Thanks in advance. Girvin Herr As far as I know there haven't been any issues particularly against KDE 4.8, also you could check out LibreOffice 4.0.1 that was released today, most people seem very happy with it :-D Best, Joel Joel, Thanks for your response. That's good to know that I don't have to be concerned about LO. As for checking out LO 4.0.1, I am waiting for that zero to go away! When 4.1.5+ is released, I will jump on. I have a rule that I don't install any software that has a version ending in zero. Every time I have violated that rule, I have regretted it. Thanks again. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] LibreOffice 3.6 work with KDE 4.8?
Greetings, I am contemplating upgrading my Slackware 12.2 Linux to 14.0. I am currently using LO 3.6.4.3 under KDE 3.5.10. I would like to know if anyone has LO 3.6, especially the standard binary download, working with KDE 4.8+? Thanks in advance. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] definition of flat/relational database
Wolfgang Keller wrote: I don't know if it will be suitable, but you can try Kexi (part of Calligra suite, I believe; but you can install it separately). I heard it is much better than LO Base, but I don't know enough to verify that statement. Kexi will become usable as soon as it supports composite (natural) keys. It's a pity that Knoda, Rekall etc. have vanished or died without anyone picking up the code behind the original developers, so that Kexi is now the n-th re-implementation of the same functionality. Sincerely, Wolfgang Alas, Rekall is no more. I used the Open Source version before switching to Base and was quite pleased with it, less a few annoying bugs. The Rekall report builder could run rings around the Base Report Builder- especially in speed - but it was quirky to design with it. Before it went dormant, the Open Source Rekall developer made some announcement about moving to another organization (not The Kompany) to continue development of his new ideas. For a few years after that, The Kompany still had the stagnant version of Rekall available for sale from their website. Now today, I see The Kompany is no longer on the net. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] definition of flat/relational database
Dan Lewis wrote: snip I'm still don't understand what the structure of dBase2 is. How can you use two or more tables in a query for example using this database engine? Some light reading required? https://en.wikipedia.org/wiki/DBase File formats: dbase II: http://www.fileformat.info/format/dbf/corion-dbase-ii.htm http://www.clicketyclick.dk/databases/xbase/format/ dbase III: http://www.fileformat.info/format/corion-dbase-iii.htm It has been my experience, and that is from the 90s, so maybe others on this forum with later experience or knowledge can confirm or deny that, that dbase2 or 3 does not use SQL. The wikipedia url above confirms that. dbase does everything with a command file (.CMD) using a dbase Programming Language. Base does not attempt to use the CMD files. It only imports the dbase data from the DBF files. Even so, it has been my experience that trying to import dbase III+ (c. 1990) DBF files into Base does not work. They are too old and Base does not go back that far in DBF file formats. Hope this helps. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Re-Connecting LO Base to an SQL DB
Ian, Just a note: Why do you think you need httpd? Unless you are running a web server (http://www...) on your computer, you should not need httpd installed! I am not running a web server, do not have httpd running, and the computer runs fine without it. Girvin Herr Alex Thurgood wrote: On 02/28/2013 12:25 PM, Ian Whitfield wrote: On the other problem - When I re-installed httpd, which I understand I need, I get the error ... Warning: network-up is needed by httpd in runlevel 4 Any idea what this means and how I get round this?? It means that the apache server is expecting the network interface(s) to be already up and running (with a correct local or IP address) when the httpd service starts. Apparently, that isn't the case with your latest PCLinuxOS version, or else it may come from a race condition caused by the parallelised boot process of init.d scripts. In other words, you will have to find a way to ensure that either the httpd daemon is started after your network interface(s) is/are brought up, or else make sure that your network interface(s) are running very early on in the boot process. This is a problem with PCLinuxOS and has absolutely nothing to do with LibreOffice, or Java, or MySQL. Potentially, your network interface(s) are not being brought up in time during boot because the networking script is set to obtain a DHCP address and this action is not completed when the httpd daemon is started (for whatever reason, that might be, e.g. DNS or hostname resolution problems, dhcpclient bugs, timeouts with the DHCP server, wrong or conflicting static IP address attribution, etc - on other words, a whole host of potential problems totally unrelated to LO, mysql or java). I have a similar problem on one of my Linux Mint machines (fortunately not running an apache server, but a PITA nonetheless), which is linked to the network card not being initialised (internal memory buffers being systematically cleared or some such other trickery), on boot. I am often forced to reinitialise the network interfaces by hand in order to obtain an address from my dhcp server (my ADSL router), as it turns out. Before even attempting to fiddle with any of that, go and ask on the PCLinuxOS forums whether this is a known problem. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Re-Connecting LO Base to an SQL DB
Alex Thurgood wrote: Le 22/02/2013 10:53, Ian Whitfield a écrit : Ian, Well I'm in a real hole here!!! This morning I decided to go back to basics and re-installed all the MySQL packages (in case) Seriously, that was an unnecessary, and potentially, bad move. I have no idea how PCLinuxOS packages mysql server and its dependencies, so maybe you did indeed overwrite everything. I now have the situation that I can not CREATE USER so am unable to set any GRANTS!! When I try I get the error message ERROR 1396 (HY000): Operation CREATE USER failed for 'ianw'@'localhost' Yep, sounds like you have overwritten the permissions table. So is this correct?? Have I now lost my Database?? As I did not back-up the root at all Yes, the mysql data is stored in /var/lib/mysql/data, or sometimes in /var/mysql/data, it DEPENDS on the particular distrib as to where it finally gets put, but usually it is somewhere in a sub-directory of /var. It has been like this for as long as I can remember, and if you had read the mysql manuals like it has been suggested in the past you would know this. If this is so I think it is very poor practice to store data outside the 'home' partition No, it is perfectly reasonable, given that Mysql is a server daemon. Many well behaved Linux daemons (e.g. postfix, mail, printer spool, etc) tend to store their persistent data in /var, their configuration data in /etc, and so on, nothing new there. You can also manually configure the data directory by editing the configuration files, providing you give the mysql server process the appropriate rights, but I think we are a long way from there at the moment. Meanwhile phpMyAdmin will not work for me at all even after a re-install - so as I said I'm in a real hole!! IF I have lost the Database is there a way to make it save it in the 'home' directory in future?? Yes, change the directory in your mysql configuration files. Please read the fine manual before doing this, as changing the config files without knowing what, or being sure of what, you are doing, can make even your current situation worse. Again, reading the official manual really helps one come to terms with how everything fits together. Also, because distribs all tend to do their own thing, read the documentation associated with your Linux distrib's version of mysql. Note that the folder name is /var/lib and not /ver/lib. And yes, you generally require root privileges to be able to read the data in this directory. Alternatively, you can pop in a Live Distro CD/DVD and use that to look through your file system, without having to be root. I apologise for sounding imperious, but there really is no substitute for reading the manuals, or at least a decent mysql administrator's book, when it comes to mysql (or any other database server, for that matter). Alex Ian, Yes, you can do it, but just because you can, doesn't make it right. Storing the database in /home is a _very bad idea_! /home is the least secure location, where, as you found out, the current location in /var/lib won't even allow SU to get into it, but I think that is because you have not configured MySQL correctly yet. You need to go back and follow the initial MySQL setup procedure again, as you did in the past. You did write it down, didn't you? This is also a good example of the consequences of not backing up properly. In a past thread of yours, I am sure I mentioned the use of mysqldump, which creates a human-readable SQL backup of your database. If you had done that regularly, you would have a backup to re-create (restore) your database using the mysql program. Without that backup, I am afraid it looks like you are out of luck. With mysqldump, you can specify where the backup file goes, even /home, if you don't care about security. We learn by experience. Make a backup script, as I have, and run it at least monthly to make the backups easy. _Always_ run that backup before you do any messing with system software updates. I am not sure if Base does this, but some database clients (Rekall, for example) use the database to store the table, form, and report definitions. If that is so with Base, then you may have lost all the work you have done in Base also. Sorry for the bad news. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Re-Connecting LO Base to an SQL DB
Ian, Which version of MySQL are you using? Girvin Herr Ian Whitfield wrote: On 21/02/13 13:21, Alex Thurgood wrote: From the console/command line, try to connect as the user ian that you just created : mysql -u ianw -p Can you connect to mysql as user ianw from the command line ? Yes Alex I can!! [ian@localhost ~]$ mysql -u ianw -p Enter password: Welcome to the MySQL monitor. mysql IanW Pretoria RSA -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MySQL on a network
Luuk wrote: On 17-02-2013 22:53, Girvin R. Herr wrote: Luuk wrote: On 17-02-2013 20:03, Dan Lewis wrote: On 02/17/2013 01:19 PM, Luuk wrote: On 16-02-2013 23:44, Dan Lewis wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in the MySQL manual, or I don't know where to look in it. I use MySQL Workbench for administrative purposes. --Dan Here is the link to the manual: http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_skip-networking Thanks for the link, but I already have it in ePUB format. My problem is trying to determine what the manual means. It is very verbose! --Dan It might be 'skip-networking' in your config (read:my.cnf) means that MySQL will not listen to any network interface. Yuou will still be able to connect to localhost, because its something 'sepecial' http://en.wikipedia.org/wiki/Localhost The public releases of the MySQL database differentiate between localhost and 127.0.0.1. When using localhost from a client program, say a PHP application, then MySQL connects to the database using a Unix domain socket rather than making a direct TCP connection[7][8]. To ensure a TCP connection to the database in IPv4 then use 127.0.0.1. Umm. Are you sure about that? I am not an expert, but it has been my experience that if skip-networking is enabled, then localhost will not work either. As you say, there are two ways to access the server: the network or the Unix socket. The MySQL programs generally use the socket. However, LO Base and, more specifically, the connector driver, use the network interface. When users complain about not being able to connect to MySQL, I suggest commenting out the skip-networking directive and when they do, they are able to connect. That implies that localhost is controlled by skip-networking. localhost may indeed be something special, but I think in this respect, it isn't. If you do an ifconfig while root (Linux), you will see that the lo (loopback) interface, which is 127.0.0.1, is listed along with the hardware LAN Ethernet interface(s). So it is treated at the same level as the Ethernet interface in the IP (Internet Protocol) stack. BTW, the last sentence of the wiki you quote doesn't make sense. Under *nix, the name localhost is defined as 127.0.0.1 (the lo interface) in the /etc/hosts file. Therefor, when localhost is requested, it gets translated to 127.0.0.1 by the computer, not passed on to MySQL as a special case. MySQL should have nothing to do with this translation, so it would never see the name localhost. That said, it seems that the connector driver could make that translation for MySQL. I don't know the interior details of the connector, but It could get the localhost name from Base and then process it. It could make a special case of localhost and vector subsequent requests to the socket. However, as I said, that has not been my experience. Just my 2-cents. Girvin Herr a special adddition to this: on my linux box: opensuse:/home/luuk # mysql -u root -p test -h localhost Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.5.28-log Source distribution . mysql \s -- mysql Ver 14.14 Distrib 5.5.28, for Linux (x86_64) using readline 6.2 .. Server version: 5.5.28-log Source distribution Protocol version: 10 Connection: Localhost via UNIX socket . mysql and: opensuse:/home/luuk # mysql -u root -p test -h 127.0.0.1 Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.5.28-log Source distribution .. mysql \s -- mysql Ver 14.14 Distrib 5.5.28, for Linux (x86_64) using readline 6.2 . Server version: 5.5.28-log Source distribution Protocol version: 10 Connection: 127.0.0.1 via TCP/IP . mysql notice the differences in the 'Connection:'-line. and, of course, i DO have the line: 127.0.0.1 localhost in my /etc/hosts file Luuk, Yes, I stand corrected. I have and was thinking of MySQL 5.0. I now understand that 5.5+ is different. I have already made note of this for future reference. MySQL 5.5 is using a way to circumvent the normal translation. Interesting. Thanks. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MySQL on a network
Luuk wrote: On 17-02-2013 20:03, Dan Lewis wrote: On 02/17/2013 01:19 PM, Luuk wrote: On 16-02-2013 23:44, Dan Lewis wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in the MySQL manual, or I don't know where to look in it. I use MySQL Workbench for administrative purposes. --Dan Here is the link to the manual: http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_skip-networking Thanks for the link, but I already have it in ePUB format. My problem is trying to determine what the manual means. It is very verbose! --Dan It might be 'skip-networking' in your config (read:my.cnf) means that MySQL will not listen to any network interface. Yuou will still be able to connect to localhost, because its something 'sepecial' http://en.wikipedia.org/wiki/Localhost The public releases of the MySQL database differentiate between localhost and 127.0.0.1. When using localhost from a client program, say a PHP application, then MySQL connects to the database using a Unix domain socket rather than making a direct TCP connection[7][8]. To ensure a TCP connection to the database in IPv4 then use 127.0.0.1. Umm. Are you sure about that? I am not an expert, but it has been my experience that if skip-networking is enabled, then localhost will not work either. As you say, there are two ways to access the server: the network or the Unix socket. The MySQL programs generally use the socket. However, LO Base and, more specifically, the connector driver, use the network interface. When users complain about not being able to connect to MySQL, I suggest commenting out the skip-networking directive and when they do, they are able to connect. That implies that localhost is controlled by skip-networking. localhost may indeed be something special, but I think in this respect, it isn't. If you do an ifconfig while root (Linux), you will see that the lo (loopback) interface, which is 127.0.0.1, is listed along with the hardware LAN Ethernet interface(s). So it is treated at the same level as the Ethernet interface in the IP (Internet Protocol) stack. BTW, the last sentence of the wiki you quote doesn't make sense. Under *nix, the name localhost is defined as 127.0.0.1 (the lo interface) in the /etc/hosts file. Therefor, when localhost is requested, it gets translated to 127.0.0.1 by the computer, not passed on to MySQL as a special case. MySQL should have nothing to do with this translation, so it would never see the name localhost. That said, it seems that the connector driver could make that translation for MySQL. I don't know the interior details of the connector, but It could get the localhost name from Base and then process it. It could make a special case of localhost and vector subsequent requests to the socket. However, as I said, that has not been my experience. Just my 2-cents. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MySQL on a network
Dan Lewis wrote: On 02/17/2013 04:53 PM, Girvin R. Herr wrote: snip MySQL server 5.1 has a skip network section. This has been modified in Server 5.5 to this: # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address= 127.0.0.1 The reference in the MySQL Reference Manual ( Access Control, Stage 1: Connection Verification) states what to put in place of 127.0.0.1 for using MySQL over a network. In my case, I can use 192.168.2.% or 192.168.2.0/255.255.255.0. That's interesting. I am using MySQL 5.0.67, so this does not yet apply to me. However, I will have to make note of this for future reference. How did you make out? Did you get your laptop talking to the server? Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MySQL on a network
Dan Lewis wrote: On 02/16/2013 06:44 PM, Heinrich Stoellinger wrote: On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis elderdanle...@gmail.com wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in the MySQL manual, or I don't know where to look in it. I use MySQL Workbench for administrative purposes. --Dan Hi Dan, When you define your MySQL-database under LO-Base, specify the hostname (or the IP-address) of the server as well as the port (usually 3306) instead of localhost. I am actually using a MySQL-server over the internet. It works o.k Regards H More information: My laptop is 192.168.2.101 and the MySQL server is on 192.168.2.100. The database I want to access is Budget. I entered Budget as the database name, Server as 192.168.2.100, port is 3306. I then test the connection, enter the user name and password. The error message I get is Host '192.168.2.101' is not allowed to connect to this MySQL server. I am using the MySQL JDBC driver, and when I click the Test Class button, I get the message The JDBC Driver was loaded successfully. Any suggestions as to what I might be doing wrong? --Dan Sounds like the server is not configured to allow you access. Since the IP addresses for the server and your computer are on the same LAN, I can assume the MySQL server is on another computer on the same LAN. You don't say if you did this in mysql: GRANT ALL PRIVILEGES ON *.* TO username@hostname IDENTIFIED BY `password` WITH GRANT OPTION; Note that the hostname should be the IP address of your laptop, or 192.168.2.101 . Note that the IP address may need around it due to the periods and numbers. If not, the server will not allow you access. The laptop is not registered as a trusted computer. You must have done this for your other computer, but you need to do it for all computers you need access for. Or, if you are brave, you can use % for any host: username@%. Or, better yet, you can limit access to your LAN: username@192.168.2.% For further information, this can be found in the MySQL reference manual under Access Control, Stage 1: Connection Verification. Hope this helps. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] calc: method to subdivide individual cells
Jomali, I once used it to correct a goof on a cell merge operation when it was impractical to use undo. I was only creating a form, so I was not referencing any of these cells. The problem was that the subdivide required a lot of cleanup to get the cell boundaries aligned again. Messy, but better than starting over or using undo. Girvin Herr jomali wrote: I've been following this thread and wondering what a use case would be for subdividing cells. On Thursday, February 14, 2013, Tanstaafl wrote: On 2013-02-14 9:19 AM, Brian Barker b.m.bar...@btinternet.com wrote: At 08:50 14/02/2013 -0500, Nobody Noname wrote: ... but it is much more complicated than if there was the possibility to just subdivide a single cell into multiples... OK: suppose you divide cell Xn into four cells- two vertically and two horizontally. How do you now refer to the four new cells in formulae? Initially, until some method was developed that made sense, it could just be a limitation of split cells that you can't use them in formulas. And maybe it would have to stay that way. None of the times I wanted to be able to do this was it critical that I me able to use them in formulas. And which of the now four separate values gets used if you refer to plain cell Xn in a formula? Pick one (upper left, lower right, etc). Could even be a pref. Or, as above, make it unsupported, unless/until a method is developed for supporting it that makes sense. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/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: LO 4.0: intrinsic database: relations only between primaries keys?
Dan, This is good! It is a good start on an introduction to databases for newbies. It should be put in the Base manual? Girvin Herr Dan Lewis wrote: snip Some basics about creating a database: 1) You begin with data that you want to use for some purpose or purposes. 2) Then you design the database to organize this data so that it will be useful. For example: an address database: In the beginning, the database consists of information such as names, addresses, email address, phone numbers, etc. The first thing you would want to do is to organize this data so that a name is linked to its address, its email address, its phone numbers, etc. Now you have rows of data, each one of them containing information about a single person (a relationship exists between the data for each row). Each of these pieces of information is a field. If you look at these rows, you will see that they also contain some things in common. Several rows can contain data about your friends, others are about your relatives, and others are about companies you do business with. You probably know of other possibilities. So, these rows can be organized into groups based upon what they have in common. (This too is a relationship.) The next thing you should do is to further organize these rows in each one of these groups to make them more useful. You could form a table using these as the column headings: name, address, email address, and phone number. ( Now you have a table for each group of rows. So, if you want data about a particular contact, you can go to the table that contains it. If you want to look at the data for a relative, you go to the table containing all of your relatives. This is basically how a flat database is created. Relational databases begin in the same way. At this point, each of these tables are checked to see whether they are normal or not. For example, a contact is likely to have multiple phone numbers or other possible multiple entries. Each of these have something in common (another relationship). We can remove the field containing multiple entries forming a new table. To keep the relationship between this new table with the original table, we create a primary-foreign key pair (the primary key is for the new table, and the foreign key is added to the original table in place of the fields we removed.) This is what is done to make a table first normal form. There are several levels of a table being normal: first normal form to fourth normal form and beyond. Fourth normal form is considered to be the standard against which a table should be judged. The point being that we do not create tables with their fields and then define the relationship between them. We begin the the fields that we know we will need, combine the fields based upon relationships between data, and combine the fields into tables based upon relationships between the fields. The the tables are normalized up to fourth normal form creating new tables and modifying the old ones. Primary-foreign key pairs are used to define the relationship of the new tables and the modified old table from which the new table came. Hopefully this will help some. --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: LO 4.0: intrinsic database: relations only between primaries keys?
Dan, Chapter 2?? All I have is Chapter 1 - Introducing Base and Chapter 8 - Getting Started with Base. I see there is a draft copy of Chapter 2 and 3 now. I will read them. Thanks. Girvin Herr Dan Lewis wrote: Have you read Chapter 2 of the Base Guide? (Planning/Designing your database) There are 56 pages in which I used this approach for all the parts of a database. There are many questions in it designed to help a person. --Dan https://wiki.documentfoundation.org/Documentation/Publications On 02/14/2013 07:39 PM, Girvin R. Herr wrote: Dan, This is good! It is a good start on an introduction to databases for newbies. It should be put in the Base manual? Girvin Herr Dan Lewis wrote: snip Some basics about creating a database: 1) You begin with data that you want to use for some purpose or purposes. 2) Then you design the database to organize this data so that it will be useful. For example: an address database: In the beginning, the database consists of information such as names, addresses, email address, phone numbers, etc. The first thing you would want to do is to organize this data so that a name is linked to its address, its email address, its phone numbers, etc. Now you have rows of data, each one of them containing information about a single person (a relationship exists between the data for each row). Each of these pieces of information is a field. If you look at these rows, you will see that they also contain some things in common. Several rows can contain data about your friends, others are about your relatives, and others are about companies you do business with. You probably know of other possibilities. So, these rows can be organized into groups based upon what they have in common. (This too is a relationship.) The next thing you should do is to further organize these rows in each one of these groups to make them more useful. You could form a table using these as the column headings: name, address, email address, and phone number. ( Now you have a table for each group of rows. So, if you want data about a particular contact, you can go to the table that contains it. If you want to look at the data for a relative, you go to the table containing all of your relatives. This is basically how a flat database is created. Relational databases begin in the same way. At this point, each of these tables are checked to see whether they are normal or not. For example, a contact is likely to have multiple phone numbers or other possible multiple entries. Each of these have something in common (another relationship). We can remove the field containing multiple entries forming a new table. To keep the relationship between this new table with the original table, we create a primary-foreign key pair (the primary key is for the new table, and the foreign key is added to the original table in place of the fields we removed.) This is what is done to make a table first normal form. There are several levels of a table being normal: first normal form to fourth normal form and beyond. Fourth normal form is considered to be the standard against which a table should be judged. The point being that we do not create tables with their fields and then define the relationship between them. We begin the the fields that we know we will need, combine the fields based upon relationships between data, and combine the fields into tables based upon relationships between the fields. The the tables are normalized up to fourth normal form creating new tables and modifying the old ones. Primary-foreign key pairs are used to define the relationship of the new tables and the modified old table from which the new table came. Hopefully this will help some. --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: Installing the Deb
Jay Lozier wrote: snip Tom I confirm the CLI libreoffice gives the error missing libreoffice-common run sudo apt-get libreoffice-common. This was using LO 4.0 (direct download) and Mint 13 Maya. All the features have beens installed including help-pack and SDK LO 4.0 does run when menu or file is clicked. What is the CLI entry to run LO 4.0 in Linux I think is the question. Jay, Have you tried soffice or unambiguously: /opt/libreofficeversion/program/soffice? soffice is a legacy name from the StarOffice days. Some day, it will be changed, but I am not sure 4.x is it yet. I have not installed 4.x yet, so I am not sure of that. Note that soffice is a script which does a lot of setup. It eventually invokes soffice.bin, which should not be invoked directly from the command line. Hope this helps. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Installing the Deb
Jay Lozier wrote: On 02/09/2013 05:16 PM, Girvin R. Herr wrote: Jay Lozier wrote: snip Tom I confirm the CLI libreoffice gives the error missing libreoffice-common run sudo apt-get libreoffice-common. This was using LO 4.0 (direct download) and Mint 13 Maya. All the features have beens installed including help-pack and SDK LO 4.0 does run when menu or file is clicked. What is the CLI entry to run LO 4.0 in Linux I think is the question. Jay, Have you tried soffice or unambiguously: /opt/libreofficeversion/program/soffice? soffice is a legacy name from the StarOffice days. Some day, it will be changed, but I am not sure 4.x is it yet. I have not installed 4.x yet, so I am not sure of that. Note that soffice is a script which does a lot of setup. It eventually invokes soffice.bin, which should not be invoked directly from the command line. Hope this helps. Girvin Herr I did try soffice but not the full path. soffice did not work and when I tried /opt/libreoffice4.0/program/soffice it worked. Jay, That means you need to add the /opt/libreoffice4.0/program path to your $PATH environment variable. Dan has already mentioned that in this thread. You can try export PATH=/opt/libreoffice4.0/program:$PATH to add it until you log out. However, to permanently add it when you log in, you will need to add the statement to your .bash_profile script in your home directory. This is, of course, if you are using the bash shell. If you are using another shell, then it will be slightly different. Another trick I do so I don't have to keep changing these each time I update, is to create a /opt/bin directory and then create a symlink in that directory which points to the soffice script. That way all I need to change is what the symlink points to when I install a new LO version, leaving /opt/bin unchanged in the $PATH variable. Another advantage to this is that you can have several different symlinks in /opt/bin pointing to different versions of LO or other programs, without changing $PATH. 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] fyi: Java dependance, and others
The last I heard, admittedly many years ago for Access 1.x, MS Access uses the JET database server, which is bundled with Access much like Base uses HSQLDB by default. However, you are correct in that MS makes it difficult to connect the Access front-end to an external database server, but that is their business model. It is a bit for users to grasp. Especially when the Base documentation talks of everything as a database when there are several separate elements involved. The term database, in my opinion, refers to the disk files containing the data. Those files are accessed by the database _Server_, sometimes called the Back-End. Base is one of many _Client_s, sometimes called the _Front End_, that communicate with the server to access data and format it in human-readable form. IMHO, some such explanation should be in the first paragraphs (introduction) of the Base manual, but it is not in the 11/30/11 version I read lately. There is an introduction, but it is not very enlightening for first-time users with little or no database system experience. Continuing to refer to these element names throughout the manual, where applicable, would do much to educate the users instead of using the generic, all-encompassing term database. A block diagram may also be of benefit: Database File(s) - Server [- Driver] - Client - user Where: Database File(s) are the actual data files on the disk. Server is one of MySQL, HSQLDB, POSTGRESQL, JASPER, etc. Driver is an optional interface between the server and client and in the case of MySQL would be mysql-connector-java for example. Client is the front-end, or interface between the user and the server. In this case, Base. You may be forgetting that the Base Oracle Report Builder is known to be Java-based, which is a big chunk of Base in my opinion. Also from the manual, page 5, under What Is Base? - HSQLDB is written in Java. Girvin Herr Tom Davies wrote: Hi :) Some interesting articles and comments on 4.0.0. Not all completely precisely accurate and quite a lot of the comments are clearly either deliberate FUD or hopelessly confused people that need help. There are some gems in there though and i liked this one in ArsTechnica DannyB | Wise, Aged Ars Veteran about 10 hours ago scuttle22 wrote: So now Libre Office depends on Java AND Python. From a Slashdot post that I saw: http://tech.slashdot.org/comments.pl?si ... d=42822061 To be precise, as computed by sloccount, libreoffice-4.0.0.3.tar.xz contains: cpp: 3990644 (87.04%) java: 400958 (8.75%) ansic: 91036 (1.99%) perl: 42456 (0.93%) python: 17392 (0.38%) sh: 17256 (0.38%) yacc: 8228 (0.18%) cs: 6648 (0.15%) asm: 3269 (0.07%) objc: 2602 (0.06%) lex: 2030 (0.04%) awk: 907 (0.02%) pascal: 800 (0.02%) csh: 235 (0.01%) lisp: 115 (0.00%) php: 104 (0.00%) sed: 7 (0.00%) However, as Desler said, the Java bits are actually optional. It seems that a common misunderstanding is that people often seem to think Base is completely dependant on Java and that Base is used by everyone. Neither is really true. Base seems best when connecting to an external back-end and it's much easier to do that with Base than with Access. Base really pushes people into using an external source of data. If you choose a java-based back-end then Base will effectively be using java. If you choose a non-java back-end then it wont [shrugs]. I guess that is really difficult for people to grasp. I guess the misunderstanding arises because Access uses an internal back-end for it's data so people try to force Base to use it's own back-end too instead of doing something sensible. To be fair i am doing exactly that too. Bases internal back-end uses java. Hmmm, i can see myself running into a problem now that i have uninstalled java from all works machines! Time for me to be a bit more sensible and work at migrating the data tables to a decent external back-end. (There are a couple of old posts that should be able to help me so no worries there) So, the main thing i found interesting was the breakdown of different percentages of languages used in LibreOffice. My guess is that non C++ is gradually being replaced by C++ but there's still 12.94% left with most of that being java which is mostly in easily avoidable wizards and Extensions. Regards from Tom :) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] fyi: Java dependance, and others
Tom Davies wrote: Hi :) I was forgetting the Report Builder wizard but i thought it was best to avoid using that anyway? I avoid Oracle Report Builder too! For me, it is a basket case and needs a lot of work. Your division of Back-end into 2 parts; data and server made a lot of sense. Using the word Client instead of Front-end also makes sense and is probably more familiar to a lot of people now anyway as we hear the terms email client rather than email front-end and such. These are the terms that I have always used. However, I have seen the *-end terms used also. But IMHO client - server seems more logical and informative of what they do, than front-end - back-end. Are you offering to review the Base Guide that is in ODFAuthors? or could you email Dan to see what he suggests? There might be some good reason why he has gone a more generic route with the guide and perhaps is saving up the divisions for another chapter or a guide aimed at a different level of users. Well, I could offer suggestions, but I am not the writer, so I could only suggest. As you say, there may be other reasons for the current manual references. However, I have seen postings on this forum from confused novice users, who could have benefited by additional background information on the database system. I realize that with so many possible servers out there, writing a manual section on each one and how it fits into the Base system could be daunting. I have run across many other documents relating to configuring MySQL and Base, but there are all the other servers that could use some documentation regarding how to set them up with Base. That setup documentation is currently lacking in my view. Maybe the recent work of translating the German handbook will correct that. But the users surely need more documentation on connecting to servers other than the bundled default HSQLDB internal server, which does not have a good reputation with some users. In that light, I would also suggest some words to the effect that ...here is the embedded HSQLDB, but if you want a serious database server connection, we recommend using x, y or z. Now here is how you connect them... Documentation on connecting Base to external servers may be at least a chapter in itself, with each server as a separate section in that chapter so the user could go to that section and perform a particular process to connect it. The users should not be required to do all the time-consuming research and study to find how to connect his/her preferred server to Base. I could offer some words on MySQL, but I have no experience with the other servers. I just realized that the scope expands to include processes for the different operating systems that LO and the different servers can run under! That would make writing it even more daunting. I can see now why it has not been attempted to date. But I think it should still be done for the user's and the future of Base's sake. Regards from Tom :) snip Regards, Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Printing Envelopes
webmaster-Kracked_P_P wrote: I use Ubuntu 12.04 and a HP Laserjet 2300dn I have add three different drivers to test out for that printer. Did the same for an Epson inkjet. I have [my text name for description] the following drivers. I do not remember which HP/Linux defaults to for this printer. HP Laserjet 2300 Foomatic Postscript HP Laserjet 2300 hpijs PL3 HP Laserjet 2300 CUPS Gutenprint lsb3.2-v5.27 Each of these show different options in the printing dialogs. Also each seems to have a different quality of printing of the sample test page with text and graphics. I chose the CUPS Gutenprint, since it seems the best print quality and the better print options for this duplexing printer. As for the Envelope, does your printer have an envelope tray? Or do you use the manual tray that centers the paper from letter to postcard widths? I have one HP printer that does not center the envelopes, and it uses an envelope feeder tray that is left justified to the printer face of the page. My Epson also uses a left justified, but the Canon uses the centered. I do think that the pstoraster is the issue though. You need to find a better driver, either a newer one from HP or try the CUPS Gutenprint driver. I have no idea what that pstoraster filter/driver could be. pstoraster or Postscript interpreter for CUPS printing to non-PS printers , is a Postscript to raster, or page bitmap, filter. It is sometimes used on printers that do not respond to Postscript or a similar compositing language such as HP's own printer language, which I cannot remember what its acronym is now. Slackware is RPM, correct? Also is 13.1 the newest? Did the envelope printing work in 12.x or 11.x? No, Slackware is zipped tarball (TGZ). Slackware comes with a filter called rpm2cpio which can be used to extract an RPM file. I use it to extract the LibreOffice binary RPM packages and then re-package them into a TGZ for installation on my Slack 12.2 system. Slack 13.0 up changed from TGZ to TXZ which uses a different zipper algorithm. Slack 14.0 is the newest as of the last time I checked. But I have not installed it because it's version ends in 0. Every time Ubuntu's update manager system downloads and installs a new hplip, CUPS, or other printer file/driver upgrade, I seem to need to delete and reinstall my printers. They never seem to fully work properly after an automatic upgrade download/install. Sometimes I loose the connection to those network printers and it acts like they do not exist. That makes some sense. CUPS probably needs to be updated as to what the new files are and updating CUPS would be self-explanatory. Updating requires printer re-installation. The newer CUPSs goes out and find printers, which worked well for me. However, it only installs one printer at a time, so the find function must be repeated until all the printers are found. At least that is how CUPS 1.3.11 works. SO, long winded statement . . . Please try downloading the newest hplip/driver installer script from the HP/Linux page. http://hplipopensource.com/hplip-web/index.html http://www.openprinting.org/printer/HP/HP-LaserJet_5 Full List of HP printers http://www.openprinting.org/printers/manufacturer/HP/ That's what I suggested. I might add that sometimes searching (i.e. googling) for an error message brings some meaningful hints or places to look for the problem. NOTE: Before I buy a new or re-manufactured printer, I first look for Ubuntu/Debian drivers and how much the ink/toner will cost me. The non-OEM toner for this laser printer costs about $35 shipped when the HP's original one is over $120. Had to look far and wide for the Canon inkjet printer. Canon USA does not support or have Linux drivers, but Canon UK does. The Epson inkjet has a driver in the OpenPrinting.org list[s]. The Canon ink costs $180+ for 2 full sets, while a good non-OEM 2 full sets cost about $35 with shipping included. The Canon uses - Black, Big Black, Gray, Yellow, Magenta, Cyan. The Epson uses - Black, Yellow, Magenta, Light Magenta, Cyan, Light Cyan. So you see it is impo0rtant to find out how much it will cost a person to get the ink/toner. Stick with Postscript and you can't go wrong. It simplifies printing interfaces immensely. Hope this helps. Yours in enlightenment. Girvin Herr On 01/24/2013 10:21 PM, Girvin R. Herr wrote: Rich, I am using CUPS with my HP Laserjet 8150DN and I have no trouble printing #10 envelopes in LO. So, it is possible. pstoraster is a printer driver that converts Postscript to rastor, the printer page. That implies that you are not using the Laserjet's Postscript emulation (missing option?), which would not need the pstoraster conversion. CUPS has several driver options to select from, such as Foomatic, Gutenprint, or in my printer's case, a CUPS driver (HP Laserjet 8150 Series Postscript (en)). You
Re: [libreoffice-users] Printing Envelopes
Rich, I am using CUPS with my HP Laserjet 8150DN and I have no trouble printing #10 envelopes in LO. So, it is possible. pstoraster is a printer driver that converts Postscript to rastor, the printer page. That implies that you are not using the Laserjet's Postscript emulation (missing option?), which would not need the pstoraster conversion. CUPS has several driver options to select from, such as Foomatic, Gutenprint, or in my printer's case, a CUPS driver (HP Laserjet 8150 Series Postscript (en)). You may try adding the same printer as a different name using different drivers to experiment with. I see on my Slackware 12.2 Linux CUPS that there are only Gutenprint or Foomatic drivers for the LJ5. However, HP has produced more then one model 5 over the years, so I am not sure which one you have. Here is a place I go for Linux printer information: http://www.linuxfoundation.org/collaborate/workgroups/openprinting http://www.openprinting.org/printers When I select the HP Laserjet 5, the result says it works perfectly. It also says you should be using the hplip (HP Linux Imaging and Printing) driver. Hope this helps. Girvin Herr Rich Shepard wrote: Running LO-3.5.5.3 on Slackware-13.1. The envelope template was built for a COM10 size envelope in 2003 using whatever version of OO.o was then current. Worked fine then; hasn't since OO.o was supplanted by LO. Time to fix this problem. The page size is set for a COM10 US business envelope. When I try printing it (paper size is commercial 10 and paper orientation is landscape mode), the HP LaserJet 5 sits with nothing to print. When I check the CUPS jobs tab I see this error message: /usr/lib/cups/filter/pstoraster failed. If I print to a disk file I can print the resulting .pdf to a letter size page, but not to an envelope. Any thoughts on this? Rich -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] is MSFT running scared ...
Tom, et. al., Here is another computer system boot issue that should be of concern to free software, especially OS's: http://www.fsf.org/campaigns/campaigns/secure-boot-vs-restricted-boot Sleep tight. Girvin Herr Tom Davies wrote: Hi :) Yes, installing a new Windows alongside an existing one still does over-write the Mbr and hides all previous versions of Windows as well as any other OSes you have. It doesn't matter if the newer version is on a different physical drive or on an external drive or anything else. One trick is to physically unplug the drive with the Mbr you want to save and then install the newer Windows on it's own drive. it will overwrite the Mbr on it's drive but will leave the unplugged drive's Mbr alone. Then when you plug in the old drive then hopefully you can set the bios to boot the old drive first. Of course this means the old drive is unaware of the new install so you'll need to run something like sudo update-grub from you old GnuLinux distro. Regards form Tom :) From: webmaster-Kracked_P_P webmas...@krackedpress.com To: LibreO - Users Global users@global.libreoffice.org Sent: Tuesday, 22 January 2013, 0:39 Subject: Re: [libreoffice-users] is MSFT running scared ... Maybe you should give the URL for the Linux-based boot repair disk [.iso file download]. I do not remember it it. I have two different disk type/names. boot-repair-disk.iso - 355 MB ubuntu-secure-remix-12.10-32-bit.iso - 787 MB ubuntu-secure-remix-12.10-64-bit.iso - 797.1 MB I think I used the boot-repair-disk version since all you had to do was choose your OS version/type you are using. I think I remember correctly that there was only 4 buttons to choose from once the disk/OS booted up. My Dell laptop had 32-bit Vista even though 64-bit Vista was out and working. Too cheap maybe to include it, since it cost us more for the 64-bit version back then. I just upgraded that dual boot laptop 64-bit Win7 professional from 32-bit Vista and 64-bit Ubuntu 12.10 from 12.04 version. Win7/pro killed the dual booting till I ran the repair disk. I tend to use the Ubuntu boot for the testing of the newest version of Ubuntu [10.04 to 10.10 to 11.04 to 11.10 to 12.04 to 12.10] before I upgrade it on my production desktop. I upgraded the Vista to Win7/pro [64-bit] so I can have a working 64-bit Windows OS on one of my systems without going to Win8, since I do not have any touch screens except on my Android 4.0 tablet. Actually, I wonder if Win7 or Win8 would break the dual [or triple] booting a laptop if both boot partitions were running a Windows OS before one was upgraded from XP or Vista to Win7 or Win8? Would Windows break the multi-boot if there would be two+ Windows OSs on the same system but in different boot partitions? Windows 2000 was for business based on Win NT, while Win Millennium was for the home user based on Win98. Millennium was worse than Vista ever was and most users I dealt with switched to Win 2000 till XP [home or professional] came out. Win8 look and feel is a reworking of their failed smart phone OS. They decided that they still liked it and moved it to the Win8 tablet OS. BUT, someone had the bad idea of wanting all of your Windows based systems to look and feel the same. I do not want my production desktop to have the look and feel of my tablet. I hated Unity's look and feel when it came out in the Spring of 2011. Win8 seemed to look and feel the same. I read that a large number of Ubuntu user switched to Mint Linux because of Unity. If MS would have looked at the fallout when Ubuntu went to Unity, maybe they would have thought twice about using a tablet looking OS desktop display for their desktop/laptop OSs. I kept Ubuntu, but switched to MATE for the desktop environment. For my opinion what business users in my area will do with new Win8 systems; not buy them if they can get new Win7 systems or downgrade the new Win8 systems to Win7. Every business user I have talked to locally hates the look of Win8 and do not want to have to pay for the training to get their users to be able to use it. XP/Vista to Win7 was a little change, but XP/Vista/Win7 to Win8 was a real big change that needs a lot of training. TV ads for retail computer stores use to offer free Win8 training so people could learn how to deal with the big changes. Well, those TV ads are all gone, along with most of the Win8 ads [number of ads per day/week] are gone now. Almost all of the MS's tablet are gone now, but there are some major computer companies [like HP] ads about tablet to laptop convertibles though replacing MS's tablet with a keyboard ads.. On 01/21/2013 04:55 PM, Tom Davies wrote: Hi :) There is always 'unexpectedly low' take-up of Windows newest OS when it first gets released. Historically corporate users have learned to leave it until after at least the first Service Pack gets released.
Re: [libreoffice-users] is MSFT running scared ...
Webmaster, Not always true. My HP laptop, admittedly old, has a hard drive that can be removed fairly easily with a screwdriver. The trick is to have a spare drive and mounting frame to install. Girvin Herr webmaster-Kracked_P_P wrote: That unplugging does not work when you deal with a laptop though. snip -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base: Changing restoring (Default) font
Tom, I don't think I am over-complicating it. Here is what I found: In Tools - Options - Writer - Basic fonts, I have Default listed as Liberation Sans, Size 12. (This is correct, for my Writer.) In the example Base form I mentioned, when I have no control selected (edit mode) , the toolbar shows Default, DejaVu Serif, size 12. If I select a control the toolbar options are greyed out and in the control's properties dialog under Font, it lists (Default), and when I click on the [...] button to the right to get the font selection dialog, it first highlights DejaVu Sans, with size of 10. I am assuming that since it is highlighted first, it is what (Default) is set to. These are three different fonts! So, your comment that Base does not have a separate default font does not appear true. Base does not seem to track the Writer Default font as its (Default) font. Keep in mind, this form was created way back with an early version of OpenOffice, probably 2.4, so these font definitions may be embedded in the form file somewhere from then. However, the form's (Default) font should be changeable somewhere, as is Writer's, since it can't seem to be changed in the Base form's style dialog. I just had another idea and looked at the form's character style (no control selected). There is a Default character style, but when I right-click on it, all I get is New, no Modify option. Weird! In the big picture, what I am trying to do is change (Default) to the font I want without changing each and every one of the numerous controls in numerous forms that I have. That will be painful, as I discovered already on one form, which I will have to return to (Default) when I learn the secret of changing the (Default) font. That is why I asked question #2 - how to return a control font to (Default) after is has been changed to something else. Thanks. Girvin Herr Tom Davies wrote: Hi :) Are you over-complicating the default font? Tools - Options - Writer - Basic Fonts should set the defaults for most things. There isn't a different one for Base. Regards from Tom :) *From:* Girvin R. Herr girvin.h...@sbcglobal.net *To:* LibreOffice Users users@global.libreoffice.org *Sent:* Saturday, 12 January 2013, 2:28 *Subject:* [libreoffice-users] Base: Changing restoring (Default) font Greetings, I am running Base in LO 3.6.4.3. In a form, I am trying to change the (Default) font without any progress. I do not know where this (Default) font setting is located and the styles icon on the toolbar, along with the font window on the toolbar are grayed out if I have a control selected. They are not grayed out if I do not have any control selected and then I can change the Default style font to another font. However, when I select a control, the control properties dialog still has (Default) selected and the font displayed in the control is not the font I changed to in the style dialog. Does anyone know where to set the font assigned to the (Default) font? Second, related question: Once the control's font is changed in the control properties dialog to something other than (Default), how does one get it back to (Default)? The (Default) option is not available in the font selection dialog. Thanks in advance. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org mailto: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: Base scenario
Tom, I can't seem to change the direction from the editing (Join Properties) dialog. If the direction needs to be changed, I have been selecting the line by right-clicking on it and selecting the Delete option. I then re-enter the relationship (Join) in the opposite direction as I had explained in my last posting to Dan et al. The type of Join can be changed in the right-click Edit option under the Join Properties dialog. There is a Type list box, which has the Inner, Left, Right, or Cross Join options. Under that list box in the dialog, there is a table labeled Fields involved, with two columns, left and right, corresponding to the left and right join ends. Under that panel, is a hint of sorts, that explains the Join type, the direction, and that warning about the join may not be supported, for all but when Inner is selected in the list box. There is another radio button labeled Natural for a Natural Join augmentation, but I am not familiar with that option. Hope this helps. Girvin Herr Tom Davies wrote: Hi :) So in the editing can you change the direction? or rather the way that the relationships works? Regards from Tom :) *From:* Girvin R. Herr girvin.h...@sbcglobal.net *To:* Tom Davies tomdavie...@yahoo.co.uk *Cc:* Dan Lewis elderdanle...@gmail.com; users@global.libreoffice.org users@global.libreoffice.org *Sent:* Thursday, 10 January 2013, 21:44 *Subject:* Re: [libreoffice-users] Re: Base scenario Tom, Yes. I confirmed that right-clicking on a join line does allow deleting or editing. If I understand you correctly, no, relationship definitions should not be part of the back-end. The table relationship is defined for the back-end by the front-end through the SQL statements. For example, I have a table of suppliers, with names and addresses and other contact information. This table is related to almost all of my database (main) tables. Additionally, each main table has its own set of table relationships with other (sub?) tables, most of which are for selecting options with a join. Each record of these option tables contains a primary key and a text field for the option. For example, I have a table of statuses for the item in the main table record. An integer foreign key in the main table contains a primary key value corresponding to the text element of the statuses table record. That way, I am only storing an integer (key value) in the main table, rather than the option text, and with no repeated option text. It also standardizes the option texts. All of these multiple relationships must be defined by me - ergo it needs to be in the front-end. Hope this helps clarify this. Girvin Herr Tom Davies wrote: Hi :) Can you right-click on a relationship's join-line and edit it's properties? Shouldn't the relationships be part of the back-end rather than defined in the front-end? Regards from Tom :) From: Dan Lewis elderdanle...@gmail.com mailto:elderdanle...@gmail.com To: users@global.libreoffice.org mailto:users@global.libreoffice.org Sent: Wednesday, 9 January 2013, 4:14 Subject: Re: [libreoffice-users] Re: Base scenario Comment inline below. --Dan On 01/08/2013 07:07 PM, Girvin R. Herr wrote: Ian, Have you actually drawn any relationships? Base will not do that for you. Just adding the tables in the 'Relationships Window' will not create the relationships automagically. You must click and hold on the one table element (remote key) and drag over to the related table's element (primary key), then release the mouse button. Base will then draw a line between the two. Note, the order of the drag is important. It determines the type of join. Joins are confusing to me too, so I can't help much there. I had to experiment with the direction to get it to work right. I think it was remote key to primary key, but I am not sure of that any more. Warning! The way the SQL language is set up, if either of the ends of a join (relationship) is NULL, then the record will be discarded and not show up in your result set. No warnings, no errors. Data records will just be missing. IMHO, this is stupid (my mantra is: thou shall not lose data), but that is how the SQL language was set up. So, make sure any joined data elements in all of your table records are not NULL. Note that NULL is not zero (0) and vice-versa! NULL means that there is no data in the record element. I use a lot of remote keys in my database main tables that point to primary keys (options) in other tables. In those other tables, I have made it a point
Re: [libreoffice-users] Re: Base: Action Queries
Tom, One thing that popped out at me is that you used double quotes () around your names. So I checked one of my queries to be sure and confirmed Base is using the single reverse quote ` ( not '). You might try that. The ...unexpected $end... is a clue. It sounds like it is finding an end-of-statement prematurely. On my keyboard, the single reverse quote is the quote under the ~ tilde key, not the single quote under the key. Hope this helps. Girvin Herr Tom Davies wrote: Hi :) Thanks guys :) Ok, so i am starting out with the embedded database against all advice but just so that i can keep emailing it to myself easily until i get to grips with it better. Then i hope to export this table to whatever small back-end seems best. My Sql coding gets rejected Syntax error in SQL expression and then these SQL Status: HY000 Error code: 1000 Syntax error in SQL expression SQL Status: HY000 Error code: 1000 SQL Status: HY000 Error code: 1000 syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE Here's 'my' code INSERT INTO OrgTable (IdOfOrg, IdOfPerson, OrgName) SELECT (IdOfOrg, IdOfPerson, OrgName) FROM zzQuery1 WHERE OrgName IS NOT NULL; Regards from Tom :) From: Alex Thurgood alex.thurg...@gmail.com To: users@global.libreoffice.org Sent: Friday, 11 January 2013, 20:46 Subject: [libreoffice-users] Re: Base: Action Queries Le 11/01/2013 21:28, Tom Davies a écrit : Hi Tom, I've exported a tiny part of the data, and ended up with 2 columns ClientID CompanyName Not all clients have a company name so there are a lot of blanks in the 2nd column. I've written a query to just show the non-blanks (=non-nulls) but now i want to make that into a table in it's own right. Is there an easy way to get a query to create the table for me or should i export as a Csv? This might help http://www.techonthenet.com/sql/insert.php using INSERT ... SELECT Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Base: Changing restoring (Default) font
Greetings, I am running Base in LO 3.6.4.3. In a form, I am trying to change the (Default) font without any progress. I do not know where this (Default) font setting is located and the styles icon on the toolbar, along with the font window on the toolbar are grayed out if I have a control selected. They are not grayed out if I do not have any control selected and then I can change the Default style font to another font. However, when I select a control, the control properties dialog still has (Default) selected and the font displayed in the control is not the font I changed to in the style dialog. Does anyone know where to set the font assigned to the (Default) font? Second, related question: Once the control's font is changed in the control properties dialog to something other than (Default), how does one get it back to (Default)? The (Default) option is not available in the font selection dialog. Thanks in advance. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Base: Setting the default listbox entry
Greetings, I am using LO 3.6.4.3 for Linux. I am trying to set a default entry for a listbox based on a joined table. The listbox has entries from the joined table as options. One of those options is the character: - (dash). I would like this option to be used whenever I do not set the listbox, rather than Base using NULL. I am working in the listbox control's Properties-listbox dialog, Default selection box. If I enter -, it gets changed to 0. If I enter -, it gets changed to -. I don't think either of these are what I want. There is a continuation box ([...]) to the right of the Default selection box, but this icon does not seem to do anything. The key number for the dash entry in the table is 1. So, I tried entering 1 as the default selection, which resulted in 1. I don't think this is what I want either. How do I get the default entry I want in this listbox control? Is it possible? Thanks. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base scenario
Tom, Yes. I confirmed that right-clicking on a join line does allow deleting or editing. If I understand you correctly, no, relationship definitions should not be part of the back-end. The table relationship is defined for the back-end by the front-end through the SQL statements. For example, I have a table of suppliers, with names and addresses and other contact information. This table is related to almost all of my database (main) tables. Additionally, each main table has its own set of table relationships with other (sub?) tables, most of which are for selecting options with a join. Each record of these option tables contains a primary key and a text field for the option. For example, I have a table of statuses for the item in the main table record. An integer foreign key in the main table contains a primary key value corresponding to the text element of the statuses table record. That way, I am only storing an integer (key value) in the main table, rather than the option text, and with no repeated option text. It also standardizes the option texts. All of these multiple relationships must be defined by me - ergo it needs to be in the front-end. Hope this helps clarify this. Girvin Herr Tom Davies wrote: Hi :) Can you right-click on a relationship's join-line and edit it's properties? Shouldn't the relationships be part of the back-end rather than defined in the front-end? Regards from Tom :) From: Dan Lewis elderdanle...@gmail.com To: users@global.libreoffice.org Sent: Wednesday, 9 January 2013, 4:14 Subject: Re: [libreoffice-users] Re: Base scenario Comment inline below. --Dan On 01/08/2013 07:07 PM, Girvin R. Herr wrote: Ian, Have you actually drawn any relationships? Base will not do that for you. Just adding the tables in the 'Relationships Window' will not create the relationships automagically. You must click and hold on the one table element (remote key) and drag over to the related table's element (primary key), then release the mouse button. Base will then draw a line between the two. Note, the order of the drag is important. It determines the type of join. Joins are confusing to me too, so I can't help much there. I had to experiment with the direction to get it to work right. I think it was remote key to primary key, but I am not sure of that any more. Warning! The way the SQL language is set up, if either of the ends of a join (relationship) is NULL, then the record will be discarded and not show up in your result set. No warnings, no errors. Data records will just be missing. IMHO, this is stupid (my mantra is: thou shall not lose data), but that is how the SQL language was set up. So, make sure any joined data elements in all of your table records are not NULL. Note that NULL is not zero (0) and vice-versa! NULL means that there is no data in the record element. I use a lot of remote keys in my database main tables that point to primary keys (options) in other tables. In those other tables, I have made it a point to make the data elements of the first record to be -, which is my equivalent of unknown, just to have something to select that is not NULL. You could probably use a blank ( ), but I prefer seeing the - in forms and reports. Most times in reports, it is hard to see anyway. Seeing the - tells me the field is not NULL. Hope this helps. Girvin Herr These statements about joins do not seem to be quite correct. What you are describing is an Inner Join: you will only see the rows of data in which both the foreign (remote) key and the primary key have a value. Suppose we have two tables A and B and that the foreign (remote) key is in table A and the primary key is in table B. Example 1: table A Left Outer Join table B. The output (result set) for this contains all the fields in table A and their values on the left side of the combined table. The right side contains all the fields in Table B. The rows in which the primary key value matches the foreign key value, data from both table appear in the output. However, where there is no primary key value in table B that matches the foreign key value in table A, all the fields from table B for that row will be NULL. Example 2: table A Right Outer Join table B. The output for this contains all the fields in table B and their values on the right side. For each output row in which the foreign key does not have a value that matches any value of the primary key, the fields in the left side of it will be NULL. Example 3: table A Cross Join table B. This is also referred to as a Cartesian Product. In this case, each row of table A is joined to all the rows of table B. This contains all of the possible combinations of combining both tables. Usually, some rows of the output will have the table A fields all showing NULL while others will have the fields of table B
Re: [libreoffice-users] Re: Base scenario
Dan Lewis wrote: Comment inline below. --Dan On 01/08/2013 07:07 PM, Girvin R. Herr wrote: Ian, Have you actually drawn any relationships? Base will not do that for you. Just adding the tables in the 'Relationships Window' will not create the relationships automagically. You must click and hold on the one table element (remote key) and drag over to the related table's element (primary key), then release the mouse button. Base will then draw a line between the two. Note, the order of the drag is important. It determines the type of join. Joins are confusing to me too, so I can't help much there. I had to experiment with the direction to get it to work right. I think it was remote key to primary key, but I am not sure of that any more. Warning! The way the SQL language is set up, if either of the ends of a join (relationship) is NULL, then the record will be discarded and not show up in your result set. No warnings, no errors. Data records will just be missing. IMHO, this is stupid (my mantra is: thou shall not lose data), but that is how the SQL language was set up. So, make sure any joined data elements in all of your table records are not NULL. Note that NULL is not zero (0) and vice-versa! NULL means that there is no data in the record element. I use a lot of remote keys in my database main tables that point to primary keys (options) in other tables. In those other tables, I have made it a point to make the data elements of the first record to be -, which is my equivalent of unknown, just to have something to select that is not NULL. You could probably use a blank ( ), but I prefer seeing the - in forms and reports. Most times in reports, it is hard to see anyway. Seeing the - tells me the field is not NULL. Hope this helps. Girvin Herr These statements about joins do not seem to be quite correct. What you are describing is an Inner Join: you will only see the rows of data in which both the foreign (remote) key and the primary key have a value. Suppose we have two tables A and B and that the foreign (remote) key is in table A and the primary key is in table B. Example 1: table A Left Outer Join table B. The output (result set) for this contains all the fields in table A and their values on the left side of the combined table. The right side contains all the fields in Table B. The rows in which the primary key value matches the foreign key value, data from both table appear in the output. However, where there is no primary key value in table B that matches the foreign key value in table A, all the fields from table B for that row will be NULL. Example 2: table A Right Outer Join table B. The output for this contains all the fields in table B and their values on the right side. For each output row in which the foreign key does not have a value that matches any value of the primary key, the fields in the left side of it will be NULL. Example 3: table A Cross Join table B. This is also referred to as a Cartesian Product. In this case, each row of table A is joined to all the rows of table B. This contains all of the possible combinations of combining both tables. Usually, some rows of the output will have the table A fields all showing NULL while others will have the fields of table B showing all NULL. Dan, Your and Winston's explanations of joins cleared up a lot of my misunderstanding of them. You can only get so much from books. The fact that my using an Inner Join requires non-null values to get a complete result set makes a lot of sense now. If I now understand correctly, I should be using a Left Outer Join. That way I always get the table A data in the result set, but table B data may be null if there is no match to table A. That is the response I was looking for. I just tried it and it does give me the same result set information (no records missing) as the Inner Join. However, I have no Null values in table A. It may take me a little while to test it with Nulls in the Left (table A) side. I also recant and apologize for my stupid remark about SQL losing data. The reasons for the missing data are now apparent to me and that remark was premature. While I was doing this join editing testing on my sample query, I took time to look at the order of joining in the Query Design window and it looks like in order to get the main table (with foreign key) as table A, I had to first click on the sub table (table B) element and then drag to the table A element. In other words, it needs to be primary key - foreign key. My original response to Ian was not sure of this drag order. In any case, the Join Properties dialog and prompt show the correct order in the Fields Involved window, with table A in the left column and table B in the right column. Thanks for the help. Girvin Herr snip -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http
Re: [libreoffice-users] portable, mobile printers and a more
Tom, If you are interested in printers for Linux computers, here is a site I use to check out printer compatibility: http://www.linuxfoundation.org/collaborate/workgroups/openprinting They list printers and how well a particular printer will work or is implemented under Linux, BSD, etc. and supply drivers, if needed. They once had a chart of printers and listed how well they work. Another option for running printers off 12 volts could be an inverter. They are reasonably cheap at places like Harbor Freight http://www.harborfreight.com/ and others. You can probably find one to power a printer. Beware that some of these inverters may not put out a sine wave, so best to ask both the printer supplier and the inverter supplier about this compatibility issue. If the printer has a switching power supply, it shouldn't be a problem. But if it has a transformer power supply (even some wall-warts) then it could be a problem. Hope this helps. Girvin Herr Tom Davies wrote: Hi :) Does anyone use or know of good portable/mobile printers to carry with you when you have to work-on-the-move? I have already asked at LinuxQuestions but many of my company's outreach workers use Windows. Anyway, here's the LQ thread ... http://www.linuxquestions.org/questions/linux-hardware-18/mobile-printers-4175444990/ We are hoping to prepare a funding application detailing how much it would cost to provide 1 outreach workers with a tablet and a printer and then we can show how much we need for all of them or how many we could make do with. Obviously it takes a long time for funders to respond and even if successful the money takes even longer to arrive so i'm not looking for cheapest one-off deals. I'm looking for reasonably reliable models and manufacturers and then i can look-up how much they cost. I've had a lot of questions about printers generally this year and they always seem to be a pita to look after. So, on LQ i am hoping to start a poll to find which manufacturer people prefer. Unfortunately i can only think of a very few; Hewlett Packard, Cannon, Brother, Oki and Ricoh. I feel like i am missing some very obvious ones. If you can think of any please can you let me know in this thread or at LQ http://www.linuxquestions.org/questions/linux-hardware-18/how-to-set-up-a-poll-here-at-lq-to-see-which-printer-company-people-prefer-4175445008/ Any suggestions? Regards from Tom :) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Base date entry less flexible
Greetings, I noted that after I updated LO from 3.5.7 to 3.6.4, the Base date entry format flexibility has changed. With a 3.5.7 (and before) Base form, I could enter 12-29-12 and it would be changed to 12/29/12. With 3.6.4, entering 12-29-12 will result in a strange date, as if it were interpreting the dashes as a formula and maybe subtracting the numbers. Okay, I could live with that because it was apparent that the date was incorrect. But now I see this is resulting in a Java error when I accidentally use dashes and try to save the record. I get Java.lang.IllegalArgumentException errors. Even that could be worked around, if the error message had any diagnostics, such as the offending date. However, this is all I get. No SQL. No indication as to what the problem really is. I got a clue by doing a web search and found a similar error with dates and put two-and-two together to determine the real cause. I guess my complaint is that between 3.5 and 3.6, the error messages stopped putting diagnostic data into the message. Has anyone else seen this feature? Is there an option somewhere to add the diagnostics to error messages? Note that I tried entering 12-29-12 into a Calc date cell where the format was MM/DD/YY and it kept the dashes. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Exporting Text File to PDF (One Page At A time)
Hal Vaughan wrote: I'm exporting ODT files to PDF, but I want to export only 1 page at a time, so I'm using a BASIC macro to handle this. I've been searching, but since somewhere around 3-4am EST, I have not been able to access oooforum.org and most links lead to there. I can't find examples elsewhere that show me how to export a PDF file from in BASIC or how to specify, again, from BASIC, what pages to export. Can anyone give me links for examples that are not on oooforum.org? Or tell me what classes I would be using for this so I can look them up in the IDL to find out how to specify the page (or pages) to export and how to use the PDF exporter? Thank you. Hal Hal, I just checked on my LO 3.6.4 and discovered there is a way to export only certain page(s). Don't use the button on the toolbar, but use File - Export as PDF. A dialog comes up with Range in the top left corner of the General tab. There, you can select All, Pages, or Selection (if pre-selected). The Pages option allows you to specify which range of pages, or a single page number, you want to be included in the export. This dialog has many other PDF options that the toolbar button does not offer. However, I may have mis-read your problem. If you want to have an automated method of creating a separate file for each page, then this may not help. If your document is long, using this method can be tedious and an automated method would be preferable. Hope this helps. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] where is that configuration file again?
Mirosław Zalewski wrote: On 22/12/2012 at 23:07, Girvin R. Herr girvin.h...@sbcglobal.net wrote: Apparently, I downloaded a pair of PowerPoint files that LO can't handle - they cause LO to pop up the ASCII Filter Options dialog and when I click on OK, LO goes out to lunch. I have encountered similar problem with one certain PowerPoint file. It opened fine on LibreOffice 3.6.4. You may consider upgrade as possible way of solving this issue. That worked! I updated to LO 3.6.4.3 and loaded both powerpoint files without any problems. Thanks to Miroslaw and all who offered me help on this problem. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] where is that configuration file again?
Greetings, I am having problems with importing a powerpoint file, causing LO to hang and crash, and wanted to try renaming the configuration file. However, I can no longer find it. Previous versions had it in my home directory, but it is no longer there. Can someone point me to that help on finding the configuration file for LO 3.5.4? Thanks. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] where is that configuration file again?
Mirosław Zalewski wrote: On 22/12/2012 at 22:36, Girvin R. Herr girvin.h...@sbcglobal.net wrote: Can someone point me to that help on finding the configuration file for LO 3.5.4? It's ~/.config/libreoffice/ (if you are using Linux, which probably you do - but you could mention it in your message). Oops! You are correct in both - sorry. I am running Linux. I found the directory and renamed it, but it didn't solve my problem. Apparently, I downloaded a pair of PowerPoint files that LO can't handle - they cause LO to pop up the ASCII Filter Options dialog and when I click on OK, LO goes out to lunch. Kpresenter can't handle them either. Thanks. Girvin -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] where is that configuration file again?
Tom, Thanks. That was what I was looking for. Renaming the profile didn't help though. I think I found a couple of Powerpoint files that LO can't handle. It is either a first for me, or the files are corrupt. I contacted the source to see if something can be done. Thanks. Girvin Tom Davies wrote: Hi :) https://wiki.documentfoundation.org/Documentation/UserProfile or look in Tools - Options - Paths to see if you moved it somewhere unusual. Regards from Tom :) From: Girvin R. Herr girvin.h...@sbcglobal.net To: LibreOffice Users users@global.libreoffice.org Sent: Saturday, 22 December 2012, 21:36 Subject: [libreoffice-users] where is that configuration file again? Greetings, I am having problems with importing a powerpoint file, causing LO to hang and crash, and wanted to try renaming the configuration file. However, I can no longer find it. Previous versions had it in my home directory, but it is no longer there. Can someone point me to that help on finding the configuration file for LO 3.5.4? Thanks. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Pdf import. Was: Fw: Wiki quick guide page - see if this is a good format. . .
Tom Davies wrote: Hi :) There are many different sorts of Pdfs (fdf and what-not as Amiko says in interviews on Nasa tele). Sometimes forms can be filled out using a proper Pdf reader such as Foxit (a good Pdf reader in Windows) but sometimes people try to make things difficult so that you are forced into using Adobe's Pdf reader, or use a work-around as you did with the frst one in Draw (sounded like a Pita though). Tom, Actually, no. I found it was fairly easy to do in Draw. One company sent me a Pdf form to fill in and then complained that i returned it as a Pdf! It had been a bit ilke a multiple choice in that it had one question per line but instead of the choices it just left the rest of the line empty. I pulled the form into Writer, set it as the background, added a 2 column table on top and adjusted the row's widths to fit the form and then wrote on my layer and saved as Pdf. I was really chuffed because it's the first time i had managed anything like it with Pdfs but then got a complaint! That was their problem, not yours. Sounds like they are in the last century. Unless they wanted the ability to change your entries without your permission. I hope you didn't sign it! How did you pull the PDF form into Writer?! snip Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Pdf import. Was: Fw: Wiki quick guide page - see if this is a good format. . .
Tom Davies wrote: Hi :) I'm not sure what i did. Something fairly hideous. I think i might have used Gimp to make it into a Gif or Png image and then inserted that. I'm kinda flailing around with Pdfs at the moment. Regards from Tom :) Tom, That does sound painful! As a test, I was successful at Inserting a PDF as a Draw OLE object in a Writer document. Here is what I did: 1. Using the PDF importer, I opened the PDF file, which brings up Draw. 2. While in Draw, I saved the PDF file as an ODF Draw file. 3. I opened a new Writer document. 4. Using Insert - Object - OLE Object - LibreOffice 3.5 Drawing, I got a Draw window embedded in the Writer document. 5. Double-click on the Draw object window to bring up the draw OLE. 6. Open the ODF file saved in step #2. 7. Click outside the Draw OLE window (anywhere in the document but the Draw OLE window) to get out of Draw. 8. You should have the PDF image from step #1 now in Writer. Note that the PDF importer does not seem to work if attempting to directly open the PDF file in step #6. It seems to think it is opening the PDF in Writer, not the Draw OLE window. There are many limitations to the Draw OLE that the Draw program itself does not have. You may have to do some scaling or dragging the Draw window tags around to get the size you want. Note that the Object properties dialog has a lot to do with formatting this object (right click on the Draw OLE - select Object). Hope this helps. Girvin Herr From: Girvin R. Herr girvin.h...@sbcglobal.net To: Tom Davies tomdavie...@yahoo.co.uk Cc: Felmon Davis dav...@union.edu; users@global.libreoffice.org users@global.libreoffice.org Sent: Wednesday, 5 December 2012, 23:34 Subject: Re: [libreoffice-users] Re: Pdf import. Was: Fw: Wiki quick guide page - see if this is a good format. . . Tom Davies wrote: Hi :) There are many different sorts of Pdfs (fdf and what-not as Amiko says in interviews on Nasa tele). Sometimes forms can be filled out using a proper Pdf reader such as Foxit (a good Pdf reader in Windows) but sometimes people try to make things difficult so that you are forced into using Adobe's Pdf reader, or use a work-around as you did with the frst one in Draw (sounded like a Pita though). Tom, Actually, no. I found it was fairly easy to do in Draw. One company sent me a Pdf form to fill in and then complained that i returned it as a Pdf! It had been a bit ilke a multiple choice in that it had one question per line but instead of the choices it just left the rest of the line empty. I pulled the form into Writer, set it as the background, added a 2 column table on top and adjusted the row's widths to fit the form and then wrote on my layer and saved as Pdf. I was really chuffed because it's the first time i had managed anything like it with Pdfs but then got a complaint! That was their problem, not yours. Sounds like they are in the last century. Unless they wanted the ability to change your entries without your permission. I hope you didn't sign it! How did you pull the PDF form into Writer?! snip Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Pdf import. Was: Fw: Wiki quick guide page - see if this is a good format. . .
Tom Davies wrote: Hi :) snip Although a lot of programs can now write Pdfs they seldom allow you to edit the text as freely as you would edit an Odt or Doc. They do sometimes allow you to crop and rotate pages and do some fairly rough work like that. snip In the last 6 months or so, I had the task of completing two PDF forms that organizations sent me to fill out. I decided to try the LO PDF import and use LO to fill out the forms. In both cases, PDF import created a Draw file of pages conforming to each page of the PDF file. With the first PDF form, I was not able to modify any text or objects in the form. It was if the original format was a picture. However, I was able to add text boxes over the picture and get the form filled out. With the second PDF form, I was not only able to add text boxes as before, but I was also able to edit the original form text! What was different between the two PDFs? I haven't a clue. So, it looks like PDF file editability in LO Draw depends on the particular PDF you are trying to edit. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
