Hi David, On Wednesday, 2008-06-25 20:55:12 +0100, David King wrote:
> Say we have A1:C1 = {7|6|5}
>
> In cell A2 we enter, as an array formula:
>
> =PROB({5;6;7};{0.2;0.3;0.5};A1:C1)
>
> and, correctly, A2:C2 = {0.5|0.3|0.2}.
>
>
> Now in cell D4 we enter, as a normal (non-array) formula:
>
> =PROB({5;6;7};{0.2;0.3;0.5};A1:C1)
Sorry, I misinterpreted the issue's description. Yes, indeed that should
result in an error and not evaluate A1:C1 as array. I'll reopen the
issue.
> I hold that the relevant part of ODFF is:
>
> "3.2 Non-Scalar Evaluation (aka 'Array expressions')
> <snip>
> 1)Normal evaluation in non-'array' mode does an implicit
> intersection of the argument with the expression's evaluation
> position.
> <snip>
> 1.1)References
> If the target reference is a row-vector (Nx1) use the value at
> the intersection of the evaluation position's column and the
> reference's row.
> in cell B2 : =ABS(A1:C1) => ABS(B1)
> if there is no intersection the result is #VALUE!
> in cell B4 : =ABS(A1:C1) => #VALUE!"
>
> OK, clearly there's an error in this ODFF draft, because B4
> intersects A1:C1 at cell B1. Let's say it should read
> "in cell D4 : =ABS(A1:C1) => #VALUE!"
Thanks for the hint, I set that on the list of things to be corrected.
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.
pgpyK3yvdgLTd.pgp
Description: PGP signature
