Re: [libreoffice-users] countif() problem in calc

2013-05-30 Thread James E. Lang
Correction: RANK() does not have this problem however I cannot use it without making a copy of the data that I'm attempting to rank since it is actually in several disjoint ranges and each call to RANK() must find the value or else an error is reported. COUNTIF() does not have this restriction.

[libreoffice-users] event interceptor

2013-05-30 Thread Vieri
Hi, I'm attaching a calc document with macros I took from oooforum.org. My goal is to have a macro intercept certain events such as underline or save. I'm supposing I need to somehow run the Basic macro register within the document. Could anyone please tell me why I'm getting the following

Re: [libreoffice-users] event interceptor

2013-05-30 Thread Vieri
--- On Thu, 5/30/13, Vieri rentor...@yahoo.com wrote: Hi, I'm attaching a calc document with macros I took from oooforum.org. My goal is to have a macro intercept certain events such as underline or save. I'm supposing I need to somehow run the Basic macro register within the document.

Re: [libreoffice-users] auto-spell checking not working on a fresh install.

2013-05-30 Thread Tom Davies
Hi :) Cool :)  I like the hierarchy view and hadn't known about it before.  It took me a bit of faffing around to find it.  Eventually noticed i had to scroll upwards in the drop-down list.  It's not intuitive to scroll upwards like that but it does make sense and once you know it's possible

Re: [libreoffice-users] countif() problem in calc

2013-05-30 Thread Brian Barker
At 20:49 29/05/2013 -0700, James E. Lang wrote: I am having a problem with a formula in Calc. The formula includes a call to function COUNTIF() which is miscounting in one case. The problem appears to be very sensitive to the data value in cell K3 as shown below. Cell E3 contains the value

[libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Tanstaafl
Hi all, Ok, I'm at my wits end. We have a Canon Imagerunner iR-ADV C5030/5035 UFR II. It has 4 paper trays: 2 for Letter (different orientations), one for Legal, and one for Tabloid. Microsoft office works fine under the following circumstances, but Libreoffice is driving me crazy. I

Re: [libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Brian Barker
At 08:26 30/05/2013 -0400, Charles Marcus wrote: Ok, I'm at my wits end. We have a Canon Imagerunner iR-ADV C5030/5035 UFR II. It has 4 paper trays: 2 for Letter (different orientations), one for Legal, and one for Tabloid. Microsoft Office works fine under the following circumstances, but

Re: [libreoffice-users] Re: How to extract a color from a text?

2013-05-30 Thread Dan Lewis
On 05/29/2013 03:34 PM, Regina Henschel wrote: Brian Barker schrieb: At 06:19 29/05/2013 -0400, Dan Lewis wrote: On 05/29/2013 12:36 AM, Axel Braun wrote: Yes, that works for colors that are known to the system, not for custom colors (like in imported documents) Try this: Open the Styles

Re: [libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Tanstaafl
On 2013-05-30 9:33 AM, Brian Barker b.m.bar...@btinternet.com wrote: I'm guessing here, but Microsoft Office has only one place to define page and paper size, I think, whereas LibreOffice has two: you define page size in Format | Page... but paper size at File | Printer Settings... (or

Re: [libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Malcolm Moore
We had enormous fun with printers that have lots of paper trays and sizesIt nearly drove me crazy printing in landscape when it should have beenportrait, using the wrong tray or just refusing to print in anything other than A4. The combination of wrong ways to do it seem endless ! In the end

Re: [libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Regina Henschel
Hi, Tanstaafl schrieb: Hi all, Ok, I'm at my wits end. We have a Canon Imagerunner iR-ADV C5030/5035 UFR II. It has 4 paper trays: 2 for Letter (different orientations), one for Legal, and one for Tabloid. Microsoft office works fine under the following circumstances, but Libreoffice is

Re: [libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Brian Barker
At 09:51 30/05/2013 -0400, Charles Marcus wrote: On 2013-05-30 9:33 AM, Brian Barker wrote: I'm guessing here, but Microsoft Office has only one place to define page and paper size, I think, whereas LibreOffice has two: you define page size in Format | Page... but paper size at File | Printer

[libreoffice-users] Creating EPUB e-books

2013-05-30 Thread James Knott
There has been some discussion about creating EPUB e-books from OpenOffice and LibreOffice. One method I recently came across is to use Sigil to create the EPUB from HTML. OpenOffice and LibreOffice can save in HTML format, which can then be used as a source for this application.

[libreoffice-users] Receiving duplicate msgs, no replay from list admin

2013-05-30 Thread John R. Sowden
Good Morning: I have been receiving duplicate messages from the libreoffice users mailing list for about a month. Multiple messages to users+ow...@global.libreoffice.org is only resulting in a boilerplate email that talks mainly about how to unsubscribe from the list. How do I get a

Re: [libreoffice-users] Creating EPUB e-books

2013-05-30 Thread Dan Lewis
On 05/30/2013 11:51 AM, James Knott wrote: There has been some discussion about creating EPUB e-books from OpenOffice and LibreOffice. One method I recently came across is to use Sigil to create the EPUB from HTML. OpenOffice and LibreOffice can save in HTML format, which can then be used as

[libreoffice-users] Default Superscript and Subscript size

2013-05-30 Thread Tim Vivian-Griffiths
Dear all, Just wondering if someone could help me with this. I have posted a question in the openoffice forums, but I wasn't able to get any help, and someone advised me to maybe report a bug. Basically, I am trying to change the default size of the superscript and subscript to make them

Re: [libreoffice-users] Receiving duplicate msgs, no replay from list admin

2013-05-30 Thread Tom Davies
Hi :) Ouch!  I vaguely  remember you posting about this before but then lost track of it.  Do you have 2 or more email accounts with 2 of them subscribed to the mailing list?  It might be worth unsubscribing yourself and then re-subscribe about a day later.  Monitor what happens during that

Re: [libreoffice-users] Creating EPUB e-books

2013-05-30 Thread Marc Grober
Perhaps better solutions can be found in using the elaix extension or by saving as docxml and thenfeeding the result through pandoc On 5/30/13 7:51 AM, James Knott wrote: There has been some discussion about creating EPUB e-books from OpenOffice and LibreOffice. One method I recently came

Re: [libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Tanstaafl
On 2013-05-30 10:43 AM, Regina Henschel rb.hensc...@t-online.de wrote: If I change the paper size to Tabloid Print dialog does show it in landscape mode, but the paper size is showing as Letter, NOT tabloid. You have changed to Tabloid in Format Page _and_ in printing dialog Properties ...

Re: [libreoffice-users] LO Base/MySQL Backup??

2013-05-30 Thread Girvin R. Herr
Sajan Steve, Thanks. I will have to look at this as an alternate possibility. I didn't mean to criticize, but I take computer security seriously and when I see a vulnerability, I tend to bring it to the person's attention. There are far too many people out there who take computer security

Re: [libreoffice-users] LO Base/MySQL Backup??

2013-05-30 Thread Tom Davies
Hi :) I think for a lot of us on the list that have been lurking around this topic the security issue has been interesting.  I think this discussion and the different approaches to dealing with the issue may well help some of us in the future.  many thanks to all that have posted in this

Re: [libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Regina Henschel
Hi, I have searched AOO Bugzilla and found this one https://issues.apache.org/ooo/show_bug.cgi?id=112863 It seems to be indeed a problem with sign tabloid. Kind regards Regina Tanstaafl schrieb: On 2013-05-30 10:43 AM, Regina Henschel rb.hensc...@t-online.de wrote: If I change the paper

[libreoffice-users] Re: [LO-marketing] Microsoft seems to have bought advertising space on our twitter timeline

2013-05-30 Thread Tom Davies
Hi :) Apparently MS have bought advertising space from LibreOffice.  Does anyone know what this means in practice?  Does it mean that every-time someone looks up LibreOffice in twitter then 1 of the top entries is for MS Office?  I don't understand how to view this.  Do i have to get a twitter

Re: [libreoffice-users] Re: Tracking changes in LibO writer

2013-05-30 Thread sun shine
On 28/05/13 14:29, Werner F. Bruhin wrote: Hi, On 28/05/2013 14:23, sun shine wrote: Hello list ... Don't have solution for you Also, BTW: what purpose is there in recording changes but not showing them, which the Edit - Changes menu allows for? Wouldn't it be more straight forward to

Re: [libreoffice-users] Default Superscript and Subscript size

2013-05-30 Thread Tom Davies
Hi :) Did you get any answers at all over at the AOO forums?  Any chance of giving us a link to your thread there?  Regards from Tom :)  From: Tim Vivian-Griffiths timv...@gmail.com To: LibreOffice users@global.libreoffice.org Sent: Thursday, 30 May

Re: [libreoffice-users] Creating EPUB e-books

2013-05-30 Thread Daniel A. Rodriguez
There has been some discussion about creating EPUB e-books from OpenOffice and LibreOffice. One method I recently came across is to use Sigil to create the EPUB from HTML. OpenOffice and LibreOffice can save in HTML format, which can then be used as a source for this application.

[libreoffice-users] test-delete me

2013-05-30 Thread John R. Sowden
test-delete me -- 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:

Re: [libreoffice-users] Default Superscript and Subscript size

2013-05-30 Thread Steve Edmonds
Hi. To have the settings (changes) you make stay for a new document you may need to make these changes to the default style and then save the document as a template and make it your default. This is the first thing I do as I do not like the default font and margins. Steve On 2013-05-31

off-list Re: [libreoffice-users] test-delete me

2013-05-30 Thread Tom Davies
Hi :) We got that on the Users List without it even being held up at the moderators so you haven't unsubscribed yet.  Try these instructions http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Regards from Tom :)  From: John R. Sowden

weird email problems with list, was: Fw: [libreoffice-users] To the moderators

2013-05-30 Thread Tom Davies
Hi :) I don't know of anyone else having those issues.  Can you check your settings or post a question to your email-client's forums/mailing-list?  Is there something obviously wrong in your email headers?  Have you emptied your email-client's trash-can?  how is your normal internet connection? 

Re: [libreoffice-users] Default Superscript and Subscript size

2013-05-30 Thread Tim Vivian-Griffiths
Dear all, Thank you very much for your replies. Here is the link to my post in the forum: http://forum.openoffice.org/en/forum/viewtopic.php?f=7t=61594 I have put a fair bit of description of the issue there, but let me know if I can give any more information. I have tried to save the

[libreoffice-users] test3-delete me

2013-05-30 Thread John R. Sowden
-- 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

[libreoffice-users] Upgrading Version 10.04

2013-05-30 Thread George R. Crossman
I would like to upgrade my current Ubuntu version 10.04 to the new 12.04.2. Can someone outline the steps which I need to take to accomplish this? Thanks. George Crossman -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] How to insert a row between current fields?

