Lines Matching refs:rEntry
949 ScQueryEntry& rEntry = rParam.GetEntry(i); in ValidQuery() local
952 pCell = GetCell( static_cast<SCCOL>(rEntry.nField), nRow ); in ValidQuery()
959 if (rEntry.nVal == SC_EMPTYFIELDS) in ValidQuery()
960 bOk = !( aCol[rEntry.nField].HasDataAt( nRow ) ); in ValidQuery()
962 bOk = aCol[rEntry.nField].HasDataAt( nRow ); in ValidQuery()
964 else if ( !rEntry.bQueryByString && (pCell ? pCell->HasValueData() : in ValidQuery()
965 HasValueData( static_cast<SCCOL>(rEntry.nField), nRow))) in ValidQuery()
984 nCellVal = GetValue( static_cast<SCCOL>(rEntry.nField), nRow ); in ValidQuery()
992 if (rEntry.bQueryByDate) in ValidQuery()
994 sal_uInt32 nNumFmt = GetNumberFormat(static_cast<SCCOL>(rEntry.nField), nRow); in ValidQuery()
1014 switch (rEntry.eOp) in ValidQuery()
1017 bOk = ::rtl::math::approxEqual( nCellVal, rEntry.nVal ); in ValidQuery()
1020 bOk = (nCellVal < rEntry.nVal) && !::rtl::math::approxEqual( nCellVal, rEntry.nVal ); in ValidQuery()
1023 bOk = (nCellVal > rEntry.nVal) && !::rtl::math::approxEqual( nCellVal, rEntry.nVal ); in ValidQuery()
1026 bOk = (nCellVal < rEntry.nVal) || ::rtl::math::approxEqual( nCellVal, rEntry.nVal ); in ValidQuery()
1028 bTestEqual = ::rtl::math::approxEqual( nCellVal, rEntry.nVal ); in ValidQuery()
1031 bOk = (nCellVal > rEntry.nVal) || ::rtl::math::approxEqual( nCellVal, rEntry.nVal ); in ValidQuery()
1033 bTestEqual = ::rtl::math::approxEqual( nCellVal, rEntry.nVal ); in ValidQuery()
1036 bOk = !::rtl::math::approxEqual( nCellVal, rEntry.nVal ); in ValidQuery()
1044 else if ( (rEntry.eOp == SC_EQUAL || rEntry.eOp == SC_NOT_EQUAL) || in ValidQuery()
1045 (rEntry.eOp == SC_CONTAINS || rEntry.eOp == SC_DOES_NOT_CONTAIN || in ValidQuery()
1046 rEntry.eOp == SC_BEGINS_WITH || rEntry.eOp == SC_ENDS_WITH || in ValidQuery()
1047 rEntry.eOp == SC_DOES_NOT_BEGIN_WITH || rEntry.eOp == SC_DOES_NOT_END_WITH) || in ValidQuery()
1048 (rEntry.bQueryByString && (pCell ? pCell->HasStringData() : in ValidQuery()
1050 static_cast<SCCOL>(rEntry.nField), in ValidQuery()
1054 if( rEntry.eOp == SC_CONTAINS || rEntry.eOp == SC_DOES_NOT_CONTAIN in ValidQuery()
1055 || rEntry.eOp == SC_BEGINS_WITH || rEntry.eOp == SC_ENDS_WITH in ValidQuery()
1056 || rEntry.eOp == SC_DOES_NOT_BEGIN_WITH || rEntry.eOp == SC_DOES_NOT_END_WITH ) in ValidQuery()
1062 sal_uLong nFormat = GetNumberFormat( static_cast<SCCOL>(rEntry.nField), nRow ); in ValidQuery()
1067 GetInputString( static_cast<SCCOL>(rEntry.nField), nRow, aCellStr ); in ValidQuery()
1069 sal_Bool bRealRegExp = (rParam.bRegExp && ((rEntry.eOp == SC_EQUAL) in ValidQuery()
1070 || (rEntry.eOp == SC_NOT_EQUAL) || (rEntry.eOp == SC_CONTAINS) in ValidQuery()
1071 || (rEntry.eOp == SC_DOES_NOT_CONTAIN) || (rEntry.eOp == SC_BEGINS_WITH) in ValidQuery()
1072 || (rEntry.eOp == SC_ENDS_WITH) || (rEntry.eOp == SC_DOES_NOT_BEGIN_WITH) in ValidQuery()
1073 || (rEntry.eOp == SC_DOES_NOT_END_WITH))); in ValidQuery()
1075 && ((rEntry.eOp == SC_LESS_EQUAL) in ValidQuery()
1076 || (rEntry.eOp == SC_GREATER_EQUAL))); in ValidQuery()
1084 if ( rEntry.eOp == SC_ENDS_WITH || rEntry.eOp == SC_DOES_NOT_END_WITH ) in ValidQuery()
1088 bMatch = (sal_Bool) rEntry.GetSearchTextPtr( rParam.bCaseSens ) in ValidQuery()
1093 bMatch = (sal_Bool) rEntry.GetSearchTextPtr( rParam.bCaseSens ) in ValidQuery()
1100 switch (rEntry.eOp) in ValidQuery()
1132 if ( rEntry.eOp == SC_EQUAL || rEntry.eOp == SC_NOT_EQUAL in ValidQuery()
1133 || rEntry.eOp == SC_CONTAINS || rEntry.eOp == SC_DOES_NOT_CONTAIN in ValidQuery()
1134 || rEntry.eOp == SC_BEGINS_WITH || rEntry.eOp == SC_ENDS_WITH in ValidQuery()
1135 || rEntry.eOp == SC_DOES_NOT_BEGIN_WITH || rEntry.eOp == SC_DOES_NOT_END_WITH ) in ValidQuery()
1137 if ( !rEntry.bQueryByString && rEntry.pStr->Len() == 0 ) in ValidQuery()
1143 if ( rEntry.eOp == SC_NOT_EQUAL ) in ValidQuery()
1148 bOk = pTransliteration->isEqual( aCellStr, *rEntry.pStr ); in ValidQuery()
1149 if ( rEntry.eOp == SC_NOT_EQUAL ) in ValidQuery()
1158 *rEntry.pStr, ScGlobal::eLnge, 0, rEntry.pStr->Len(), in ValidQuery()
1160 xub_StrLen nIndex = (rEntry.eOp == SC_ENDS_WITH in ValidQuery()
1161 || rEntry.eOp == SC_DOES_NOT_END_WITH)? (aCell.Len()-aQuer.Len()):0; in ValidQuery()
1163 switch (rEntry.eOp) in ValidQuery()
1195 aCellStr, *rEntry.pStr ); in ValidQuery()
1196 switch (rEntry.eOp) in ValidQuery()
1224 if (rEntry.bQueryByString && in ValidQuery()
1225 (rEntry.eOp == SC_LESS || rEntry.eOp == SC_LESS_EQUAL) && in ValidQuery()
1227 HasValueData( static_cast<SCCOL>(rEntry.nField), nRow))) in ValidQuery()
1231 else if (!rEntry.bQueryByString && in ValidQuery()
1232 (rEntry.eOp == SC_GREATER || rEntry.eOp == SC_GREATER_EQUAL) && in ValidQuery()
1234 HasStringData( static_cast<SCCOL>(rEntry.nField), nRow))) in ValidQuery()
1248 if (rEntry.eConnect == SC_AND) in ValidQuery()
1288 ScQueryEntry& rEntry = rParam.GetEntry(i); in TopTenQuery() local
1289 switch ( rEntry.eOp ) in TopTenQuery()
1296 ScSortParam aLocalSortParam( rParam, static_cast<SCCOL>(rEntry.nField) ); in TopTenQuery()
1318 if ( rEntry.bQueryByString ) in TopTenQuery()
1320 rEntry.bQueryByString = sal_False; in TopTenQuery()
1321 rEntry.nVal = 10; // 10 bzw. 10% in TopTenQuery()
1323 SCSIZE nVal = (rEntry.nVal >= 1 ? static_cast<SCSIZE>(rEntry.nVal) : 1); in TopTenQuery()
1325 switch ( rEntry.eOp ) in TopTenQuery()
1329 rEntry.eOp = SC_GREATER_EQUAL; in TopTenQuery()
1337 rEntry.eOp = SC_LESS_EQUAL; in TopTenQuery()
1345 rEntry.eOp = SC_GREATER_EQUAL; in TopTenQuery()
1355 rEntry.eOp = SC_LESS_EQUAL; in TopTenQuery()
1372 rEntry.nVal = ((ScValueCell*)pCell)->GetValue(); in TopTenQuery()
1374 rEntry.nVal = ((ScFormulaCell*)pCell)->GetValue(); in TopTenQuery()
1379 rEntry.eOp = SC_GREATER_EQUAL; in TopTenQuery()
1380 rEntry.nVal = 0; in TopTenQuery()
1385 rEntry.eOp = SC_GREATER_EQUAL; in TopTenQuery()
1386 rEntry.bQueryByString = sal_False; in TopTenQuery()
1387 rEntry.nVal = 0; in TopTenQuery()
1410 ScQueryEntry& rEntry = rParam.GetEntry(i); in lcl_PrepareQuery() local
1411 if ( rEntry.bDoQuery ) in lcl_PrepareQuery()
1413 if ( rEntry.bQueryByString ) in lcl_PrepareQuery()
1416 rEntry.bQueryByString = !( pDoc->GetFormatTable()-> in lcl_PrepareQuery()
1417 IsNumberFormat( *rEntry.pStr, nIndex, rEntry.nVal ) ); in lcl_PrepareQuery()
1418 if (rEntry.bQueryByDate) in lcl_PrepareQuery()
1420 if (!rEntry.bQueryByString && ((nIndex % SV_COUNTRY_LANGUAGE_OFFSET) != 0)) in lcl_PrepareQuery()
1427 rEntry.bQueryByDate = false; // not a date only in lcl_PrepareQuery()
1430 rEntry.bQueryByDate = false; // what the ... not a date in lcl_PrepareQuery()
1433 rEntry.bQueryByDate = false; // not a date in lcl_PrepareQuery()
1439 if ( rEntry.nVal == SC_EMPTYFIELDS || rEntry.nVal == SC_NONEMPTYFIELDS ) in lcl_PrepareQuery()
1446 switch ( rEntry.eOp ) in lcl_PrepareQuery()
1749 ScQueryEntry& rEntry = rQueryParam.GetEntry(nIndex); in CreateStarQuery() local
1758 rEntry.eConnect = SC_AND; in CreateStarQuery()
1763 rEntry.eConnect = SC_OR; in CreateStarQuery()
1782 rEntry.nField = i; in CreateStarQuery()
1797 rEntry.eOp = SC_NOT_EQUAL; in CreateStarQuery()
1799 rEntry.eOp = SC_LESS_EQUAL; in CreateStarQuery()
1801 rEntry.eOp = SC_LESS; in CreateStarQuery()
1806 rEntry.eOp = SC_GREATER_EQUAL; in CreateStarQuery()
1808 rEntry.eOp = SC_GREATER; in CreateStarQuery()
1811 rEntry.eOp = SC_EQUAL; in CreateStarQuery()
1817 GetString(nCol1 + 3, nRow, *rEntry.pStr); in CreateStarQuery()
1818 rEntry.bDoQuery = sal_True; in CreateStarQuery()
1894 ScQueryEntry& rEntry = aParam.GetEntry(i); in GetFilteredFilterEntries() local
1895 if ( rEntry.nField == nCol ) in GetFilteredFilterEntries()