[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [sc-dev] =CELL("Width";A1) does not recognize changes of columnwidth ?
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 > >
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]