Issue with code

[Joseph Da Silva]

Hi

Here is the code I am having an issue with in open org works in excel

=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0))))) There seems there is an issue with the CELL command and using 3.30 version on windows 7 Any advise would be appreciated. Thanks for your time and consideration --
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help

[Eike Rathke]

Hi Joseph,

Post by Joseph Da Silva
Here is the code I am having an issue with in open org works in excel
=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0)))))
There seems there is an issue with the CELL command and using 3.30
version on windows 7 Any advise would be appreciated. Thanks for your
time and consideration

And the issue is?

Eike

P.S.: As you're not subscribed to the mailing list you were posting to,
you will miss replies that are directed to the list only. When answering,
please reply only to the list (Reply-To header is set), not to my
personal account. Thanks.

[Joseph Da Silva]

Hi

Thanks for the quick reply

=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0))))

The issue is I am getting a 508 with version 3.30 error but works fine with Microsoft Excel

Thanks

Date: Sun, 7 Aug 2011 22:03:15 +0200
Subject: Re: [discuss] Issue with code
Hi Joseph,

Post by Joseph Da Silva
Here is the code I am having an issue with in open org works in excel
=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0)))))
There seems there is an issue with the CELL command and using 3.30
version on windows 7 Any advise would be appreciated. Thanks for your
time and consideration

And the issue is?
Eike
P.S.: As you're not subscribed to the mailing list you were posting to,
you will miss replies that are directed to the list only. When answering,
please reply only to the list (Reply-To header is set), not to my
personal account. Thanks.
--
PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication.
Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD

--
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help

[Eike Rathke]

Hi Joseph,

Post by Joseph Da Silva
=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0))))
The issue is I am getting a 508 with version 3.30 error but works fine with Microsoft Excel

Err:508 is an "errPairExpected" and probably due to the extraneous
parenthesis in the expression at the end you had in your previous mail,
not in this one, try to remove that.

Other than that, in OOo the parameter separator is a ; semicolon, not
a comma, unless you use a go-oo / LibreOffice that comes with your Linux
distribution. Check under Tools->Options->Calc->Formula if there are
separator settings.

Eike

[Joseph Da Silva]

Hi Eike,

Thank you for your response I have tried your suggestions and have provided a sample file with the formula.

If you have a chance take a look.

Thanks

Date: Mon, 8 Aug 2011 22:42:26 +0200
Subject: Re: [discuss] Re: Issue with code
Hi Joseph,

Post by Joseph Da Silva
=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0))))
The issue is I am getting a 508 with version 3.30 error but works fine with Microsoft Excel

Err:508 is an "errPairExpected" and probably due to the extraneous
parenthesis in the expression at the end you had in your previous mail,
not in this one, try to remove that.
Other than that, in OOo the parameter separator is a ; semicolon, not
a comma, unless you use a go-oo / LibreOffice that comes with your Linux
distribution. Check under Tools->Options->Calc->Formula if there are
separator settings.
Eike
--
PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication.
Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD

[Harold Fuchs]

Post by Joseph Da Silva
Hi Eike,
Thank you for your response I have tried your suggestions and have provided a sample file with the formula.
If you have a chance take a look.
Thanks

<snip>

Replace all the commas (",") with semicolons (";"). Your formula then works.

[Johnny Rosenberg]

Post by Joseph Da Silva
Hi
Here is the code I am having an issue with in open org works in excel
=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0)))))

Have you tried to select that cell and then hit Ctrl+F2? Then you can
easier debug the formula, by placing the cursor in different places of
the formula to see the results of different parts of the formula.
I don't know for sure, but aren't you supposed to use a ”;”
(semicolon) as a parameter separator rather than a ”,” (comma)? Or
maybe both work these days.

Post by Joseph Da Silva
There seems there is an issue with the CELL command and using 3.30 version
on windows 7
Any advise would be appreciated.
Thanks for your time and consideration

I'm not sure that I helped at all, though…


Regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

[Steve Ahlers]

Could it be that you have 6 closing parenthesis and only 5 opening parenthesis.

Steve
Sent from my iPad

Post by Johnny Rosenberg

Post by Joseph Da Silva
Hi
Here is the code I am having an issue with in open org works in excel
=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0)))))

Have you tried to select that cell and then hit Ctrl+F2? Then you can
easier debug the formula, by placing the cursor in different places of
the formula to see the results of different parts of the formula.
I don't know for sure, but aren't you supposed to use a ”;”
(semicolon) as a parameter separator rather than a ”,” (comma)? Or
maybe both work these days.

Post by Joseph Da Silva
There seems there is an issue with the CELL command and using 3.30 version
on windows 7
Any advise would be appreciated.
Thanks for your time and consideration

I'm not sure that I helped at all, though…
Regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
-----------------------------------------------------------------
with Subject: help

[john tyler]

why are you assholes mailing me this shit? o0o sucks anyway

