Proposal for a new calculation setting: table:use-wildcards

[Eike Rathke <erack@sun.com>]

Hi,

I'm proposing a new calculation setting table:use-wildcards that is
needed for interoperable formula calculation. To the
<table:calculation-settings> element of section 8.5.2 add the following:


Use Wildcards

The table:use-wildcards attribute specifies whether wildcards are
enabled for character string comparisons and when searching.

<define name="table-calculation-setting-attlist" combine="interleave">
    <optional>
        <attribute name="table:use-wildcards" a:defaultValue="false">
            <ref name="boolean"/>
        </attribute>
    </optional>
</define>

The table:use-regular-expressions attribute and the table:use-wildcards
attribute are mutually exclusive, the value can not be 'true' for both
attributes.

If set, in a query or search string of a function declared to consider
this attribute, a question mark '?' matches any single character, and an
asterisk '*' matches any sequence of characters, including no character
at all. A tilde '~' escapes the special meaning of a question mark or
asterisk. To search for a tilde character prefix the tilde with a second
tilde.



  Eike