Lines Matching refs:aReplaceFormula
448 OUString aReplaceFormula; in finalizeImport() local
460 aReplaceFormula = CREATE_OUSTRING( "NOT(ISERROR(SEARCH(#T,#B)))" ); in finalizeImport()
465 aReplaceFormula = CREATE_OUSTRING( "ISERROR(SEARCH(#T,#B))" ); in finalizeImport()
469 aReplaceFormula = CREATE_OUSTRING( "LEFT(#B,#L)=#T" ); in finalizeImport()
473 aReplaceFormula = CREATE_OUSTRING( "RIGHT(#B,#L)=#T" ); in finalizeImport()
479 aReplaceFormula = CREATE_OUSTRING( "FLOOR(#B,1)=TODAY()-1" ); in finalizeImport()
482 aReplaceFormula = CREATE_OUSTRING( "FLOOR(#B,1)=TODAY()" ); in finalizeImport()
485 aReplaceFormula = CREATE_OUSTRING( "FLOOR(#B,1)=TODAY()+1" ); in finalizeImport()
488 … aReplaceFormula = CREATE_OUSTRING( "AND(TODAY()-7<FLOOR(#B,1),FLOOR(#B,1)<=TODAY())" ); in finalizeImport()
491 …aReplaceFormula = CREATE_OUSTRING( "AND(TODAY()-WEEKDAY(TODAY())-7<FLOOR(#B,1),FLOOR(#B,1)<=TODAY(… in finalizeImport()
494 …aReplaceFormula = CREATE_OUSTRING( "AND(TODAY()-WEEKDAY(TODAY())<FLOOR(#B,1),FLOOR(#B,1)<=TODAY()-… in finalizeImport()
497 …aReplaceFormula = CREATE_OUSTRING( "AND(TODAY()-WEEKDAY(TODAY())+7<FLOOR(#B,1),FLOOR(#B,1)<=TODAY(… in finalizeImport()
500 …aReplaceFormula = CREATE_OUSTRING( "OR(AND(MONTH(#B)=MONTH(TODAY())-1,YEAR(#B)=YEAR(TODAY())),AND(… in finalizeImport()
503 … aReplaceFormula = CREATE_OUSTRING( "AND(MONTH(#B)=MONTH(TODAY()),YEAR(#B)=YEAR(TODAY()))" ); in finalizeImport()
506 …aReplaceFormula = CREATE_OUSTRING( "OR(AND(MONTH(#B)=MONTH(TODAY())+1,YEAR(#B)=YEAR(TODAY())),AND(… in finalizeImport()
513 aReplaceFormula = CREATE_OUSTRING( "LEN(TRIM(#B))=0" ); in finalizeImport()
516 aReplaceFormula = CREATE_OUSTRING( "LEN(TRIM(#B))>0" ); in finalizeImport()
519 aReplaceFormula = CREATE_OUSTRING( "ISERROR(#B)" ); in finalizeImport()
522 aReplaceFormula = CREATE_OUSTRING( "NOT(ISERROR(#B))" ); in finalizeImport()
526 aReplaceFormula = CREATE_OUSTRING( "RANK(#B,#R,#M)/COUNT(#R)<=#K%" ); in finalizeImport()
528 aReplaceFormula = CREATE_OUSTRING( "RANK(#B,#R,#M)<=#K" ); in finalizeImport()
532 aReplaceFormula = CREATE_OUSTRING( "#B#CAVERAGE(#R)" ); in finalizeImport()
536 if( aReplaceFormula.getLength() > 0 ) in finalizeImport()
539 sal_Int32 nStrPos = aReplaceFormula.getLength(); in finalizeImport()
540 while( (nStrPos = aReplaceFormula.lastIndexOf( '#', nStrPos )) >= 0 ) in finalizeImport()
542 switch( aReplaceFormula[ nStrPos + 1 ] ) in finalizeImport()
547 aReplaceFormula = aReplaceFormula.replaceAt( nStrPos, 2, aAddress ); in finalizeImport()
552 aReplaceFormula = aReplaceFormula.replaceAt( nStrPos, 2, aRanges ); in finalizeImport()
558 aReplaceFormula = aReplaceFormula.replaceAt( nStrPos, 2, aText ); in finalizeImport()
561 aReplaceFormula = aReplaceFormula.replaceAt( nStrPos, 2, in finalizeImport()
565 aReplaceFormula = aReplaceFormula.replaceAt( nStrPos, 2, in finalizeImport()
569 aReplaceFormula = aReplaceFormula.replaceAt( nStrPos, 2, in finalizeImport()
577 aReplaceFormula = aReplaceFormula.replaceAt( nStrPos, 2, aComp ); in finalizeImport()
586 appendFormula( aReplaceFormula ); in finalizeImport()