diff options
| author | Eike Rathke <erack@redhat.com> | 2013-11-27 23:43:09 +0100 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2013-11-28 00:15:41 +0100 |
| commit | f0701470858f57a855ba57c0c2283e52953db327 (patch) | |
| tree | 0d200bc70e0496af73e1b74b4099f64e59d49bcf /sc/inc/queryparam.hxx | |
| parent | Unbreak the build (diff) | |
| download | core-f0701470858f57a855ba57c0c2283e52953db327.tar.gz core-f0701470858f57a855ba57c0c2283e52953db327.zip | |
resolved fdo#71589 reimplemented horizontal range lookup
Regression introduced with ebdd9c300718bce454ef56a31d5d8fb699fc1822
(first eaea417bfdf8d06df2b7f2e42c904c32ce77e871) that removed the
bMixedComparison member from ScQueryParam under the false assumption
that is was only used to emulate a legacy Excel behavior. In fact it was
also needed to do the at least horizontal range lookup in sorted mixed
data, though didn't evaluate exactly the same conditions as Excel and
defined in ODFF.
Reimplemented a similar behavior for the new code structures but this
time also checking for the additional condtion that a query ByString
does not return the last numeric result and vice versa, which previously
was missing.
Change-Id: I46061777879ba5301bfcaca2d50cf87a994f93f2
Diffstat (limited to 'sc/inc/queryparam.hxx')
| -rw-r--r-- | sc/inc/queryparam.hxx | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sc/inc/queryparam.hxx b/sc/inc/queryparam.hxx index ff89d3e62aac..a0e94f8db96f 100644 --- a/sc/inc/queryparam.hxx +++ b/sc/inc/queryparam.hxx @@ -42,6 +42,7 @@ struct ScQueryParamBase bool bCaseSens; bool bRegExp; bool bDuplicate; + bool mbRangeLookup; ///< for spreadsheet functions like MATCH, LOOKUP, HLOOKUP, VLOOKUP virtual ~ScQueryParamBase(); |