Hi Eike,
You said:
>> and another thing is that, I wonder if the error information should be
>> changed frome #VALUE! to #N/A, when we can not get value from
>> THEN or ELSE condition(like Excel).
>What exactly are you referring? Could you give an example?
I mean if I input such a formula:
=IF({1;0};{2;2|22;22};{3;3;|33;33|333;333}),
the result will be:
2 3
22 33
#VALUE! 333.
but Excel will show:
2 3
22 33
#N/A 333.
A small problem, just ask. :)
and thank you for your advice, I will pay attention to that next time.
also a nice day!
Lvyue
2008-05-08
发件人： Eike Rathke
发送时间： 2008-05-07 19:02:03
收件人： [email protected]
抄送：
主题： Re: [sc-dev] About i46681(ODFF: Repeat values of single arrayvector if used
in second array dimension)
Hi Yue,
On Tuesday, 2008-05-06 15:59:29 +0800, Lvyue wrote:
> I will attach a patch on i46681, which only changed a few functions,
> including ScIfJump(), JumpMatrix(), ScMatRef(), MatAdd(),
> ScMatrix::Get() and ScMatrix::GetDouble().
See your IRC log from today ;-)
> and another thing is that, I wonder if the error information should be
> changed frome #VALUE! to #N/A, when we can not get value from
> THEN or ELSE condition(like Excel).
What exactly are you referring? Could you give an example?
> and at last, have a nice day! :)
Thanks, you too :)
Btw, when creating a new mail topic please don't reply to a mail of an
already existing thread, startwith a new mail instead to keep threading
meaningful. Otherwise your mail may get buried in the old thread and be
overlooked at first sight.
Thanks
Eike
--
OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412
OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
Please don't send personal mail to the [EMAIL PROTECTED] account, which I use
for
mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED]
Thanks.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
iD8DBQFIIYvIZcn5tYf41BIRAorxAJ4g1qZ8dWZU7ZcRrh5ZC6B1j0pxxwCffaC2
RklZwSLlNF9SnPKswQsL2Ms=
=BFTo
-----END PGP SIGNATURE-----