Date: Sun, 7 Aug 2011 22:09:57 +0200
Subject: [discuss] Re: Issue with code

Post by Joseph Da Silva
Hi
Here is the code I am having an issue with in open org works in excel
=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0)))))

Have you tried to select that cell and then hit Ctrl+F2? Then you can
easier debug the formula, by placing the cursor in different places of
the formula to see the results of different parts of the formula.
I don't know for sure, but aren't you supposed to use a $B!I(B;$B!I(B
(semicolon) as a parameter separator rather than a $B!I(B,$B!I(B (comma)? Or
maybe both work these days.

Post by Joseph Da Silva
There seems there is an issue with the CELL command and using 3.30 version
on windows 7
Any advise would be appreciated.
Thanks for your time and consideration

I'm not sure that I helped at all, though$B!D(B
Regards
Johnny Rosenberg
$B%8%g%K!<!&%m!<%<%s%P!<%0(B
--
-----------------------------------------------------------------
with Subject: help

--
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help

[RA Brown]

John,

You need to address the message to discuss-***@openoffice.org
not put it in the subject. As for why your getting the messages you
signed up for them, and you have to unsubscribe yourself.

[john tyler]

netiquette demands that unsubscribing works by inserting the request in the subject line

this is a typical example of why I would never dream of using open office: why make it simple if you can fuck it up?

I don't care who has registered in my name or with my account or how that has been done, I have a very poor opinion of open office and that's that.

Date: Sun, 7 Aug 2011 16:58:08 -0700
John,
not put it in the subject. As for why your getting the messages you
signed up for them, and you have to unsubscribe yourself.
--
-----------------------------------------------------------------
with Subject: help

--
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help

[Mathias Bauer]

Hi,

with the explicit wording you have used in your mail I doubt that you
are qualified to write about netiquette.

Besides that, this is not a matter of netiquette, it's a matter of how
the mailing list software works. The ML software of OOo works as it
works, and I know other project where it works in the same way. That
doesn't mean that it is perfect, but OTOH it's easy to understand and
you are told how it works in every mail you receive. Being able to read
is a clear advantage that you shouldn't abandon.

Nevertheless, in case you are unable to read or follow the advice in the
mail footer for whatever reason, usually kind people would help to
unsubscribe you in case you asked politely. In case you know what
"polite" means.

Maybe you don't understand what I have written above. So let me
translate it into your "language":

You showed a typical example of making a fool of yourself by choosing an
inadequate communication style: why make it simple if you can fuck it up?

I don't care who has registered in your name or with your account of how
that has been done, I have a very poor opinion of you and that's that.

Please apologize if my translation lacks the "elegance" of your own
wording, my knowledge of your "language" is somewhat limited.

Regards,
Mathias

Post by john tyler
netiquette demands that unsubscribing works by inserting the request in the subject line
this is a typical example of why I would never dream of using open
office: why make it simple if you can fuck it up?
I don't care who has registered in my name or with my account or how
that has been done, I have a very poor opinion of open office and that's
that.

Date: Sun, 7 Aug 2011 16:58:08 -0700
John,
not put it in the subject. As for why your getting the messages you
signed up for them, and you have to unsubscribe yourself.
--
-----------------------------------------------------------------
with Subject: help

[Tim Fairchild]

Post by Mathias Bauer
Please apologize if my translation lacks the "elegance" of your own
wording, my knowledge of your "language" is somewhat limited.

lol Mathias. Very elegant :)

And I have literally written millions of words with OOo. I would be lost
without it and the OOo team.

tim.
--
Author, dog lover, strange dude in general.
Book: https://www.smashwords.com/profile/view/ATF
Blog: http://amostfairchild.blogspot.com/
Page: http://bcss4me.com

[William W. Austin]

Post by Tim Fairchild

Post by Mathias Bauer
Please apologize if my translation lacks the "elegance" of your own
wording, my knowledge of your "language" is somewhat limited.

lol Mathias. Very elegant :)
And I have literally written millions of words with OOo. I would be lost
without it and the OOo team.
tim.

[SNIP]

I would have to second Tim's statement:
"I would be lost without it and the OOo team."

Although I have only written 2 novels with it (one in negotiation, one
sold months ago, still waiting to be published [so I'm told] "as soon
as the economy improves..." Oh for more "spare time"), together with
others at my office, we we have written around 2,000 technical
documents ranging from a few pages to over 2500. And by the way, some
of them are sufficiently complex that they invariably crash MS word.

We adopted the OASIS formats years ago (originally under StarOffice,
later OOo) when it was clear that they would be around for a long time
and were NOT a closed, intentionally obfuscated, proprietary set of
formats lacking any published specifications, a "standard" which seems
to change without warning at the whim of a single, intractable
corporation whose sole motive seems to be profit at the expense of the
integrity, preservation, and long-term use or reuse of information.

I'm not knocking profit as a motive -- quite the opposite. However,
try taking an MS Word 2.0 document and putting it on your windows 7
machine with the "latest and greatest" release of office on it. You
can't. Case closed.

(And finally, since when did proper "netiquette" include gratuitous
profanity?)

- bill

[c***@tadaust.org.au]

STOP SENDING ME YOUR FUCKEN EMAILS TO ME, EVERY DAY I GET UP TO 20 EMAIL
MESSAGES, AM FUCKEN SICK AND TIRED OF IT, OR I WILL FUCKEN DEAL WITH YOU,
YOU GOT KNOW IDEA WHO YOU ARE DEALING WITH, SO FUCK OFF OR ELSE,,

-----Original Message-----
From: Tim Fairchild
Sent: Monday, August 08, 2011 7:40 PM

Post by Mathias Bauer
Please apologize if my translation lacks the "elegance" of your own
wording, my knowledge of your "language" is somewhat limited.

lol Mathias. Very elegant :)

And I have literally written millions of words with OOo. I would be lost
without it and the OOo team.

tim.
--
Author, dog lover, strange dude in general.
Book: https://www.smashwords.com/profile/view/ATF
Blog: http://amostfairchild.blogspot.com/
Page: http://bcss4me.com
--
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help


-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1392 / Virus Database: 1520/3822 - Release Date: 08/08/11

[Tim Fairchild]

The trolls seem to be bad lately...

tim
--
Author, dog lover, strange dude in general.
Book: https://www.smashwords.com/profile/view/ATF
Blog: http://amostfairchild.blogspot.com/
Page: http://bcss4me.com

[Fernando Cassia]

It seems the paychecks from Redmond stopped coming and there´s a room
full of trolls subscribed to this mailing list who are now locked
inside and hungry, they can´t even order pizza to be slipped under the
door as they ran out of money...

What a tragedy...
FC

Post by Tim Fairchild
The trolls seem to be bad lately...

--
"Si, yo creo en los objetos. Inclusive más que en los seres humanos.
Creo que son más fieles ¿no?. Porque, claro, los seres humanos pueden
traicionarte, pero los objetos no, a los objetos
los traicionamos nosotros."
                                     -Manuel Mujica Laines

[h***@cox.net]

Post by c***@tadaust.org.au
STOP SENDING ME YOUR FUCKEN EMAILS TO ME, EVERY DAY I GET UP TO 20
EMAIL MESSAGES, AM FUCKEN SICK AND TIRED OF IT, OR I WILL FUCKEN
DEAL WITH YOU, YOU GOT KNOW IDEA WHO YOU ARE DEALING WITH, SO FUCK
OFF OR ELSE,,

Put Daddy's computer back before he comes home. Remember what he did to
your naughty parts the last time he caught you playing with his
computer? You don't want that to happen again, do you?

[Paul]

Post by c***@tadaust.org.au
STOP SENDING ME YOUR FUCKEN EMAILS TO ME, EVERY DAY I GET UP TO 20 EMAIL
MESSAGES, AM FUCKEN SICK AND TIRED OF IT, OR I WILL FUCKEN DEAL WITH YOU,
YOU GOT KNOW IDEA WHO YOU ARE DEALING WITH, SO FUCK OFF OR ELSE,,

Shut up you dipshit - how in the world are you going to "deal" with email
list management software you dumb ass .. Stupid Australian dick head... I've
blacklisted you now so that should stop the emails.... Please next time do
everyone a favour and turn your computer off...

/paul

Post by c***@tadaust.org.au
-----Original Message----- From: Tim Fairchild
Sent: Monday, August 08, 2011 7:40 PM

Post by Mathias Bauer
Please apologize if my translation lacks the "elegance" of your own
wording, my knowledge of your "language" is somewhat limited.

lol Mathias. Very elegant :)
And I have literally written millions of words with OOo. I would be lost
without it and the OOo team.
tim.
--
Author, dog lover, strange dude in general.
Book: https://www.smashwords.com/**profile/view/ATF<https://www.smashwords.com/profile/view/ATF>
Blog: http://amostfairchild.**blogspot.com/<http://amostfairchild.blogspot.com/>
Page: http://bcss4me.com
--
------------------------------**------------------------------**-----
with Subject: help
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1392 / Virus Database: 1520/3822 - Release Date: 08/08/11
--
------------------------------**------------------------------**-----
with Subject: help

[Fernando Cassia]

. Stupid Australian dick head..

I agree with everything expect the "Australian" part. Let´s hope not
all Australians are like him. In fact, I know quite a few who are
brilliant, lovely human beings.

;)

Now, could the next troll please enter the stage? We´re on a schedule
here... ;))