2013-05-30 Thread minhsien0330
Dear all: When editing field names in Design View in Libreoffice Base, I cannot insert a new row between current fields. If I click the Insert Rows, Base will add a new row at the end of this table, but not the current site. Does Base not support insert a new field that just like Calc does?

[libreoffice-users] What happened to autoformat option?

2013-05-30 Thread Girvin R. Herr
Greetings, I upgraded to LO 3.6.6.2 and just installed it on my HP laptop. However, Calc keeps changing the 1st character of a filename in a text cell to upper case. If I go back and edit it back to lower case, it sticks. However, it is a pain to have to do this every entry and the

Re: [libreoffice-users] What happened to autoformat option?

2013-05-30 Thread Steve Edmonds
Hi. What about FormatAutocorrectAutocorrect optionsOptions. Untick capitalise first letter... On 31/05/13 1:21 PM, Girvin R. Herr wrote: Greetings, I upgraded to LO 3.6.6.2 and just installed it on my HP laptop. However, Calc keeps changing the 1st character of a filename in a text cell to

Re: [libreoffice-users] Upgrading Version 10.04

2013-05-30 Thread Keith Bates
This is the libre-office list not a Ubuntu list, but we won't hold that against you. Try this article http://www.omgubuntu.co.uk/2012/04/ubuntu-10-04-12-04-upgrade-how-well-does-it-go which I just found by googling upgrade ubuntu 10.04 to 12.04 Keith On 31/05/13 09:54, George R. Crossman