Difference between revisions of "Documentation/How Tos/Calc: CELL function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
m |
||
(4 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE:CELL funtion}} |
+ | {{Documentation/CalcFunc InformationTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_Information_functions | ||
+ | |NextPage=Documentation/How_Tos/Calc:_CURRENT_function | ||
+ | }}__NOTOC__ | ||
== CELL == | == CELL == | ||
Line 8: | Line 13: | ||
<tt>'''CELL(info_type; cell_ref)'''</tt> | <tt>'''CELL(info_type; cell_ref)'''</tt> | ||
− | : returns information about the cell <tt>'''cell_ref'''</tt>. The information returned depends on the (case insensitive) text string <tt>'''info_type'''</tt>, which can be set as follows: | + | : returns information about the cell <tt>'''cell_ref'''</tt>. The information returned depends on the (case-insensitive) text string <tt>'''info_type'''</tt>, which can be set as follows: |
: '''COL''' | : '''COL''' | ||
Line 97: | Line 102: | ||
* <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]] | ||