diff options
Diffstat (limited to 'sc/source')
| -rw-r--r-- | sc/source/core/data/dpoutput.cxx | 15 |
1 files changed, 13 insertions, 2 deletions
diff --git a/sc/source/core/data/dpoutput.cxx b/sc/source/core/data/dpoutput.cxx index e52fbed66432..cfd90933baaa 100644 --- a/sc/source/core/data/dpoutput.cxx +++ b/sc/source/core/data/dpoutput.cxx @@ -57,6 +57,8 @@ #include "unonames.hxx" #include "sc.hrc" #include "dpglobal.hxx" +#include "stringutil.hxx" + #include <com/sun/star/beans/XPropertySet.hpp> #include <vector> @@ -795,7 +797,11 @@ void ScDPOutput::HeaderCell( SCCOL nCol, SCROW nRow, SCTAB nTab, if ( nFlags & sheet::MemberResultFlags::HASMEMBER ) { - pDoc->SetString( nCol, nRow, nTab, rData.Caption); + // Avoid unwanted automatic format detection. + ScSetStringParam aParam; + aParam.mbDetectNumberFormat = false; + aParam.mbSetTextCellFormat = true; + pDoc->SetString(nCol, nRow, nTab, rData.Caption, &aParam); } if ( nFlags & sheet::MemberResultFlags::SUBTOTAL ) @@ -827,7 +833,12 @@ void ScDPOutput::HeaderCell( SCCOL nCol, SCROW nRow, SCTAB nTab, void ScDPOutput::FieldCell( SCCOL nCol, SCROW nRow, SCTAB nTab, const String& rCaption, bool bInTable, bool bPopup, bool bHasHiddenMember ) { - pDoc->SetString( nCol, nRow, nTab, rCaption ); + // Avoid unwanted automatic format detection. + ScSetStringParam aParam; + aParam.mbDetectNumberFormat = false; + aParam.mbSetTextCellFormat = true; + pDoc->SetString(nCol, nRow, nTab, rCaption, &aParam); + if (bInTable) lcl_SetFrame( pDoc,nTab, nCol,nRow, nCol,nRow, 20 ); |