[libreoffice-users] Calc fails to warn when insert cell breaks sum(A1:A2)
I recently noticed that a complicated spreadsheet that had previously functioned correctly was giving wrong answers without warning. After the usual wailing and gnashing of teeth, I traced the problem to a cell containing =C4-SUM(G11:G1016)”. Further experimentation produced the following simple version of the problem: (1) Let A1=1, A2=2, and A3=sum(A1:A2); A3 computes here as 3. (2) Insert cell A1 shift right. (3) Observe: A3 now computes as 2. This is obvious in this case but far from obvious in a complicated spreadsheet, where the connection between A1 and A3 is obscure. In such cases, For an insert that would cause an error in a reference like A1:A2, I believe that Calc should issue a warning something like, “WARNING: Insert may change the answer computed in A3. Do you want to proceed?” I further think there should be no default and the user should be forced to select either “Yes” or “No”. This was observed in LO 4.3.5.2, LO 4..5.0.0.alpha0 2015-02-05 00:36:56, and MS Excell 2003 sp3. Should this be filed as a bug report or a feature request? If yes, which, and what message should display? Wikipedia says, A software bug is an error, flaw, failure, or fault in a computer program or system that causes it to produce an incorrect or unexpected result, or to behave in unintended ways.” I think this fits that definition. However, it may qualify as a feature request, because the fix is less than obvious (and it has been around for so long). Enjoy, Spencer -- 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] Writer: how to turn off auto-generated lists?
Hi Gary, Le 12/02/2015 11:33, Gary Collins a écrit : Hi, Hopefully an easy question for someone :-) How to I turn off auto-generation of list entries (preferably without altering any other settings? I generally tend to find this feature a pain in the proverbials, and would much rather apply list formatting, etc using styles, after a document (or section of a document) has been completed. The problem really came to a head yesterday, when I was writing up some notes on language, and made some table headings (not an actual table, but one made manually using tabs) using M. F. N. (for masculine, feminine, neuter). LO completely reinterpreted this, and, when I pressed 'enter,' made it into the first entry of a list, supposing it to be the Roman numeral M, and inserting MI at the beginning of the new line. I was unable to find a way to eradicate this effectively, and had to stop what I was doing as a result. I looked in options and I looked in preferences but couldn't see a way to turn off this behaviour. There was nothing in the paragraph style that I could see that should cause this behaviour. (IMO, this behaviour should be restricted to styles which are designated for lists). This FAQ may help you https://wiki.documentfoundation.org/Faq/Writer/025 Kind regards Sophie -- Sophie Gautier sophie.gaut...@documentfoundation.org GSM: +33683901545 IRC: sophi Co-founder - Release coordinator The Document Foundation -- 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] Writer: how to turn off auto-generated lists?
Hi, Hopefully an easy question for someone :-) How to I turn off auto-generation of list entries (preferably without altering any other settings? I generally tend to find this feature a pain in the proverbials, and would much rather apply list formatting, etc using styles, after a document (or section of a document) has been completed. The problem really came to a head yesterday, when I was writing up some notes on language, and made some table headings (not an actual table, but one made manually using tabs) using M. F. N. (for masculine, feminine, neuter). LO completely reinterpreted this, and, when I pressed 'enter,' made it into the first entry of a list, supposing it to be the Roman numeral M, and inserting MI at the beginning of the new line. I was unable to find a way to eradicate this effectively, and had to stop what I was doing as a result. I looked in options and I looked in preferences but couldn't see a way to turn off this behaviour. There was nothing in the paragraph style that I could see that should cause this behaviour. (IMO, this behaviour should be restricted to styles which are designated for lists). thanks, /Gary -- 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 (writer, esp.) and alternative keyboard layouts
Thanks for your relpy, Simos. I had assumed that I was (or should be) getting single Unicode characters, and I think you have confirmed that in your reply. I was wondering if the language input setting should be regarded as local or global; I had assumed global, but a few tests have shown that actually the setting is local for each document, so no problem there I still have a problem with the dead key combinations, which appear to stop working at random times, for no apparent reason. This may be a problem with LO, or it may be a problem with windows (7); since the problem appears to manifest at random times, it's difficult, if not impossible, to know the source or cause. The problem may be exemplified as follows (I hope these characters still display correctly after I press send!!): Normally, using polytonic Greek keyboard, A key gives bare alpha, α dead key / , followed by A key, gives alpha +smooth breathing + acute, ἄ dead key Shift+/, followed by A key, gives alpha + rough breathing + acute, ἅ Adding AltGr to the dead key combination adds an iota subscript, so: altGr + / followed by A gives ᾄ altGr + shift + / followed by A gives ᾅ Then something mysterious, as yet undetected, happens, and most of these stop working: A key still gives alpha, α dead key / , followed by A still gives ἄ but all the other combinations now give bare alpha, α. It's as if the dead keys on their own still work, but combinations with shift, or with altGr, or both, stop working. As I say, I don't know where the problem arises, but it's making life rather frustrating at the moment. I can usually, eventually, get the problem to go away, at least for a while, but again, there seems to be no consistent way to do this; what works some times doesn't work at other times. I'd like to be able to get to the bottom of this somehow. Best,/Gary From: Simos Xenitellis simos.li...@googlemail.com To: Gary Collins gcatl...@yahoo.co.uk Cc: Tom Davies tomc...@gmail.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Monday, 9 February 2015, 8:24 Subject: Re: [libreoffice-users] LO (writer, esp.) and alternative keyboard layouts On 6 February 2015 at 10:11, Gary Collins gcatl...@yahoo.co.uk wrote: Hi, I've been having some trouble lately using in Writer especially when using alternative keyboard mappings (Windows 7). Yesterday, for example, I was using a mapping that was basically English but which included macron vowels (that's vowels with a bar over the top, used, e.g., to indicate a long vowel in works of reference for Latin). I found that the assigned key combination - in this case, AltGr+vowel - was giving me a vowel with something like an acute accent over it instead of a bar - though the key combination was working OK in other applications, e.g. WordPad and even the humble NotePad.It did start to work, however; but in order to get it to do so, I had to set the keyboard in the language bar whilst the LO document was active. Is this the expected behaviour? Should LO override the locale settings in cases like this? (wondering). When you type characters with diacritics, you can get either a precomposed character or a character with diacritics. It depends on the keyboard layout that is active at the moment. For Windows and the default Latin/Greek keyboard layouts, you get precomposed characters. These are single Unicode characters that show the letter with any accents/diacritics drawn on it. They look really well, because the font designer had to draw them with the diacritics on top. The Unicode standard stopped accepting those precomposed characters into the standard about 15 years ago because you had to have all combinations of letters with accents into the standard. The keyboard layouts for Latin and Greek produce precomposed characters. For some exotic Latin scripts, there are no precomposed characters, so they use diacritics. ALPHA with TONOS: ά (precomposed, it's a single character) ALPHA with TONOS: ά (with diacritic, it's actually two characters!) I have an impression you are hitting some issue with the above two different ways to represent characters with accents/diacritics. Again, whilst using the polytonic Greek keyboard, I have noticed that from time to time the key combinations required to obtain some of the special characters stop working - that is, the key presses appear to be detected, but they stop having the desired effect. An example: to obtain an alpha with a rough breathing, acute accent and iota subscript, I would have to first press the combination altGr + shift + '/', release those keys, and then press 'a' (for alpha). It's the altGr + shift combination that stops working here; when I press 'a' I get an alpha alright, but without the special diacritics (I think that's the right word).Using a combination without shift and/or altGr still works; e.g. I can press (and release) '/' and then press 'a' and get an
Re: [libreoffice-users] Writer: how to turn off auto-generated lists?
Hi :) I don't seem to be able to get the (wrong) results as described. I'm attaching a quick little simple example file to give a few examples of what it sounds like you are doing - and a table method. Obviously i have missed something from the description so hopefully you'll be able to clarify what you are doing. On the other hand maybe my file might be free of formatting issues and prove useful in getting the task done. If that's the case i might upload it to Nabble so that other people can use it but i haven't done anything particularly special so i doubt it's going to help in this way. When any word-processor behaves badly i find it helps to start a fresh new document and use the default format for original versions of the file. Then i might maybe create copies in other formats for other people to use but at the moment i am beginning to find an increasing number of people seem increasingly happy with ODF. A lot of people seem to open an old document and then use that to create new documents but that way tons of hidden formatting codes and stuff seem to lurk and sometimes do some really odd things. I once found a document that seemed to have traces indicating it had started as a Word Perfect document and at some point been through Apple systems and Word. CopyPasting as unformatted text into a fresh new document got rid of all sorts of weird problems. Writer doesn't seem to generate lists in the way described, at least not for me. Calc does, of course, but i usually have to select 3-4 cells and then drag. So i am not sure what is going on. Regards from Tom :) On 12 February 2015 at 10:49, Gary Collins gcatl...@yahoo.co.uk wrote: Hi Sophie, Thanks for the link; yes, I looked at that menu as well, but couldn't see anything pertinent to generation of list entries. Perhaps I have a blind spot? /Gary From: Sophie gautier.sop...@gmail.com To: users@global.libreoffice.org Sent: Thursday, 12 February 2015, 10:41 Subject: Re: [libreoffice-users] Writer: how to turn off auto-generated lists? Hi Gary, Le 12/02/2015 11:33, Gary Collins a écrit : Hi, Hopefully an easy question for someone :-) How to I turn off auto-generation of list entries (preferably without altering any other settings? I generally tend to find this feature a pain in the proverbials, and would much rather apply list formatting, etc using styles, after a document (or section of a document) has been completed. The problem really came to a head yesterday, when I was writing up some notes on language, and made some table headings (not an actual table, but one made manually using tabs) using M. F. N. (for masculine, feminine, neuter). LO completely reinterpreted this, and, when I pressed 'enter,' made it into the first entry of a list, supposing it to be the Roman numeral M, and inserting MI at the beginning of the new line. I was unable to find a way to eradicate this effectively, and had to stop what I was doing as a result. I looked in options and I looked in preferences but couldn't see a way to turn off this behaviour. There was nothing in the paragraph style that I could see that should cause this behaviour. (IMO, this behaviour should be restricted to styles which are designated for lists). This FAQ may help you https://wiki.documentfoundation.org/Faq/Writer/025 Kind regards Sophie -- Sophie Gautier sophie.gaut...@documentfoundation.org GSM: +33683901545 IRC: sophi Co-founder - Release coordinator The Document Foundation -- 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] Re: Conditional Whitespace for Mail Merge
Hi Andreas, thanks for your reply. I've a Calc-Sheet with address data (linked with Writer it was transformed to a database). In my used Writer (LO 4.4) the query does no work properly. The query described by you would be in my case [my calc sheet].members.title != but only [title] != is interpreted correctly. :-/ (why?) But in my case the whitespace is printed anytime. Condition: [title] != Then: Else: empty field I think there could be a bug? Can you confirm my described behavior? regards, Sven On Wed, Feb 11, 2015 at 8:42 PM, Andreas Säger ville...@t-online.de wrote: Composing the lines of an addressing area is easy to do with a query. Details depend on the type of your database. In Writer you can use a conditional field with a nested data source field like this: If condition: DataSource.QueryName.Title != Then: -- View this message in context: http://nabble.documentfoundation.org/Conditional-Whitespace-for-Mail-Merge-tp4139674p4139762.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 -- 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] Writer: how to turn off auto-generated lists?
Hi Sophie, Thanks for the link; yes, I looked at that menu as well, but couldn't see anything pertinent to generation of list entries. Perhaps I have a blind spot? /Gary From: Sophie gautier.sop...@gmail.com To: users@global.libreoffice.org Sent: Thursday, 12 February 2015, 10:41 Subject: Re: [libreoffice-users] Writer: how to turn off auto-generated lists? Hi Gary, Le 12/02/2015 11:33, Gary Collins a écrit : Hi, Hopefully an easy question for someone :-) How to I turn off auto-generation of list entries (preferably without altering any other settings? I generally tend to find this feature a pain in the proverbials, and would much rather apply list formatting, etc using styles, after a document (or section of a document) has been completed. The problem really came to a head yesterday, when I was writing up some notes on language, and made some table headings (not an actual table, but one made manually using tabs) using M. F. N. (for masculine, feminine, neuter). LO completely reinterpreted this, and, when I pressed 'enter,' made it into the first entry of a list, supposing it to be the Roman numeral M, and inserting MI at the beginning of the new line. I was unable to find a way to eradicate this effectively, and had to stop what I was doing as a result. I looked in options and I looked in preferences but couldn't see a way to turn off this behaviour. There was nothing in the paragraph style that I could see that should cause this behaviour. (IMO, this behaviour should be restricted to styles which are designated for lists). This FAQ may help you https://wiki.documentfoundation.org/Faq/Writer/025 Kind regards Sophie -- Sophie Gautier sophie.gaut...@documentfoundation.org GSM: +33683901545 IRC: sophi Co-founder - Release coordinator The Document Foundation -- 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: LibréOffice and PDFs (Again)
On Tue, 10 Feb 2015 09:43:20 -0700 (MST) V Stuart Foote vstuart.fo...@utsa.edu wrote: Jim Seymour wrote [snip] Question: Do recent (i.e. 4.3.x.x and later) versions of LO *capably* allow the opening/editing/saving of PDF files that are writable and not encrypted or otherwise protected? Simple answer... YES, but LibreOffice is not a PDF editor and will never be. It will always import to ODF native formats, and then must export/print back to PDF as a round trip process. [snip] Surely a distinction without a difference? On Tue, 10 Feb 2015 18:19:03 + Tom Davies tomc...@gmail.com wrote: It might be possible to ask your distro's package maintainers if they would be kind enough to make a more recent version of LibreOffice available in their repos. [snip] Even my Linux Mint 17 MATE install at home has only 4.2.7 (near as I can tell, from here). I doubt I'll see an LO upgrade for Mint 13. In any event: Not particularly germane: 99-44/100% of the end-users at work are using MS-Win7 Pro, and it for them I ask this question. If LO can do the job: Great. If not: I guess we'll have to go out and but a few copies of some-or-another PDF-editing-capable thing. On Tue, 10 Feb 2015 18:47:34 + jonathon toki.kant...@gmail.com wrote: On 10/02/15 16:43, V Stuart Foote wrote: Your unsupported version of LibreOffice 3.5.7 was release 5 Oct 2012 and is well past its end-of-life from the projects perspective. - From the perspective of a commercial enterprise, the EOL dates guarantee that LibO is not suitable. This is a concept that the open source community does not seem to grasp. This is but one reason, out of many, that Linux will *never*, *ever* replace MS-Win on the desktop. It is one of the reasons I no longer suggest the idea. With thirteen months from feature freeze, to EOL, an organization doesn't have time to test, much less deploy new versions, before they are passed the EOL date. Which makes purchasing Tier 3 support mandatory. [snip] And, if we had to purchase the stuff, anyway, why not just go with the flow and continue purchasing MS Office? Not trying to be an urmas. Just trying to point out the realities of a business environment. I have all the time in the world (that I care to invest, anyway) at home. At work...? No, not so much. Even at home: I install LTS versions of stuff where I can, and let it run until it EOLs. None of the above is by way of complaint. It is what it is, and I'm more than happy with it as it is. It's worth way, *way* more than what I paid for it, so who'm I to complain? :) Thanks for the responses, everybody. I'll see if I can install 4.3.x.x or later on my laptop, under its Win7 Pro boot, and see if it'll do what we need. Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.php. -- 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] Calc fails to warn when insert cell breaks sum(A1:A2)
Hi :) I think post as a Feature Request. If at all possible i think it's best to post Feature Requests instead of bug-reports. They have a much bigger feel-good factor and i suspect they are more likely to attract new devs. I think there has got to be a default and i tend to prefer it if there is one. It can be a pain when you know the pop-up and have to do more than just hit enter all the time. Regards form Tom :) On 12 February 2015 at 20:14, Spencer Graves spencer.gra...@prodsyse.com wrote: I recently noticed that a complicated spreadsheet that had previously functioned correctly was giving wrong answers without warning. After the usual wailing and gnashing of teeth, I traced the problem to a cell containing =C4-SUM(G11:G1016)”. Further experimentation produced the following simple version of the problem: (1) Let A1=1, A2=2, and A3=sum(A1:A2); A3 computes here as 3. (2) Insert cell A1 shift right. (3) Observe: A3 now computes as 2. This is obvious in this case but far from obvious in a complicated spreadsheet, where the connection between A1 and A3 is obscure. In such cases, For an insert that would cause an error in a reference like A1:A2, I believe that Calc should issue a warning something like, “WARNING: Insert may change the answer computed in A3. Do you want to proceed?” I further think there should be no default and the user should be forced to select either “Yes” or “No”. This was observed in LO 4.3.5.2, LO 4..5.0.0.alpha0 2015-02-05 00:36:56, and MS Excell 2003 sp3. Should this be filed as a bug report or a feature request? If yes, which, and what message should display? Wikipedia says, A software bug is an error, flaw, failure, or fault in a computer program or system that causes it to produce an incorrect or unexpected result, or to behave in unintended ways.” I think this fits that definition. However, it may qualify as a feature request, because the fix is less than obvious (and it has been around for so long). Enjoy, Spencer -- 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] Romove all pictures
There are times when I copy paste from websites to Calc. Things like lists of TV stations or Twitter followers. When I do so it also captures all the images and pastes them to the document. This causes a big mess since most of the images cover each other and do not align with their respective text entry. I have to click them one by one and delete them. With a big list this takes a lot of time. Is there a way of removing all images at once? -- 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] Calc fails to warn when insert cell breaks sum(A1:A2)
Brian Barker wrote: At 12:14 12/02/2015 -0800, Spencer Graves wrote: I recently noticed that a complicated spreadsheet that had previously functioned correctly was giving wrong answers without warning. After the usual wailing and gnashing of teeth, I traced the problem to a cell containing =C4-SUM(G11:G1016). Further experimentation produced the following simple version of the problem: (1) Let A1=1, A2=2, and A3=sum(A1:A2); A3 computes here as 3. (2) Insert cell A1 shift right. (3) Observe: A3 now computes as 2. This is obvious in this case but far from obvious in a complicated spreadsheet, where the connection between A1 and A3 is obscure. In such cases, For an insert that would cause an error in a reference like A1:A2, I believe that Calc should issue a warning something like, WARNING: Insert may change the answer computed in A3. Do you want to proceed? I further think there should be no default and the user should be forced to select either Yes or No. Sorry, but I do not see how you can claim that the formula in A3 is broken: it remains as =SUM(A1:A2) exactly as you entered it. What has changed is that you have displaced your data and made the result of the formula correctly different. I'm glad that Calc has allowed you to do this. If a spreadsheet program warned you when any calculated results might change, you would have to confirm just about every entry or change. This was observed in LO 4.3.5.2, LO 4..5.0.0.alpha0 2015-02-05 00:36:56, and MS Excel 2003 sp3. And perhaps in every other spreadsheet ever created? Should this be filed as a bug report or a feature request? Neither, I hope. Wikipedia says, A software bug is an error, flaw, failure, or fault in a computer program or system that causes it to produce an incorrect or unexpected result, or to behave in unintended ways. I think this fits that definition. I don't see that the result is incorrect and I'm sure the behaviour is not unintended. I accept that you see this as an unexpected result, but then expectation is in the eye of the beholder. A couple of points: o Spreadsheets are useful only when the (usually hidden) formulae are appropriate and there is generally no way to ensure that this is so. Consequently spreadsheets are a fragile way to construct a means of computation. This is perhaps unfortunate but nevertheless true. o One helpful technique might be, after selecting A1 and before creating the problem by displacing its value, to use Tools | Detective | Trace Dependents to show where any dependent formulae are. This might help you to rethink your change. I trust this helps. Brian Barker Another point to add... If the problem is that spreadsheet has been carefully created, but used by less skilled users (who change values they shouldn't, overwrite formulas, insert extra cells where they break formulas etc.), you can guard against that with cell protection. By default, all cells are marked to be protected if the sheet is protected, although the sheet is not protected by default. Steps to make use of this are: - Create the spreadsheet as normal - For each cell or range of cells which the user needs to modify: - Select the cell (or range of cells) - Format Cells Cell Protection Untick Protected OK - For each sheet containing cells to be protected: - Tools Protect Document Sheet, optionally enter a password OK If you later need to make changes to the protected cells, go to Tools Protect Document Sheet. You'll have to enter the password if you set one (so don't forget it!) Once you're done, enable the protection again (entering the password again if you want to use one). If you don't set a password, the sheet will still be protected against accidental changes, but can be unprotected without entering a password so doesn't stop people who are determined to break it. That's probably good enough for most purposes. Then again, I doubt the protection is very secure anyway (unless the document is somehow encrypted to allow reading but not modification of the protected cells), so while it would take a bit more skill and determination to get around a password it may still be possible. I'd suggest not using the same password as you do for anything else that needs to be secure (not that you'd use the same password for more than one thing anyway, of course...). Older versions of MS Office stored its equivalent of that password in the file with a relatively simple obfuscation, so it was possible to extract the password from the file. LibreOffice and newer versions of MS Office are probably better, but I still wouldn't like to bet my bank account on it ;o) Mark. -- 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
Re: [libreoffice-users] Romove all pictures
Hi :) I was going to suggest that answer too but Brian beat me and gave a better answer too :)) I felt like i really learned something that i could possibly remember and probably even find useful myself. Usually my usage is tooo basic to make much advantage of most of the answers here but it's still feels good to see them. Regards from Tom :) On 12 February 2015 at 22:05, libreoffice-ml.mbou...@spamgourmet.com wrote: Emil Payne wrote: There are times when I copy paste from websites to Calc. Things like lists of TV stations or Twitter followers. When I do so it also captures all the images and pastes them to the document. This causes a big mess since most of the images cover each other and do not align with their respective text entry. I have to click them one by one and delete them. With a big list this takes a lot of time. Is there a way of removing all images at once? Rather than just pasting, select Edit Paste Special, and choose Unformatted Text. I don't think there's an easy way to keep text formatting but not images, but I'm sure someone will correct me if I'm wrong. Mark. -- 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] installation problem LO4.4 - linux mint
Hi :) Hmm, i am not sure. Have you made sure you have administrator/SuperUser rights? Sudo perhaps? Regards from Tom :) On 12 February 2015 at 17:00, sqroot sqr...@zoho.com wrote: hallo! I was curious to test LO4.4, so i tried to install it on Linux Mint 17 Qiana. I followed the installation instructions, first purged the old LO-version, downloaded the file, checked it, etc... installation worked fine. but when I try to start it, wheter from the icons or from the command line, i get this error message Libre Office 4.4 - Fatal Error The application cannot be started. User installation could not be completed. any ideas, why i get this error message and how to fix it? thank you, Markus -- 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] Romove all pictures
Emil Payne wrote: There are times when I copy paste from websites to Calc. Things like lists of TV stations or Twitter followers. When I do so it also captures all the images and pastes them to the document. This causes a big mess since most of the images cover each other and do not align with their respective text entry. I have to click them one by one and delete them. With a big list this takes a lot of time. Is there a way of removing all images at once? Rather than just pasting, select Edit Paste Special, and choose Unformatted Text. I don't think there's an easy way to keep text formatting but not images, but I'm sure someone will correct me if I'm wrong. Mark. -- 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] Calc fails to warn when insert cell breaks sum(A1:A2)
At 12:14 12/02/2015 -0800, Spencer Graves wrote: I recently noticed that a complicated spreadsheet that had previously functioned correctly was giving wrong answers without warning. After the usual wailing and gnashing of teeth, I traced the problem to a cell containing =C4-SUM(G11:G1016). Further experimentation produced the following simple version of the problem: (1) Let A1=1, A2=2, and A3=sum(A1:A2); A3 computes here as 3. (2) Insert cell A1 shift right. (3) Observe: A3 now computes as 2. This is obvious in this case but far from obvious in a complicated spreadsheet, where the connection between A1 and A3 is obscure. In such cases, For an insert that would cause an error in a reference like A1:A2, I believe that Calc should issue a warning something like, WARNING: Insert may change the answer computed in A3. Do you want to proceed? I further think there should be no default and the user should be forced to select either Yes or No. Sorry, but I do not see how you can claim that the formula in A3 is broken: it remains as =SUM(A1:A2) exactly as you entered it. What has changed is that you have displaced your data and made the result of the formula correctly different. I'm glad that Calc has allowed you to do this. If a spreadsheet program warned you when any calculated results might change, you would have to confirm just about every entry or change. This was observed in LO 4.3.5.2, LO 4..5.0.0.alpha0 2015-02-05 00:36:56, and MS Excel 2003 sp3. And perhaps in every other spreadsheet ever created? Should this be filed as a bug report or a feature request? Neither, I hope. Wikipedia says, A software bug is an error, flaw, failure, or fault in a computer program or system that causes it to produce an incorrect or unexpected result, or to behave in unintended ways. I think this fits that definition. I don't see that the result is incorrect and I'm sure the behaviour is not unintended. I accept that you see this as an unexpected result, but then expectation is in the eye of the beholder. A couple of points: o Spreadsheets are useful only when the (usually hidden) formulae are appropriate and there is generally no way to ensure that this is so. Consequently spreadsheets are a fragile way to construct a means of computation. This is perhaps unfortunate but nevertheless true. o One helpful technique might be, after selecting A1 and before creating the problem by displacing its value, to use Tools | Detective | Trace Dependents to show where any dependent formulae are. This might help you to rethink your change. 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] Calc fails to warn when insert cell breaks sum(A1:A2)
I think have a wee difficult to understand what you are doing, as I do not see any error. You put constants 1 and 2 in the cells A1 and A2 and a sum formula in A3. Then you insert an empty cell in A1 while moving the existing content in the cells one step to the right. Hence after the insertion A2 contains the constant 1, A3 contains the constant 2 and A4 contains the formula. All references are relative, so cell A4 now is = sum(A2:A3) giving the result 3, just as before. That the cell A3 computes 2 is evident as it contains the constant you put in cell A2 before the move. So sorry, I am not clever enough to realize your problem. Den 2015-02-12 21:14, skrev Spencer Graves: I recently noticed that a complicated spreadsheet that had previously functioned correctly was giving wrong answers without warning. After the usual wailing and gnashing of teeth, I traced the problem to a cell containing =C4-SUM(G11:G1016)”. Further experimentation produced the following simple version of the problem: (1) Let A1=1, A2=2, and A3=sum(A1:A2); A3 computes here as 3. (2) Insert cell A1 shift right. (3) Observe: A3 now computes as 2. This is obvious in this case but far from obvious in a complicated spreadsheet, where the connection between A1 and A3 is obscure. In such cases, For an insert that would cause an error in a reference like A1:A2, I believe that Calc should issue a warning something like, “WARNING: Insert may change the answer computed in A3. Do you want to proceed?” I further think there should be no default and the user should be forced to select either “Yes” or “No”. This was observed in LO 4.3.5.2, LO 4..5.0.0.alpha0 2015-02-05 00:36:56, and MS Excell 2003 sp3. Should this be filed as a bug report or a feature request? If yes, which, and what message should display? Wikipedia says, A software bug is an error, flaw, failure, or fault in a computer program or system that causes it to produce an incorrect or unexpected result, or to behave in unintended ways.” I think this fits that definition. However, it may qualify as a feature request, because the fix is less than obvious (and it has been around for so long). Enjoy, Spencer -- 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] Calc fails to warn when insert cell breaks sum(A1:A2)
Hi :) I'm guessing you are a fairly logical and astute thinker rather than a typical office drone or a typically tech-averse accountancy person. Yes there is no problem unless the user is a moron. Sadly many of us often are a bit moronic from time to time. The suggestion was to maybe write a feature request to guard against user-error or pebkac problems. Regards from Tom :) On 13 February 2015 at 00:14, Kaj 70147pers...@telia.com wrote: I think have a wee difficult to understand what you are doing, as I do not see any error. You put constants 1 and 2 in the cells A1 and A2 and a sum formula in A3. Then you insert an empty cell in A1 while moving the existing content in the cells one step to the right. Hence after the insertion A2 contains the constant 1, A3 contains the constant 2 and A4 contains the formula. All references are relative, so cell A4 now is = sum(A2:A3) giving the result 3, just as before. That the cell A3 computes 2 is evident as it contains the constant you put in cell A2 before the move. So sorry, I am not clever enough to realize your problem. Den 2015-02-12 21:14, skrev Spencer Graves: I recently noticed that a complicated spreadsheet that had previously functioned correctly was giving wrong answers without warning. After the usual wailing and gnashing of teeth, I traced the problem to a cell containing =C4-SUM(G11:G1016)”. Further experimentation produced the following simple version of the problem: (1) Let A1=1, A2=2, and A3=sum(A1:A2); A3 computes here as 3. (2) Insert cell A1 shift right. (3) Observe: A3 now computes as 2. This is obvious in this case but far from obvious in a complicated spreadsheet, where the connection between A1 and A3 is obscure. In such cases, For an insert that would cause an error in a reference like A1:A2, I believe that Calc should issue a warning something like, “WARNING: Insert may change the answer computed in A3. Do you want to proceed?” I further think there should be no default and the user should be forced to select either “Yes” or “No”. This was observed in LO 4.3.5.2, LO 4..5.0.0.alpha0 2015-02-05 00:36:56, and MS Excell 2003 sp3. Should this be filed as a bug report or a feature request? If yes, which, and what message should display? Wikipedia says, A software bug is an error, flaw, failure, or fault in a computer program or system that causes it to produce an incorrect or unexpected result, or to behave in unintended ways.” I think this fits that definition. However, it may qualify as a feature request, because the fix is less than obvious (and it has been around for so long). Enjoy, Spencer -- 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]
PLEASE TAKE ME OFF OF ALL OF YOUR LISTS! THANK YOU. -- 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] Remove all pictures
At 15:14 12/02/2015 -0600, Emil Payne wrote: There are times when I copy paste from websites to Calc. Things like lists of TV stations or Twitter followers. When I do so it also captures all the images and pastes them to the document. This causes a big mess since most of the images cover each other and do not align with their respective text entry. I have to click them one by one and delete them. With a big list this takes a lot of time. Is there a way of removing all images at once? o Go to Edit | Select All (or press Ctrl+A). o Go to Edit | Delete Content... (or press Delete). o In the Delete Contents dialogue, untick Delete all if necessary and ensure only Objects is ticked. o OK. You may also like to experiment with using Edit | Paste Special... (or Ctrl+Shift+V) instead of ordinary Paste to insert the material originally. In the Paste Special dialogue, select Unformatted text. 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
[libreoffice-users] Where is Base?
Hello. I just installed 4.4.03 on Windows 7. I'd like to use Base. When I click on the LibreOffice icon on my desktop, I see a screen with list of buttons on the left under Create. I select Base Database but nothing happens. The only buttons that work are Writer and Calc. What am I doing wrong? Thanks -- View this message in context: http://nabble.documentfoundation.org/Where-is-Base-tp4139808.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] Re: LibréOffice and PDFs (Again)
Hi :) PDF Editor or PDF Editing can mean many different things. It rarely means editing in the way you would edit a .doc or .odt. In a word-processor format when you delete words or add words to a sentence the whole line reflows to avoid leaving a gap or having words over-writing each other. Add or remove enough words and the rest of the paragraph adjusts and may well affect the length of the whole document. If you have images Anchored to paragraph, character or as character then those images will also move. If images (or other objects) have almost any of the wrap settings then text will usually reflow around the image rather than over-writing it or vanishing under it. With almost all PDF Editors each element on the page might be able to move around but does so without affecting other elements. An element might be a line of text, but it's very unlikely to be a whole sentence. Another element might be an image but if you move it around no text reflows around it. Sometimes words seem to be sort of sub-elements and/or individual letters can be sub-sub-elements and removing them sometimes doesn't even affect the other words in the same line, let alone the flow of the sentence. So if you are going to buy a Pdf Editor you need to make sure of what they mean by edit. Some Pdf Readers offer to convert or export Pdfs to certain formats but so far i have only seen docX being offered and then it's a bit hit-or-miss as to whether it's a transistional format that works on whichever version of MS Office you happen to have - or maybe it uses MS Office on the machine you export/convert the Pdf from and then you just have to hope you have the same version on whichever machine you are going to edit on - or hope the document works on non-MS programs. If the Pdf Readers converted/exported to Doc or Odf, rather than one of the many versions of DocX, then most of those worries would vanish. So, LibreOffice CAN edit Pdfs but only in the way most Pdf Editors mean. NOT in the way most users expect such editors to work. Regards from Tom :) On 12 February 2015 at 12:14, Jim Seymour jseym...@linxnet.com wrote: On Tue, 10 Feb 2015 09:43:20 -0700 (MST) V Stuart Foote vstuart.fo...@utsa.edu wrote: Jim Seymour wrote [snip] Question: Do recent (i.e. 4.3.x.x and later) versions of LO *capably* allow the opening/editing/saving of PDF files that are writable and not encrypted or otherwise protected? Simple answer... YES, but LibreOffice is not a PDF editor and will never be. It will always import to ODF native formats, and then must export/print back to PDF as a round trip process. [snip] Surely a distinction without a difference? On Tue, 10 Feb 2015 18:19:03 + Tom Davies tomc...@gmail.com wrote: It might be possible to ask your distro's package maintainers if they would be kind enough to make a more recent version of LibreOffice available in their repos. [snip] Even my Linux Mint 17 MATE install at home has only 4.2.7 (near as I can tell, from here). I doubt I'll see an LO upgrade for Mint 13. In any event: Not particularly germane: 99-44/100% of the end-users at work are using MS-Win7 Pro, and it for them I ask this question. If LO can do the job: Great. If not: I guess we'll have to go out and but a few copies of some-or-another PDF-editing-capable thing. On Tue, 10 Feb 2015 18:47:34 + jonathon toki.kant...@gmail.com wrote: On 10/02/15 16:43, V Stuart Foote wrote: Your unsupported version of LibreOffice 3.5.7 was release 5 Oct 2012 and is well past its end-of-life from the projects perspective. - From the perspective of a commercial enterprise, the EOL dates guarantee that LibO is not suitable. This is a concept that the open source community does not seem to grasp. This is but one reason, out of many, that Linux will *never*, *ever* replace MS-Win on the desktop. It is one of the reasons I no longer suggest the idea. With thirteen months from feature freeze, to EOL, an organization doesn't have time to test, much less deploy new versions, before they are passed the EOL date. Which makes purchasing Tier 3 support mandatory. [snip] And, if we had to purchase the stuff, anyway, why not just go with the flow and continue purchasing MS Office? Not trying to be an urmas. Just trying to point out the realities of a business environment. I have all the time in the world (that I care to invest, anyway) at home. At work...? No, not so much. Even at home: I install LTS versions of stuff where I can, and let it run until it EOLs. None of the above is by way of complaint. It is what it is, and I'm more than happy with it as it is. It's worth way, *way* more than what I paid for it, so who'm I to complain? :) Thanks for the responses, everybody. I'll see if I can install 4.3.x.x or later on my laptop, under its Win7 Pro boot, and see if it'll do what we need. Regards, Jim -- Note: My mail server employs *very* aggressive
Re: [libreoffice-users] Writer: how to turn off auto-generated lists?
Hi :) There are various different layers of hidden codes. Ctrl A, Delete only gets rid of a few of them. Some can be seen by pressing the backwards sort of double-struck P in the toolbar icons. This shows non-printing characters, such as tabs and end-of-paragraphs, that don't get printed out. These are the ones that get deleted by Ctrl A, delete. If you poke around with a hex-editor or get even further (well, slightly further) down into the 1s and 0s (with a side-bar or something to see the ascii characters) then you see all sorts of weird characters, most of which are incomprehensible to almost anyone but some are human-readable and show things such as names, systems, occasionally even addresses and phone numbers from ancient times. I think some of the incomprehensible ones are the ones doing screwey things. Yeh, Windows tries to avoid letting people develop good habits and tries to push them into bad ones. One of my favs was Microsoft saying you should never accept cookies and never turn your anti-virus off for anything. Then their own website asked you to accept cookies and to install anything from them they would tell you to turn off your anti-virus. However if you did so and ran into troubles then 'experts' would blame the user for obviously bad habits and ignoring security issues. One wonders why people are so surprised that Windows so frequently runs into problems and is so open to malware and attacks. Regards from Tom :) On 12 February 2015 at 12:54, Gary Collins gcatl...@yahoo.co.uk wrote: Hi Tom, A lot of people seem to open an old document and then use that to create new documents [sometimes that's the easiest way in windows] but that way tons of hidden formatting codes and stuff seem to lurk and sometimes do some really odd things. [I'd have thought that selecting all with Ctrl-A and hitting del or backspace should remove everything? perhaps not?] CopyPasting as unformatted text into a fresh new document got rid of all sorts of weird problems. [I'll try that, it may well work] Writer doesn't seem to generate lists in the way described, at least not for me. Calc does, of course, but i usually have to select 3-4 cells and then drag. So i am not sure what is going on. [I've tried it here in the office with a new document, and it doesn't seem to do it here, either; so your explanation may well be right. I'm not sure if the version here and the version at home are the same, I'll check. The style in my home doc was default, and there was nothing I could find that indicated that it might be in the middle of a list. Perhaps there is a way of making formatting codes visible in a document? And deleting unwanted ones? If not, perhaps it might be a good idea if one were to be introduced? ] best, /Gary -- 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] Writer: how to turn off auto-generated lists?
At 10:33 12/02/2015 +, Gary Collins wrote: Hopefully an easy question for someone :-) Yup: so easy that there are two answers! How to I turn off auto-generation of list entries (preferably without altering any other settings? I generally tend to find this feature a pain in the proverbials, and would much rather apply list formatting, etc using styles, after a document (or section of a document) has been completed. The problem really came to a head yesterday, when I was writing up some notes on language, and made some table headings (not an actual table, but one made manually using tabs) using M. F. N. (for masculine, feminine, neuter). LO completely reinterpreted this, and, when I pressed 'enter,'Â made it into the first entry of a list, supposing it to be the Roman numeral M, and inserting MI at the beginning of the new line. I was unable to find a way to eradicate this effectively, and had to stop what I was doing as a result. Always think of keeping the facility and dealing it with it piecemeal when it happens. The action of pressing Enter to complete the first paragraph causes an automatic correction which you will notice. The correction is a separate process from the paragraph break that you actually want. So if you go *immediately* to Edit | Undo (or Ctrl+Z), you can remove the correction but retain the part you need. I looked in options and I looked in preferences but couldn't see a way to turn off this behaviour. There was nothing in the paragraph style that I could see that should cause this behaviour. If you really want to disable this correction process completely, remove the tick from Tools | AutoCorrect Options... | Options | Apply numbering - symbol: *. 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
[libreoffice-users] Re: [libreoffice-marketing] Fw: 14 February 2015 - I love Free Software Day
Hi :) I think this is a nice idea. Most people on these mailing list already do quite a lot of work and are under-appreciated. It would be nice to see this idea formally extended to cover all the non-devs who do fantastic work in 'User' / Client Support, Documentation, Translation. I think that is the intention but (as just about always) we once again get ignored and undervalued when it comes to direct comments and mentions. So i think just see all the thanks as being at least partly directed at each of you too! You all do a fantastic job, even the lurkers on these lists are often doing a lot outside of the mailing lists. On the plus side i guess we do get thanks from individuals probably more often than devs do and we are not always dealing with grumbles so maybe this sort of thing is meant to help redress that imbalance ;) Many thanks to everyone for helping make LibreOffice what it is today. Fantastic job! : Many thanks and regards from Tom :) On 12 February 2015 at 01:40, Thorsten Behrens t...@documentfoundation.org wrote: Hi, FYI - sounds ideal for spreading on social networks shortly before. :) - Forwarded message from Matthias Kirschner m...@fsfe.org - Date: Mon, 9 Feb 2015 17:24:03 +0100 From: Matthias Kirschner m...@fsfe.org Subject: 14 February 2015 - I love Free Software Day Dear all, I am quite sure many of you receive a lot of bug reports, feature requests or criticism during the whole year. Sometimes people forget to thank others for their good work. So for this Saturday, 14 February 2015, we again ask people around the globe to show their love to the people behind Free Software (=you, too). We made some suggestions here (available in 8 languages): https://fsfe.org/news/2015/news-20150209-01.html and we would be thankful if you can spread this to your communities, and thereby motivate other Free Software contributors to continue their good work [1]. Feel free to order some postcards, leaflets, or posters for your office on https://fsfe.org/contribute/spreadtheword.en.html#ilovefs-campaign or use our graphics https://fsfe.org/campaigns/ilovefs/artwork/artwork.html. I hope many of you will receive a nice thank you note, a picture https://fsfe.org/campaigns/ilovefs/whylovefs/gallery.en.html, a drink, some chocolate, a hug, or other cool signs of appreciation. You earned it! And I hope that you also have some time to thank others. Thank you all for your work! Matthias 1. On 15 February you can write the next bug report ;) -- Matthias Kirschner - Vice President FSFE Schönhauser Allee 6/7, 10119 Berlin, t +49-30-27595290 Weblog (blogs.fsfe.org/mk) - Contact (fsfe.org/about/kirschner) Receive monthly Free Software news (fsfe.org/news/newsletter.html) Your donation enables our work (fsfe.org/donate) - End forwarded message - Cheers, -- Thorsten -- To unsubscribe e-mail to: marketing+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/marketing/ 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] Writer: how to turn off auto-generated lists?
Hi Tom, A lot of people seem to open an old document and then use that to create new documents [sometimes that's the easiest way in windows] but that way tons of hidden formatting codes and stuff seem to lurk and sometimes do some really odd things. [I'd have thought that selecting all with Ctrl-A and hitting del or backspace should remove everything? perhaps not?] CopyPasting as unformatted text into a fresh new document got rid of all sorts of weird problems. [I'll try that, it may well work] Writer doesn't seem to generate lists in the way described, at least not for me. Calc does, of course, but i usually have to select 3-4 cells and then drag. So i am not sure what is going on. [I've tried it here in the office with a new document, and it doesn't seem to do it here, either; so your explanation may well be right. I'm not sure if the version here and the version at home are the same, I'll check.The style in my home doc was default, and there was nothing I could find that indicated that it might be in the middle of a list. Perhaps there is a way of making formatting codes visible in a document? And deleting unwanted ones? If not, perhaps it might be a good idea if one were to be introduced?] best,/Gary -- 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] Writer: how to turn off auto-generated lists?
From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Thursday, 12 February 2015, 13:12 Subject: Re: [libreoffice-users] Writer: how to turn off auto-generated lists? At 10:33 12/02/2015 +, Gary Collins wrote: Hopefully an easy question for someone :-) Yup: so easy that there are two answers! ... Always think of keeping the facility and dealing it with it piecemeal when it happens. The action of pressing Enter to complete the first paragraph causes an automatic correction which you will notice. The correction is a separate process from the paragraph break that you actually want. So if you go *immediately* to Edit | Undo (or Ctrl+Z), you can remove the correction but retain the part you need. Thanks, Brian, I'll try to remember to try that and see if it helps. I looked in options and I looked in preferences but couldn't see a way to turn off this behaviour. There was nothing in the paragraph style that I could see that should cause this behaviour. If you really want to disable this correction process completely, remove the tick from Tools | AutoCorrect Options... | Options | Apply numbering - symbol: *. I'm pretty sure I unchecked that, and it didn't make any difference. I'd better double check, though. As I indicated in a response to another reply, it doesn't seem to work like that here in the office, in a new document. It seems that in my document at home, LO seems to think that it is in the middle of a list and responds accordingly. I really don't know. I'm going to install the latest version soon, though, and will see if that helps... I trust this helps. I hope it does! We'll have to see ;-) Brian Barker Thanks,/Gary -- 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] Writer: how to turn off auto-generated lists?
Hi :) Yes, you are doing the correct thing. So, my answer doesn't explain why you are running into the problems you are having. My advice might still have helped but more by accident than for the reasons i gave. Errr, of course LibreOffice also puts tons of stuff in that underlaying coding but i think it does a lot less than Word. Fortunately Brian has given a good answer that hopefully might help. His answer just fleshes out the answers given by other people this time but you can always rely on his answers as being well worth trying. Regards from Tom :) On 12 February 2015 at 16:12, Gary Collins gcatl...@yahoo.co.uk wrote: ha ha! I guess it doesn't surprise me. Thinking about it though, that's not what I normally do. What I do is to open a document, then create a new one from the filenew menu entry. This seems to me to be the best way to do it - but maybe I'm wrong. Anyway, I'm probably going to install the latest version very soon, so I'll see how that behaves!! Thanks, /G. From: Tom Davies tomc...@gmail.com To: Gary Collins gcatl...@yahoo.co.uk Cc: Sophie gautier.sop...@gmail.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 12 February 2015, 13:30 Subject: Re: [libreoffice-users] Writer: how to turn off auto-generated lists? Hi :) There are various different layers of hidden codes. Ctrl A, Delete only gets rid of a few of them. Some can be seen by pressing the backwards sort of double-struck P in the toolbar icons. This shows non-printing characters, such as tabs and end-of-paragraphs, that don't get printed out. These are the ones that get deleted by Ctrl A, delete. If you poke around with a hex-editor or get even further (well, slightly further) down into the 1s and 0s (with a side-bar or something to see the ascii characters) then you see all sorts of weird characters, most of which are incomprehensible to almost anyone but some are human-readable and show things such as names, systems, occasionally even addresses and phone numbers from ancient times. I think some of the incomprehensible ones are the ones doing screwey things. Yeh, Windows tries to avoid letting people develop good habits and tries to push them into bad ones. One of my favs was Microsoft saying you should never accept cookies and never turn your anti-virus off for anything. Then their own website asked you to accept cookies and to install anything from them they would tell you to turn off your anti-virus. However if you did so and ran into troubles then 'experts' would blame the user for obviously bad habits and ignoring security issues. One wonders why people are so surprised that Windows so frequently runs into problems and is so open to malware and attacks. Regards from Tom :) On 12 February 2015 at 12:54, Gary Collins gcatl...@yahoo.co.uk wrote: Hi Tom, A lot of people seem to open an old document and then use that to create new documents [sometimes that's the easiest way in windows] but that way tons of hidden formatting codes and stuff seem to lurk and sometimes do some really odd things. [I'd have thought that selecting all with Ctrl-A and hitting del or backspace should remove everything? perhaps not?] CopyPasting as unformatted text into a fresh new document got rid of all sorts of weird problems. [I'll try that, it may well work] Writer doesn't seem to generate lists in the way described, at least not for me. Calc does, of course, but i usually have to select 3-4 cells and then drag. So i am not sure what is going on. [I've tried it here in the office with a new document, and it doesn't seem to do it here, either; so your explanation may well be right. I'm not sure if the version here and the version at home are the same, I'll check. The style in my home doc was default, and there was nothing I could find that indicated that it might be in the middle of a list. Perhaps there is a way of making formatting codes visible in a document? And deleting unwanted ones? If not, perhaps it might be a good idea if one were to be introduced? ] best, /Gary -- 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] Re: Conditional Whitespace for Mail Merge
So it's a Calc sheet actually. I would simply use Calc to concatenate the
proper field contents and then use that calculated field for the mail merge.
Something like =TRIM($A2 $B2 $C2) with a column title in the firs
row copied down along the list.
A database query would be easier to handle because it automatically applies
to the whole record set:
Something like:
SELECT
LTRIM(CONCAT(Title,CONCAT(' ',CONCAT(ForeName,CONCAT(' ',LastName)
AS Full Name,
other fields
FROM Sheet1
This looks horrible because there is only a very limited set of functions
when you mis-use a spreadsheet for a database connection. But with the right
double-quoted names of sheets and columns it will generate a calculated
Full Name field on the fly.
Availlable SQL-functions with file based data sources
http://www.openoffice.org/dba/specifications/file_based_functions.html
Doing this in the last element of the chain is difficult. The only resource
I know is
http://openoffice.blogs.com/openoffice/2007/05/suppressing_bla.html
describing a solution for a similar problem.
--
View this message in context:
http://nabble.documentfoundation.org/Conditional-Whitespace-for-Mail-Merge-tp4139674p4139885.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] Re: Conditional Whitespace for Mail Merge
Hi Andreas,
thank you for your effort. :)
I got the fail.
Our concluded condition is working correctly.
Field type - Conditional Text
Condition: [Titel] !=
Then:
Else:
Now the big BUT!
If I click me through the mail merge assistant I got a document preview
where I can scroll through the data sets.
The document preview is displaying the whitespace anytime. (this lead me
astray)
If I print/save the mail merge document I can see that die conditional text
is working correctly. :)
I will file an error for this document preview behavior.
Thank you very much.
regards,
Sven
On Thu, Feb 12, 2015 at 4:23 PM, Andreas Säger ville...@t-online.de wrote:
So it's a Calc sheet actually. I would simply use Calc to concatenate the
proper field contents and then use that calculated field for the mail
merge.
Something like =TRIM($A2 $B2 $C2) with a column title in the firs
row copied down along the list.
A database query would be easier to handle because it automatically applies
to the whole record set:
Something like:
SELECT
LTRIM(CONCAT(Title,CONCAT(' ',CONCAT(ForeName,CONCAT('
',LastName)
AS Full Name,
other fields
FROM Sheet1
This looks horrible because there is only a very limited set of functions
when you mis-use a spreadsheet for a database connection. But with the
right
double-quoted names of sheets and columns it will generate a calculated
Full Name field on the fly.
Availlable SQL-functions with file based data sources
http://www.openoffice.org/dba/specifications/file_based_functions.html
Doing this in the last element of the chain is difficult. The only resource
I know is
http://openoffice.blogs.com/openoffice/2007/05/suppressing_bla.html
describing a solution for a similar problem.
--
View this message in context:
http://nabble.documentfoundation.org/Conditional-Whitespace-for-Mail-Merge-tp4139674p4139885.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
--
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] Writer: how to turn off auto-generated lists?
ha ha!I guess it doesn't surprise me. Thinking about it though, that's not what I normally do. What I do is to open a document, then create a new one from the filenew menu entry. This seems to me to be the best way to do it - but maybe I'm wrong. Anyway, I'm probably going to install the latest version very soon, so I'll see how that behaves!! Thanks,/G. From: Tom Davies tomc...@gmail.com To: Gary Collins gcatl...@yahoo.co.uk Cc: Sophie gautier.sop...@gmail.com; users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 12 February 2015, 13:30 Subject: Re: [libreoffice-users] Writer: how to turn off auto-generated lists? Hi :) There are various different layers of hidden codes. Ctrl A, Delete only gets rid of a few of them. Some can be seen by pressing the backwards sort of double-struck P in the toolbar icons. This shows non-printing characters, such as tabs and end-of-paragraphs, that don't get printed out. These are the ones that get deleted by Ctrl A, delete. If you poke around with a hex-editor or get even further (well, slightly further) down into the 1s and 0s (with a side-bar or something to see the ascii characters) then you see all sorts of weird characters, most of which are incomprehensible to almost anyone but some are human-readable and show things such as names, systems, occasionally even addresses and phone numbers from ancient times. I think some of the incomprehensible ones are the ones doing screwey things. Yeh, Windows tries to avoid letting people develop good habits and tries to push them into bad ones. One of my favs was Microsoft saying you should never accept cookies and never turn your anti-virus off for anything. Then their own website asked you to accept cookies and to install anything from them they would tell you to turn off your anti-virus. However if you did so and ran into troubles then 'experts' would blame the user for obviously bad habits and ignoring security issues. One wonders why people are so surprised that Windows so frequently runs into problems and is so open to malware and attacks. Regards from Tom :) On 12 February 2015 at 12:54, Gary Collins gcatl...@yahoo.co.uk wrote: Hi Tom, A lot of people seem to open an old document and then use that to create new documents [sometimes that's the easiest way in windows] but that way tons of hidden formatting codes and stuff seem to lurk and sometimes do some really odd things. [I'd have thought that selecting all with Ctrl-A and hitting del or backspace should remove everything? perhaps not?] CopyPasting as unformatted text into a fresh new document got rid of all sorts of weird problems. [I'll try that, it may well work] Writer doesn't seem to generate lists in the way described, at least not for me. Calc does, of course, but i usually have to select 3-4 cells and then drag. So i am not sure what is going on. [I've tried it here in the office with a new document, and it doesn't seem to do it here, either; so your explanation may well be right. I'm not sure if the version here and the version at home are the same, I'll check. The style in my home doc was default, and there was nothing I could find that indicated that it might be in the middle of a list. Perhaps there is a way of making formatting codes visible in a document? And deleting unwanted ones? If not, perhaps it might be a good idea if one were to be introduced? ] best, /Gary -- 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] installation problem LO4.4 - linux mint
hallo! I was curious to test LO4.4, so i tried to install it on Linux Mint 17 Qiana. I followed the installation instructions, first purged the old LO-version, downloaded the file, checked it, etc... installation worked fine. but when I try to start it, wheter from the icons or from the command line, i get this error message Libre Office 4.4 - Fatal Error The application cannot be started. User installation could not be completed. any ideas, why i get this error message and how to fix it? thank you, Markus -- 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] Re: Conditional Whitespace for Mail Merge
That wizard is counter productive and irritating for several reasons. You can create serial letters easier without it. Once you have a registered database connection to your list (F4 shows your database and tables), all you need to do is this: Select your table or query in the left pane and then drag column headers from the right pane into your document. -- View this message in context: http://nabble.documentfoundation.org/Conditional-Whitespace-for-Mail-Merge-tp4139674p4139898.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
