Hi Kingsley,
On Tue, Oct 09, 2007 at 14:22:30 -0700, Kingsley G. Morse Jr. wrote:
> Put =count(A1:$B$1) in A4
Here, the argument to count is a range.
> Put =count(A1:address(1,2)) in A5
Here, it isn't, as the return value of "address" is of type "string"; it is
not a reference, nor is it automatically converted into one.
On Tue, Oct 09, 2007 at 14:54:16 -0700, Kingsley G. Morse Jr. wrote:
> It now seems to me that the following works
>
> =count(indirect("a1:"&address(1,4)))
>
> and I find myself wondering whether
>
> 1.) my original bug report used the wrong syntax
Yes, sort of. Type-wise, things didn't match up to your expectations.
> and
>
> 2.) somehow gnumeric failed to
>
> a.) catch it or
> b.) warn about it.
Playing around with things, even something like
=count(A1:sum(1))
does not generate an error, which it really should.
Ray
--
Subtlety is fine. It might warrant a comment, though.
Linus Torvalds
in <[EMAIL PROTECTED]>
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
