29 #include <editeng/editeng.hxx>
50 #include <com/sun/star/awt/XBitmap.hpp>
51 #include <com/sun/star/util/CellProtection.hpp>
52 #include <com/sun/star/table/CellHoriJustify.hpp>
53 #include <com/sun/star/table/CellOrientation.hpp>
54 #include <com/sun/star/table/ShadowFormat.hpp>
55 #include <com/sun/star/table/TableBorder.hpp>
56 #include <com/sun/star/table/TableBorder2.hpp>
57 #include <com/sun/star/sheet/CellFlags.hpp>
58 #include <com/sun/star/sheet/FormulaResult.hpp>
59 #include <com/sun/star/beans/PropertyAttribute.hpp>
60 #include <com/sun/star/lang/IndexOutOfBoundsException.hpp>
61 #include <com/sun/star/lang/Locale.hpp>
62 #include <com/sun/star/beans/TolerantPropertySetResultType.hpp>
63 #include <com/sun/star/beans/SetPropertyTolerantFailed.hpp>
64 #include <com/sun/star/text/WritingMode2.hpp>
65 #include <com/sun/star/text/textfield/Type.hpp>
66 #include <com/sun/star/sheet/XConditionalFormats.hpp>
93 #include <docfunc.hxx>
100 #include <stlsheet.hxx>
115 #include <globstr.hrc>
117 #include <unonames.hxx>
129 #include <tokenarray.hxx>
250 {
u"", 0, css::uno::Type(), 0, 0 }
253 return &aCellsPropertySet;
361 {
u"", 0, css::uno::Type(), 0, 0 }
364 return &aRangePropertySet;
478 {
u"", 0, css::uno::Type(), 0, 0 }
481 return &aCellPropertySet;
593 {
u"", 0, css::uno::Type(), 0, 0 }
596 return &aColumnPropertySet;
706 {
u"", 0, css::uno::Type(), 0, 0 }
709 return &aRowPropertySet;
831 {
u"", 0, css::uno::Type(), 0, 0 }
834 return &aSheetPropertySet;
847 {
u"", 0, css::uno::Type(), 0, 0 }
849 return aEditPropertyMap_Impl;
854 return &aEditPropertySet;
890 uno::Reference<beans::XPropertySetInfo> xInfo(rSource.getPropertySetInfo());
893 const uno::Sequence<beans::Property>
aSeq(xInfo->getProperties());
894 for (
const beans::Property& rProp :
aSeq)
896 OUString
aName(rProp.Name);
897 rDest.setPropertyValue( aName, rSource.getPropertyValue( aName ) );
905 throw std::out_of_range(
"empty range");
906 const ScRange & rFirst = rRanges[0];
912 if ( rRanges.
size() == 1 )
914 const ScRange & rRange = rRanges[0];
923 template<
typename BorderLineType>
924 const ::editeng::SvxBorderLine* lcl_getBorderLine(
941 return lcl_getBorderLine( rLine, rStruct);
947 return lcl_getBorderLine( rLine, rStruct);
951 template<
typename TableBorderType>
962 rInner.
SetValid( SvxBoxInfoItemValidFlags::TOP, rBorder.IsTopLineValid );
963 rInner.
SetValid( SvxBoxInfoItemValidFlags::BOTTOM, rBorder.IsBottomLineValid );
964 rInner.
SetValid( SvxBoxInfoItemValidFlags::LEFT, rBorder.IsLeftLineValid );
965 rInner.
SetValid( SvxBoxInfoItemValidFlags::RIGHT, rBorder.IsRightLineValid );
966 rInner.
SetValid( SvxBoxInfoItemValidFlags::HORI, rBorder.IsHorizontalLineValid );
967 rInner.
SetValid( SvxBoxInfoItemValidFlags::VERT, rBorder.IsVerticalLineValid );
968 rInner.
SetValid( SvxBoxInfoItemValidFlags::DISTANCE, rBorder.IsDistanceValid );
975 lcl_fillBoxItems( rOuter, rInner, rBorder);
980 lcl_fillBoxItems( rOuter, rInner, rBorder);
995 template<
typename TableBorderItem>
997 bool bInvalidateHorVerDist )
1007 rBorder.IsTopLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::TOP);
1008 rBorder.IsBottomLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::BOTTOM);
1009 rBorder.IsLeftLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::LEFT);
1010 rBorder.IsRightLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::RIGHT);
1011 rBorder.IsHorizontalLineValid = !bInvalidateHorVerDist && rInner.
IsValid(SvxBoxInfoItemValidFlags::HORI);
1012 rBorder.IsVerticalLineValid = !bInvalidateHorVerDist && rInner.
IsValid(SvxBoxInfoItemValidFlags::VERT);
1013 rBorder.IsDistanceValid = !bInvalidateHorVerDist && rInner.
IsValid(SvxBoxInfoItemValidFlags::DISTANCE);
1020 table::TableBorder aBorder;
1021 lcl_fillTableBorder( aBorder, rOuter, rInner, bInvalidateHorVerDist);
1028 table::TableBorder2 aBorder;
1029 lcl_fillTableBorder( aBorder, rOuter, rInner, bInvalidateHorVerDist);
1044 for (
size_t i = 0;
i < nCount; ++
i)
1046 ScRange const & rRange = rRanges[
i ];
1052 pUndoDoc->InitUndo( rDoc, nTab, nTab );
1054 pUndoDoc->AddUndoTab( nTab, nTab );
1060 aMark.SelectTable( nTab,
true );
1069 std::make_unique<ScUndoBorder>( pDocShell, rRanges, std::move(pUndoDoc), rOuter, rInner ) );
1072 for (
size_t i = 0;
i < nCount; ++
i )
1082 const uno::Sequence< uno::Sequence<uno::Any> >& aData )
1092 if ( !rDoc.
IsBlockEditable( nTab, nStartCol,nStartRow, nEndCol,nEndRow ) )
1098 sal_Int32 nCols = 0;
1099 sal_Int32 nRows =
aData.getLength();
1101 nCols =
aData[0].getLength();
1103 if ( nCols != nEndCol-nStartCol+1 || nRows != nEndRow-nStartRow+1 )
1113 pUndoDoc->InitUndo( rDoc, nTab, nTab );
1119 bool bError =
false;
1120 SCROW nDocRow = nStartRow;
1121 for (
const uno::Sequence<uno::Any>& rColSeq :
aData)
1123 if ( rColSeq.getLength() == nCols )
1125 SCCOL nDocCol = nStartCol;
1126 for (
const uno::Any& rElement : rColSeq)
1130 switch( rElement.getValueTypeClass() )
1132 case uno::TypeClass_VOID:
1135 rDoc.
SetError( nDocCol, nDocRow, nTab, FormulaError::NotAvailable );
1141 case uno::TypeClass_BYTE:
1142 case uno::TypeClass_SHORT:
1143 case uno::TypeClass_UNSIGNED_SHORT:
1144 case uno::TypeClass_LONG:
1145 case uno::TypeClass_UNSIGNED_LONG:
1146 case uno::TypeClass_FLOAT:
1147 case uno::TypeClass_DOUBLE:
1155 case uno::TypeClass_STRING:
1159 if ( !aUStr.isEmpty() )
1169 case uno::TypeClass_SEQUENCE:
1171 uno::Sequence< sheet::FormulaToken > aTokens;
1172 if ( rElement >>= aTokens )
1202 std::make_unique<ScUndoPaste>(
1203 &rDocShell,
ScRange(nStartCol, nStartRow, nTab, nEndCol, nEndRow, nTab),
1216 const uno::Sequence< uno::Sequence<OUString> >& aData,
1227 if ( !rDoc.
IsBlockEditable( nTab, nStartCol,nStartRow, nEndCol,nEndRow ) )
1233 sal_Int32 nCols = 0;
1234 sal_Int32 nRows =
aData.getLength();
1236 nCols =
aData[0].getLength();
1238 if ( nCols != nEndCol-nStartCol+1 || nRows != nEndRow-nStartRow+1 )
1248 pUndoDoc->InitUndo( rDoc, nTab, nTab );
1254 bool bError =
false;
1255 SCROW nDocRow = nStartRow;
1256 for (
const uno::Sequence<OUString>& rColSeq :
aData)
1258 if ( rColSeq.getLength() == nCols )
1260 SCCOL nDocCol = nStartCol;
1261 for (
const OUString& aText : rColSeq)
1263 ScAddress aPos( nDocCol, nDocRow, nTab );
1299 std::make_unique<ScUndoPaste>( &rDocShell,
1300 ScRange(nStartCol, nStartRow, nTab, nEndCol, nEndRow, nTab), aDestMark,
1355 OUString aTempString = aVal;
1356 bool bIsNumberFormat(pFormatter->
IsNumberFormat(aTempString, nNumFmt, fDummy));
1357 if ( bIsNumberFormat )
1358 aTempString =
"'" + aTempString;
1359 else if ( aTempString.startsWith(
"'") )
1363 if ( bEnglish || ( pFormatter->
GetType(nNumFmt) != SvNumFormatType::TEXT ) )
1364 aTempString =
"'" + aTempString;
1373 pDocShell( pDocSh ),
1375 bChartColAsHdr( false ),
1376 bChartRowAsHdr( false ),
1377 bCursorOnly( false ),
1378 bGotDataChangedHint( false ),
1379 aValueListeners( 0 )
1395 pDocShell( pDocSh ),
1398 bChartColAsHdr( false ),
1399 bChartRowAsHdr( false ),
1400 bCursorOnly( false ),
1401 bGotDataChangedHint( false ),
1402 aValueListeners( 0 )
1508 if ( nId == SfxHintId::Dying )
1519 lang::EventObject
aEvent;
1520 aEvent.Source.set(static_cast<cppu::OWeakObject*>(
this));
1521 for (uno::Reference<util::XModifyListener> & xValueListener :
aValueListeners)
1522 xValueListener->disposing( aEvent );
1524 aValueListeners.clear();
1530 else if ( nId == SfxHintId::DataChanged )
1545 lang::EventObject
aEvent;
1546 aEvent.Source.set(static_cast<cppu::OWeakObject*>(
this));
1551 for (
const uno::Reference<util::XModifyListener> & xValueListener :
aValueListeners)
1557 else if ( nId == SfxHintId::ScCalcAll )
1565 else if (
auto pRefHint = dynamic_cast<const ScUpdateRefHint*>(&rHint) )
1568 std::unique_ptr<ScRangeList> pUndoRanges;
1573 pRefHint->GetDx(), pRefHint->GetDy(), pRefHint->GetDz() ) )
1597 else if (
auto pUndoHint = dynamic_cast<const ScUnoRefUndoHint*>(&rHint) )
1599 if ( pUndoHint->GetObjectId() ==
nObjectId )
1603 aRanges = pUndoHint->GetRanges();
1709 throw uno::RuntimeException();
1738 sal_uInt16& rItemWhich )
1746 rItemWhich = pEntry->
nWID;
1748 switch ( pEntry->
nWID )
1770 beans::PropertyState eRet = beans::PropertyState_DIRECT_VALUE;
1785 if ( eState == SfxItemState::SET )
1786 eRet = beans::PropertyState_DIRECT_VALUE;
1787 else if ( eState == SfxItemState::DEFAULT )
1788 eRet = beans::PropertyState_DEFAULT_VALUE;
1789 else if ( eState == SfxItemState::DONTCARE )
1790 eRet = beans::PropertyState_AMBIGUOUS_VALUE;
1793 OSL_FAIL(
"unknown ItemState");
1800 eRet = beans::PropertyState_DIRECT_VALUE;
1806 eRet = beans::PropertyState_DIRECT_VALUE;
1808 eRet = beans::PropertyState_AMBIGUOUS_VALUE;
1811 eRet = beans::PropertyState_DEFAULT_VALUE;
1820 throw uno::RuntimeException();
1823 sal_uInt16 nItemWhich = 0;
1830 const uno::Sequence<OUString>& aPropertyNames )
1836 uno::Sequence<beans::PropertyState> aRet(aPropertyNames.getLength());
1837 std::transform(aPropertyNames.begin(), aPropertyNames.end(), aRet.getArray(),
1838 [
this, &rPropertyMap](
const auto& rName) -> beans::PropertyState {
1839 sal_uInt16 nItemWhich = 0;
1854 sal_uInt16 nItemWhich = 0;
1865 sal_uInt16 aWIDs[3];
1866 aWIDs[0] = nItemWhich;
1885 OUString aStyleName(
ScResId( STR_STYLENAME_STANDARD ) );
1912 switch ( pEntry->
nWID )
1919 aAny <<= static_cast<sal_Int16>(
convertTwipToMm100(static_cast<const ScIndentItem&>(
1928 switch ( pEntry->
nWID )
1936 ScResId(STR_STYLENAME_STANDARD), SfxStyleFamily::Para );
1965 aAny <<= uno::Reference<sheet::XSheetConditionalEntries>(
1979 aAny <<= uno::Reference<beans::XPropertySet>(
2000 static uno::Reference<beans::XPropertySetInfo> aRef(
2007 sal_uInt16& rFirstItemId, sal_uInt16& rSecondItemId )
2009 rFirstItemId = rEntry.
nWID;
2013 switch ( rEntry.
nWID )
2023 sal_Int32 nIntVal = 0;
2024 if ( !(rValue >>= nIntVal) )
2025 throw lang::IllegalArgumentException();
2053 sal_Int16 nIntVal = 0;
2054 if ( !(rValue >>= nIntVal) )
2055 throw lang::IllegalArgumentException();
2063 sal_Int32 nRotVal = 0;
2064 if ( !(rValue >>= nRotVal) )
2065 throw lang::IllegalArgumentException();
2078 table::CellOrientation eOrient;
2079 if( rValue >>= eOrient )
2083 case table::CellOrientation_STANDARD:
2086 case table::CellOrientation_TOPBOTTOM:
2091 case table::CellOrientation_BOTTOMTOP:
2096 case table::CellOrientation_STACKED:
2115 const OUString& aPropertyName,
const uno::Any& aValue )
2120 throw uno::RuntimeException();
2125 throw beans::UnknownPropertyException(aPropertyName);
2152 sal_uInt16 nFirstItem, nSecondItem;
2156 if ( nWhich != nFirstItem && nWhich != nSecondItem )
2163 switch ( pEntry->
nWID )
2190 SfxItemSet aAttr = aEngine.GetEmptyItemSet();
2191 aEngine.SetText(aStr);
2196 aEngine.QuickSetAttribs(aAttr,
ESelection(0, 0, 0, aStr.getLength()));
2216 aStrVal, SfxStyleFamily::Para ));
2222 table::TableBorder aBorder;
2235 table::TableBorder2 aBorder2;
2250 uno::Reference<sheet::XSheetConditionalEntries> xInterface(aValue, uno::UNO_QUERY);
2254 comphelper::getFromUnoTunnel<ScTableConditionalFormat>( xInterface );
2279 auto pNew = std::make_unique<ScConditionalFormat>( 0, &rDoc );
2280 pFormat->
FillFormat( *pNew, rDoc, eGrammar );
2297 uno::Reference<beans::XPropertySet> xInterface(aValue, uno::UNO_QUERY);
2301 comphelper::getFromUnoTunnel<ScTableValidationObj>( xInterface );
2311 std::unique_ptr<ScValidationData> pNewData(
2332 throw uno::RuntimeException();
2337 throw beans::UnknownPropertyException(aPropertyName);
2354 switch ( pEntry->
nWID )
2365 GetFormatForLanguageIfBuiltIn( nOldFormat, eOldLang );
2366 rAny <<= static_cast<sal_Int32>(nOldFormat);
2370 rAny <<= static_cast<sal_Int16>(
convertTwipToMm100(static_cast<const ScIndentItem&>(
2386 switch ( pEntry->
nWID )
2396 OUString aStyleName;
2399 aStyleName = pStyle->
GetName();
2401 aStyleName, SfxStyleFamily::Para );
2417 aMark.SelectTable( rFirst.
aStart.
Tab(), true );
2445 rAny <<= uno::Reference<sheet::XSheetConditionalEntries>(
2465 rAny <<= uno::Reference<beans::XPropertySet>(
2486 rAny <<= pPattern->
GetKey();
2493 const uno::Reference<beans::XPropertyChangeListener>& )
2497 throw uno::RuntimeException();
2499 OSL_FAIL(
"not implemented");
2503 const uno::Reference<beans::XPropertyChangeListener>& )
2507 throw uno::RuntimeException();
2509 OSL_FAIL(
"not implemented");
2513 const uno::Reference<beans::XVetoableChangeListener>&)
2515 OSL_FAIL(
"not implemented");
2519 const uno::Reference<beans::XVetoableChangeListener>&)
2521 OSL_FAIL(
"not implemented");
2527 const uno::Sequence< uno::Any >& aValues )
2531 sal_Int32
nCount(aPropertyNames.getLength());
2532 sal_Int32 nValues(aValues.getLength());
2534 throw lang::IllegalArgumentException();
2540 const OUString* pNames = aPropertyNames.getConstArray();
2546 for(i = 0; i < nCount; i++)
2552 pEntryArray[i] = pEntry;
2561 catch ( lang::IllegalArgumentException& )
2570 std::unique_ptr<ScPatternAttr> pOldPattern;
2571 std::unique_ptr<ScPatternAttr> pNewPattern;
2573 for(i = 0; i < nCount; i++)
2585 pOldPattern->GetItemSet().ClearInvalidItems();
2591 sal_uInt16 nFirstItem, nSecondItem;
2596 pNewPattern->GetItemSet().Put( pOldPattern->GetItemSet().Get( nFirstItem ) );
2598 pNewPattern->GetItemSet().Put( pOldPattern->GetItemSet().Get( nSecondItem ) );
2613 const uno::Sequence< OUString >& aPropertyNames )
2619 uno::Sequence<uno::Any> aRet(aPropertyNames.getLength());
2620 uno::Any* pProperties = aRet.getArray();
2621 for(sal_Int32
i = 0;
i < aPropertyNames.getLength();
i++)
2630 const uno::Reference< beans::XPropertiesChangeListener >& )
2632 OSL_FAIL(
"not implemented");
2637 OSL_FAIL(
"not implemented");
2641 const uno::Reference< beans::XPropertiesChangeListener >& )
2643 OSL_FAIL(
"not implemented");
2648 if ( pDocShell && (rHint.GetId() == SfxHintId::ScDataChanged))
2654 bGotDataChangedHint =
true;
2660 const uno::Sequence< uno::Any >& aValues )
2664 sal_Int32
nCount(aPropertyNames.getLength());
2665 sal_Int32 nValues(aValues.getLength());
2667 throw lang::IllegalArgumentException();
2671 uno::Sequence < beans::SetPropertyTolerantFailed > aReturns(
nCount);
2672 beans::SetPropertyTolerantFailed* pReturns = aReturns.getArray();
2675 const OUString* pNames = aPropertyNames.getConstArray();