← Prev in month ← Prev in thread
Next in thread → Next in month →

STYLE function in section 2.1.3 Large Group

From
Eike Rathke <>
Date
2006-11-03T15:23:01+00:00
ID
Thread
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.
← Prev in month ← Prev in thread
Next in thread → Next in month →