Difference between revisions of "Documentation/How Tos/Calc: CELL function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
|||
Line 126: | Line 126: | ||
* <tt>'''CELL()'''</tt> returns information captured when the target cell was last updated. For example <tt>'''CELL("WIDTH"; D2)'''</tt> returns the width of column D - but if column D is then made wider, the value returned will not update until the contents of D2 are changed. To ensure an update, use (for example) <tt>'''CELL("WIDTH"; D2) + 0*RAND()'''</tt>; this works because <tt>'''RAND()'''</tt> updates when the column width is changed. | * <tt>'''CELL()'''</tt> returns information captured when the target cell was last updated. For example <tt>'''CELL("WIDTH"; D2)'''</tt> returns the width of column D - but if column D is then made wider, the value returned will not update until the contents of D2 are changed. To ensure an update, use (for example) <tt>'''CELL("WIDTH"; D2) + 0*RAND()'''</tt>; this works because <tt>'''RAND()'''</tt> updates when the column width is changed. | ||
− | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: TYPE function|TYPE]] | * [[Documentation/How_Tos/Calc: TYPE function|TYPE]] | ||
Revision as of 19:07, 16 July 2018
CALC FUNCTIONS