Re: [libreoffice-users] MS problems
Hi :) Just thought people might like a few equations to see what Wolfgang is driving at As the old (is it really a joke) goes... From http://www.chaosmatrix.org/library/humor/equation.html Knowledge is Power Time is Money and as every engineer knows, Power is Work over Time. So, substituting algebraic equations for these time worn bits of wisdom, we get: 1. K = P 2. T = M 3. P = W/T Now, do a few simple substitutions: Put W/T in for P in equation (1), which yields: 4. K = W/T Put M in for T into equation (4), which yields: 5. K = W/M Now we've got something. Expanding back into English, we get: Knowledge equals Work over Money. What this MEANS is that: a) The More You Know, the More Work You Do, and b) The More You Know, the Less Money You Make. Solving for Money, we get: 6. M = W/K Money equals Work Over Knowledge. From equation (6) we see that Money approaches infinity as Knowledge approaches 0, regardless of the Work done. What THIS MEANS is: The More you Make, the Less you Know. Solving for Work, we get 7. W = M K Work equals Money times Knowledge From equation (7) we see that Work approaches 0 as Knowledge approaches 0. What THIS MEANS is: The stupid rich do little or no work. Nice eh? Even maths 'proves' Wolfgang is correct :) Have a good weekend all! Make sure you get a chance to relax and enjoy :) Regards from Tom :) --- On Wed, 3/10/12, Wolfgang Keller felip...@gmx.net wrote: From: Wolfgang Keller felip...@gmx.net Subject: Re: [libreoffice-users] MS problems To: users@global.libreoffice.org Date: Wednesday, 3 October, 2012, 19:51 A. so in your opinion people - both young and old - not yet knowing anything about computers, perhaps buying their first unit, are - not only IT-illiterate but also morons The point is not whether someone is IT-illiterate or not, but whether (s)he is aware of the limits of his/her IT competence or not. And whether (s)he arrogates to impose his/her decisions onto those people who have to do the actual work despite his/her demonstrated incompetence. B. so you agree that among these IT-illiterate morons (= idiots) are bosses, persons in chief position (managers). It is (unfortunately) indeed an empirical fact that people who are career-competent enough to usurp a management position in a hierarchically structured organisation are *exclusively* career competent. When responsible for their dept's/company's strategic The usage of the word strategy or strategic etc. empirically indicates pretty well the main focus of the author of the corresponding statement - cheaptalk. and operative effectiveness and economical result, these IT-illiterate morons decide about the need of an IT-department -- and employ an IT-manager to that department to take care of the company's IT-system, programs and personnel included. See my other reply concerning the (all too well known and too well documented) antipattern of dedicated IT departments. C. Obviously you qualify yourselves as highly IT-literate -- perhaps even non-morons. I never made any statement like that. But given the level of (not only IT-related) competence that you exhibit through your statements, it doesn't seem to take much to be more competent. Some weeks ago LibO invited people to take part to make LibO better. Would it not be an good idea that you - instead of blaming others - took the opportunity to practice your high quality IT-knowledge to the benefit of LibO. My original message with the ID 20120925175229.00e623b1a418830757ecd...@gmx.net contains a few recommendations for potential conceptual improvements to LO from the perspective of an experienced information worker who has also used something else than MS Office and LO. Sincerely, Wolfgang -- 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] MS problems
I think the market share of MSO has nothing to do with the users being idiots or not. The 90% share is caused by 3 things 1 - When you buy a PC you often get the MSO already pre-installed 2 - Not many people know about alternatives. I only learned about OO and LO from my brother who is a IT wizard. While talking to people about me utilization of LO I am always experiecing that almost all people do not know about OO or LO or other packages. 3 - Many IT departments in companies choose MSO because it is easily available and they consider the support as good. Keep in mind that introduction of an alternative suit requires a lot of testing in an IT department. The suit must be stable and keep productivity high. If my above statements are wrong, then I am happy because I converted from MSO to LO, thus from an idiot to something else... On 2012-10-06 01:12, Wolfgang Keller wrote: If MSO is a 90% market leader all its users cannot be complete idiots. -- 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] name of pdf export
On 2012-10-05 21:15, Brian Barker wrote: At 19:55 05/10/2012 +0900, Nobody Noname wrote: When I export an LO file to pdf, I would like that the original file name is automatically transferred to become the pdf-file name. As I cannot find any information in the LO documentation I ask you to please give me a hint how this can be done. If you mean the PDF file name, this appears to happen normally - though perhaps not invariably. If you mean the PDF file title - which appears at the head of the window in Adobe Reader, for example - go to File | Properties... | Description | Title, and enter your desired title (which can be the same as the file name) there. I often copy the file name from the General tab to the Description tab and edit off the extension. I trust this helps. Brian Barker I mean the file name. But thanks for your comment that utilization of the original file name as the file name for the pdf-file happens normally. This is what I had in mind. But because this did not work anymore, I thought I changed a setting somewhere without intention and started searching... Triggerd by your comment I did a test with a WRITER file and it works again Magic or a bug -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Using photos within a Mail Merge setup??
Le 05/10/2012 23:45, robertjm a écrit : Hi Robert, While I understand how to insert the name and ages text from a Calc spreadsheet, I'm not clear on how to automate the photo insert. Is it as simple as adding a URL link into a cell within Calc (i.e.: John,Smith,c:\files\JohnSmith.jpg) and then add a pointer to that data within the Text document? No that won't work on its own because you're attempting to define a secondary data source (i.e. for the images) by reference to the underlying file system and LO doesn't know how to process that kind of information, which in essence is saying something like : take this character string, consider it to be a file, open the file and parse (stream) its contents so that it gets interpreted and displayed as an image. At the moment, the only way to directly display images from a datasource are through Forms or Reports, and these are not tied into the mailmerge capabilities, otherwise you need a macro to do the lifting work for you. Below are links to information on the subject : http://forum.openoffice.org/en/forum/viewtopic.php?f=7t=31109 http://forum.openoffice.org/en/forum/viewtopic.php?f=7t=33396 http://www.oooforum.org/forum/viewtopic.phtml?t=89804 http://www.oooforum.org/forum/viewtopic.phtml?t=73329 And the following extension, which seems to be almost identical to what you want : http://extensions.services.openoffice.org/fr/project/text2pic As you will no doubt understand after having read the various posts, a request for this functionality, i.e. being able to mailmerge image files and have them display and print properly in a merged document is a feature that has been requested since at least 2003, for OpenOffice.org, and was never implemented. https://issues.apache.org/ooo/show_bug.cgi?id=18651 Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
Am 05.10.2012 14:09, John Clegg wrote: I thought LO was emulating MSO 97?? Read-only is the only sensible way to open other people's files (web downloads, mail attachments). -- 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] MS problems
On 10/06/2012 03:57 AM, Dr. R. O Stapf wrote: I think the market share of MSO has nothing to do with the users being idiots or not. The 90% share is caused by 3 things 1 - When you buy a PC you often get the MSO already pre-installed 2 - Not many people know about alternatives. I only learned about OO and LO from my brother who is a IT wizard. While talking to people about me utilization of LO I am always experiecing that almost all people do not know about OO or LO or other packages. 3 - Many IT departments in companies choose MSO because it is easily available and they consider the support as good. Keep in mind that introduction of an alternative suit requires a lot of testing in an IT department. The suit must be stable and keep productivity high. Some of the IT departments I had to work with convinced me the average tech person in the department knew less about computers in general than I did. Not that I necessarily know that much. I can remember trying to solve a networking problem according to my then employer's IT staff and nothing worked. Eventually, they found that the hardware and software they had specified did work well together. My sarcastic engineering comment was to ask if they had bothered to read both spec sheets; I was working in chemical process engineering then and reading spec sheets was a mandatory practice for us to avoid killing innocent people. Another problem is that it is often easier in many companies to get approval to buy/install from a name brand than from someone who is not a name brand. MS, Apple, Dell, HP, and Intel are name brands and it is presumed safe to buy from them. A superior product may not get installed/bought because of this mindset. In the 70's and 80's the joke was no one got fired for buying IBM even if their product was the worst in the market segment because of the brand image of IBM. If my above statements are wrong, then I am happy because I converted from MSO to LO, thus from an idiot to something else... On 2012-10-06 01:12, Wolfgang Keller wrote: If MSO is a 90% market leader all its users cannot be complete idiots. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
On 10/6/2012 6:13 AM, Andreas Säger wrote: Am 05.10.2012 14:09, John Clegg wrote: I thought LO was emulating MSO 97?? Read-only is the only sensible way to open other people's files (web downloads, mail attachments). Why? What if I want to edit it? Are you outlawing collaborative work? I'm confused. Spencer -- 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] MS problems
On Saturday, October 06, 2012 11:36:38 AM Jay Lozier wrote: On 10/06/2012 03:57 AM, Dr. R. O Stapf wrote: I think the market share of MSO has nothing to do with the users being idiots or not. The 90% share is caused by 3 things 1 - When you buy a PC you often get the MSO already pre-installed 2 - Not many people know about alternatives. I only learned about OO and LO from my brother who is a IT wizard. While talking to people about me utilization of LO I am always experiecing that almost all people do not know about OO or LO or other packages. 3 - Many IT departments in companies choose MSO because it is easily available and they consider the support as good. Keep in mind that introduction of an alternative suit requires a lot of testing in an IT department. The suit must be stable and keep productivity high. Some of the IT departments I had to work with convinced me the average tech person in the department knew less about computers in general than I did. Not that I necessarily know that much. I can remember trying to solve a networking problem according to my then employer's IT staff and nothing worked. Eventually, they found that the hardware and software they had specified did work well together. My sarcastic engineering comment was to ask if they had bothered to read both spec sheets; I was working in chemical process engineering then and reading spec sheets was a mandatory practice for us to avoid killing innocent people. Another problem is that it is often easier in many companies to get approval to buy/install from a name brand than from someone who is not a name brand. MS, Apple, Dell, HP, and Intel are name brands and it is presumed safe to buy from them. A superior product may not get installed/bought because of this mindset. In the 70's and 80's the joke was no one got fired for buying IBM even if their product was the worst in the market segment because of the brand image of IBM. This statement goes back further than that. i remember it in the 60's. There were far superior systems than IBM at that time, but the company bought IBM, mainly because of the above statement. If my above statements are wrong, then I am happy because I converted from MSO to LO, thus from an idiot to something else... On 2012-10-06 01:12, Wolfgang Keller wrote: If MSO is a 90% market leader all its users cannot be complete idiots. -- openSUSE 12.2(Linux 3.4.6-2.10-desktop x86_64)| KDE 4.8.5 release 521|Intel core2duo 2.5 MHZ,|8GB DDR3|GeForce 8400GS(NVIDIA-Linux-x86_64-304.43) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
On 10/06/2012 11:37 AM, Spencer Graves wrote: On 10/6/2012 6:13 AM, Andreas Säger wrote: Am 05.10.2012 14:09, John Clegg wrote: I thought LO was emulating MSO 97?? Read-only is the only sensible way to open other people's files (web downloads, mail attachments). Why? What if I want to edit it? Are you outlawing collaborative work? I'm confused. Spencer Spencer Usually Save As 'will allow you to create an editable version. The issue is security and balancing usefulness and safety. If you are only allowed to open with limited privileges (no macro execution or editing) the possibility of infecting your computer unintentionally with malware is lessened considerably. This gives the users a chance to verify before granting full privileges on their computers. Having cleaned serious malware infections on friends and coworkers computers; the inconvenience is worth the protection. It is not perfect but puts another step in the way of disaster. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
Whilst a condom is always wise I still prefer to put it on for myself On 6 October 2012 18:13, Jay Lozier jsloz...@gmail.com wrote: On 10/06/2012 11:37 AM, Spencer Graves wrote: On 10/6/2012 6:13 AM, Andreas Säger wrote: Am 05.10.2012 14:09, John Clegg wrote: I thought LO was emulating MSO 97?? Read-only is the only sensible way to open other people's files (web downloads, mail attachments). Why? What if I want to edit it? Are you outlawing collaborative work? I'm confused. Spencer Spencer Usually Save As 'will allow you to create an editable version. The issue is security and balancing usefulness and safety. If you are only allowed to open with limited privileges (no macro execution or editing) the possibility of infecting your computer unintentionally with malware is lessened considerably. This gives the users a chance to verify before granting full privileges on their computers. Having cleaned serious malware infections on friends and coworkers computers; the inconvenience is worth the protection. It is not perfect but puts another step in the way of disaster. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
On Sat, 6 Oct 2012, Jay Lozier wrote: On 10/06/2012 11:37 AM, Spencer Graves wrote: On 10/6/2012 6:13 AM, Andreas Säger wrote: Am 05.10.2012 14:09, John Clegg wrote: I thought LO was emulating MSO 97?? Read-only is the only sensible way to open other people's files (web downloads, mail attachments). Why? What if I want to edit it? Are you outlawing collaborative work? I'm confused. Spencer Spencer Usually Save As 'will allow you to create an editable version. The issue is security and balancing usefulness and safety. If you are only allowed to open with limited privileges (no macro execution or editing) the possibility of infecting your computer unintentionally with malware is lessened considerably. This gives the users a chance to verify before granting full privileges on their computers. Having cleaned serious malware infections on friends and coworkers computers; the inconvenience is worth the protection. It is not perfect but puts another step in the way of disaster. I am still not sure how one gets an infection from saving a file as writable. on a Linux system it's not executable, not sure how it works on Windows. how would infection occur? (if you download an .exe file in Windows, it wouldn't matter if it's writable, right?) F. -- Felmon Davis A good word costs no more than a bad one. -- B. Googe -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
On 06/10/2012 at 19:27, Felmon Davis dav...@union.edu wrote: I am still not sure how one gets an infection from saving a file as writable. on a Linux system it's not executable, not sure how it works on Windows. how would infection occur? It's rather that in read-only mode, office suite will not run any macros attached to document, despite macro security configuration. -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
Am 06.10.2012 19:16, John Clegg wrote: Whilst a condom is always wise I still prefer to put it on for myself If you prefer to not choose anything, the other side will take her own precautions. -- Your mail/cloud client creates a *temporary file for viewing* unless you explicitly *downloaded* your own copy of the document. You can never be sure about the life time, location or file name of a temporary file. Your modification on a temporary file will be all lost on restart. If you want an editable file you need to download your own copy to a location and file name of your choice. -- Any other application which allows me to edit a document loaded from a read-only file will not allow me to save the modified document to the same file. It will force me to choose another path-name to store my modifications. -- The application which displays the document loaded from a read-only file is not the application which is responsible for the read-only status of that file. -- LibreOffice never ever modifies the read-write status of any file on your entire file system. It has no means to do such things. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
On Sat, 6 Oct 2012, Mirosław Zalewski wrote: On 06/10/2012 at 19:27, Felmon Davis dav...@union.edu wrote: I am still not sure how one gets an infection from saving a file as writable. on a Linux system it's not executable, not sure how it works on Windows. how would infection occur? It's rather that in read-only mode, office suite will not run any macros attached to document, despite macro security configuration. thank you for the clear and illuminating answer. F. -- Felmon Davis He is such a steady worker that he is really motionless. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
Am 06.10.2012 19:59, Felmon Davis wrote: On Sat, 6 Oct 2012, Mirosław Zalewski wrote: On 06/10/2012 at 19:27, Felmon Davis dav...@union.edu wrote: I am still not sure how one gets an infection from saving a file as writable. on a Linux system it's not executable, not sure how it works on Windows. how would infection occur? It's rather that in read-only mode, office suite will not run any macros attached to document, despite macro security configuration. thank you for the clear and illuminating answer. F. ... which is plain wrong like so many answers on this particular list. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead
On 10/06/2012 01:27 PM, Felmon Davis wrote: On Sat, 6 Oct 2012, Jay Lozier wrote: On 10/06/2012 11:37 AM, Spencer Graves wrote: On 10/6/2012 6:13 AM, Andreas Säger wrote: Am 05.10.2012 14:09, John Clegg wrote: I thought LO was emulating MSO 97?? Read-only is the only sensible way to open other people's files (web downloads, mail attachments). Why? What if I want to edit it? Are you outlawing collaborative work? I'm confused. Spencer Spencer Usually Save As 'will allow you to create an editable version. The issue is security and balancing usefulness and safety. If you are only allowed to open with limited privileges (no macro execution or editing) the possibility of infecting your computer unintentionally with malware is lessened considerably. This gives the users a chance to verify before granting full privileges on their computers. Having cleaned serious malware infections on friends and coworkers computers; the inconvenience is worth the protection. It is not perfect but puts another step in the way of disaster. I am still not sure how one gets an infection from saving a file as writable. on a Linux system it's not executable, not sure how it works on Windows. how would infection occur? VBS macros in MSO documents have been used to infect Windows computers. The issue is what is good practice regardless of the OS. If you follow good practices, the possibility of problems is significantly reduced. (if you download an .exe file in Windows, it wouldn't matter if it's writable, right?) F. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MS problems
I think the market share of MSO has nothing to do with the users being idiots or not. The 90% share is caused by 3 things *snip* 2 - Not many people know about alternatives. That's what I call ignorance. Ignorance plus unwillingness to inform oneself to remedy that ignorance equals idiocy. I don't have anything against idiots, as long as they don't impose their idiocy onto me. 3 - Many IT departments in companies choose MSO because it is easily available and they consider the support as good. IT departments, just like managers choose (in fact, they don't choose at all) MS because it's not them who have to do the actual work, so they can't have a clue. And because they're too lazy and ignorant to get some input from the information workers who have to do the actual work. Keep in mind that introduction of an alternative suit requires a lot of testing in an IT department. The suit must be stable and keep productivity high. With MS products, user productivity will be minimised compared to all available alternatives. Sincerely, Wolfgang -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: documentation for LO base
Am 06.10.2012 21:34, Wolfgang Keller wrote: Huh? Access is a pathological data shredder. Not as bad as Base's default type of database. This part of Base is not even a valid proof-of-concept. The whole concept is dysfunctional by design and nobody dares to stop this madness. Just like MSAccess, Base is extremely useful as a frontend for database engines. You must not use the built-in JET engine with Access. HSQL is an excellent platform independent database engine but you must not embed HSQL in extensions which are installed and repackaged every time you open or close the so called database document. -- 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] using \t in regular expression replace
Hi all, I was trying to use \t to replace e.g a paragraph ending with a tab. So find $ replace with \t That does not work. Nor in combination with ^ or \n (one has to try something ;-) ) I can replace e.a. an character with a tab though. This is the same in 3.3.4, 3.4.6, 3.5.7, 3.6.2.2 (Testing on Ubuntu/Linux). So prolly I try something that can't be done (not directly anyway) or something that should be done in a different way? thanks for replies, Cheers, -- - Cor - http://nl.libreoffice.org - www.librelex.org -- 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] MS problems
On 10/06/2012 03:11 PM, Wolfgang Keller wrote: So, until LO and/or LO and/or Symphony--my first choice-- can *really* read MS documents, I will have to use a Windows program. Which I really don't mind, except that I have to move the files and boot another OS. See www.winehq.org. On an *operating* system that actually deserves that designation, it runs Windows applications better than Windows itself. I.e. with far less cursor animation syndrome. Sincerely, Wolfgang I think I tried to install WP on Wine once, but I'll try it again. Let's see what happens. I'll report back--doug -- Blessed are the peacekeepers...for they shall be shot at from both sides. --A.M. Greeley -- 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] using \t in regular expression replace
Hi :) Is \t reserved for something in LO or in your OS? Can you replace $ with ? If that works can you replace with \t? Also can you try doing those replacements in a normal text-editor to try to pin it down to either the OS or LO? Regards from Tom :) --- On Sat, 6/10/12, Cor Nouws oo...@nouenoff.nl wrote: From: Cor Nouws oo...@nouenoff.nl Subject: [libreoffice-users] using \t in regular expression replace To: users@global.libreoffice.org Date: Saturday, 6 October, 2012, 22:09 Hi all, I was trying to use \t to replace e.g a paragraph ending with a tab. So find $ replace with \t That does not work. Nor in combination with ^ or \n (one has to try something ;-) ) I can replace e.a. an character with a tab though. This is the same in 3.3.4, 3.4.6, 3.5.7, 3.6.2.2 (Testing on Ubuntu/Linux). So prolly I try something that can't be done (not directly anyway) or something that should be done in a different way? thanks for replies, Cheers, -- - Cor - http://nl.libreoffice.org - www.librelex.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Using photos within a Mail Merge setup??
Thanks Alex!!I think this will do the trick nicely. Unfortunately, it looks
like I can't access my images by way of the Google Drive folder I have them
stored in. However, when I tried using a generic picture over at the
National Geographic website, it loaded just fine.Now I just have to come up
with a proper Badge formatted .odt file so the pictures fall where they need
to fall!!For anyone looking to resolve this, here is a detailed outline of
what I did to accomplish what I wanted:I - Create document with final layout
A: LibreOffice Text document format (.odt)II - Create spreadsheet with
information to be merged (.ods) A: Create column headers in first row B:
Anny photographs need to be {{FILENAME}}III - Create databae from
spreadsheet information (.odb) A: Connect to existing database B: Select
Spreadsheet C: Make sure to select YES to register the database D: Save
databaseE: Confirm info has been added to database i:
Click on Tables ii:
Double-Click on SheetIV - Open layout document (.odt) A: Select View --
Data Sources (shortcut: f4) B: Choose database created in Step III C:
Select Tables D: Select Sheet1 (database records will appear to immediate
right of data sources E: Drag column header to place in layout document
(.odt) where you want it inserted G: Save layout document after inserting
remaining column headersV - Create a merged documentA: Select File --
Print A: Select YES when asked if you want to print as a Form Letter B:
Select Output into a File C: Select Save as Single Document D: Save
merged
documenti: Use different name so you don't overwrite original
ii: Can
change to .pdf format if not inserting any photographsVI - Insert
photographs into document A: Open newly saved document (.odt) B:
Select
Tools -- Extension Manager -- Text2pic i: If Text2pic
extension is
not installed, download it from:
http://extensions.services.openoffice.org/fr/project/text2pic C: Select
Options i: Set Root folder or URL to root folder of where
images are
stored a: If set to blank, image column entries needs to be
the full path
in spreadsheet ii: Set front and back delimeter to what was used in
spreadsheet iii: Checkmark Resize inserted images
a: Select proper
Resize Mode b: Set height and/or width parameters
iv: Click on Default
Picturea: Select image to display for broken photo
links D: Click OK E:
Click CLOSE F: Select Tools -- Add-Ons -- Convert Text to Picture
G:
Save merged documenti: Use different name so you don't overwrite
originalHOPE THAT HELPS SOMEONE
Alexander Thurgood wrote
...No that won't work on its own because you're attempting to define
asecondary data source (i.e. for the images) by reference to
theunderlying file system and LO doesn't know how to process that kind
ofinformation, which in essence is saying something like : take
thischaracter string, consider it to be a file, open the file and
parse(stream) its contents so that it gets interpreted and displayed as
animage.At the moment, the only way to directly display images from a
datasourceare through Forms or Reports, and these are not tied into the
mailmergecapabilities, otherwise you need a macro to do the lifting work
for you..the following extension... seems to be almost identical to
whatyou want
:http://extensions.services.openoffice.org/fr/project/text2pic
--
View this message in context:
http://nabble.documentfoundation.org/Using-photos-within-a-Mail-Merge-setup-tp4011420p4011634.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Using photos within a Mail Merge setup??
Thanks Alex!!
I think this will do the trick nicely. Unfortunately, it looks like I can't
access my images by way of the Google Drive folder I have them stored in.
However, when I tried using a generic picture over at the National
Geographic website, it loaded just fine.
Now I just have to come up with a proper Badge formatted .odt file so the
pictures fall where they need to fall!!
For anyone looking to resolve this, here is a detailed outline of what I did
to accomplish what I wanted:
I - Create document with final layout
A: LibreOffice Text document format (.odt)
II - Create spreadsheet with information to be merged (.ods)
A: Create column headers in first row
B: Anny photographs need to be {{FILENAME}}
III - Create databae from spreadsheet information (.odb)
A: Connect to existing database
B: Select Spreadsheet
C: Make sure to select YES to register the database
D: Save database
E: Confirm info has been added to database
i: Click on Tables
ii: Double-Click on Sheet
IV - Open layout document (.odt)
A: Select View -- Data Sources (shortcut: f4)
B: Choose database created in Step III
C: Select Tables
D: Select Sheet1 (database records will appear to immediate right of
data
sources
E: Drag column header to place in layout document (.odt) where you want
it
inserted
G: Save layout document after inserting remaining column headers
V - Create a merged document
A: Select File -- Print
A: Select YES when asked if you want to print as a Form Letter
B: Select Output into a File
C: Select Save as Single Document
D: Save merged document
i: Use different name so you don't overwrite original
ii: Can change to .pdf format if not inserting any photographs
VI - Insert photographs into document
A: Open newly saved document (.odt)
B: Select Tools -- Extension Manager -- Text2pic
i: If Text2pic extension is not installed, download it from:
http://extensions.services.openoffice.org/fr/project/text2pic
C: Select Options
i: Set Root folder or URL to root folder of where images are
stored
a: If set to blank, image column entries needs to be
the full path in
spreadsheet
ii: Set front and back delimeter to what was used in spreadsheet
iii: Checkmark Resize inserted images
a: Select proper Resize Mode
b: Set height and/or width parameters
iv: Click on Default Picture
a: Select image to display for broken photo links
D: Click OK
E: Click CLOSE
F: Select Tools -- Add-Ons -- Convert Text to Picture
G: Save merged document
i: Use different name so you don't overwrite original
Alexander Thurgood wrote
...No that won't work on its own because you're attempting to define a
secondary data source (i.e. for the images) by reference to the
underlying file system and LO doesn't know how to process that kind of
information, which in essence is saying something like : take this
character string, consider it to be a file, open the file and parse
(stream) its contents so that it gets interpreted and displayed as an
image.
At the moment, the only way to directly display images from a datasource
are through Forms or Reports, and these are not tied into the mailmerge
capabilities, otherwise you need a macro to do the lifting work for you...
...the following extension... seems to be almost identical to what
you want :
http://extensions.services.openoffice.org/fr/project/text2pic
--
View this message in context:
http://nabble.documentfoundation.org/Using-photos-within-a-Mail-Merge-setup-tp4011420p4011635.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Using photos within a Mail Merge setup??
Sorry for the badly formatted text. Will report below with proper formatting. -- View this message in context: http://nabble.documentfoundation.org/Using-photos-within-a-Mail-Merge-setup-tp4011420p4011636.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] using \t in regular expression replace
On 10/06/2012 05:09 PM, Cor Nouws wrote: Hi all, I was trying to use \t to replace e.g a paragraph ending with a tab. So find $ replace with \t That does not work. Nor in combination with ^ or \n (one has to try something ;-) ) I can replace e.a. an character with a tab though. This is the same in 3.3.4, 3.4.6, 3.5.7, 3.6.2.2 (Testing on Ubuntu/Linux). So prolly I try something that can't be done (not directly anyway) or something that should be done in a different way? thanks for replies, Cheers, At first I did not understand what you meant since paragraphs always end with paragraph breaks. Well they do, but that does not mean there has to be any punctuation at the end of the paragraph. Here is what I was able to do: In the search box, I entered .$ (period followed by the dollar sign). This searches paragraphs that end with a period. In the Replace box, I entered \t. Clicking the Find and then Replace buttons changed the period to a tab. This is for 3.6.2.2. I think a possible problem is that you did not enter the ending punctuation for a paragraph. Probably this will only search for one type of punctuation mark at a time. HTH --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] using \t in regular expression replace
At 20:24 06/10/2012 -0400, Dan Lewis wrote: On 10/06/2012 05:09 PM, Cor Nouws wrote: I was trying to use \t to replace e.g a paragraph ending with a tab. So find $ replace with \t That does not work. At first I did not understand what you meant since paragraphs always end with paragraph breaks. The questioner presumably wants to merge existing paragraphs: removing paragraph breaks and replacing them by tab characters. Here is what I was able to do: In the search box, I entered .$ (period followed by the dollar sign). This searches paragraphs that end with a period. Sorry, but that's not so. If Regular expressions is not ticked, then .$ matches exactly that: a dot followed by a dollar sign - nothing about paragraph breaks. If Regular expressions is ticked, then .$ matches any single character but only if it occurs at the end of a paragraph. But note in this latter case that the expression matches only that single character, without including the paragraph break itself. So any replacement replaces the single character but leaves the paragraph break as it was. The $ sign anchors any search to the end of a paragraph, but does not match the paragraph break itself, which - in the view of LibreOffice's regular expressions - does not exist as a separate entity. There is no simple way to match and replace paragraph breaks, I think. (You can match and replace Shift+Enter line breaks - using \n.) I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Label mail merge producing one page per record, not six records per page
Hi all, Sorry for the subject being confusing, but that's the best way I could describe it. I'm working with Avery 5384 Name Badge labels. These has six spots per page. I set up a layout in the upper left-hand label, and then clicked synchronize to make sure all the labels contained the same layout. Since I have 150 records, I expected to create 25 pages (6 unique labels per page). However, when I complete the mail merge, I get 150 pages (one duplicate label in all six positions). I'm sure it's something really simple I'm overlooking here as this is my first time venturing into making labels from a database. Here's a link to the .odt file, though I'm not sure if looking at it will help. ReunionBadgesLayout.odt https://www.dropbox.com/s/th3bs3s0183gc3h/ReunionBadgesLayout.odt -- View this message in context: http://nabble.documentfoundation.org/Label-mail-merge-producing-one-page-per-record-not-six-records-per-page-tp4011700.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Fw: Help request on CALC charts' features
The following mail was sent about 10-days ago. I picked the address from the e-mails I receive from other list-members. Even I did not get it back through the list nor was it bounced from somewhere hence sending again. This is the last time. Sorry for the trouble. /* *** */ Hi, I am new to Open source *.* (OS, environment, office, Banshee, wvdial, the works) I recently moved my excel spread-sheets to calc. I am still going through files/features-check post the translation. Most of the data, formula, and formatting are okay, fonts are better. In the charts I observed: 1. The full worksheet as chart in excel are converted to embedded charts in those sheets (no full charts). 2. Legends are peculiar. They are named as column? and not any text string that I would like to give. Is this the way Libre Calc is implemented or I can get back to chart as worksheet in itself and legends of my liking without being restricted to the first column/ first row? Also, is the system info below sufficient for posting here or anything more is advised? Any pointers would be great help. Thanks, Viral Orpe -- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory: 4GB, DDR3 Operating System: Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice Version : LibreOffice 3.4.3 OOO340m1 (Build:302) -- 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