FC

[Paul]

Post by Paul
. Stupid Australian dick head..

I agree with everything expect the "Australian" part. LetŽs hope not

Totally agree, but being a kiwi there had to be some Aussie knocking - its
traditional...

/paul

[c***@tadaust.org.au]

Call me an Australian dipship, and Dumb ass,Its time we met, fuck wit, and then I will deal with you, my way,

From: Paul
Sent: Tuesday, August 09, 2011 6:58 PM
To: ***@openoffice.org ; ***@tadaust.org.au
Subject: [discuss] Re: discuss-***@openoffice.org




On Tue, Aug 9, 2011 at 4:02 PM, <***@tadaust.org.au> wrote:

STOP SENDING ME YOUR FUCKEN EMAILS TO ME, EVERY DAY I GET UP TO 20 EMAIL MESSAGES, AM FUCKEN SICK AND TIRED OF IT, OR I WILL FUCKEN DEAL WITH YOU, YOU GOT KNOW IDEA WHO YOU ARE DEALING WITH, SO FUCK OFF OR ELSE,,



Shut up you dipshit - how in the world are you going to "deal" with email list management software you dumb ass .. Stupid Australian dick head... I've blacklisted you now so that should stop the emails.... Please next time do everyone a favour and turn your computer off...

/paul


