Hi Joe, On Friday, 2008-01-11 15:41:17 -0500, Joe Smith wrote:
> I recently came across this formula in a tip for Excel[1]:
> =2^(ROW(INDIRECT("1:8")))
> which (in an array context) is a convenient, if ugly, way of generating
>
> 2^{1;2;3;4;5;6;7;8} --> (2, 4, 8, ... 256)
>
> Without having to write it all out.
[...]
> [1] It works in Calc if you use "A1:A8".
It doesn't need the INDIRECT call, you can write =2^ROW(A1:A8) in
array context. Same with COLUMN(
> Is it worth thinking about extending the array constant syntax to allow a
> simple series to be written clearly and easily? Something like:
>
> {1..8} --> (1, 2, 3, 4, 5, 6, 7, 8)
Not really. It would add just a small benefit serving a very specialized
purpose, would complicate parsing, and no other application supports it.
I'd say we got more important things to do.
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.
pgpuKLWLVL4CQ.pgp
Description: PGP signature
