OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: STYLE function in section 2.1.3 Large Group


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.


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]