-----Original Message----- From: Tim Fairchild
Sent: Monday, August 08, 2011 7:40 PM

To: ***@openoffice.org
Subject: [discuss] Re: discuss-***@openoffice.org


On 8/08/2011 8:00 PM, Mathias Bauer wrote:

Please apologize if my translation lacks the "elegance" of your own
wording, my knowledge of your "language" is somewhat limited.



lol Mathias. Very elegant :)

And I have literally written millions of words with OOo. I would be lost
without it and the OOo team.

tim.

--
Author, dog lover, strange dude in general.
Book: https://www.smashwords.com/profile/view/ATF
Blog: http://amostfairchild.blogspot.com/
Page: http://bcss4me.com

--
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help



-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1392 / Virus Database: 1520/3822 - Release Date: 08/08/11
--
-----------------------------------------------------------------

To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help



--------------------------------------------------------------------------------

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1390 / Virus Database: 1520/3824 - Release Date: 08/09/11

[Paul]

Post by c***@tadaust.org.au
Call me an Australian dipship, and Dumb ass,Its time we met, fuck wit,
and then I will deal with you, my way,

I actually called you a dip *shit*, you ignorant piss ant ... And to be
honest if you stop acting like one, or showed a modacum of manners it
wouldn't have happened... And please stop with the inane threats - they are
about as intimadating as the Australian rugby team was when they were pwned
by our team (all blacks).

/paul

Post by c***@tadaust.org.au
*Sent:* Tuesday, August 09, 2011 6:58 PM

Post by c***@tadaust.org.au
STOP SENDING ME YOUR FUCKEN EMAILS TO ME, EVERY DAY I GET UP TO 20 EMAIL
MESSAGES, AM FUCKEN SICK AND TIRED OF IT, OR I WILL FUCKEN DEAL WITH YOU,
YOU GOT KNOW IDEA WHO YOU ARE DEALING WITH, SO FUCK OFF OR ELSE,,

Shut up you dipshit - how in the world are you going to "deal" with email
list management software you dumb ass .. Stupid Australian dick head... I've
blacklisted you now so that should stop the emails.... Please next time do
everyone a favour and turn your computer off...
/paul

Post by c***@tadaust.org.au
-----Original Message----- From: Tim Fairchild
Sent: Monday, August 08, 2011 7:40 PM

Post by Mathias Bauer
Please apologize if my translation lacks the "elegance" of your own
wording, my knowledge of your "language" is somewhat limited.

lol Mathias. Very elegant :)
And I have literally written millions of words with OOo. I would be lost
without it and the OOo team.
tim.
--
Author, dog lover, strange dude in general.
Book: https://www.smashwords.com/**profile/view/ATF<https://www.smashwords.com/profile/view/ATF>
Blog: http://amostfairchild.**blogspot.com/<http://amostfairchild.blogspot.com/>
Page: http://bcss4me.com
--
------------------------------**------------------------------**-----
with Subject: help
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1392 / Virus Database: 1520/3822 - Release Date: 08/08/11
--
------------------------------**------------------------------**-----
with Subject: help

------------------------------
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1390 / Virus Database: 1520/3824 - Release Date: 08/09/11

[Eike Rathke]

Hi,

Can all please stop this thread?

Thanks
Eike

[Joshua Lee]

LMAO, +10 points to Mathias Bauer for slamming that idot John Tyler in the most polite way I've ever seen.
I can't believe there are instructions at the bottom of EVERY email, including the one generated by his message, on how to subscribe, and he's too stupid to follow those instructions.
I mean, if you are reading this John, please don't' go killing yourself or anything, maybe you're just having a bad day. The instructions were: To unsubscribe send email to discuss-***@openoffice.org
But seriously, he came across as SUCH a douche, and Mathias, I've never seen such a polite ass woopin online before, that rocked,.. it made my day.


