Re: [email protected]

Because you signed up for it!!

On Sun, 07 Aug 2011 18:58:45 -0400, you wrote in =20
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: [email protected]
>> To: [email protected]
>> Subject: [discuss] Re: Issue with code
>>
>> 2011/8/3 Joseph Da Silva <[email protected]>:
>> > Hi
>> >
>> > Here is the code I am having an issue with in open org works in exce=
l
>> >
>> >
>> > =20
>> =3DINDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q3=
0000),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 =E2=80=9D;=E2=80=
=9D
>> (semicolon) as a parameter separator rather than a =E2=80=9D,=E2=80=9D=
 (comma)? Or
>> maybe both work these days.
>>
>> >
>> >
>> > There seems there is an issue with the CELL command and using 3.30 =20
>> 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=E2=80=A6
>>
>>
>> Regards
>>
>> Johnny Rosenberg
>> =E3=82=B8=E3=83=A7=E3=83=8B=E3=83=BC=E3=83=BB=E3=83=AD=E3=83=BC=E3=82=BC=
=E3=83=B3=E3=83=90=E3=83=BC=E3=82=B0
>> --
>> -----------------------------------------------------------------
>> To unsubscribe send email to [email protected]
>> For additional commands send email to [email protected]
>> with Subject: help
>  		 	   		  --
> -----------------------------------------------------------------
> To unsubscribe send email to [email protected]
> For additional commands send email to [email protected]
> with Subject: help


--=20
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help