summaryrefslogtreecommitdiff
path: root/sc/inc/queryparam.hxx
AgeCommit message (Collapse)Author
2013-11-28resolved fdo#71589 reimplemented horizontal range lookupEike Rathke
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
2013-10-11Store svl::SharedString in query entry items, and adjust all call sites.Kohei Yoshida
Change-Id: Ifd3bbb84c7abbe983a017a169c7e05914ef33450
2013-08-31fdo#62475 removed pointless commentsJelle van der Waa
Change-Id: Ifc9837e9f6e3c6a84e9f01c192f10271b184fb6d Reviewed-on: https://gerrit.libreoffice.org/5720 Reviewed-by: Tor Lillqvist <tml@iki.fi> Tested-by: Tor Lillqvist <tml@iki.fi>
2013-07-01Reduce dependency on the matrix header.Kohei Yoshida
Change-Id: Iade09d108aec78f8cbe92f9103f206d0c99fab8e
2013-04-07mass removal of rtl:: prefixes for O(U)String*Luboš Luňák
Modules sal, salhelper, cppu, cppuhelper, codemaker (selectively) and odk have kept them, in order not to break external API (the automatic using declaration is LO-internal). Change-Id: I588fc9e0c45b914f824f91c0376980621d730f09
2012-12-04re-base on ALv2 code. Includes:Michael Meeks
Patches contributed by Herbert Duerr i#118735 prevent endless loop if vlookup/hlookup doesn't find anything http://svn.apache.org/viewvc?view=revision&revision=1239673 Patches contributed by Andre Fischer remove lp_solver http://svn.apache.org/viewvc?view=revision&revision=1199180 i#118160: Added external CoinMP library. http://svn.apache.org/viewvc?view=revision&revision=1233909 Patches contributed by Armin Le-Grand i#118485 - Styles for OLEs are not saved. http://svn.apache.org/viewvc?view=revision&revision=1182166 i#118524: apply patch, followup fixes to 118485 http://svn.apache.org/viewvc?view=revision&revision=1186077 Patches contributed by lihuiibm i#108860 - Fix range validation. http://svn.apache.org/viewvc?view=revision&revision=1242846 i#118954 Chart data will lost after copy to different file http://svn.apache.org/viewvc?view=revision&revision=1301345 Patches contributed by Ariel Constenla-Haile Fix Linux build breaker: extra qualification on member http://svn.apache.org/viewvc?view=revision&revision=1301591 i#118696 - i#118697 - Fix some Sheet Tab Color API issues http://svn.apache.org/viewvc?view=revision&revision=1225428 i#118697 - Fix uninitialized variable http://svn.apache.org/viewvc?view=revision&revision=1225859 i#118771 - ScUndoImportTab should preserve tab background color http://svn.apache.org/viewvc?view=revision&revision=1230356 i#118921 - Repaint linked sheet tab background color after updating link http://svn.apache.org/viewvc?view=revision&revision=1245177 i#118927 - Undo/Redo "Update Link" does not reset sheet tab color http://svn.apache.org/viewvc?view=revision&revision=1245241 i#118747 - Copy tab color when transferring sheets across documents http://svn.apache.org/viewvc?view=revision&revision=1230355 Patch contributed by Oliver Rainer-Wittman i#118012 - methods <ScBroadcastAreaSlot::AreaBroadcast(..)> and <ScBroadcastAreaSlot::AreaBroadcastInRange(..)> adapt stl-container iteration in order to avoid destroyed iterators during iteration. http://svn.apache.org/viewvc?view=revision&revision=1297916 Patches contributed by Mathias Bauer gnumake4 work variously http://svn.apache.org/viewvc?view=revision&revision=1394707 http://svn.apache.org/viewvc?view=revision&revision=1394326 http://svn.apache.org/viewvc?view=revision&revision=1396797 http://svn.apache.org/viewvc?view=revision&revision=1397315 Patch contributed by Daniel Rentz calc69: #i116936# fix VBA symbol Cells http://svn.apache.org/viewvc?view=revision&revision=1172135 Patches contributed by leiw: i#118546 CPU 100% on switched off AutoCalculate with Conditional Formatting on date values http://svn.apache.org/viewvc?view=revision&revision=1301380 Re-add new function documentation. Many various cleanups. Add missing calc66: #o11817313# also look at formula result number format, remove redundant binaries.
2012-06-06Use iterators over index access.Kohei Yoshida
This makes ValidQuery *slightly* faster. Change-Id: I9fff6099b597d7a8d4d5a4358099348baa657802
2011-11-18Populate the query entries directly.Kohei Yoshida
2011-11-18Replace DeleteQuery with RemoveEntryByField.Kohei Yoshida
The latter takes care of iterating through the elements.
2011-11-18Remove the query entry when all items are selected.Kohei Yoshida
2011-11-18Now the new popup works somewhat as expected.Kohei Yoshida
2011-11-18Handle query after the popup gets dismissed by clicking OK.Kohei Yoshida
But it's not working right. :-(
2011-11-14Revert "Revert "Removing the mixed comparison flag, which is no longer needed.""Kohei Yoshida
This reverts commit 7d7036c235a92268f23cc04eab8abcb08cddeb3f.
2011-11-11Revert "Removing the mixed comparison flag, which is no longer needed."Kohei Yoshida
This reverts commit eaea417bfdf8d06df2b7f2e42c904c32ce77e871.
2011-11-10Removing the mixed comparison flag, which is no longer needed.Kohei Yoshida
This flag was introduced years ago to deal with Excel's behavior on incorrectly sorted data range. But later versions of Excel no longer follow that behavior & keeping this flag would make the evaluation code unnecessarily more complex & hard to adopt to multi-item matching.
2011-11-07Encapsulated empty and non-empty filter criteria.Kohei Yoshida
Because those two conditions were not very obvious.
2011-11-07forgot to amend these changes to my last commitMarkus Mohrhard
2011-11-07String->OUString in ScDocument and follow upMarkus Mohrhard
2011-11-05Moved ScQueryEntry into its own file set.Kohei Yoshida
Because I'll be modifying this struct in the next few days...
2011-11-04Hide the query strings member, and add relevant methods for it.Kohei Yoshida
2011-11-04Do the simple string equality matching in ScQueryEntry instead.Kohei Yoshida
2011-11-04Set pStr private and discovered several more direct access to this member.Kohei Yoshida
2011-11-04Remove direct access to the query string (pStr).Kohei Yoshida
I'm about half-way through.
2011-11-04Moved ScQueryEntry out of global.?xx to queryparam.?xx.Kohei Yoshida
This is more appropriate.
2011-11-04const correct ness etc & mutable only for lazy-initializing accessor.Kohei Yoshida
2011-11-04Let's not use a hard-coded MAXQUERY all over the place.Kohei Yoshida
For now, the maximum query size is determined by the size of the vector that holds the entries. For now, the size of the vector is fixed, and won't change. We may later work on making it dynamically sized, however...
2011-04-01Removed the dynamic row bits from the db range. It was a hack.Kohei Yoshida
This concept was there before the Hamburg added their own mechanism to allow dynamic expansion of db ranges. There is no need to have two of them, or it would cause weird problems.
2011-03-18Merge remote-tracking branch 'origin/integration/dev300_m101'Jan Holesovsky
Conflicts: chart2/source/controller/main/UndoManager.cxx chart2/source/tools/RegressionCurveHelper.cxx sc/inc/address.hxx sc/inc/attrib.hxx sc/inc/bigrange.hxx sc/inc/callform.hxx sc/inc/cell.hxx sc/inc/chartarr.hxx sc/inc/chartlis.hxx sc/inc/chgtrack.hxx sc/inc/collect.hxx sc/inc/compiler.hxx sc/inc/detdata.hxx sc/inc/document.hxx sc/inc/fillinfo.hxx sc/inc/olinetab.hxx sc/inc/prnsave.hxx sc/inc/queryparam.hxx sc/inc/sc.hrc sc/inc/scabstdlg.hxx sc/inc/table.hxx sc/inc/validat.hxx sc/inc/zforauto.hxx sc/source/core/data/documen2.cxx sc/source/core/data/document.cxx sc/source/core/data/table1.cxx sc/source/core/tool/address.cxx sc/source/core/tool/token.cxx sc/source/filter/excel/frmbase.cxx sc/source/filter/excel/impop.cxx sc/source/filter/excel/xename.cxx sc/source/filter/inc/formel.hxx sc/source/filter/inc/xename.hxx sc/source/filter/xml/xmlexprt.cxx sc/source/filter/xml/xmlnexpi.cxx sc/source/filter/xml/xmlnexpi.hxx sc/source/ui/dbgui/filtdlg.cxx sc/source/ui/inc/docfunc.hxx sc/source/ui/inc/namedlg.hxx sc/source/ui/namedlg/namedlg.cxx sc/source/ui/src/namedlg.src
2011-03-13translate german comments in /sc/incNicolas Christener
2011-03-10Merge commit 'ooo/DEV300_m101' into integration/dev300_m101Kohei Yoshida
2011-01-21Remove old RCS lines.Thomas Arnhold
2011-01-19Ported calc-formula-db-function-fix.diff from the build repo.Kohei Yoshida
This patch fixes n#594332 and n#595713.
2011-01-17removetooltypes01: #i112600# remove tooltypes from scMikhail Voytenko
2010-10-28add modelines to .hxx files as wellCaolán McNamara
2010-09-15sc-dbrange-dynamic-resize.diff: Dynamically resize filtered range.Kohei Yoshida
n#352662, i#85305 Dynamically resize filtered range when new data rows are present.
2009-09-16last cleanup - use vector to store an array of ScQueryEntry, instead of the ↵Kohei Yoshida
old-fashioned c-style dynamic array.
2009-09-16removed the duplicated ScTable::ValidQuery.Kohei Yoshida
2009-09-16Moved the string flag from the iterator to the query param struct.Kohei Yoshida
2009-09-09#i102750# more work toward supporting external refs in DB functions. Still ↵Kohei Yoshida
a long way to go...
2009-09-09#i102750# initial refactoring in an effort to support external references in ↵Kohei Yoshida
DSUM, DGET etc. Not finished yet.
generated by cgit (git 2.34.1) at 2025-01-17 03:38:21 +0000