Hello everyone,
Thinking more thoroughly about this:
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)
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) ) }
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. [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 .]
Sincerely,
Leonard
Oliver Brinzing wrote:
Hi, Eike,
thanks a lot :-)
So as long as your default font (what's that anyway?) is not monospaced
the result is even meaningless.
yes but now i am can determine whether a column is hidden or not ...
=WENN(ZELLE("WIDTH";A1)+0*ZUFALLSZAHL()=0
Oliver
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