________________________________

Joshua R. Lee
Senior Software Engineer
Global Telecom & Technology
8484 Westpark Drive, Suite 720
McLean, VA 22102 USA
Office [phone] ext 528
Direct [phone]
Cell [phone]
Fax [phone]
***@GT-T.net

The information in this transmittal (including attachments, if any) is confidential, is intended only for the use of the individual named above, and includes information which is or may be legally privileged. Any review, use, copying, disclosure, dissemination or distribution of the information in this transmittal other than by the intended recipient is strictly prohibited. If you have received this transmittal in error, please notify me by e-mail immediately and delete the original message, any and all attachments, and all copies from all locations in your computer systems.
-----Original Message-----
From: Mathias Bauer [mailto:***@gmx.de]
Sent: Monday, August 08, 2011 6:01 AM
To: ***@openoffice.org
Subject: [CONTENT] [discuss] Re: discuss-***@openoffice.org

Hi,

with the explicit wording you have used in your mail I doubt that you are qualified to write about netiquette.

Besides that, this is not a matter of netiquette, it's a matter of how the mailing list software works. The ML software of OOo works as it works, and I know other project where it works in the same way. That doesn't mean that it is perfect, but OTOH it's easy to understand and you are told how it works in every mail you receive. Being able to read is a clear advantage that you shouldn't abandon.

Nevertheless, in case you are unable to read or follow the advice in the mail footer for whatever reason, usually kind people would help to unsubscribe you in case you asked politely. In case you know what "polite" means.

Maybe you don't understand what I have written above. So let me translate it into your "language":

You showed a typical example of making a fool of yourself by choosing an inadequate communication style: why make it simple if you can fuck it up?

I don't care who has registered in your name or with your account of how that has been done, I have a very poor opinion of you and that's that.

Please apologize if my translation lacks the "elegance" of your own wording, my knowledge of your "language" is somewhat limited.

Regards,
Mathias

Post by john tyler
netiquette demands that unsubscribing works by inserting the request in the subject line
this is a typical example of why I would never dream of using open
office: why make it simple if you can fuck it up?
I don't care who has registered in my name or with my account or how
that has been done, I have a very poor opinion of open office and
that's that.

Date: Sun, 7 Aug 2011 16:58:08 -0700
John,
not put it in the subject. As for why your getting the messages you
signed up for them, and you have to unsubscribe yourself.
--
-----------------------------------------------------------------
Subject: help

--
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org with Subject: help

[Sigrid Carrera]

Nettiquette also demands, that you use a civil tone in your messages.
If you idiot cannot unsubscribe yourself, than so be it.

For subscription you have to confirm that you want to subscribe, so it is impossible that someone else has subscribed you - unless you've given your mail password to someone else. But this would be - in my opinion - exceptionally stupid.

And yes, I know, that I didn't use a civil tone here as well, but only because you called me an asshole twice before, which I don't like.

EOT for me.

*PLONK*

[c***@tadaust.org.au]

STOP SENDING ME YOUR EMAIL MESSAGES, OR I WILL FUCKEN DEAL WITH YOU, EVERY
DAY I GET 20 EMAILS FROM YOU, BE VERY CAREFULL WHO YOU ARE DEALING WITH,,,

-----Original Message-----
From: Sigrid Carrera
Sent: Monday, August 08, 2011 7:35 PM
To: ***@openoffice.org
Subject: [discuss] Re: discuss-***@openoffice.org

Nettiquette also demands, that you use a civil tone in your messages.
If you idiot cannot unsubscribe yourself, than so be it.

For subscription you have to confirm that you want to subscribe, so it is
impossible that someone else has subscribed you - unless you've given your
mail password to someone else. But this would be - in my opinion -
exceptionally stupid.

And yes, I know, that I didn't use a civil tone here as well, but only
because you called me an asshole twice before, which I don't like.

EOT for me.

*PLONK*
--
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help


-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1392 / Virus Database: 1520/3822 - Release Date: 08/08/11

[Fernando Cassia]

why the fuck are you assholes mailing me this shit?
why are you assholes mailing me this shit? o0o sucks anyway
netiquette demands that unsubscribing works by inserting the request in the
subject line

Why the fuck are you spaming a mailing list because you forgot you
subscribed to it in the first place and why the fuck do you think
someone gives a fuck about what you think about openoffice and why the
fuck do you insist on using the fuck word instead of just
unsubscribing from the list?.

Fuck off.

FC

[john tyler]

your initials are FC?

FUCKIN CUNT?

LOL - rarely has a nick fitted better

Date: Mon, 8 Aug 2011 12:24:10 -0300

why the fuck are you assholes mailing me this shit?
why are you assholes mailing me this shit? o0o sucks anyway
netiquette demands that unsubscribing works by inserting the request in the
subject line

