[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: STYLE function in section 2.1.3 Large Group
Hi, The TODO of section "2.3.1 Large Group" says | STYLE was not included in the list above, even though it's in | OpenOffice.org 2, because it does not appear to be appropriate in | a formula language. If you believe it SHOULD be in this set of | functions, please explain WHY. The conditional formatting system is | a more appropriate place for this kind of functionality, if it is | needed. The STYLE function may be used in asynchronous Add-In function scenarios, where an Add-In function may update a formula result at any given time. By using STYLE with a timeout you may create some "blink" effect to attract the user's attention if a value changes. This is also where the CURRENT function comes in handy. When combining IF or CHOOSE with CURRENT and STYLE you may also create more attribution conditions than it is possible using conditional formatting, which mainly is used for background colors. Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.