Talk:Documentation/Calc Functions/STYLE

SF Comments

 * (1) Summary. Suggest the following minor re-word – “Applies a style to the cell containing the function call and, optionally, applies a second style to that cell after a set delay.”.
 * (2) Returns. The current wording is a little confusing. A simpler statement would be – “Returns the value 0, allowing you to add the STYLE function call to other components of a formula without changing the value of the formula.”.
 * (3) Arguments, Style. Suggest replacing with – “Style is a string in quotation marks or a reference to a cell containing that string, which is the name of a defined cell style to be (initially) assigned to the cell.”.
 * (4) Arguments, Time. Suggest changing “time range in seconds” to “delay in seconds before applying the Style2 cell style”. Suggest changing the second sentence to – “If this argument is omitted, the initially applied style will not be changed.”.
 * (5) Arguments, Style2. Suggest replacing with – “Style2 is a string in quotation marks or a reference to a cell containing that string, which is the name of a defined cell style to be applied to the cell after the specified delay time has passed. If a delay time is specified and this argument is omitted, the cell will revert to the predefined Default Cell Style after the delay time.”
 * (6) Arguments, general. What happens if one or both styles passed as arguments are undefined? What happens if a negative or zero value is passed for the Time argument?
 * (7) Additional details. It would be worth making some comment as to when the style switching is re-started. Obviously when the function call is first entered in a cell. Also, when you select Data > Calculate > Recalculate Hard all STYLE function calls seem to be reset. Finally, when you select Data > Calculate > Recalculate, the STYLE function call in the selected cell seems to be reset. Need to check what happens when a file containing STYLE function calls is re-opened.
 * (8) General. Possibly a contrived circumstance but what happens if you put two STYLE function calls in one cell? (Maybe you are hoping to get one colour change after a short period and another colour change after a longer period?)
 * (9) Examples, general. I feel that the corresponding Open Office page at https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_STYLE_function has some useful examples. Please review and check whether we can use any ideas from that page.
 * (10) Examples, 1st example. I do not like the repeated use of the word format in this description. Suggest the following re-word – “The function formats the cell using the Invisible cell style for 60 seconds, then the Default cell style is applied. Both cell styles must be defined beforehand.”.
 * (11) Examples, comment after Table. If the example on the CURRENT page adds anything to this function, then I suggest we also include the example here rather than just referring to it. If it has no value, then do not mention it.

--Stevefanning (talk) 2020-12-23T17:19:19 (UTC)