/************************************************************** * * Licensed to the Apache Software Foundation (ASF) under one * or more contributor license agreements. See the NOTICE file * distributed with this work for additional information * regarding copyright ownership. The ASF licenses this file * to you under the Apache License, Version 2.0 (the * "License"); you may not use this file except in compliance * with the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. * *************************************************************/ // MARKER(update_precomp.py): autogen include statement, do not remove #include "precompiled_sc.hxx" // INCLUDE --------------------------------------------------------------- #include "queryparam.hxx" using ::std::vector; // ============================================================================ ScQueryParamBase::ScQueryParamBase() { Resize( MAXQUERY ); for (sal_uInt16 i=0; i aNewEntries(nNew); SCSIZE nCopy = ::std::min(maEntries.size(), nNew); for (SCSIZE i=0; i= maEntries.size()) return; size_t n = maEntries.size(); vector aNewEntries; aNewEntries.reserve(n); for (size_t i = 0; i < n; ++i) if (i != nPos) aNewEntries.push_back(maEntries[i]); // Don't forget to append an empty entry to make up for the removed one. // The size of the entries is not supposed to change. aNewEntries.push_back(ScQueryEntry()); maEntries.swap(aNewEntries); } void ScQueryParamBase::FillInExcelSyntax(String& aCellStr, SCSIZE nIndex) { if (aCellStr.Len() > 0) { if ( nIndex >= maEntries.size() ) Resize( nIndex+1 ); ScQueryEntry& rEntry = GetEntry(nIndex); rEntry.bDoQuery = sal_True; // Operatoren herausfiltern if (aCellStr.GetChar(0) == '<') { if (aCellStr.GetChar(1) == '>') { *rEntry.pStr = aCellStr.Copy(2); rEntry.eOp = SC_NOT_EQUAL; } else if (aCellStr.GetChar(1) == '=') { *rEntry.pStr = aCellStr.Copy(2); rEntry.eOp = SC_LESS_EQUAL; } else { *rEntry.pStr = aCellStr.Copy(1); rEntry.eOp = SC_LESS; } } else if (aCellStr.GetChar(0) == '>') { if (aCellStr.GetChar(1) == '=') { *rEntry.pStr = aCellStr.Copy(2); rEntry.eOp = SC_GREATER_EQUAL; } else { *rEntry.pStr = aCellStr.Copy(1); rEntry.eOp = SC_GREATER; } } else { if (aCellStr.GetChar(0) == '=') *rEntry.pStr = aCellStr.Copy(1); else *rEntry.pStr = aCellStr; rEntry.eOp = SC_EQUAL; } } } // ============================================================================ ScQueryParamTable::ScQueryParamTable() { } ScQueryParamTable::ScQueryParamTable(const ScQueryParamTable& r) : nCol1(r.nCol1),nRow1(r.nRow1),nCol2(r.nCol2),nRow2(r.nRow2),nTab(r.nTab) { } ScQueryParamTable::~ScQueryParamTable() { } // ============================================================================ ScQueryParam::ScQueryParam() : ScQueryParamBase(), ScQueryParamTable(), bDestPers(true), nDestTab(0), nDestCol(0), nDestRow(0) { Clear(); } //------------------------------------------------------------------------ ScQueryParam::ScQueryParam( const ScQueryParam& r ) : ScQueryParamBase(r), ScQueryParamTable(r), bDestPers(r.bDestPers), nDestTab(r.nDestTab), nDestCol(r.nDestCol), nDestRow(r.nDestRow) { } ScQueryParam::ScQueryParam( const ScDBQueryParamInternal& r ) : ScQueryParamBase(r), ScQueryParamTable(r), bDestPers(true), nDestTab(0), nDestCol(0), nDestRow(0) { } //------------------------------------------------------------------------ ScQueryParam::~ScQueryParam() { } //------------------------------------------------------------------------ void ScQueryParam::Clear() { nCol1=nCol2 = 0; nRow1=nRow2 = 0; nTab = SCTAB_MAX; bHasHeader = bCaseSens = bRegExp = bMixedComparison = sal_False; bInplace = bByRow = bDuplicate = sal_True; Resize( MAXQUERY ); for (sal_uInt16 i=0; i( nCol1 + nDifX ); nRow1 = sal::static_int_cast( nRow1 + nDifY ); nCol2 = sal::static_int_cast( nCol2 + nDifX ); nRow2 = sal::static_int_cast( nRow2 + nDifY ); nTab = sal::static_int_cast( nTab + nDifZ ); size_t n = maEntries.size(); for (size_t i=0; i