Lines Matching refs:sheet
195 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellSamples()
270 com.sun.star.sheet.XCellAddressable xCellAddr = (com.sun.star.sheet.XCellAddressable) in doCellSamples()
271 UnoRuntime.queryInterface( com.sun.star.sheet.XCellAddressable.class, xCell ); in doCellSamples()
280 com.sun.star.sheet.XSheetAnnotationsSupplier xAnnotationsSupp = in doCellSamples()
281 (com.sun.star.sheet.XSheetAnnotationsSupplier) UnoRuntime.queryInterface( in doCellSamples()
282 com.sun.star.sheet.XSheetAnnotationsSupplier.class, xSheet ); in doCellSamples()
283 com.sun.star.sheet.XSheetAnnotations xAnnotations = xAnnotationsSupp.getAnnotations(); in doCellSamples()
286 …com.sun.star.sheet.XSheetAnnotationAnchor xAnnotAnchor = (com.sun.star.sheet.XSheetAnnotationAncho… in doCellSamples()
287 UnoRuntime.queryInterface( com.sun.star.sheet.XSheetAnnotationAnchor.class, xCell ); in doCellSamples()
288 com.sun.star.sheet.XSheetAnnotation xAnnotation = xAnnotAnchor.getAnnotation(); in doCellSamples()
298 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellRangeSamples()
383 com.sun.star.sheet.XCellRangeData xData = (com.sun.star.sheet.XCellRangeData) in doCellRangeSamples()
384 UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeData.class, xCellRange ); in doCellRangeSamples()
413 … com.sun.star.sheet.XCellRangeAddressable xRangeAddr = (com.sun.star.sheet.XCellRangeAddressable) in doCellRangeSamples()
414 UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeAddressable.class, xCellRange ); in doCellRangeSamples()
423 com.sun.star.sheet.XSheetOperation xSheetOp = (com.sun.star.sheet.XSheetOperation) in doCellRangeSamples()
424 UnoRuntime.queryInterface( com.sun.star.sheet.XSheetOperation.class, xData ); in doCellRangeSamples()
425 double fResult = xSheetOp.computeFunction( com.sun.star.sheet.GeneralFunction.AVERAGE ); in doCellRangeSamples()
444 com.sun.star.sheet.XCellSeries xSeries = null; in doCellRangeSamples()
447 … xSeries.fillSeries( com.sun.star.sheet.FillDirection.TO_RIGHT, com.sun.star.sheet.FillMode.LINEAR, in doCellRangeSamples()
448 com.sun.star.sheet.FillDateMode.FILL_DATE_DAY, 2, 9 ); in doCellRangeSamples()
451 … xSeries.fillSeries( com.sun.star.sheet.FillDirection.TO_RIGHT, com.sun.star.sheet.FillMode.DATE, in doCellRangeSamples()
452 com.sun.star.sheet.FillDateMode.FILL_DATE_MONTH, 1, 0x7FFFFFFF ); in doCellRangeSamples()
455 … xSeries.fillSeries( com.sun.star.sheet.FillDirection.TO_LEFT, com.sun.star.sheet.FillMode.LINEAR, in doCellRangeSamples()
456 com.sun.star.sheet.FillDateMode.FILL_DATE_DAY, 10, 0x7FFFFFFF ); in doCellRangeSamples()
459 … xSeries.fillSeries( com.sun.star.sheet.FillDirection.TO_RIGHT, com.sun.star.sheet.FillMode.AUTO, in doCellRangeSamples()
460 com.sun.star.sheet.FillDateMode.FILL_DATE_DAY, 1, 0x7FFFFFFF ); in doCellRangeSamples()
463 … xSeries.fillSeries( com.sun.star.sheet.FillDirection.TO_TOP, com.sun.star.sheet.FillMode.GROWTH, in doCellRangeSamples()
464 com.sun.star.sheet.FillDateMode.FILL_DATE_DAY, 2, 0x7FFFFFFF ); in doCellRangeSamples()
467 xSeries.fillAuto( com.sun.star.sheet.FillDirection.TO_RIGHT, 2 ); in doCellRangeSamples()
475 … com.sun.star.sheet.XArrayFormulaRange xArrayFormula = (com.sun.star.sheet.XArrayFormulaRange) in doCellRangeSamples()
476 UnoRuntime.queryInterface( com.sun.star.sheet.XArrayFormulaRange.class, xCellRange ); in doCellRangeSamples()
486 … getCellSeries( xSheet, "E27:E31" ).fillAuto( com.sun.star.sheet.FillDirection.TO_BOTTOM, 1 ); in doCellRangeSamples()
487 getCellSeries( xSheet, "F26:J26" ).fillAuto( com.sun.star.sheet.FillDirection.TO_RIGHT, 1 ); in doCellRangeSamples()
493 … getCellSeries( xSheet, "E34:E38" ).fillAuto( com.sun.star.sheet.FillDirection.TO_BOTTOM, 2 ); in doCellRangeSamples()
501 com.sun.star.sheet.XMultipleOperation xMultOp = (com.sun.star.sheet.XMultipleOperation) in doCellRangeSamples()
502 UnoRuntime.queryInterface( com.sun.star.sheet.XMultipleOperation.class, xCellRange ); in doCellRangeSamples()
504 aFormulaRange, com.sun.star.sheet.TableOperationMode.BOTH, aColCell, aRowCell ); in doCellRangeSamples()
511 xMultOp = (com.sun.star.sheet.XMultipleOperation) in doCellRangeSamples()
512 UnoRuntime.queryInterface( com.sun.star.sheet.XMultipleOperation.class, xCellRange ); in doCellRangeSamples()
514 aFormulaRange, com.sun.star.sheet.TableOperationMode.COLUMN, aColCell, aRowCell ); in doCellRangeSamples()
519 com.sun.star.sheet.XCellRangesQuery xRangesQuery = (com.sun.star.sheet.XCellRangesQuery) in doCellRangeSamples()
520 UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangesQuery.class, xCellRange ); in doCellRangeSamples()
521 com.sun.star.sheet.XSheetCellRanges xCellRanges = in doCellRangeSamples()
522 xRangesQuery.queryContentCells( (short)com.sun.star.sheet.CellFlags.STRING ); in doCellRangeSamples()
532 private com.sun.star.sheet.XCellSeries getCellSeries( in getCellSeries()
533 com.sun.star.sheet.XSpreadsheet xSheet, String aRange ) in getCellSeries()
535 return (com.sun.star.sheet.XCellSeries) UnoRuntime.queryInterface( in getCellSeries()
536 com.sun.star.sheet.XCellSeries.class, xSheet.getCellRangeByName( aRange ) ); in getCellSeries()
550 com.sun.star.sheet.XSheetCellRangeContainer xRangeCont = in doCellRangesSamples()
551 (com.sun.star.sheet.XSheetCellRangeContainer) UnoRuntime.queryInterface( in doCellRangesSamples()
552 com.sun.star.sheet.XSheetCellRangeContainer.class, in doCellRangesSamples()
569 com.sun.star.sheet.XCellAddressable xAddr = (com.sun.star.sheet.XCellAddressable) in doCellRangesSamples()
570 UnoRuntime.queryInterface( com.sun.star.sheet.XCellAddressable.class, aCellObj ); in doCellRangesSamples()
587 com.sun.star.sheet.XSheetCellRangeContainer xContainer, in insertRange()
610 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellCursorSamples()
615 com.sun.star.sheet.XSheetCellRange xCellRange = (com.sun.star.sheet.XSheetCellRange) in doCellCursorSamples()
616 UnoRuntime.queryInterface( com.sun.star.sheet.XSheetCellRange.class, xRange ); in doCellCursorSamples()
617 com.sun.star.sheet.XSheetCellCursor xCursor = xSheet.createCursorByRange( xCellRange ); in doCellCursorSamples()
620 com.sun.star.sheet.XArrayFormulaRange xArray = (com.sun.star.sheet.XArrayFormulaRange) in doCellCursorSamples()
621 UnoRuntime.queryInterface( com.sun.star.sheet.XArrayFormulaRange.class, xCursor ); in doCellCursorSamples()
628 com.sun.star.sheet.XUsedAreaCursor xUsedCursor = (com.sun.star.sheet.XUsedAreaCursor) in doCellCursorSamples()
629 UnoRuntime.queryInterface( com.sun.star.sheet.XUsedAreaCursor.class, xCursor ); in doCellCursorSamples()
643 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 1 ); in doFormattingSamples()
689 com.sun.star.sheet.XCellFormatRangesSupplier xFormatSupp = in doFormattingSamples()
690 (com.sun.star.sheet.XCellFormatRangesSupplier) UnoRuntime.queryInterface( in doFormattingSamples()
691 com.sun.star.sheet.XCellFormatRangesSupplier.class, xCellRange ); in doFormattingSamples()
697 com.sun.star.sheet.XUniqueCellFormatRangesSupplier xUniqueFormatSupp = in doFormattingSamples()
698 (com.sun.star.sheet.XUniqueCellFormatRangesSupplier) UnoRuntime.queryInterface( in doFormattingSamples()
699 com.sun.star.sheet.XUniqueCellFormatRangesSupplier.class, xCellRange ); in doFormattingSamples()
793 com.sun.star.sheet.XSheetConditionalEntries xEntries = in doFormattingSamples()
794 (com.sun.star.sheet.XSheetConditionalEntries) UnoRuntime.queryInterface( in doFormattingSamples()
795 com.sun.star.sheet.XSheetConditionalEntries.class, in doFormattingSamples()
802 aCondition[0].Value = com.sun.star.sheet.ConditionOperator.GREATER; in doFormattingSamples()
822 com.sun.star.sheet.XSpreadsheet xSheet = insertSpreadsheet( "A new sheet", (short)0x7FFF ); in doDocumentSamples()
833 com.sun.star.sheet.XCellRangeMovement xMovement = (com.sun.star.sheet.XCellRangeMovement) in doDocumentSamples()
834 UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeMovement.class, xSheet ); in doDocumentSamples()
841 com.sun.star.sheet.XSheetPageBreak xPageBreak = (com.sun.star.sheet.XSheetPageBreak) in doDocumentSamples()
842 UnoRuntime.queryInterface( com.sun.star.sheet.XSheetPageBreak.class, xSheet ); in doDocumentSamples()
843 com.sun.star.sheet.TablePageBreakData[] aPageBreakArray = xPageBreak.getColumnPageBreaks(); in doDocumentSamples()
881 xValidPropSet.setPropertyValue( "Type", com.sun.star.sheet.ValidationType.DECIMAL ); in doDocumentSamples()
884 … xValidPropSet.setPropertyValue( "ErrorAlertStyle", com.sun.star.sheet.ValidationAlertStyle.STOP ); in doDocumentSamples()
886 com.sun.star.sheet.XSheetCondition xCondition = (com.sun.star.sheet.XSheetCondition) in doDocumentSamples()
887 UnoRuntime.queryInterface( com.sun.star.sheet.XSheetCondition.class, xValidPropSet ); in doDocumentSamples()
888 xCondition.setOperator( com.sun.star.sheet.ConditionOperator.BETWEEN ); in doDocumentSamples()
927 com.sun.star.sheet.XSpreadsheet xSheet, in insertScenario()
937 com.sun.star.sheet.XCellRangeAddressable xAddr = (com.sun.star.sheet.XCellRangeAddressable) in insertScenario()
938 UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeAddressable.class, xCellRange ); in insertScenario()
943 com.sun.star.sheet.XScenariosSupplier xScenSupp = (com.sun.star.sheet.XScenariosSupplier) in insertScenario()
944 UnoRuntime.queryInterface( com.sun.star.sheet.XScenariosSupplier.class, xSheet ); in insertScenario()
945 com.sun.star.sheet.XScenarios xScenarios = xScenSupp.getScenarios(); in insertScenario()
949 com.sun.star.sheet.XCellRangeData xData = (com.sun.star.sheet.XCellRangeData) in insertScenario()
950 UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeData.class, xCellRange ); in insertScenario()
958 com.sun.star.sheet.XSpreadsheet xSheet, in showScenario()
962 com.sun.star.sheet.XScenariosSupplier xScenSupp = (com.sun.star.sheet.XScenariosSupplier) in showScenario()
963 UnoRuntime.queryInterface( com.sun.star.sheet.XScenariosSupplier.class, xSheet ); in showScenario()
964 com.sun.star.sheet.XScenarios xScenarios = xScenSupp.getScenarios(); in showScenario()
968 com.sun.star.sheet.XScenario xScenario = (com.sun.star.sheet.XScenario) in showScenario()
969 UnoRuntime.queryInterface( com.sun.star.sheet.XScenario.class, aScenarioObj ); in showScenario()
978 com.sun.star.sheet.XSpreadsheetDocument xDocument = getDocument(); in doNamedRangesSamples()
979 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doNamedRangesSamples()
993 com.sun.star.sheet.XNamedRanges xNamedRanges = (com.sun.star.sheet.XNamedRanges) in doNamedRangesSamples()
994 UnoRuntime.queryInterface( com.sun.star.sheet.XNamedRanges.class, aRangesObj ); in doNamedRangesSamples()
1009 com.sun.star.sheet.XCellRangeData xData = ( com.sun.star.sheet.XCellRangeData ) in doNamedRangesSamples()
1010 UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeData.class, xRange ); in doNamedRangesSamples()
1021 com.sun.star.sheet.XLabelRanges xLabelRanges = (com.sun.star.sheet.XLabelRanges) in doNamedRangesSamples()
1022 UnoRuntime.queryInterface( com.sun.star.sheet.XLabelRanges.class, aLabelsObj ); in doNamedRangesSamples()
1115 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 2 ); in doDatabaseSamples()
1120 com.sun.star.sheet.XCellRangeData xData = ( com.sun.star.sheet.XCellRangeData ) in doDatabaseSamples()
1121 UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeData.class, xRange ); in doDatabaseSamples()
1151 com.sun.star.sheet.XSheetFilterable xFilter = ( com.sun.star.sheet.XSheetFilterable ) in doDatabaseSamples()
1152 UnoRuntime.queryInterface( com.sun.star.sheet.XSheetFilterable.class, xRange ); in doDatabaseSamples()
1153 com.sun.star.sheet.XSheetFilterDescriptor xFilterDesc = in doDatabaseSamples()
1155 com.sun.star.sheet.TableFilterField[] aFilterFields = in doDatabaseSamples()
1156 new com.sun.star.sheet.TableFilterField[1]; in doDatabaseSamples()
1157 aFilterFields[0] = new com.sun.star.sheet.TableFilterField(); in doDatabaseSamples()
1160 aFilterFields[0].Operator = com.sun.star.sheet.FilterOperator.GREATER_EQUAL; in doDatabaseSamples()
1171 com.sun.star.sheet.XCellRangeData xCritData = ( com.sun.star.sheet.XCellRangeData ) in doDatabaseSamples()
1172 UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeData.class, xCritRange ); in doDatabaseSamples()
1179 com.sun.star.sheet.XSheetFilterableEx xCriteria = ( com.sun.star.sheet.XSheetFilterableEx ) in doDatabaseSamples()
1180 UnoRuntime.queryInterface( com.sun.star.sheet.XSheetFilterableEx.class, xCritRange ); in doDatabaseSamples()
1208 com.sun.star.sheet.XSubTotalCalculatable xSub = ( com.sun.star.sheet.XSubTotalCalculatable ) in doDatabaseSamples()
1209 UnoRuntime.queryInterface( com.sun.star.sheet.XSubTotalCalculatable.class, xRange ); in doDatabaseSamples()
1210 com.sun.star.sheet.XSubTotalDescriptor xSubDesc = xSub.createSubTotalDescriptor( true ); in doDatabaseSamples()
1211 com.sun.star.sheet.SubTotalColumn[] aColumns = new com.sun.star.sheet.SubTotalColumn[1]; in doDatabaseSamples()
1213 aColumns[0] = new com.sun.star.sheet.SubTotalColumn(); in doDatabaseSamples()
1215 aColumns[0].Function = com.sun.star.sheet.GeneralFunction.SUM; in doDatabaseSamples()
1231 aImportDesc[1].Value = com.sun.star.sheet.DataImportMode.TABLE; in doDatabaseSamples()
1260 … com.sun.star.sheet.XCellRangeReferrer xRef = ( com.sun.star.sheet.XCellRangeReferrer ) in doDatabaseSamples()
1261 … UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeReferrer.class, aRangeObj ); in doDatabaseSamples()
1279 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doDataPilotSamples()
1284 …com.sun.star.sheet.XDataPilotTablesSupplier xDPSupp = (com.sun.star.sheet.XDataPilotTablesSupplier) in doDataPilotSamples()
1285 UnoRuntime.queryInterface( com.sun.star.sheet.XDataPilotTablesSupplier.class, xSheet ); in doDataPilotSamples()
1286 com.sun.star.sheet.XDataPilotTables xDPTables = xDPSupp.getDataPilotTables(); in doDataPilotSamples()
1287 com.sun.star.sheet.XDataPilotDescriptor xDPDesc = xDPTables.createDataPilotDescriptor(); in doDataPilotSamples()
1299 … xFieldProp.setPropertyValue( "Orientation", com.sun.star.sheet.DataPilotFieldOrientation.COLUMN ); in doDataPilotSamples()
1304 … xFieldProp.setPropertyValue( "Orientation", com.sun.star.sheet.DataPilotFieldOrientation.ROW ); in doDataPilotSamples()
1309 … xFieldProp.setPropertyValue( "Orientation", com.sun.star.sheet.DataPilotFieldOrientation.DATA ); in doDataPilotSamples()
1310 xFieldProp.setPropertyValue( "Function", com.sun.star.sheet.GeneralFunction.SUM ); in doDataPilotSamples()
1318 xDPDesc = (com.sun.star.sheet.XDataPilotDescriptor) in doDataPilotSamples()
1319 UnoRuntime.queryInterface( com.sun.star.sheet.XDataPilotDescriptor.class, aDPTableObj ); in doDataPilotSamples()
1325 … xFieldProp.setPropertyValue( "Orientation", com.sun.star.sheet.DataPilotFieldOrientation.DATA ); in doDataPilotSamples()
1326 xFieldProp.setPropertyValue( "Function", com.sun.star.sheet.GeneralFunction.AVERAGE ); in doDataPilotSamples()
1340 com.sun.star.sheet.XFunctionAccess xFuncAcc = in doFunctionAccessSamples()
1341 (com.sun.star.sheet.XFunctionAccess)UnoRuntime.queryInterface( in doFunctionAccessSamples()
1342 com.sun.star.sheet.XFunctionAccess.class, aFuncInst ); in doFunctionAccessSamples()
1357 com.sun.star.sheet.XRecentFunctions xRecFunc = in doFunctionAccessSamples()
1358 (com.sun.star.sheet.XRecentFunctions)UnoRuntime.queryInterface( in doFunctionAccessSamples()
1359 com.sun.star.sheet.XRecentFunctions.class, aRecInst ); in doFunctionAccessSamples()
1366 com.sun.star.sheet.XFunctionDescriptions xFuncDesc = in doFunctionAccessSamples()
1367 (com.sun.star.sheet.XFunctionDescriptions)UnoRuntime.queryInterface( in doFunctionAccessSamples()
1368 com.sun.star.sheet.XFunctionDescriptions.class, aDescInst ); in doFunctionAccessSamples()