sc/inc/cellform.hxx | 11 ++--------- sc/source/core/data/column2.cxx | 8 ++++---- sc/source/core/tool/cellform.cxx | 23 ++++------------------- sc/source/ui/view/output2.cxx | 8 +++----- 4 files changed, 13 insertions(+), 37 deletions(-)
New commits: commit e6b0ad680e6fa122e49bf01116edb049dc4b0570 Author: Eike Rathke <er...@redhat.com> Date: Thu Oct 6 21:29:26 2016 +0200 Resolves: tdf#76836 use text format only for text content Numeric content is not to be formatted with the text format. Entering a value in such formatted cell still forces it to text content as usual and then it is displayed using the text format. The previous behavior displaying also numeric content using the text format was always wrong and neither Excel nor Gnumeric do it. A numeric content is displayed left aligned though, which also Excel does. Change-Id: I3038123b2bfdc4669a8f73840742da92a1df895d diff --git a/sc/inc/cellform.hxx b/sc/inc/cellform.hxx index 84ee916..ff2bb8a 100644 --- a/sc/inc/cellform.hxx +++ b/sc/inc/cellform.hxx @@ -30,12 +30,6 @@ class ScDocument; class ScAddress; struct ScRefCellValue; -enum ScForceTextFmt { - ftDontForce, ///< numbers as numbers - ftForce, ///< numbers as text - ftCheck ///< is the numberformat a textformat? -}; - class SC_DLLPUBLIC ScCellFormat { public: @@ -43,13 +37,12 @@ public: static void GetString( ScRefCellValue& rCell, sal_uLong nFormat, OUString& rString, Color** ppColor, SvNumberFormatter& rFormatter, const ScDocument* pDoc, bool bNullVals = true, - bool bFormula = false, ScForceTextFmt eForceTextFmt = ftDontForce, - bool bUseStarFormat = false ); + bool bFormula = false, bool bUseStarFormat = false ); static OUString GetString( ScDocument& rDoc, const ScAddress& rPos, sal_uLong nFormat, Color** ppColor, SvNumberFormatter& rFormatter, bool bNullVals = true, - bool bFormula = false, ScForceTextFmt eForceTextFmt = ftDontForce ); + bool bFormula = false ); static void GetInputString( ScRefCellValue& rCell, sal_uLong nFormat, OUString& rString, SvNumberFormatter& rFormatter, diff --git a/sc/source/core/data/column2.cxx b/sc/source/core/data/column2.cxx index 85ab7e6..063e14e 100644 --- a/sc/source/core/data/column2.cxx +++ b/sc/source/core/data/column2.cxx @@ -271,7 +271,7 @@ long ScColumn::GetNeededSize( Color* pColor; OUString aValStr; ScCellFormat::GetString( - aCell, nFormat, aValStr, &pColor, *pFormatter, pDocument, true, rOptions.bFormula, ftCheck); + aCell, nFormat, aValStr, &pColor, *pFormatter, pDocument, true, rOptions.bFormula); if (!aValStr.isEmpty()) { @@ -443,7 +443,7 @@ long ScColumn::GetNeededSize( OUString aString; ScCellFormat::GetString( aCell, nFormat, aString, &pColor, *pFormatter, pDocument, true, - rOptions.bFormula, ftCheck); + rOptions.bFormula); if (!aString.isEmpty()) pEngine->SetTextNewDefaults(aString, pSet); @@ -581,7 +581,7 @@ class MaxStrLenFinder Color* pColor; OUString aValStr; ScCellFormat::GetString( - rCell, mnFormat, aValStr, &pColor, *mrDoc.GetFormatTable(), &mrDoc, true, false, ftCheck); + rCell, mnFormat, aValStr, &pColor, *mrDoc.GetFormatTable(), &mrDoc, true, false); if (aValStr.getLength() > mnMaxLen) { @@ -668,7 +668,7 @@ sal_uInt16 ScColumn::GetOptimalColWidth( { ScRefCellValue aCell = GetCellValue(pParam->mnMaxTextRow); ScCellFormat::GetString( - aCell, nFormat, aLongStr, &pColor, *pFormatter, pDocument, true, false, ftCheck); + aCell, nFormat, aLongStr, &pColor, *pFormatter, pDocument, true, false); } else { diff --git a/sc/source/core/tool/cellform.cxx b/sc/source/core/tool/cellform.cxx index 0507d7c..afa9eea 100644 --- a/sc/source/core/tool/cellform.cxx +++ b/sc/source/core/tool/cellform.cxx @@ -35,8 +35,7 @@ const ScFormulaCell* pLastFormulaTreeTop = nullptr; void ScCellFormat::GetString( ScRefCellValue& rCell, sal_uLong nFormat, OUString& rString, Color** ppColor, SvNumberFormatter& rFormatter, const ScDocument* pDoc, - bool bNullVals, bool bFormula, ScForceTextFmt eForceTextFmt, - bool bUseStarFormat ) + bool bNullVals, bool bFormula, bool bUseStarFormat ) { *ppColor = nullptr; @@ -54,21 +53,7 @@ void ScCellFormat::GetString( ScRefCellValue& rCell, sal_uLong nFormat, OUString if (!bNullVals && nValue == 0.0) rString.clear(); else - { - if( eForceTextFmt == ftCheck ) - { - if( nFormat && rFormatter.IsTextFormat( nFormat ) ) - eForceTextFmt = ftForce; - } - if( eForceTextFmt == ftForce ) - { - OUString aTemp; - rFormatter.GetOutputString( nValue, 0, aTemp, ppColor ); - rFormatter.GetOutputString( aTemp, nFormat, rString, ppColor ); - } - else - rFormatter.GetOutputString( nValue, nFormat, rString, ppColor, bUseStarFormat ); - } + rFormatter.GetOutputString( nValue, nFormat, rString, ppColor, bUseStarFormat ); } break; case CELLTYPE_FORMULA: @@ -127,13 +112,13 @@ void ScCellFormat::GetString( ScRefCellValue& rCell, sal_uLong nFormat, OUString OUString ScCellFormat::GetString( ScDocument& rDoc, const ScAddress& rPos, sal_uLong nFormat, Color** ppColor, - SvNumberFormatter& rFormatter, bool bNullVals, bool bFormula, ScForceTextFmt eForceTextFmt ) + SvNumberFormatter& rFormatter, bool bNullVals, bool bFormula ) { OUString aString; *ppColor = nullptr; ScRefCellValue aCell(rDoc, rPos); - GetString(aCell, nFormat, aString, ppColor, rFormatter, &rDoc, bNullVals, bFormula, eForceTextFmt); + GetString(aCell, nFormat, aString, ppColor, rFormatter, &rDoc, bNullVals, bFormula); return aString; } diff --git a/sc/source/ui/view/output2.cxx b/sc/source/ui/view/output2.cxx index e6e75b2..0db7147 100644 --- a/sc/source/ui/view/output2.cxx +++ b/sc/source/ui/view/output2.cxx @@ -505,7 +505,7 @@ bool ScDrawStringsVars::SetText( ScRefCellValue& rCell ) pOutput->mpDoc, pOutput->mbShowNullValues, pOutput->mbShowFormulas, - ftCheck, true ); + true ); if ( nFormat ) { nRepeatPos = aString.indexOf( 0x1B ); @@ -2394,8 +2394,7 @@ bool ScOutputData::DrawEditParam::readCellContent( *pDoc->GetFormatTable(), pDoc, bShowNullValues, - bShowFormulas, - ftCheck ); + bShowFormulas); mpEngine->SetText(aString); if ( pColor && !bSyntaxMode && !( bUseStyleColor && bForceAutoColor ) ) @@ -4922,8 +4921,7 @@ void ScOutputData::DrawRotated(bool bPixelToLogic) *mpDoc->GetFormatTable(), mpDoc, mbShowNullValues, - mbShowFormulas, - ftCheck ); + mbShowFormulas); pEngine->SetText(aString); if ( pColor && !mbSyntaxMode && !( mbUseStyleColor && mbForceAutoColor ) ) _______________________________________________ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits