Hi Leonard, On Sunday, 2008-10-12 19:11:36 +0200, Leonard Mada wrote:
> Shouldn't ODF implement the following functions:
>
> 1.) ISHIDDEN(cell, IGNORE_EMPTY = TRUE)
> 2.) ISFILTERED(cell, IGNORE_EMPTY = TRUE)
> 3.) ISVISIBLE(cell, IGNORE_EMPTY = TRUE)
While ISHIDDEN() and ISFILTERED() might be useful, I don't see what
ISVISIBLE() would be good for. Changing formula results depending on
which part of the document is visible, if at all, is not such a good
idea.
> These functions would allow to catch the state of a cell
> (visible/hidden/filtered), allowing greatly-expanded interactivity in
> spreadsheet-sessions. I believe that especially the ISFILTERED() has an
> enormous potential. Of course, ISFILTERED() should support
> array-formulas:
> {=SUM( IF( ISFILTERED(A1:A1000); 0 ; B1:B1000) ) }
Exactly this example could already be accomplished using
=SUBTOTAL(9;B1:B1000).
> To go one step further, it should be possible to mark a row as
> *non-filterable*, this means, it should be displayed always. This would
> be the row where the user computes and displays some results.
_Within_ the data to be filtered? Doesn't make much sense to me.
> [A more
> advanced concept involves splitting the results area completely off the
> main spreadsheet - a completely dedicated results area, going in-line
> with:
> http://www.openoffice.org/issues/show_bug.cgi?id=83767 and
> http://www.openoffice.org/issues/show_bug.cgi?id=85825 .]
IZ currently is unavailable so I can't look it up.. but this sounds
pretty much like copying a filtered result to a different area, which is
already possible.
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.
pgpymKLkeJPr2.pgp
Description: PGP signature
