Lines Matching refs:sheet
70 using ::com::sun::star::sheet::DataPilotTablePositionData;
71 using ::com::sun::star::sheet::DataPilotTableResultData;
103 uno::Sequence<sheet::MemberResult> aResult;
179 const uno::Reference<sheet::XDataPilotMemberResults>& xLevRes, in lcl_FillNumberFormats()
188 uno::Sequence<sheet::MemberResult> aResult = xLevRes->getResults(); in lcl_FillNumberFormats()
210 sheet::DataPilotFieldOrientation eDimOrient = in lcl_FillNumberFormats()
211 (sheet::DataPilotFieldOrientation) ScUnoHelpFunctions::GetEnumProperty( in lcl_FillNumberFormats()
213 sheet::DataPilotFieldOrientation_HIDDEN ); in lcl_FillNumberFormats()
214 if ( eDimOrient == sheet::DataPilotFieldOrientation_DATA ) in lcl_FillNumberFormats()
230 const sheet::MemberResult* pArray = aResult.getConstArray(); in lcl_FillNumberFormats()
247 if ( !(pArray[nPos].Flags & sheet::MemberResultFlags::CONTINUE) ) in lcl_FillNumberFormats()
277 sheet::DataPilotFieldOrientation eDimOrient = in lcl_GetFirstNumberFormat()
278 (sheet::DataPilotFieldOrientation) ScUnoHelpFunctions::GetEnumProperty( in lcl_GetFirstNumberFormat()
280 sheet::DataPilotFieldOrientation_HIDDEN ); in lcl_GetFirstNumberFormat()
281 if ( eDimOrient == sheet::DataPilotFieldOrientation_DATA ) in lcl_GetFirstNumberFormat()
305 sal_Bool lcl_MemberEmpty( const uno::Sequence<sheet::MemberResult>& rSeq ) in lcl_MemberEmpty()
310 const sheet::MemberResult* pArray = rSeq.getConstArray(); in lcl_MemberEmpty()
312 if (pArray[i].Flags & sheet::MemberResultFlags::HASMEMBER) in lcl_MemberEmpty()
318 uno::Sequence<sheet::MemberResult> lcl_GetSelectedPageAsResult( const uno::Reference<beans::XProper… in lcl_GetSelectedPageAsResult()
320 uno::Sequence<sheet::MemberResult> aRet; in lcl_GetSelectedPageAsResult()
329 uno::Sequence<sheet::TableFilterField> aSeq; in lcl_GetSelectedPageAsResult()
334 const sheet::TableFilterField& rField = aSeq[0]; in lcl_GetSelectedPageAsResult()
335 … if ( rField.Field == 0 && rField.Operator == sheet::FilterOperator_EQUAL && !rField.IsNumeric ) in lcl_GetSelectedPageAsResult()
339 sheet::MemberResult aResult( aSelectedPage, aSelectedPage, 0 ); in lcl_GetSelectedPageAsResult()
340 aRet = uno::Sequence<sheet::MemberResult>( &aResult, 1 ); in lcl_GetSelectedPageAsResult()
354 ScDPOutput::ScDPOutput( ScDocument* pD, const uno::Reference<sheet::XDimensionsSupplier>& xSrc, in ScDPOutput()
381 uno::Reference<sheet::XDataPilotResults> xResult( xSource, uno::UNO_QUERY ); in ScDPOutput()
394 uno::Reference<sheet::XHierarchiesSupplier> xDimSupp( xDim, uno::UNO_QUERY ); in ScDPOutput()
397 sheet::DataPilotFieldOrientation eDimOrient = in ScDPOutput()
398 (sheet::DataPilotFieldOrientation) ScUnoHelpFunctions::GetEnumProperty( in ScDPOutput()
400 sheet::DataPilotFieldOrientation_HIDDEN ); in ScDPOutput()
409 if ( eDimOrient != sheet::DataPilotFieldOrientation_HIDDEN ) in ScDPOutput()
422 uno::Reference<sheet::XLevelsSupplier> xHierSupp( xHier, uno::UNO_QUERY ); in ScDPOutput()
434 uno::Reference<sheet::XDataPilotMemberResults> xLevRes( in ScDPOutput()
449 case sheet::DataPilotFieldOrientation_COLUMN: in ScDPOutput()
461 case sheet::DataPilotFieldOrientation_ROW: in ScDPOutput()
476 case sheet::DataPilotFieldOrientation_PAGE: in ScDPOutput()
501 if ( eDimOrient == sheet::DataPilotFieldOrientation_COLUMN ) in ScDPOutput()
503 else if ( eDimOrient == sheet::DataPilotFieldOrientation_ROW ) in ScDPOutput()
570 void ScDPOutput::DataCell( SCCOL nCol, SCROW nRow, SCTAB nTab, const sheet::DataResult& rData ) in DataCell()
573 if ( nFlags & sheet::DataResultFlags::ERROR ) in DataCell()
577 else if ( nFlags & sheet::DataResultFlags::HASDATA ) in DataCell()
617 const sheet::MemberResult& rData, sal_Bool bColHeader, long nLevel ) in HeaderCell()
622 if (!(nFlags & sheet::MemberResultFlags::NUMERIC)) in HeaderCell()
627 if ( nFlags & sheet::MemberResultFlags::HASMEMBER ) in HeaderCell()
636 if ( nFlags & sheet::MemberResultFlags::SUBTOTAL ) in HeaderCell()
706 const uno::Sequence<sheet::DataResult>* pRowAry = aData.getConstArray(); in CalcSizes()
753 using namespace ::com::sun::star::sheet; in GetPositionType()
798 const uno::Sequence<sheet::DataResult>* pRowAry = aData.getConstArray(); in Output()
819 const sheet::DataResult* pColAry = pRowAry[nRow].getConstArray(); in Output()
882 const uno::Sequence<sheet::MemberResult> rSequence = pColFields[nField].aResult; in Output()
883 const sheet::MemberResult* pArray = rSequence.getConstArray(); in Output()
892 if ( ( pArray[nCol].Flags & sheet::MemberResultFlags::HASMEMBER ) && in Output()
893 !( pArray[nCol].Flags & sheet::MemberResultFlags::SUBTOTAL ) ) in Output()
896 … while ( nEnd+1 < nThisColCount && ( pArray[nEnd+1].Flags & sheet::MemberResultFlags::CONTINUE ) ) in Output()
917 else if ( pArray[nCol].Flags & sheet::MemberResultFlags::SUBTOTAL ) in Output()
938 const uno::Sequence<sheet::MemberResult> rSequence = pRowFields[nField].aResult; in Output()
939 const sheet::MemberResult* pArray = rSequence.getConstArray(); in Output()
946 if ( ( pArray[nRow].Flags & sheet::MemberResultFlags::HASMEMBER ) && in Output()
947 !( pArray[nRow].Flags & sheet::MemberResultFlags::SUBTOTAL ) ) in Output()
952 … while ( nEnd+1 < nThisRowCount && ( pArray[nEnd+1].Flags & sheet::MemberResultFlags::CONTINUE ) ) in Output()
978 else if ( pArray[nRow].Flags & sheet::MemberResultFlags::SUBTOTAL ) in Output()
992 using namespace ::com::sun::star::sheet; in GetOutputRange()
1034 uno::Sequence<sheet::MemberResult> aMemberResults; in GetMemberResultNames()
1060 const sheet::MemberResult* pArray = aMemberResults.getConstArray(); in GetMemberResultNames()
1065 if ( pArray[nItem].Flags & sheet::MemberResultFlags::HASMEMBER ) in GetMemberResultNames()
1088 sheet::DataPilotFieldOrientation& rDataOrient, in lcl_GetTableVars()
1089 const uno::Reference<sheet::XDimensionsSupplier>& xSource ) in lcl_GetTableVars()
1094 rDataOrient = sheet::DataPilotFieldOrientation_HIDDEN; in lcl_GetTableVars()
1122 sheet::DataPilotFieldOrientation eDimOrient = in lcl_GetTableVars()
1123 (sheet::DataPilotFieldOrientation) ScUnoHelpFunctions::GetEnumProperty( in lcl_GetTableVars()
1125 sheet::DataPilotFieldOrientation_HIDDEN ); in lcl_GetTableVars()
1132 if ( eDimOrient == sheet::DataPilotFieldOrientation_DATA ) in lcl_GetTableVars()
1161 if ( ( rDataOrient == sheet::DataPilotFieldOrientation_COLUMN ) && bColGrand ) in lcl_GetTableVars()
1163 else if ( ( rDataOrient == sheet::DataPilotFieldOrientation_ROW ) && bRowGrand ) in lcl_GetTableVars()
1170 using namespace ::com::sun::star::sheet; in GetPositionData()
1220 const uno::Sequence<sheet::MemberResult> rSequence = pColFields[nField].aResult; in GetPositionData()
1223 const sheet::MemberResult* pArray = rSequence.getConstArray(); in GetPositionData()
1227 while (nItem > 0 && ( pArray[nItem].Flags & sheet::MemberResultFlags::CONTINUE) ) in GetPositionData()
1249 const uno::Sequence<sheet::MemberResult> rSequence = pRowFields[nField].aResult; in GetPositionData()
1252 const sheet::MemberResult* pArray = rSequence.getConstArray(); in GetPositionData()
1256 while ( nItem > 0 && (pArray[nItem].Flags & sheet::MemberResultFlags::CONTINUE) ) in GetPositionData()
1275 bool ScDPOutput::GetDataResultPositionData(vector<sheet::DataPilotFieldFilter>& rFilters, const ScA… in GetDataResultPositionData()
1294 sheet::DataPilotFieldOrientation eDataOrient; in GetDataResultPositionData()
1322 sheet::DataPilotFieldFilter filter; in GetDataResultPositionData()
1325 const uno::Sequence<sheet::MemberResult> rSequence = pColFields[nColField].aResult; in GetDataResultPositionData()
1326 const sheet::MemberResult* pArray = rSequence.getConstArray(); in GetDataResultPositionData()
1332 while ( nItem > 0 && (pArray[nItem].Flags & sheet::MemberResultFlags::CONTINUE) ) in GetDataResultPositionData()
1346 sheet::DataPilotFieldFilter filter; in GetDataResultPositionData()
1349 const uno::Sequence<sheet::MemberResult> rSequence = pRowFields[nRowField].aResult; in GetDataResultPositionData()
1350 const sheet::MemberResult* pArray = rSequence.getConstArray(); in GetDataResultPositionData()
1356 while ( nItem > 0 && (pArray[nItem].Flags & sheet::MemberResultFlags::CONTINUE) ) in GetDataResultPositionData()
1382 bool lcl_IsCondition( const sheet::MemberResult& rResultEntry, const ScDPGetPivotDataField& rFilter… in lcl_IsCondition()
1414 uno::Sequence<sheet::GeneralFunction> lcl_GetSubTotals( in lcl_GetSubTotals()
1415 const uno::Reference<sheet::XDimensionsSupplier>& xSource, const ScDPOutLevelData& rField ) in lcl_GetSubTotals()
1417 uno::Sequence<sheet::GeneralFunction> aSubTotals; in lcl_GetSubTotals()
1419 uno::Reference<sheet::XHierarchiesSupplier> xHierSupp; in lcl_GetSubTotals()
1427 xHierSupp = uno::Reference<sheet::XHierarchiesSupplier>( xIntDim, uno::UNO_QUERY ); in lcl_GetSubTotals()
1446 uno::Reference<sheet::XLevelsSupplier> xLevSupp( xHier, uno::UNO_QUERY ); in lcl_GetSubTotals()
1481 … const ScDPGetPivotDataField& rTarget, const uno::Reference<sheet::XDimensionsSupplier>& xSource ) in lcl_FilterInclude()
1506 bool bHasFunc = bHasFilter && aFilter.meFunction != sheet::GeneralFunction_NONE; in lcl_FilterInclude()
1508 uno::Sequence<sheet::GeneralFunction> aSubTotals; in lcl_FilterInclude()
1511 … bool bManualSub = ( aSubTotals.getLength() > 0 && aSubTotals[0] != sheet::GeneralFunction_AUTO ); in lcl_FilterInclude()
1513 const uno::Sequence<sheet::MemberResult>& rSequence = rField.aResult; in lcl_FilterInclude()
1514 const sheet::MemberResult* pArray = rSequence.getConstArray(); in lcl_FilterInclude()
1521 sheet::MemberResult aPrevious; in lcl_FilterInclude()
1524 sheet::MemberResult aResultEntry = pArray[j]; in lcl_FilterInclude()
1525 if ( aResultEntry.Flags & sheet::MemberResultFlags::CONTINUE ) in lcl_FilterInclude()
1530 else if ( ( aResultEntry.Flags & sheet::MemberResultFlags::SUBTOTAL ) == 0 ) in lcl_FilterInclude()
1539 if ( ( aResultEntry.Flags & sheet::MemberResultFlags::SUBTOTAL ) != 0 ) in lcl_FilterInclude()
1559 … ( sheet::MemberResultFlags::HASMEMBER | sheet::MemberResultFlags::SUBTOTAL ) ) == 0 || in lcl_FilterInclude()
1561 … ( sheet::MemberResultFlags::HASMEMBER | sheet::MemberResultFlags::SUBTOTAL ) ) == in lcl_FilterInclude()
1562 … ( sheet::MemberResultFlags::HASMEMBER | sheet::MemberResultFlags::SUBTOTAL ), in lcl_FilterInclude()
1568 if ( ( aResultEntry.Flags & sheet::MemberResultFlags::SUBTOTAL ) != 0 ) in lcl_FilterInclude()
1625 if ( ( aResultEntry.Flags & sheet::MemberResultFlags::HASMEMBER ) != 0 ) in lcl_FilterInclude()
1641 … rResult[j] = ( ( aResultEntry.Flags & sheet::MemberResultFlags::HASMEMBER ) != 0 ) && in lcl_FilterInclude()
1671 String lcl_GetDataFieldName( const String& rSourceName, sheet::GeneralFunction eFunc ) in lcl_GetDataFieldName()
1676 case sheet::GeneralFunction_SUM: nStrId = STR_FUN_TEXT_SUM; break; in lcl_GetDataFieldName()
1677 case sheet::GeneralFunction_COUNT: in lcl_GetDataFieldName()
1678 case sheet::GeneralFunction_COUNTNUMS: nStrId = STR_FUN_TEXT_COUNT; break; in lcl_GetDataFieldName()
1679 case sheet::GeneralFunction_AVERAGE: nStrId = STR_FUN_TEXT_AVG; break; in lcl_GetDataFieldName()
1680 case sheet::GeneralFunction_MAX: nStrId = STR_FUN_TEXT_MAX; break; in lcl_GetDataFieldName()
1681 case sheet::GeneralFunction_MIN: nStrId = STR_FUN_TEXT_MIN; break; in lcl_GetDataFieldName()
1682 case sheet::GeneralFunction_PRODUCT: nStrId = STR_FUN_TEXT_PRODUCT; break; in lcl_GetDataFieldName()
1683 case sheet::GeneralFunction_STDEV: in lcl_GetDataFieldName()
1684 case sheet::GeneralFunction_STDEVP: nStrId = STR_FUN_TEXT_STDDEV; break; in lcl_GetDataFieldName()
1685 case sheet::GeneralFunction_VAR: in lcl_GetDataFieldName()
1686 case sheet::GeneralFunction_VARP: nStrId = STR_FUN_TEXT_VAR; break; in lcl_GetDataFieldName()
1687 case sheet::GeneralFunction_NONE: in lcl_GetDataFieldName()
1688 case sheet::GeneralFunction_AUTO: in lcl_GetDataFieldName()
1719 sheet::GeneralFunction eFunc = (sheet::GeneralFunction)ScUnoHelpFunctions::GetEnumProperty( in GetDataDimensionNames()
1721 sheet::GeneralFunction_NONE ); in GetDataDimensionNames()
1739 sheet::DataPilotFieldOrientation eDataOrient; in GetPivotData()
1745 if ( eDataOrient == sheet::DataPilotFieldOrientation_HIDDEN ) in GetPivotData()
1768 bBeforeDataLayout = ( eDataOrient == sheet::DataPilotFieldOrientation_COLUMN ); in GetPivotData()
1775 bBeforeDataLayout = ( eDataOrient == sheet::DataPilotFieldOrientation_ROW ); in GetPivotData()
1815 const uno::Sequence<sheet::DataResult>& rDataRow = aData[nRowPos]; in GetPivotData()
1819 const sheet::DataResult& rResult = rDataRow[nColPos]; in GetPivotData()
1820 if ( rResult.Flags & sheet::DataResultFlags::ERROR ) in GetPivotData()
1857 rOrient = sheet::DataPilotFieldOrientation_COLUMN; in GetHeaderDim()
1866 rOrient = sheet::DataPilotFieldOrientation_ROW; in GetHeaderDim()
1876 rOrient = sheet::DataPilotFieldOrientation_PAGE; in GetHeaderDim()
1883 rOrient = sheet::DataPilotFieldOrientation_HIDDEN; in GetHeaderDim()
1953 rOrient = sheet::DataPilotFieldOrientation_COLUMN; in GetHeaderDrag()
2007 rOrient = sheet::DataPilotFieldOrientation_ROW; in GetHeaderDrag()
2063 rOrient = sheet::DataPilotFieldOrientation_PAGE; in GetHeaderDrag()