summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sc/inc/reffind.hxx33
-rw-r--r--sc/qa/unit/ucalc.cxx10
-rw-r--r--sc/source/core/tool/reffind.cxx100
3 files changed, 76 insertions, 67 deletions
diff --git a/sc/inc/reffind.hxx b/sc/inc/reffind.hxx
index d800b5c21684..1a5b228d11c0 100644
--- a/sc/inc/reffind.hxx
+++ b/sc/inc/reffind.hxx
@@ -25,31 +25,28 @@
class ScDocument;
-// -----------------------------------------------------------------------
-
class ScRefFinder
{
-private:
- String aFormula;
- formula::FormulaGrammar::AddressConvention eConv;
- ScDocument* pDoc;
- ScAddress maPos;
- xub_StrLen nFound;
- xub_StrLen nSelStart;
- xub_StrLen nSelEnd;
+ OUString maFormula;
+ formula::FormulaGrammar::AddressConvention meConv;
+ ScDocument* mpDoc;
+ ScAddress maPos;
+ sal_Int32 mnFound;
+ sal_Int32 mnSelStart;
+ sal_Int32 mnSelEnd;
public:
- ScRefFinder( const String& rFormula, const ScAddress& rPos,
- ScDocument* pDocument = NULL,
- formula::FormulaGrammar::AddressConvention eConvP = formula::FormulaGrammar::CONV_OOO );
+ ScRefFinder(
+ const OUString& rFormula, const ScAddress& rPos, ScDocument* pDoc = NULL,
+ formula::FormulaGrammar::AddressConvention eConvP = formula::FormulaGrammar::CONV_OOO );
~ScRefFinder();
- const String& GetText() const { return aFormula; }
- xub_StrLen GetFound() const { return nFound; }
- xub_StrLen GetSelStart() const { return nSelStart; }
- xub_StrLen GetSelEnd() const { return nSelEnd; }
+ const OUString& GetText() const { return maFormula; }
+ sal_Int32 GetFound() const { return mnFound; }
+ sal_Int32 GetSelStart() const { return mnSelStart; }
+ sal_Int32 GetSelEnd() const { return mnSelEnd; }
- void ToggleRel( xub_StrLen nStartPos, xub_StrLen nEndPos );
+ void ToggleRel( sal_Int32 nStartPos, sal_Int32 nEndPos );
};
diff --git a/sc/qa/unit/ucalc.cxx b/sc/qa/unit/ucalc.cxx
index 2e3e5fb2e332..ed67ad1034bb 100644
--- a/sc/qa/unit/ucalc.cxx
+++ b/sc/qa/unit/ucalc.cxx
@@ -4973,22 +4973,22 @@ void Test::testToggleRefFlag()
// column absolute / row absolute -> column relative / row absolute
aFinder.ToggleRel(0, aFormula.getLength());
aFormula = aFinder.GetText();
- CPPUNIT_ASSERT_MESSAGE( "Wrong conversion.", aFormula == "=R2C[-3]" );
+ CPPUNIT_ASSERT_EQUAL(OUString("=R2C[-3]"), aFormula);
// column relative / row absolute - > column absolute / row relative
aFinder.ToggleRel(0, aFormula.getLength());
aFormula = aFinder.GetText();
- CPPUNIT_ASSERT_MESSAGE( "Wrong conversion.", aFormula == "=R[-4]C1" );
+ CPPUNIT_ASSERT_EQUAL(OUString("=R[-4]C1"), aFormula);
// column absolute / row relative -> column relative / row relative
aFinder.ToggleRel(0, aFormula.getLength());
aFormula = aFinder.GetText();
- CPPUNIT_ASSERT_MESSAGE( "Wrong conversion.", aFormula == "=R[-4]C[-3]" );
+ CPPUNIT_ASSERT_EQUAL(OUString("=R[-4]C[-3]"), aFormula);
// column relative / row relative -> column absolute / row absolute
aFinder.ToggleRel(0, aFormula.getLength());
aFormula = aFinder.GetText();
- CPPUNIT_ASSERT_MESSAGE( "Wrong conversion.", aFormula == "=R2C1" );
+ CPPUNIT_ASSERT_EQUAL(OUString("=R2C1"), aFormula);
}
{
@@ -4999,7 +4999,7 @@ void Test::testToggleRefFlag()
ScRefFinder aFinder(aFormula, aPos, m_pDoc, formula::FormulaGrammar::CONV_XL_R1C1);
// Original
- CPPUNIT_ASSERT_EQUAL(aFormula, OUString(aFinder.GetText()));
+ CPPUNIT_ASSERT_EQUAL(aFormula, aFinder.GetText());
// Make the column relative.
sal_Int32 n = aFormula.getLength();
diff --git a/sc/source/core/tool/reffind.cxx b/sc/source/core/tool/reffind.cxx
index c4621f0029b8..88932c6dab22 100644
--- a/sc/source/core/tool/reffind.cxx
+++ b/sc/source/core/tool/reffind.cxx
@@ -65,7 +65,7 @@ inline bool IsText( bool& bQuote, sal_Unicode c )
* considered a text when it's within the ascii range and when it's not a
* delimiter.
*/
-xub_StrLen FindStartPos(const sal_Unicode* p, xub_StrLen nStartPos, xub_StrLen nEndPos)
+sal_Int32 FindStartPos(const sal_Unicode* p, sal_Int32 nStartPos, sal_Int32 nEndPos)
{
while (nStartPos <= nEndPos && !IsText(p[nStartPos]))
++nStartPos;
@@ -73,19 +73,19 @@ xub_StrLen FindStartPos(const sal_Unicode* p, xub_StrLen nStartPos, xub_StrLen n
return nStartPos;
}
-xub_StrLen FindEndPosA1(const sal_Unicode* p, xub_StrLen nStartPos, xub_StrLen nEndPos)
+sal_Int32 FindEndPosA1(const sal_Unicode* p, sal_Int32 nStartPos, sal_Int32 nEndPos)
{
bool bQuote = false;
- xub_StrLen nNewEnd = nStartPos;
+ sal_Int32 nNewEnd = nStartPos;
while (nNewEnd <= nEndPos && IsText(bQuote, p[nNewEnd]))
++nNewEnd;
return nNewEnd;
}
-xub_StrLen FindEndPosR1C1(const sal_Unicode* p, xub_StrLen nStartPos, xub_StrLen nEndPos)
+sal_Int32 FindEndPosR1C1(const sal_Unicode* p, sal_Int32 nStartPos, sal_Int32 nEndPos)
{
- xub_StrLen nNewEnd = nStartPos;
+ sal_Int32 nNewEnd = nStartPos;
p = &p[nStartPos];
for (; nNewEnd <= nEndPos; ++p, ++nNewEnd)
{
@@ -95,6 +95,8 @@ xub_StrLen FindEndPosR1C1(const sal_Unicode* p, xub_StrLen nStartPos, xub_StrLen
for (; nNewEnd <= nEndPos; ++p, ++nNewEnd)
if (*p == '\'')
break;
+ if (nNewEnd > nEndPos)
+ break;
}
else if (*p == '[')
{
@@ -102,6 +104,8 @@ xub_StrLen FindEndPosR1C1(const sal_Unicode* p, xub_StrLen nStartPos, xub_StrLen
for (; nNewEnd <= nEndPos; ++p, ++nNewEnd)
if (*p == ']')
break;
+ if (nNewEnd > nEndPos)
+ break;
}
else if (!IsText(*p))
break;
@@ -114,8 +118,8 @@ xub_StrLen FindEndPosR1C1(const sal_Unicode* p, xub_StrLen nStartPos, xub_StrLen
* Find last character position that is considred text, from the specified
* start position.
*/
-xub_StrLen FindEndPos(const sal_Unicode* p, xub_StrLen nStartPos, xub_StrLen nEndPos,
- formula::FormulaGrammar::AddressConvention eConv)
+sal_Int32 FindEndPos(const sal_Unicode* p, sal_Int32 nStartPos, sal_Int32 nEndPos,
+ formula::FormulaGrammar::AddressConvention eConv)
{
switch (eConv)
{
@@ -128,7 +132,7 @@ xub_StrLen FindEndPos(const sal_Unicode* p, xub_StrLen nStartPos, xub_StrLen nEn
}
}
-void ExpandToTextA1(const sal_Unicode* p, xub_StrLen nLen, xub_StrLen& rStartPos, xub_StrLen& rEndPos)
+void ExpandToTextA1(const sal_Unicode* p, sal_Int32 nLen, sal_Int32& rStartPos, sal_Int32& rEndPos)
{
while (rStartPos > 0 && IsText(p[rStartPos - 1]) )
--rStartPos;
@@ -138,7 +142,7 @@ void ExpandToTextA1(const sal_Unicode* p, xub_StrLen nLen, xub_StrLen& rStartPos
++rEndPos;
}
-void ExpandToTextR1C1(const sal_Unicode* p, xub_StrLen nLen, xub_StrLen& rStartPos, xub_StrLen& rEndPos)
+void ExpandToTextR1C1(const sal_Unicode* p, sal_Int32 nLen, sal_Int32& rStartPos, sal_Int32& rEndPos)
{
// move back the start position to the first text character.
if (rStartPos > 0)
@@ -182,7 +186,7 @@ void ExpandToTextR1C1(const sal_Unicode* p, xub_StrLen nLen, xub_StrLen& rStartP
rEndPos = FindEndPosR1C1(p, rEndPos, nLen-1);
}
-void ExpandToText(const sal_Unicode* p, xub_StrLen nLen, xub_StrLen& rStartPos, xub_StrLen& rEndPos,
+void ExpandToText(const sal_Unicode* p, sal_Int32 nLen, sal_Int32& rStartPos, sal_Int32& rEndPos,
formula::FormulaGrammar::AddressConvention eConv)
{
switch (eConv)
@@ -200,14 +204,16 @@ void ExpandToText(const sal_Unicode* p, xub_StrLen nLen, xub_StrLen& rStartPos,
}
ScRefFinder::ScRefFinder(
- const String& rFormula, const ScAddress& rPos,
- ScDocument* pDocument, formula::FormulaGrammar::AddressConvention eConvP) :
- aFormula( rFormula ),
- eConv( eConvP ),
- pDoc( pDocument ),
- maPos(rPos)
+ const OUString& rFormula, const ScAddress& rPos,
+ ScDocument* pDoc, formula::FormulaGrammar::AddressConvention eConvP) :
+ maFormula(rFormula),
+ meConv(eConvP),
+ mpDoc(pDoc),
+ maPos(rPos),
+ mnFound(0),
+ mnSelStart(0),
+ mnSelEnd(0)
{
- nSelStart = nSelEnd = nFound = 0;
}
ScRefFinder::~ScRefFinder()
@@ -225,50 +231,55 @@ static sal_uInt16 lcl_NextFlags( sal_uInt16 nOld )
return ( nOld & 0xfff8 ) | nNew;
}
-void ScRefFinder::ToggleRel( xub_StrLen nStartPos, xub_StrLen nEndPos )
+void ScRefFinder::ToggleRel( sal_Int32 nStartPos, sal_Int32 nEndPos )
{
- xub_StrLen nLen = aFormula.Len();
- if (!nLen)
+ sal_Int32 nLen = maFormula.getLength();
+ if (nLen <= 0)
return;
- const sal_Unicode* pSource = aFormula.GetBuffer(); // for quick access
+ const sal_Unicode* pSource = maFormula.getStr(); // for quick access
// expand selection, and instead of selection start- and end-index
if ( nEndPos < nStartPos )
::std::swap(nEndPos, nStartPos);
- ExpandToText(pSource, nLen, nStartPos, nEndPos, eConv);
+ ExpandToText(pSource, nLen, nStartPos, nEndPos, meConv);
- String aResult;
- String aExpr;
- String aSep;
+ OUString aResult;
+ OUString aExpr;
+ OUString aSep;
ScAddress aAddr;
- nFound = 0;
+ mnFound = 0;
- xub_StrLen nLoopStart = nStartPos;
+ sal_Int32 nLoopStart = nStartPos;
while ( nLoopStart <= nEndPos )
{
- // Determine the stard and end positions of a text segment.
- xub_StrLen nEStart = FindStartPos(pSource, nLoopStart, nEndPos);
- xub_StrLen nEEnd = FindEndPos(pSource, nEStart, nEndPos, eConv);
-
- aSep = aFormula.Copy( nLoopStart, nEStart-nLoopStart );
- aExpr = aFormula.Copy( nEStart, nEEnd-nEStart );
+ // Determine the stard and end positions of a text segment. Note that
+ // the end position returned from FindEndPos may be one position after
+ // the last character position in case of the last segment.
+ sal_Int32 nEStart = FindStartPos(pSource, nLoopStart, nEndPos);
+ sal_Int32 nEEnd = FindEndPos(pSource, nEStart, nEndPos, meConv);
+
+ aSep = maFormula.copy(nLoopStart, nEStart-nLoopStart);
+ if (nEEnd < maFormula.getLength())
+ aExpr = maFormula.copy(nEStart, nEEnd-nEStart);
+ else
+ aExpr = maFormula.copy(nEStart);
// Check the validity of the expression, and toggle the relative flag.
- ScAddress::Details aDetails(eConv, maPos.Row(), maPos.Col());
- sal_uInt16 nResult = aAddr.Parse(aExpr, pDoc, aDetails);
+ ScAddress::Details aDetails(meConv, maPos.Row(), maPos.Col());
+ sal_uInt16 nResult = aAddr.Parse(aExpr, mpDoc, aDetails);
if ( nResult & SCA_VALID )
{
sal_uInt16 nFlags = lcl_NextFlags( nResult );
- aAddr.Format(aExpr, nFlags, pDoc, aDetails);
+ aAddr.Format(aExpr, nFlags, mpDoc, aDetails);
- xub_StrLen nAbsStart = nStartPos+aResult.Len()+aSep.Len();
+ sal_Int32 nAbsStart = nStartPos+aResult.getLength()+aSep.getLength();
- if (!nFound) // first reference ?
- nSelStart = nAbsStart;
- nSelEnd = nAbsStart+aExpr.Len(); // selection, no indizes
- ++nFound;
+ if (!mnFound) // first reference ?
+ mnSelStart = nAbsStart;
+ mnSelEnd = nAbsStart + aExpr.getLength(); // selection, no indizes
+ ++mnFound;
}
// assemble
@@ -279,11 +290,12 @@ void ScRefFinder::ToggleRel( xub_StrLen nStartPos, xub_StrLen nEndPos )
nLoopStart = nEEnd;
}
- String aTotal = aFormula.Copy( 0, nStartPos );
+ OUString aTotal = maFormula.copy(0, nStartPos);
aTotal += aResult;
- aTotal += aFormula.Copy( nEndPos+1 );
+ if (nEndPos < maFormula.getLength()-1)
+ aTotal += maFormula.copy(nEndPos);
- aFormula = aTotal;
+ maFormula = aTotal;
}
generated by cgit (git 2.34.1) at 2024-07-27 14:06:34 +0000