[libreoffice-users] http://www.LinuxQuestions.org 2012 Annual Poll

2013-02-02 Thread Marc Paré
Hi everyone, FYI, there are just less than 72 hours left to join in on the yearly LinuxQuestions.org poll 2012! One of the categories is Office Suite of the Year of course. LibreOffice won this category last year. Let's make it the winner again this year! Go to

[libreoffice-users] stop updates please

2013-02-02 Thread Betty
Hi, I am receiving too many emails. Would you please take me off the mailing list. Thank you, Betty -- 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:

Re: [libreoffice-users] stop updates please

2013-02-02 Thread Tom Davies
Hi :) Please unsubscribe yourself.  For instructions please send an email to users+h...@global.libreoffice.org Note that if you just click on that it sometimes ignores the users+ bit at the start but that is the crucial bit.  So you need to copypaste the whole of that line into the To

[libreoffice-users] Feature request regarding LibreOffice Calc SUBSTITUTE() cell function

2013-02-02 Thread Johnny Rosenberg
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=60183 Thoughts? Johnny Rosenberg -- 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:

[libreoffice-users] spelling + grammar checker in writer

2013-02-02 Thread Walther Koehler
Hi folks, I am using the spelling and grammar checker quite often. However, there are some nasty drawbacks (in all versions of OO and LO I know): - any manual correction outside the (red marked) word will result in either reevaluation of the whole paragraph, loss of hard formats in that

[libreoffice-users] Calc SUM Error 502 - How to add results of three IF formulae?

