29 #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>
249 {
u"", 0, css::uno::Type(), 0, 0 }
252 return &aCellsPropertySet;
360 {
u"", 0, css::uno::Type(), 0, 0 }
363 return &aRangePropertySet;
477 {
u"", 0, css::uno::Type(), 0, 0 }
480 return &aCellPropertySet;
592 {
u"", 0, css::uno::Type(), 0, 0 }
595 return &aColumnPropertySet;
705 {
u"", 0, css::uno::Type(), 0, 0 }
708 return &aRowPropertySet;
830 {
u"", 0, css::uno::Type(), 0, 0 }
833 return &aSheetPropertySet;
846 {
u"", 0, css::uno::Type(), 0, 0 }
848 return aEditPropertyMap_Impl;
853 return &aEditPropertySet;
856 #define SCCHARPROPERTIES_SERVICE "com.sun.star.style.CharacterProperties"
857 #define SCPARAPROPERTIES_SERVICE "com.sun.star.style.ParagraphProperties"
858 #define SCCELLPROPERTIES_SERVICE "com.sun.star.table.CellProperties"
859 #define SCCELLRANGE_SERVICE "com.sun.star.table.CellRange"
860 #define SCCELL_SERVICE "com.sun.star.table.Cell"
861 #define SCSHEETCELLRANGES_SERVICE "com.sun.star.sheet.SheetCellRanges"
862 #define SCSHEETCELLRANGE_SERVICE "com.sun.star.sheet.SheetCellRange"
863 #define SCSPREADSHEET_SERVICE "com.sun.star.sheet.Spreadsheet"
864 #define SCSHEETCELL_SERVICE "com.sun.star.sheet.SheetCell"
889 uno::Reference<beans::XPropertySetInfo> xInfo(rSource.getPropertySetInfo());
892 const uno::Sequence<beans::Property>
aSeq(xInfo->getProperties());
893 for (
const beans::Property& rProp :
aSeq)
895 OUString
aName(rProp.Name);
896 rDest.setPropertyValue( aName, rSource.getPropertyValue( aName ) );
904 throw std::out_of_range(
"empty range");
905 const ScRange & rFirst = rRanges[0];
911 if ( rRanges.
size() == 1 )
913 const ScRange & rRange = rRanges[0];
922 template<
typename BorderLineType>
923 const ::editeng::SvxBorderLine* lcl_getBorderLine(
940 return lcl_getBorderLine( rLine, rStruct);
946 return lcl_getBorderLine( rLine, rStruct);
950 template<
typename TableBorderType>
961 rInner.
SetValid( SvxBoxInfoItemValidFlags::TOP, rBorder.IsTopLineValid );
962 rInner.
SetValid( SvxBoxInfoItemValidFlags::BOTTOM, rBorder.IsBottomLineValid );
963 rInner.
SetValid( SvxBoxInfoItemValidFlags::LEFT, rBorder.IsLeftLineValid );
964 rInner.
SetValid( SvxBoxInfoItemValidFlags::RIGHT, rBorder.IsRightLineValid );
965 rInner.
SetValid( SvxBoxInfoItemValidFlags::HORI, rBorder.IsHorizontalLineValid );
966 rInner.
SetValid( SvxBoxInfoItemValidFlags::VERT, rBorder.IsVerticalLineValid );
967 rInner.
SetValid( SvxBoxInfoItemValidFlags::DISTANCE, rBorder.IsDistanceValid );
974 lcl_fillBoxItems( rOuter, rInner, rBorder);
979 lcl_fillBoxItems( rOuter, rInner, rBorder);
994 template<
typename TableBorderItem>
996 bool bInvalidateHorVerDist )
1006 rBorder.IsTopLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::TOP);
1007 rBorder.IsBottomLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::BOTTOM);
1008 rBorder.IsLeftLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::LEFT);
1009 rBorder.IsRightLineValid = rInner.
IsValid(SvxBoxInfoItemValidFlags::RIGHT);
1010 rBorder.IsHorizontalLineValid = !bInvalidateHorVerDist && rInner.
IsValid(SvxBoxInfoItemValidFlags::HORI);
1011 rBorder.IsVerticalLineValid = !bInvalidateHorVerDist && rInner.
IsValid(SvxBoxInfoItemValidFlags::VERT);
1012 rBorder.IsDistanceValid = !bInvalidateHorVerDist && rInner.
IsValid(SvxBoxInfoItemValidFlags::DISTANCE);
1019 table::TableBorder aBorder;
1020 lcl_fillTableBorder( aBorder, rOuter, rInner, bInvalidateHorVerDist);
1027 table::TableBorder2 aBorder;
1028 lcl_fillTableBorder( aBorder, rOuter, rInner, bInvalidateHorVerDist);
1043 for (
size_t i = 0;
i < nCount; ++
i)
1045 ScRange const & rRange = rRanges[
i ];
1051 pUndoDoc->InitUndo( rDoc, nTab, nTab );
1053 pUndoDoc->AddUndoTab( nTab, nTab );
1059 aMark.SelectTable( nTab,
true );
1068 std::make_unique<ScUndoBorder>( pDocShell, rRanges, std::move(pUndoDoc), rOuter, rInner ) );
1071 for (
size_t i = 0;
i < nCount; ++
i )
1081 const uno::Sequence< uno::Sequence<uno::Any> >& aData )
1091 if ( !rDoc.
IsBlockEditable( nTab, nStartCol,nStartRow, nEndCol,nEndRow ) )
1097 sal_Int32 nCols = 0;
1098 sal_Int32 nRows =
aData.getLength();
1100 nCols =
aData[0].getLength();
1102 if ( nCols != nEndCol-nStartCol+1 || nRows != nEndRow-nStartRow+1 )
1112 pUndoDoc->InitUndo( rDoc, nTab, nTab );
1118 bool bError =
false;
1119 SCROW nDocRow = nStartRow;
1120 for (
const uno::Sequence<uno::Any>& rColSeq :
aData)
1122 if ( rColSeq.getLength() == nCols )
1124 SCCOL nDocCol = nStartCol;
1125 for (
const uno::Any& rElement : rColSeq)
1129 switch( rElement.getValueTypeClass() )
1131 case uno::TypeClass_VOID:
1134 rDoc.
SetError( nDocCol, nDocRow, nTab, FormulaError::NotAvailable );
1140 case uno::TypeClass_BYTE:
1141 case uno::TypeClass_SHORT:
1142 case uno::TypeClass_UNSIGNED_SHORT:
1143 case uno::TypeClass_LONG:
1144 case uno::TypeClass_UNSIGNED_LONG:
1145 case uno::TypeClass_FLOAT:
1146 case uno::TypeClass_DOUBLE:
1154 case uno::TypeClass_STRING:
1158 if ( !aUStr.isEmpty() )
1168 case uno::TypeClass_SEQUENCE:
1170 uno::Sequence< sheet::FormulaToken > aTokens;
1171 if ( rElement >>= aTokens )
1201 std::make_unique<ScUndoPaste>(
1202 &rDocShell,
ScRange(nStartCol, nStartRow, nTab, nEndCol, nEndRow, nTab),
1215 const uno::Sequence< uno::Sequence<OUString> >& aData,
1226 if ( !rDoc.
IsBlockEditable( nTab, nStartCol,nStartRow, nEndCol,nEndRow ) )
1232 sal_Int32 nCols = 0;
1233 sal_Int32 nRows =
aData.getLength();
1235 nCols =
aData[0].getLength();
1237 if ( nCols != nEndCol-nStartCol+1 || nRows != nEndRow-nStartRow+1 )
1247 pUndoDoc->InitUndo( rDoc, nTab, nTab );
1253 bool bError =
false;
1254 SCROW nDocRow = nStartRow;
1255 for (
const uno::Sequence<OUString>& rColSeq :
aData)
1257 if ( rColSeq.getLength() == nCols )
1259 SCCOL nDocCol = nStartCol;
1260 for (
const OUString& aText : rColSeq)
1262 ScAddress aPos( nDocCol, nDocRow, nTab );
1298 std::make_unique<ScUndoPaste>( &rDocShell,
1299 ScRange(nStartCol, nStartRow, nTab, nEndCol, nEndRow, nTab), aDestMark,
1354 OUString aTempString = aVal;
1355 bool bIsNumberFormat(pFormatter->
IsNumberFormat(aTempString, nNumFmt, fDummy));
1356 if ( bIsNumberFormat )
1357 aTempString =
"'" + aTempString;
1358 else if ( aTempString.startsWith(
"'") )
1362 if ( bEnglish || ( pFormatter->
GetType(nNumFmt) != SvNumFormatType::TEXT ) )
1363 aTempString =
"'" + aTempString;
1372 pDocShell( pDocSh ),
1374 bChartColAsHdr( false ),
1375 bChartRowAsHdr( false ),
1376 bCursorOnly( false ),
1377 bGotDataChangedHint( false ),
1378 aValueListeners( 0 )
1384 m_wThis = uno::Reference<uno::XInterface>(
1403 pDocShell( pDocSh ),
1406 bChartColAsHdr( false ),
1407 bChartRowAsHdr( false ),
1408 bCursorOnly( false ),
1409 bGotDataChangedHint( false ),
1410 aValueListeners( 0 )
1416 m_wThis = uno::Reference<uno::XInterface>(
1516 uno::Reference<uno::XInterface>
const xThis(
m_wThis);
1519 if (SfxHintId::Dying == rHint.
GetId())
1526 if (
auto pRefHint = dynamic_cast<const ScUpdateRefHint*>(&rHint) )
1529 std::unique_ptr<ScRangeList> pUndoRanges;
1534 pRefHint->GetDx(), pRefHint->GetDy(), pRefHint->GetDz() ) )
1538 && comphelper::getUnoTunnelImplementation<ScTableSheetObj>(xThis)
1558 else if (
auto pUndoHint = dynamic_cast<const ScUnoRefUndoHint*>(&rHint) )
1560 if ( pUndoHint->GetObjectId() ==
nObjectId )
1564 aRanges = pUndoHint->GetRanges();
1574 if ( nId == SfxHintId::Dying )
1583 lang::EventObject
aEvent;
1584 aEvent.Source.set(static_cast<cppu::OWeakObject*>(
this));
1585 for (uno::Reference<util::XModifyListener> & xValueListener :
aValueListeners)
1586 xValueListener->disposing( aEvent );
1588 aValueListeners.clear();
1594 else if ( nId == SfxHintId::DataChanged )
1609 lang::EventObject
aEvent;
1610 aEvent.Source.set(static_cast<cppu::OWeakObject*>(
this));
1615 for (
const uno::Reference<util::XModifyListener> & xValueListener :
aValueListeners)
1621 else if ( nId == SfxHintId::ScCalcAll )
1729 throw uno::RuntimeException();
1758 sal_uInt16& rItemWhich )
1766 rItemWhich = pEntry->
nWID;
1768 switch ( pEntry->
nWID )
1790 beans::PropertyState eRet = beans::PropertyState_DIRECT_VALUE;
1805 if ( eState == SfxItemState::SET )
1806 eRet = beans::PropertyState_DIRECT_VALUE;
1807 else if ( eState == SfxItemState::DEFAULT )
1808 eRet = beans::PropertyState_DEFAULT_VALUE;
1809 else if ( eState == SfxItemState::DONTCARE )
1810 eRet = beans::PropertyState_AMBIGUOUS_VALUE;
1813 OSL_FAIL(
"unknown ItemState");
1820 eRet = beans::PropertyState_DIRECT_VALUE;
1826 eRet = beans::PropertyState_DIRECT_VALUE;
1828 eRet = beans::PropertyState_AMBIGUOUS_VALUE;
1831 eRet = beans::PropertyState_DEFAULT_VALUE;
1840 throw uno::RuntimeException();
1843 sal_uInt16 nItemWhich = 0;
1850 const uno::Sequence<OUString>& aPropertyNames )
1856 uno::Sequence<beans::PropertyState> aRet(aPropertyNames.getLength());
1857 std::transform(aPropertyNames.begin(), aPropertyNames.end(), aRet.begin(),
1858 [
this, &rPropertyMap](
const auto& rName) -> beans::PropertyState {
1859 sal_uInt16 nItemWhich = 0;
1874 sal_uInt16 nItemWhich = 0;
1885 sal_uInt16 aWIDs[3];
1886 aWIDs[0] = nItemWhich;
1905 OUString aStyleName(
ScResId( STR_STYLENAME_STANDARD ) );
1932 switch ( pEntry->
nWID )
1939 aAny <<= static_cast<sal_Int16>(
convertTwipToMm100(static_cast<const ScIndentItem&>(
1948 switch ( pEntry->
nWID )
1956 ScResId(STR_STYLENAME_STANDARD), SfxStyleFamily::Para );
1985 aAny <<= uno::Reference<sheet::XSheetConditionalEntries>(
1999 aAny <<= uno::Reference<beans::XPropertySet>(
2020 static uno::Reference<beans::XPropertySetInfo> aRef(
2027 sal_uInt16& rFirstItemId, sal_uInt16& rSecondItemId )
2029 rFirstItemId = rEntry.
nWID;
2033 switch ( rEntry.
nWID )
2043 sal_Int32 nIntVal = 0;
2044 if ( !(rValue >>= nIntVal) )
2045 throw lang::IllegalArgumentException();
2073 sal_Int16 nIntVal = 0;
2074 if ( !(rValue >>= nIntVal) )
2075 throw lang::IllegalArgumentException();
2083 sal_Int32 nRotVal = 0;
2084 if ( !(rValue >>= nRotVal) )
2085 throw lang::IllegalArgumentException();
2098 table::CellOrientation eOrient;
2099 if( rValue >>= eOrient )
2103 case table::CellOrientation_STANDARD:
2106 case table::CellOrientation_TOPBOTTOM:
2111 case table::CellOrientation_BOTTOMTOP:
2116 case table::CellOrientation_STACKED:
2135 const OUString& aPropertyName,
const uno::Any& aValue )
2140 throw uno::RuntimeException();
2145 throw beans::UnknownPropertyException(aPropertyName);
2172 sal_uInt16 nFirstItem, nSecondItem;
2176 if ( nWhich != nFirstItem && nWhich != nSecondItem )
2183 switch ( pEntry->
nWID )
2210 SfxItemSet aAttr = aEngine.GetEmptyItemSet();
2211 aEngine.SetText(aStr);
2216 aEngine.QuickSetAttribs(aAttr,
ESelection(0, 0, 0, aStr.getLength()));
2236 aStrVal, SfxStyleFamily::Para ));
2242 table::TableBorder aBorder;
2255 table::TableBorder2 aBorder2;
2270 uno::Reference<sheet::XSheetConditionalEntries> xInterface(aValue, uno::UNO_QUERY);
2274 comphelper::getUnoTunnelImplementation<ScTableConditionalFormat>( xInterface );
2299 auto pNew = std::make_unique<ScConditionalFormat>( 0, &rDoc );
2300 pFormat->
FillFormat( *pNew, rDoc, eGrammar );
2317 uno::Reference<beans::XPropertySet> xInterface(aValue, uno::UNO_QUERY);
2321 comphelper::getUnoTunnelImplementation<ScTableValidationObj>( xInterface );
2331 std::unique_ptr<ScValidationData> pNewData(
2352 throw uno::RuntimeException();
2357 throw beans::UnknownPropertyException(aPropertyName);
2374 switch ( pEntry->
nWID )
2385 GetFormatForLanguageIfBuiltIn( nOldFormat, eOldLang );
2386 rAny <<= static_cast<sal_Int32>(nOldFormat);
2390 rAny <<= static_cast<sal_Int16>(
convertTwipToMm100(static_cast<const ScIndentItem&>(
2406 switch ( pEntry->
nWID )
2416 OUString aStyleName;
2419 aStyleName = pStyle->
GetName();
2421 aStyleName, SfxStyleFamily::Para );
2437 aMark.SelectTable( rFirst.
aStart.
Tab(), true );
2465 rAny <<= uno::Reference<sheet::XSheetConditionalEntries>(
2485 rAny <<= uno::Reference<beans::XPropertySet>(
2506 rAny <<= pPattern->
GetKey();
2513 const uno::Reference<beans::XPropertyChangeListener>& )
2517 throw uno::RuntimeException();
2519 OSL_FAIL(
"not implemented");
2523 const uno::Reference<beans::XPropertyChangeListener>& )
2527 throw uno::RuntimeException();
2529 OSL_FAIL(
"not implemented");
2533 const uno::Reference<beans::XVetoableChangeListener>&)
2535 OSL_FAIL(
"not implemented");
2539 const uno::Reference<beans::XVetoableChangeListener>&)
2541 OSL_FAIL(
"not implemented");
2547 const uno::Sequence< uno::Any >& aValues )
2551 sal_Int32
nCount(aPropertyNames.getLength());
2552 sal_Int32 nValues(aValues.getLength());
2554 throw lang::IllegalArgumentException();
2560 const OUString* pNames = aPropertyNames.getConstArray();
2566 for(i = 0; i < nCount; i++)
2572 pEntryArray[i] = pEntry;
2581 catch ( lang::IllegalArgumentException& )
2590 std::unique_ptr<ScPatternAttr> pOldPattern;
2591 std::unique_ptr<ScPatternAttr> pNewPattern;
2593 for(i = 0; i < nCount; i++)
2605 pOldPattern->GetItemSet().ClearInvalidItems();
2611 sal_uInt16 nFirstItem, nSecondItem;
2616 pNewPattern->GetItemSet().Put( pOldPattern->GetItemSet().Get( nFirstItem ) );
2618 pNewPattern->GetItemSet().Put( pOldPattern->GetItemSet().Get( nSecondItem ) );
2633 const uno::Sequence< OUString >& aPropertyNames )
2639 uno::Sequence<uno::Any> aRet(aPropertyNames.getLength());
2640 uno::Any* pProperties = aRet.getArray();
2641 for(sal_Int32
i = 0;
i < aPropertyNames.getLength();
i++)
2650 const uno::Reference< beans::XPropertiesChangeListener >& )
2652 OSL_FAIL(
"not implemented");
2657 OSL_FAIL(
"not implemented");
2661 const uno::Reference< beans::XPropertiesChangeListener >& )
2663 OSL_FAIL(
"not implemented");
2668 if ( pDocShell && (rHint.GetId() == SfxHintId::ScDataChanged))
2674 bGotDataChangedHint =
true;
2680 const uno::Sequence< uno::Any >& aValues )
2684 sal_Int32
nCount(aPropertyNames.getLength());
2685 sal_Int32 nValues(aValues.getLength());
2687 throw lang::IllegalArgumentException();