Why the fuck are you spaming a mailing list because you forgot you
subscribed to it in the first place and why the fuck do you think
someone gives a fuck about what you think about openoffice and why the
fuck do you insist on using the fuck word instead of just
unsubscribing from the list?.
Fuck off.
FC
--
-----------------------------------------------------------------
with Subject: help

--
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help

[Fernando Cassia]

Post by john tyler
your initials are FC?
FUCKIN CUNT?

Could someone please unsuscribe this retard, or troll?

Thanks. :)

FC

[john tyler]

thank you

Date: Mon, 8 Aug 2011 15:35:17 -0300

Post by john tyler
your initials are FC?
FUCKIN CUNT?

Could someone please unsuscribe this retard, or troll?
Thanks. :)
FC
--
-----------------------------------------------------------------
with Subject: help

--
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help

[Mathias Bauer]

Post by Fernando Cassia

Post by john tyler
your initials are FC?
FUCKIN CUNT?

Could someone please unsuscribe this retard, or troll?
Thanks. :)
FC

Why? That would be an undeserved benefit for him. Perhaps we should get
something from here

http://www.google.de/search?q=popcorn&hl=de&prmd=ivnsr&source=lnms&tbm=isch&ei=0klATqO0Es3Wsgb40Nm8CQ&sa=X&oi=mode_link&ct=mode&cd=2&ved=0CBoQ_AUoAQ&biw=1920&bih=1033

lay back and watch the show. :-)

Regards,
Mathias

[Graham Lauder]

Post by Mathias Bauer

Post by Fernando Cassia

Post by john tyler
your initials are FC?
FUCKIN CUNT?

Could someone please unsuscribe this retard, or troll?
Thanks. :)
FC

Why? That would be an undeserved benefit for him. Perhaps we should get
something from here
http://www.google.de/search?q=popcorn&hl=de&prmd=ivnsr&source=lnms&tbm=isch
&ei=0klATqO0Es3Wsgb40Nm8CQ&sa=X&oi=mode_link&ct=mode&cd=2&ved=0CBoQ_AUoAQ&b
iw=1920&bih=1033
lay back and watch the show. :-)
Regards,
Mathias

+1,

Don't do that for him, if getting all these mails annoys him, I'm all for
annoying him some more. He's hilarious. :)

Cheers
GL

[Anna Constantine]

I need help with office org 3.3 is this your way of being professional?
please send email to get assist.
----- Original Message -----
From: "Graham Lauder" <***@openoffice.org>
To: <***@openoffice.org>
Sent: Monday, August 08, 2011 6:11 PM

Post by Graham Lauder

Post by Mathias Bauer

Post by Fernando Cassia

Post by john tyler
your initials are FC?
FUCKIN CUNT?

Could someone please unsuscribe this retard, or troll?
Thanks. :)
FC

Why? That would be an undeserved benefit for him. Perhaps we should get
something from here
http://www.google.de/search?q=popcorn&hl=de&prmd=ivnsr&source=lnms&tbm=isch
&ei=0klATqO0Es3Wsgb40Nm8CQ&sa=X&oi=mode_link&ct=mode&cd=2&ved=0CBoQ_AUoAQ&b
iw=1920&bih=1033
lay back and watch the show. :-)
Regards,
Mathias

+1,
Don't do that for him, if getting all these mails annoys him, I'm all for
annoying him some more. He's hilarious. :)
Cheers
GL
--
-----------------------------------------------------------------
with Subject: help

[RA Brown]

I need help with office org 3.3 is this your way of being professional?
please send email to get assist.

Hi Anna,

If you need help, replying to another thread is not the best way to do
it. As with this thread you will have lost most of those that can help,
lucky I did not just delete the message.

If your not subscribed then I would suggest that you do so or let us
know that your not subscribed. That way we know where to send copies to
you.

As for the problem, give the operating system and version, give the
version of OOo. Give a good but short explanation of the problem. Give
us some idea of what you have done to correct the problem. Be willing
to do some reading if so directed.

Reply to the list only and not directly to me.

Andy

[Anna Constantine]

pls send where i can email to ...your website is too verbose
----- Original Message -----
From: "RA Brown" <***@the-martin-byrd.net>
To: <***@openoffice.org>
Cc: "Anna Constantine" <***@tampabay.rr.com>
Sent: Monday, August 08, 2011 6:35 PM
Subject: [discuss] How to get help!

Post by RA Brown

I need help with office org 3.3 is this your way of being professional?
please send email to get assist.

Hi Anna,
If you need help, replying to another thread is not the best way to do
it. As with this thread you will have lost most of those that can help,
lucky I did not just delete the message.
If your not subscribed then I would suggest that you do so or let us
know that your not subscribed. That way we know where to send copies to
you.
As for the problem, give the operating system and version, give the
version of OOo. Give a good but short explanation of the problem. Give
us some idea of what you have done to correct the problem. Be willing
to do some reading if so directed.
Reply to the list only and not directly to me.
Andy
--
-----------------------------------------------------------------
with Subject: help

