30 #include <editeng/editeng.hxx>
49 #include <com/sun/star/awt/XBitmap.hpp>
50 #include <com/sun/star/util/CellProtection.hpp>
51 #include <com/sun/star/table/CellHoriJustify.hpp>
52 #include <com/sun/star/table/CellOrientation.hpp>
53 #include <com/sun/star/table/ShadowFormat.hpp>
54 #include <com/sun/star/table/TableBorder.hpp>
55 #include <com/sun/star/table/TableBorder2.hpp>
56 #include <com/sun/star/sheet/CellFlags.hpp>
57 #include <com/sun/star/sheet/FormulaResult.hpp>
58 #include <com/sun/star/beans/PropertyAttribute.hpp>
59 #include <com/sun/star/lang/IndexOutOfBoundsException.hpp>
60 #include <com/sun/star/lang/Locale.hpp>
61 #include <com/sun/star/beans/TolerantPropertySetResultType.hpp>
62 #include <com/sun/star/beans/SetPropertyTolerantFailed.hpp>
63 #include <com/sun/star/text/WritingMode2.hpp>
64 #include <com/sun/star/text/textfield/Type.hpp>
65 #include <com/sun/star/sheet/XConditionalFormats.hpp>
92 #include <docfunc.hxx>
99 #include <stlsheet.hxx>
114 #include <globstr.hrc>
116 #include <unonames.hxx>
128 #include <tokenarray.hxx>
150 ScNamedEntry(
const OUString& rN,
const ScRange& rR) :
151 aName(rN), aRange(rR) {}
153 const OUString& GetName()
const {
return aName; }
154 const ScRange& GetRange()
const {
return aRange; }
266 {
u"", 0, css::uno::Type(), 0, 0 }
269 return &aCellsPropertySet;
377 {
u"", 0, css::uno::Type(), 0, 0 }
380 return &aRangePropertySet;
494 {
u"", 0, css::uno::Type(), 0, 0 }
497 return &aCellPropertySet;
609 {
u"", 0, css::uno::Type(), 0, 0 }
612 return &aColumnPropertySet;
722 {
u"", 0, css::uno::Type(), 0, 0 }
725 return &aRowPropertySet;
847 {
u"", 0, css::uno::Type(), 0, 0 }
850 return &aSheetPropertySet;
863 {
u"", 0, css::uno::Type(), 0, 0 }
865 return aEditPropertyMap_Impl;
870 return &aEditPropertySet;
876 #define SCCHARPROPERTIES_SERVICE "com.sun.star.style.CharacterProperties"
877 #define SCPARAPROPERTIES_SERVICE "com.sun.star.style.ParagraphProperties"
878 #define SCCELLPROPERTIES_SERVICE "com.sun.star.table.CellProperties"
879 #define SCCELLRANGE_SERVICE "com.sun.star.table.CellRange"
880 #define SCCELL_SERVICE "com.sun.star.table.Cell"
881 #define SCSHEETCELLRANGES_SERVICE "com.sun.star.sheet.SheetCellRanges"
882 #define SCSHEETCELLRANGE_SERVICE "com.sun.star.sheet.SheetCellRange"
883 #define SCSPREADSHEET_SERVICE "com.sun.star.sheet.Spreadsheet"
884 #define SCSHEETCELL_SERVICE "com.sun.star.sheet.SheetCell"
909 uno::Reference<beans::XPropertySetInfo> xInfo(rSource.getPropertySetInfo());
912 const uno::Sequence<beans::Property>
aSeq(xInfo->getProperties());
913 for (
const beans::Property& rProp :
aSeq)
915 OUString
aName(rProp.Name);
916 rDest.setPropertyValue( aName, rSource.getPropertyValue( aName ) );
924 throw std::out_of_range(
"empty range");
925 const ScRange & rFirst = rRanges[0];
931 if ( rRanges.
size() == 1 )
933 const ScRange & rRange = rRanges[0];
942 template<
typename BorderLineType>
943 const ::editeng::SvxBorderLine* lcl_getBorderLine(
960 return lcl_getBorderLine( rLine, rStruct);
966 return lcl_getBorderLine( rLine, rStruct);
970 template<
typename TableBorderType>
981 rInner.
SetValid( SvxBoxInfoItemValidFlags::TOP, rBorder.IsTopLineValid );
982 rInner.
SetValid( SvxBoxInfoItemValidFlags::BOTTOM, rBorder.IsBottomLineValid );
983 rInner.
SetValid( SvxBoxInfoItemValidFlags::LEFT, rBorder.IsLeftLineValid );
984 rInner.
SetValid( SvxBoxInfoItemValidFlags::RIGHT, rBorder.IsRightLineValid );
985 rInner.
SetValid( SvxBoxInfoItemValidFlags::HORI, rBorder.IsHorizontalLineValid );
986 rInner.
SetValid( SvxBoxInfoItemValidFlags::VERT, rBorder.IsVerticalLineValid );
987 rInner.
SetValid( SvxBoxInfoItemValidFlags::DISTANCE, rBorder.IsDistanceValid );
994 lcl_fillBoxItems( rOuter, rInner, rBorder);
999 lcl_fillBoxItems( rOuter, rInner, rBorder);
1015 template<
typename TableBorderItem>
1017 bool bInvalidateHorVerDist )
1027 rBorder.IsTopLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::TOP);
1028 rBorder.IsBottomLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::BOTTOM);
1029 rBorder.IsLeftLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::LEFT);
1030 rBorder.IsRightLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::RIGHT);
1031 rBorder.IsHorizontalLineValid = !bInvalidateHorVerDist && rInner.
IsValid(SvxBoxInfoItemValidFlags::HORI);
1032 rBorder.IsVerticalLineValid = !bInvalidateHorVerDist && rInner.
IsValid(SvxBoxInfoItemValidFlags::VERT);
1033 rBorder.IsDistanceValid = !bInvalidateHorVerDist && rInner.
IsValid(SvxBoxInfoItemValidFlags::DISTANCE);
1040 table::TableBorder aBorder;
1041 lcl_fillTableBorder( aBorder, rOuter, rInner, bInvalidateHorVerDist);
1048 table::TableBorder2 aBorder;
1049 lcl_fillTableBorder( aBorder, rOuter, rInner, bInvalidateHorVerDist);
1064 for (
size_t i = 0;
i < nCount; ++
i)
1066 ScRange const & rRange = rRanges[
i ];
1072 pUndoDoc->InitUndo( rDoc, nTab, nTab );
1074 pUndoDoc->AddUndoTab( nTab, nTab );
1080 aMark.SelectTable( nTab,
true );
1089 std::make_unique<ScUndoBorder>( pDocShell, rRanges, std::move(pUndoDoc), rOuter, rInner ) );
1092 for (
size_t i = 0;
i < nCount; ++
i )
1102 const uno::Sequence< uno::Sequence<uno::Any> >& aData )
1112 if ( !rDoc.
IsBlockEditable( nTab, nStartCol,nStartRow, nEndCol,nEndRow ) )
1119 long nRows =
aData.getLength();
1121 nCols =
aData[0].getLength();
1123 if ( nCols != nEndCol-nStartCol+1 || nRows != nEndRow-nStartRow+1 )
1133 pUndoDoc->InitUndo( rDoc, nTab, nTab );
1139 bool bError =
false;
1140 SCROW nDocRow = nStartRow;
1141 for (
const uno::Sequence<uno::Any>& rColSeq :
aData)
1143 if ( rColSeq.getLength() == nCols )
1145 SCCOL nDocCol = nStartCol;
1146 for (
const uno::Any& rElement : rColSeq)
1150 switch( rElement.getValueTypeClass() )
1152 case uno::TypeClass_VOID:
1155 rDoc.
SetError( nDocCol, nDocRow, nTab, FormulaError::NotAvailable );
1161 case uno::TypeClass_BYTE:
1162 case uno::TypeClass_SHORT:
1163 case uno::TypeClass_UNSIGNED_SHORT:
1164 case uno::TypeClass_LONG:
1165 case uno::TypeClass_UNSIGNED_LONG:
1166 case uno::TypeClass_FLOAT:
1167 case uno::TypeClass_DOUBLE:
1175 case uno::TypeClass_STRING:
1179 if ( !aUStr.isEmpty() )
1189 case uno::TypeClass_SEQUENCE:
1191 uno::Sequence< sheet::FormulaToken > aTokens;
1192 if ( rElement >>= aTokens )
1222 std::make_unique<ScUndoPaste>(
1223 &rDocShell,
ScRange(nStartCol, nStartRow, nTab, nEndCol, nEndRow, nTab),
1236 const uno::Sequence< uno::Sequence<OUString> >& aData,
1247 if ( !rDoc.
IsBlockEditable( nTab, nStartCol,nStartRow, nEndCol,nEndRow ) )
1254 long nRows =
aData.getLength();
1256 nCols =
aData[0].getLength();
1258 if ( nCols != nEndCol-nStartCol+1 || nRows != nEndRow-nStartRow+1 )
1268 pUndoDoc->InitUndo( rDoc, nTab, nTab );
1274 bool bError =
false;
1275 SCROW nDocRow = nStartRow;
1276 for (
const uno::Sequence<OUString>& rColSeq :
aData)
1278 if ( rColSeq.getLength() == nCols )
1280 SCCOL nDocCol = nStartCol;
1281 for (
const OUString& aText : rColSeq)
1283 ScAddress aPos( nDocCol, nDocRow, nTab );
1319 std::make_unique<ScUndoPaste>( &rDocShell,
1320 ScRange(nStartCol, nStartRow, nTab, nEndCol, nEndRow, nTab), aDestMark,
1375 OUString aTempString = aVal;
1376 bool bIsNumberFormat(pFormatter->
IsNumberFormat(aTempString, nNumFmt, fDummy));
1377 if ( bIsNumberFormat )
1378 aTempString =
"'" + aTempString;
1379 else if ( aTempString.startsWith(
"'") )
1383 if ( bEnglish || ( pFormatter->
GetType(nNumFmt) != SvNumFormatType::TEXT ) )
1384 aTempString =
"'" + aTempString;
1393 pDocShell( pDocSh ),
1395 bChartColAsHdr( false ),
1396 bChartRowAsHdr( false ),
1397 bCursorOnly( false ),
1398 bGotDataChangedHint( false ),
1399 aValueListeners( 0 )
1405 m_wThis = uno::Reference<uno::XInterface>(
1424 pDocShell( pDocSh ),
1427 bChartColAsHdr( false ),
1428 bChartRowAsHdr( false ),
1429 bCursorOnly( false ),
1430 bGotDataChangedHint( false ),
1431 aValueListeners( 0 )
1437 m_wThis = uno::Reference<uno::XInterface>(
1537 uno::Reference<uno::XInterface>
const xThis(
m_wThis);
1540 if (SfxHintId::Dying == rHint.
GetId())
1547 if (
auto pRefHint = dynamic_cast<const ScUpdateRefHint*>(&rHint) )
1550 std::unique_ptr<ScRangeList> pUndoRanges;
1555 pRefHint->GetDx(), pRefHint->GetDy(), pRefHint->GetDz() ) )
1559 && comphelper::getUnoTunnelImplementation<ScTableSheetObj>(xThis)
1579 else if (
auto pUndoHint = dynamic_cast<const ScUnoRefUndoHint*>(&rHint) )
1581 if ( pUndoHint->GetObjectId() ==
nObjectId )
1585 aRanges = pUndoHint->GetRanges();
1595 if ( nId == SfxHintId::Dying )
1604 lang::EventObject
aEvent;
1605 aEvent.Source.set(static_cast<cppu::OWeakObject*>(
this));
1606 for (uno::Reference<util::XModifyListener> & xValueListener :
aValueListeners)
1607 xValueListener->disposing( aEvent );
1609 aValueListeners.clear();
1615 else if ( nId == SfxHintId::DataChanged )
1630 lang::EventObject
aEvent;
1631 aEvent.Source.set(static_cast<cppu::OWeakObject*>(
this));
1636 for (
const uno::Reference<util::XModifyListener> & xValueListener :
aValueListeners)
1642 else if ( nId == SfxHintId::ScCalcAll )
1750 throw uno::RuntimeException();
1779 sal_uInt16& rItemWhich )
1787 rItemWhich = pEntry->
nWID;
1789 switch ( pEntry->
nWID )
1811 beans::PropertyState eRet = beans::PropertyState_DIRECT_VALUE;
1826 if ( eState == SfxItemState::SET )
1827 eRet = beans::PropertyState_DIRECT_VALUE;
1828 else if ( eState == SfxItemState::DEFAULT )
1829 eRet = beans::PropertyState_DEFAULT_VALUE;
1830 else if ( eState == SfxItemState::DONTCARE )
1831 eRet = beans::PropertyState_AMBIGUOUS_VALUE;
1834 OSL_FAIL(
"unknown ItemState");
1841 eRet = beans::PropertyState_DIRECT_VALUE;
1847 eRet = beans::PropertyState_DIRECT_VALUE;
1849 eRet = beans::PropertyState_AMBIGUOUS_VALUE;
1852 eRet = beans::PropertyState_DEFAULT_VALUE;
1861 throw uno::RuntimeException();
1864 sal_uInt16 nItemWhich = 0;
1871 const uno::Sequence<OUString>& aPropertyNames )
1877 uno::Sequence<beans::PropertyState> aRet(aPropertyNames.getLength());
1878 std::transform(aPropertyNames.begin(), aPropertyNames.end(), aRet.begin(),
1879 [
this, &rPropertyMap](
const auto& rName) -> beans::PropertyState {
1880 sal_uInt16 nItemWhich = 0;
1895 sal_uInt16 nItemWhich = 0;
1906 sal_uInt16 aWIDs[3];
1907 aWIDs[0] = nItemWhich;
1926 OUString aStyleName(
ScResId( STR_STYLENAME_STANDARD_CELL ) );
1953 switch ( pEntry->
nWID )
1960 aAny <<= static_cast<sal_Int16>(
TwipsToHMM(static_cast<const ScIndentItem&>(
1969 switch ( pEntry->
nWID )
1977 ScResId(STR_STYLENAME_STANDARD_CELL), SfxStyleFamily::Para );
2006 aAny <<= uno::Reference<sheet::XSheetConditionalEntries>(
2020 aAny <<= uno::Reference<beans::XPropertySet>(
2041 static uno::Reference<beans::XPropertySetInfo> aRef(
2048 sal_uInt16& rFirstItemId, sal_uInt16& rSecondItemId )
2050 rFirstItemId = rEntry.
nWID;
2054 switch ( rEntry.
nWID )
2064 sal_Int32 nIntVal = 0;
2065 if ( !(rValue >>= nIntVal) )
2066 throw lang::IllegalArgumentException();
2094 sal_Int16 nIntVal = 0;
2095 if ( !(rValue >>= nIntVal) )
2096 throw lang::IllegalArgumentException();
2104 sal_Int32 nRotVal = 0;
2105 if ( !(rValue >>= nRotVal) )
2106 throw lang::IllegalArgumentException();
2119 table::CellOrientation eOrient;
2120 if( rValue >>= eOrient )
2124 case table::CellOrientation_STANDARD:
2127 case table::CellOrientation_TOPBOTTOM:
2132 case table::CellOrientation_BOTTOMTOP:
2137 case table::CellOrientation_STACKED:
2156 const OUString& aPropertyName,
const uno::Any& aValue )
2161 throw uno::RuntimeException();
2166 throw beans::UnknownPropertyException(aPropertyName);
2193 sal_uInt16 nFirstItem, nSecondItem;
2197 if ( nWhich != nFirstItem && nWhich != nSecondItem )
2204 switch ( pEntry->
nWID )
2231 SfxItemSet aAttr = aEngine.GetEmptyItemSet();
2232 aEngine.SetText(aStr);
2237 aEngine.QuickSetAttribs(aAttr,
ESelection(0, 0, 0, aStr.getLength()));
2257 aStrVal, SfxStyleFamily::Para ));
2263 table::TableBorder aBorder;
2276 table::TableBorder2 aBorder2;
2291 uno::Reference<sheet::XSheetConditionalEntries> xInterface(aValue, uno::UNO_QUERY);
2295 comphelper::getUnoTunnelImplementation<ScTableConditionalFormat>( xInterface );
2320 auto pNew = std::make_unique<ScConditionalFormat>( 0, &rDoc );
2321 pFormat->
FillFormat( *pNew, rDoc, eGrammar );
2338 uno::Reference<beans::XPropertySet> xInterface(aValue, uno::UNO_QUERY);
2342 comphelper::getUnoTunnelImplementation<ScTableValidationObj>( xInterface );
2352 std::unique_ptr<ScValidationData> pNewData(
2373 throw uno::RuntimeException();
2378 throw beans::UnknownPropertyException(aPropertyName);
2395 switch ( pEntry->
nWID )
2406 GetFormatForLanguageIfBuiltIn( nOldFormat, eOldLang );
2407 rAny <<= static_cast<sal_Int32>(nOldFormat);
2411 rAny <<= static_cast<sal_Int16>(
TwipsToHMM(static_cast<const ScIndentItem&>(
2427 switch ( pEntry->
nWID )
2437 OUString aStyleName;
2440 aStyleName = pStyle->
GetName();
2442 aStyleName, SfxStyleFamily::Para );
2458 aMark.SelectTable( rFirst.
aStart.
Tab(), true );
2486 rAny <<= uno::Reference<sheet::XSheetConditionalEntries>(
2506 rAny <<= uno::Reference<beans::XPropertySet>(
2527 rAny <<= pPattern->
GetKey();
2534 const uno::Reference<beans::XPropertyChangeListener>& )
2538 throw uno::RuntimeException();
2540 OSL_FAIL(
"not implemented");
2544 const uno::Reference<beans::XPropertyChangeListener>& )
2548 throw uno::RuntimeException();
2550 OSL_FAIL(
"not implemented");
2554 const uno::Reference<beans::XVetoableChangeListener>&)
2556 OSL_FAIL(
"not implemented");
2560 const uno::Reference<beans::XVetoableChangeListener>&)
2562 OSL_FAIL(
"not implemented");
2568 const uno::Sequence< uno::Any >& aValues )
2572 sal_Int32
nCount(aPropertyNames.getLength());
2573 sal_Int32 nValues(aValues.getLength());
2575 throw lang::IllegalArgumentException();
2581 const OUString* pNames = aPropertyNames.getConstArray();
2587 for(i = 0; i < nCount; i++)
2593 pEntryArray[i] = pEntry;
2602 catch ( lang::IllegalArgumentException& )
2604 OSL_FAIL(
"exception when setting cell style");
2611 std::unique_ptr<ScPatternAttr> pOldPattern;
2612 std::unique_ptr<ScPatternAttr> pNewPattern;
2614 for(i = 0; i < nCount; i++)
2626 pOldPattern->GetItemSet().ClearInvalidItems();
2632 sal_uInt16 nFirstItem, nSecondItem;
2637 pNewPattern->GetItemSet().Put( pOldPattern->GetItemSet().Get( nFirstItem ) );
2639 pNewPattern->GetItemSet().Put( pOldPattern->GetItemSet().Get( nSecondItem ) );
2654 const uno::Sequence< OUString >& aPropertyNames )
2660 uno::Sequence<uno::Any> aRet(aPropertyNames.getLength());
2661 uno::Any* pProperties = aRet.getArray();
2662 for(sal_Int32
i = 0;
i < aPropertyNames.getLength();
i++)
2671 const uno::Reference< beans::XPropertiesChangeListener >& )
2673 OSL_FAIL(
"not implemented");
2678 OSL_FAIL(
"not implemented");
2682 const uno::Reference< beans::XPropertiesChangeListener >& )
2684 OSL_FAIL(
"not implemented");
2689 if ( pDocShell && (rHint.GetId() == SfxHintId::ScDataChanged))
2695 bGotDataChangedHint =
true;
2700 uno::Sequence< beans::SetPropertyTolerantFailed > SAL_CALL