Re: [sc-dev] =CELL("Width";A1) does not recognize changes of columnwidth ?

[Leonard Mada <discoleo@gmx.net>]

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
>
>