[RA Brown]

Post by Anna Constantine
pls send where i can email to ...your website is too verbose

How are you replying to these messages?

Go to http://support.openoffice.org/#fcs and you will see a listing
that says "OpenOffice.org Community Support, third down on the list will
be "Users Mailing List". To the right of that are two links, Subscribe
and Archives. Click on the Subscribe link. Your email client will open
with a blank message addressed as it needs to be. Hit send, no message
is needed. You will receive a message asking if you really want to
subscribe to the list, Hit reply and then Send. You will receive a
"Welcome to the list" message. Then your on the list. From then on
send email to ***@openoffice.org for help.

Be warned that the list can get a lot of mail, it is slow right not but
it does get very high at times. Most of the regular uses use filters to
put messages from several mailing list into folders instead of putting
every thing in the "Inbox" to help make sense of it all.

Another option is the user forums. These are online sources of help
that do not fill your inbox with messages. The first [1] is called the
"Official Forum" since it resides at this time on Oracle servers, this
will soon change. The second [2] is the oldest of the forums. Both
provide community support at no cost as everyone volunteers their time
to answer questions. According to where your located you may get a
reply in as little as a few minutes but it may take up to a few hours.

[1] http://user.services.openoffice.org/en/forum/
[2] http://www.oooforum.org/

For either the mailing list or forums remember the suggestions I made in
my last message.

Please reply to mailing list and not to me direct.

Andy

[Sigrid Carrera]

Hello Anna,


On Mon, 8 Aug 2011 18:43:43 -0400

Post by Anna Constantine
pls send where i can email to ...your website is too verbose

just send your question to the very same email address:
***@openoffice.org
There are many volunteers subscribed to this list, who are more than willing to help you with your problem, once you described in, like Andy replied to you earlier.

Oh, but please, start a new thread by sending a new message (i. e. do *not* reply to this or any other message). You can also just click on the link in my email above, this will do the right thing.

I hope, this will help you.

Sigrid

[RA Brown]

Post by Sigrid Carrera
Hello Anna,
On Mon, 8 Aug 2011 18:43:43 -0400

Post by Anna Constantine
pls send where i can email to ...your website is too verbose

There are many volunteers subscribed to this list, who are more than willing to help you with your problem, once you described in, like Andy replied to you earlier.
Oh, but please, start a new thread by sending a new message (i. e. do *not* reply to this or any other message). You can also just click on the link in my email above, this will do the right thing.
I hope, this will help you.
Sigrid

Thanks, better than my long winded reply.

Andy

[Paul]

@Tyler - I've unsubscribed you since you appear to stupid to do it yourself.
Don't bother replying

The likes of yourself aren't required since you only lower the I.Q count...

/paul

On Tue, Aug 9, 2011 at 10:19 AM, Anna Constantine <

Post by Anna Constantine
I need help with office org 3.3 is this your way of being professional?
please send email to get assist.
Sent: Monday, August 08, 2011 6:11 PM

Post by Graham Lauder

Post by Mathias Bauer

Post by Fernando Cassia

Post by john tyler
your initials are FC?
FUCKIN CUNT?

Could someone please unsuscribe this retard, or troll?
Thanks. :)
FC

Why? That would be an undeserved benefit for him. Perhaps we should get
something from here
http://www.google.de/search?q=**popcorn&hl=de&prmd=ivnsr&**
source=lnms&tbm=isch<http://www.google.de/search?q=popcorn&hl=de&prmd=ivnsr&source=lnms&tbm=isch>
&ei=0klATqO0Es3Wsgb40Nm8CQ&sa=**X&oi=mode_link&ct=mode&cd=2&**
ved=0CBoQ_AUoAQ&b
iw=1920&bih=1033
lay back and watch the show. :-)
Regards,
Mathias

+1,
Don't do that for him, if getting all these mails annoys him, I'm all for
annoying him some more. He's hilarious. :)
Cheers
GL
--
------------------------------**------------------------------**-----
with Subject: help

--
------------------------------**------------------------------**-----
with Subject: help

[ES Champ]

Because you signed up for it!!

On Sun, 07 Aug 2011 18:58:45 -0400, you wrote in

Post by john tyler
why are you assholes mailing me this shit? o0o sucks anyway

Date: Sun, 7 Aug 2011 22:09:57 +0200
Subject: [discuss] Re: Issue with code

Post by Joseph Da Silva
Hi
Here is the code I am having an issue with in open org works in excel

=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0)))))
Have you tried to select that cell and then hit Ctrl+F2? Then you can
easier debug the formula, by placing the cursor in different places of
the formula to see the results of different parts of the formula.
I don't know for sure, but aren't you supposed to use a ”;”
(semicolon) as a parameter separator rather than a ”,” (comma)? Or
maybe both work these days.