2013-02-02 Thread Hylton Conacher (ZR1HPC)
Hi, I have a formula below which is giving me an Err: 502 on Calc 3.4.5 when I try and calculate a currency total using a sliding scale. =SUMIF(b6c2,d2,0),(IF(b6-c2)c3,d3,0),(IF(b6-c2-c3)c4,sum((b6-c2)-c3)*b4,0 Each IF statement outs only a single answer and all I want to do is SUM

Re: [libreoffice-users] spelling + grammar checker in writer

2013-02-02 Thread webmaster-Kracked_P_P
On 02/02/2013 07:30 AM, Walther Koehler wrote: Hi folks, I am using the spelling and grammar checker quite often. However, there are some nasty drawbacks (in all versions of OO and LO I know): - any manual correction outside the (red marked) word will result in either reevaluation of the whole

Re: [libreoffice-users] Calc SUM Error 502 - How to add results of three IF formulae?

2013-02-02 Thread Brian Barker
At 16:35 02/02/2013 +0200, Hylton Conacher wrote: I have a formula below which is giving me an Err: 502 on Calc 3.4.5 when I try and calculate a currency total using a sliding scale. =SUMIF(b6c2,d2,0),(IF(b6-c2)c3,d3,0),(IF(b6-c2-c3)c4,sum((b6-c2)-c3)*b4,0 That's not surprising.

[libreoffice-users] VLOOKUP Problem

2013-02-02 Thread John Meyer
I have two columns. Column A displays the logon names being used and Column B contains all possible logons (technically it's on another sheet, but I'll simplify). What I want to appear on column C is a list of all logons that are not being used. For instance: COLUMNA: Frank Harry George

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread John Meyer
I figured as much. That shouldn't be a problem as long as I make sure it fires on every update of column B. On Sat, Feb 2, 2013 at 8:53 AM, Johnny Rosenberg gurus.knu...@gmail.comwrote: 2013/2/2 John Meyer john.l.me...@gmail.com: I have two columns. Column A displays the logon names being

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Brian Barker
At 08:31 02/02/2013 -0700, John Meyer wrote: I have two columns. Column A displays the logon names being used and Column B contains all possible logons (technically it's on another sheet, but I'll simplify). What I want to appear on column C is a list of all logons that are not being used.

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Brian Barker
At 08:31 02/02/2013 -0700, John Meyer wrote: I have two columns. Column A displays the logon names being used and Column B contains all possible logons (technically it's on another sheet, but I'll simplify). What I want to appear on column C is a list of all logons that are not being used.

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread John Meyer
BTW, this is off topic, but is there any way to configure GMail so when I hit reply I reply to the list and not to the person? On Sat, Feb 2, 2013 at 9:57 AM, John Meyer john.l.me...@gmail.com wrote: I'll try it out. Personally I don't know why I'm a neat freak in terms of not wanting

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Johnny Rosenberg
2013/2/2 John Meyer john.l.me...@gmail.com: BTW, this is off topic, but is there any way to configure GMail so when I hit reply I reply to the list and not to the person? The new behaviour of this list sucks badly for us gmail users. In most cases I accidently relies to the person rather than

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Keith E .
On Sat, 2 Feb 2013 08:31:35 -0700, John Meyer john.l.me...@gmail.com wrote: I have two columns. Column A displays the logon names being used and Column B contains all possible logons (technically it's on another sheet, but I'll simplify). What I want to appear on column C is a list of all

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Kieran Peckett
John: there is a lab (i forget its name) that puts reply to all the first option in the reply box, and on the top-right of the message On 2 February 2013 17:12, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2013/2/2 John Meyer john.l.me...@gmail.com: BTW, this is off topic, but is there any

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Brian Barker
At 12:23 02/02/2013 -0500, Keith Eonly wrote: On Sat, 2 Feb 2013 08:31:35 -0700, John Meyer wrote: I have two columns. Column A displays the logon names being used and Column B contains all possible logons (technically it's on another sheet, but I'll simplify). What I want to appear on

[libreoffice-users] Re: LO 4.0.0.3 has no printer in Win7 - SHOW STOPPER

2013-02-02 Thread V Stuart Foote
Bug fdo#60177 https://bugs.freedesktop.org/show_bug.cgi?id=60177 resolved as invalid after successful installation and printer function. Anyone experiencing similar printer configuration issue on LibreOffice for Windows upgrade to 4.0.0.3 RC3, i.e. Print dialogs show no printers, please

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Tom Davies
Hi :) Just use Reply to all or Group Reply.  Don't bother about editing all the different names, just leave 1 or 2 or so in the To field and then you don't need to copypaste from the CC.  It is a pain but the delete key is quite useful when you get too many copies of the same email.  Regards

[libreoffice-users] Re: [libreoffice-design] Re: LO Writer UI Analysis

2013-02-02 Thread Wolfgang Keller
MS has always been at the antipode of ergonomics. And they keep moving in the *wrong* direction. Ribbons ... are just the latest cerebral flatulances emanating from their product managers' brains. Lol! This is *not at all* fun for those screen-labourslaves who are concerned. By

Re: [libreoffice-users] Re: Base Report Builder

2013-02-02 Thread Wolfgang Keller
Lol!  I liked that post.  Very funny.  The reality is much less funny for all screen-labourslaves who have to work in those pathologically dysfunctional organisations. I thought PostgreSQL was for large databases? It's for anything.  Also i thought Firebird was supposed to be quite good?

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread John Meyer
Okay. I guess I can do that, even though I'd like a reply to list option (maybe an idea for a google lab, eh) On Sat, Feb 2, 2013 at 11:28 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Just use Reply to all or Group Reply. Don't bother about editing all the different names, just

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Johnny Rosenberg
2013/2/2 Kieran Peckett crazyske...@gmail.com: John: there is a lab (i forget its name) that puts reply to all the first option in the reply box, and on the top-right of the message What is a ”lab”? Johnny Rosenberg On 2 February 2013 17:12, Johnny Rosenberg gurus.knu...@gmail.com wrote:

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Dan Lewis
If you look at my address above, you will see that I use Gmail. My email client is Thunderbird which has choices as to how to reply: Reply to List (possibly because the mail headers contain a reply to), Reply or Reply to all (when there does not seem to be a reply to in the mail

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Johnny Rosenberg
2013/2/2 John Meyer john.l.me...@gmail.com: I have two columns. Column A displays the logon names being used and Column B contains all possible logons (technically it's on another sheet, but I'll simplify). What I want to appear on column C is a list of all logons that are not being used.

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Johnny Rosenberg
2013/2/2 Dan Lewis elderdanle...@gmail.com: If you look at my address above, you will see that I use Gmail. My email client is Thunderbird which has choices as to how to reply: Reply to List (possibly because the mail headers contain a reply to), Reply or Reply to all (when there does

Re: [libreoffice-users] VLOOKUP Problem

2013-02-02 Thread Johnny Rosenberg
Okay, I was too quick there. See corrections below. 2013/2/2 Johnny Rosenberg gurus.knu...@gmail.com: 2013/2/2 John Meyer john.l.me...@gmail.com: I have two columns. Column A displays the logon names being used and Column B contains all possible logons (technically it's on another sheet, but

[libreoffice-users] Serious problems with Insert Movie and Sound... on MAC OS X 2 bugs.

2013-02-02 Thread Declan Moriarty
I am converting a load of documents to MS Word, ODF and PDF formats.  I emailed this list some time back since some Word 97 files that I thought should work in LibreOffice wouldn't open.  I submitted a bug for this which has now been fixed. I decided to convert all this batch of old Word

Re: [libreoffice-users] Re: LO 4.0.0.3 has no printer in Win7 - SHOW STOPPER

2013-02-02 Thread webmaster-Kracked_P_P
On 02/02/2013 01:01 PM, V Stuart Foote wrote: Bug fdo#60177 https://bugs.freedesktop.org/show_bug.cgi?id=60177 resolved as invalid after successful installation and printer function. Anyone experiencing similar printer configuration issue on LibreOffice for Windows upgrade to 4.0.0.3 RC3, i.e.

[libreoffice-users] Re: LO 4.0.0.3 has no printer in Win7 - SHOW STOPPER

2013-02-02 Thread V Stuart Foote
Tim, Good idea. I'll poke around on the Wiki's and see if I can find a good spot to insert it. Of course folks would then need to realize they'd need to look in the Wiki to get the information on how to capture a log of the install if they're having problems with a Windows installation. Suspect

Re: [libreoffice-users] Re: LO 4.0.0.3 has no printer in Win7 - SHOW STOPPER

2013-02-02 Thread Tom Davies
Hi :) I think https://wiki.documentfoundation.org/BugReport already has something about how to get an strace or something in Windows.  Perhaps somewhere in that page would be good. Regards from Tom :)  From: V Stuart Foote vstuart.fo...@utsa.edu To:

Re: [libreoffice-users] Re: LO 4.0.0.3 has no printer in Win7 - SHOW STOPPER

2013-02-02 Thread webmaster-Kracked_P_P
Lets make it easier for people than dealing with a bug report process. Make it a place where you will find info to save or get before you make a bug report. I had to make an account to get into the bug reporting system. How many people do you want to do that and then search for answers?