Because you signed up for it!!
On Sun, 07 Aug 2011 18:58:45 -0400, you wrote in
gmane.comp.openoffice.general:
why are you assholes mailing me this shit? o0o sucks anyway
Date: Sun, 7 Aug 2011 22:09:57 +0200
From: gurus.knu...@gmail.com
To: discuss@openoffice.org
Subject: [discuss] Re: Issue with code
2011/8/3 Joseph Da Silva <joseph_da_si...@hotmail.com>:
> 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.
>
>
> 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
ジョニー・ローゼンバーグ
--
-----------------------------------------------------------------
To unsubscribe send email to discuss-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help
--
-----------------------------------------------------------------
To unsubscribe send email to discuss-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help
--
-----------------------------------------------------------------
To unsubscribe send email to discuss-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help