Post by Joseph Da Silva
There seems there is an issue with the CELL command and using 3.30

version

Post by Joseph Da Silva
on windows 7
Any advise would be appreciated.
Thanks for your time and consideration

I'm not sure that I helped at all, though…
Regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
-----------------------------------------------------------------
with Subject: help

--
-----------------------------------------------------------------
with Subject: help

[Cher Seymour]

Hello,
I think this came to me bye mistake, I have never sent you an email asking "Why are you sending me this ****"
To begin with I know I signed up for it and I like to read the info in them and second I would never ever swear in an email to you or to anyone else. It is something I do not do it is wrong for anyone to talk or write like that. So I don't know who sent that message to you, but you responded to the wrong email address it was not me. Also the other point is that I was in New Hampshire Friday to Monday and I wasn't even on my email on Sunday. So it never even could have been me on Sunday that wrote that.
Thanks Cheryl Seymour


Stay Well, Cher

Date: Sun, 23 Oct 2011 18:34:39 -0400
Because you signed up for it!!
On Sun, 07 Aug 2011 18:58:45 -0400, you wrote in

Post by john tyler
why are you assholes mailing me this shit? o0o sucks anyway

Date: Sun, 7 Aug 2011 22:09:57 +0200
Subject: [discuss] Re: Issue with code

Post by Joseph Da Silva
Hi
Here is the code I am having an issue with in open org works in excel

=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0)))))
Have you tried to select that cell and then hit Ctrl+F2? Then you can
easier debug the formula, by placing the cursor in different places of
the formula to see the results of different parts of the formula.
I don't know for sure, but aren't you supposed to use a $B!I(B;$B!I(B
(semicolon) as a parameter separator rather than a $B!I(B,$B!I(B (comma)? Or
maybe both work these days.

Post by Joseph Da Silva
There seems there is an issue with the CELL command and using 3.30

version

Post by Joseph Da Silva
on windows 7
Any advise would be appreciated.
Thanks for your time and consideration

I'm not sure that I helped at all, though$B!D(B
Regards
Johnny Rosenberg
$B%8%g%K!<!&%m!<%<%s%P!<%0(B
--
-----------------------------------------------------------------
with Subject: help

--
-----------------------------------------------------------------
with Subject: help

--
-----------------------------------------------------------------
with Subject: help

--
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help

[Cher Seymour]

Hello again,
I just remembered another reason it wasn't me. The original email from you at the bottom of this one went into my junk folder and your emails don't go there, I have you in my contact address file so all your emails usually go to my inbox not to junk file.


Stay Well, Cher





From: ***@msn.com
To: ***@openoffice.org
Date: Tue, 25 Oct 2011 16:53:55 -0400
Subject: [discuss] Re: discuss-***@openoffice.org





Hello,
I think this came to me bye mistake, I have never sent you an email asking "Why are you sending me this ****"
To begin with I know I signed up for it and I like to read the info in them and second I would never ever swear in an email to you or to anyone else. It is something I do not do it is wrong for anyone to talk or write like that. So I don't know who sent that message to you, but you responded to the wrong email address it was not me. Also the other point is that I was in New Hampshire Friday to Monday and I wasn't even on my email on Sunday. So it never even could have been me on Sunday that wrote that.
Thanks Cheryl Seymour



Stay Well, Cher

Date: Sun, 23 Oct 2011 18:34:39 -0400
Because you signed up for it!!
On Sun, 07 Aug 2011 18:58:45 -0400, you wrote in

Post by john tyler
why are you assholes mailing me this shit? o0o sucks anyway

Date: Sun, 7 Aug 2011 22:09:57 +0200
Subject: [discuss] Re: Issue with code

Post by Joseph Da Silva
Hi
Here is the code I am having an issue with in open org works in excel

=INDIRECT(CELL("ADDRESS",INDEX($P $28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0)))))
Have you tried to select that cell and then hit Ctrl+F2? Then you can
easier debug the formula, by placing the cursor in different places of
the formula to see the results of different parts of the formula.
I don't know for sure, but aren't you supposed to use a $B!I(B;$B!I(B
(semicolon) as a parameter separator rather than a $B!I(B,$B!I(B (comma)? Or
maybe both work these days.

Post by Joseph Da Silva
There seems there is an issue with the CELL command and using 3.30

version

Post by Joseph Da Silva
on windows 7
Any advise would be appreciated.
;
Thanks for your time and consideration

I'm not sure that I helped at all, though$B!D(B
Regards
Johnny Rosenberg
$B%8%g%K!<!&%m!<%<%s%P!<%0(B
--
-----------------------------------------------------------------
with Subject: help

--
-----------------------------------------------------------------
with Subject: help

--
-----------------------------------------------------------------
with Subject: help

--
-----------------------------------------------------------------
To unsubscribe send email to discuss-***@openoffice.org
For additional commands send email to ***@openoffice.org
with Subject: help