Lines Matching refs:star
24 import com.sun.star.uno.UnoRuntime;
25 import com.sun.star.uno.RuntimeException;
26 import com.sun.star.uno.AnyConverter;
195 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellSamples()
196 com.sun.star.table.XCell xCell = null; in doCellSamples()
197 com.sun.star.beans.XPropertySet xPropSet = null; in doCellSamples()
206 com.sun.star.text.XText xText = (com.sun.star.text.XText) in doCellSamples()
207 UnoRuntime.queryInterface( com.sun.star.text.XText.class, xCell ); in doCellSamples()
208 com.sun.star.text.XTextCursor xTextCursor = xText.createTextCursor(); in doCellSamples()
212 com.sun.star.text.ControlCharacter.PARAGRAPH_BREAK, false ); in doCellSamples()
216 … com.sun.star.lang.XMultiServiceFactory xServiceMan = (com.sun.star.lang.XMultiServiceFactory) in doCellSamples()
217 … UnoRuntime.queryInterface( com.sun.star.lang.XMultiServiceFactory.class, getDocument() ); in doCellSamples()
219 xPropSet = (com.sun.star.beans.XPropertySet) in doCellSamples()
220 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, aHyperlinkObj ); in doCellSamples()
224 com.sun.star.text.XTextContent xContent = (com.sun.star.text.XTextContent) in doCellSamples()
225 UnoRuntime.queryInterface( com.sun.star.text.XTextContent.class, aHyperlinkObj ); in doCellSamples()
230 com.sun.star.container.XEnumerationAccess xParaEA = in doCellSamples()
231 (com.sun.star.container.XEnumerationAccess) UnoRuntime.queryInterface( in doCellSamples()
232 com.sun.star.container.XEnumerationAccess.class, xCell ); in doCellSamples()
233 com.sun.star.container.XEnumeration xParaEnum = xParaEA.createEnumeration(); in doCellSamples()
238 com.sun.star.container.XEnumerationAccess xPortionEA = in doCellSamples()
239 (com.sun.star.container.XEnumerationAccess) UnoRuntime.queryInterface( in doCellSamples()
240 com.sun.star.container.XEnumerationAccess.class, aPortionObj ); in doCellSamples()
241 com.sun.star.container.XEnumeration xPortionEnum = xPortionEA.createEnumeration(); in doCellSamples()
247 com.sun.star.text.XTextRange xRange = (com.sun.star.text.XTextRange) in doCellSamples()
248 UnoRuntime.queryInterface(com.sun.star.text.XTextRange.class, in doCellSamples()
257 xPropSet = (com.sun.star.beans.XPropertySet) in doCellSamples()
258 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, xCell ); 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()
272 com.sun.star.table.CellAddress aAddress = xCellAddr.getCellAddress(); 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()
299 com.sun.star.table.XCellRange xCellRange = null; in doCellRangeSamples()
300 com.sun.star.beans.XPropertySet xPropSet = null; in doCellRangeSamples()
301 com.sun.star.table.CellRangeAddress aRangeAddress = null; in doCellRangeSamples()
312 xPropSet = (com.sun.star.beans.XPropertySet) in doCellRangeSamples()
313 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, xCellRange ); in doCellRangeSamples()
325 com.sun.star.util.XReplaceable xReplace = (com.sun.star.util.XReplaceable) in doCellRangeSamples()
326 UnoRuntime.queryInterface( com.sun.star.util.XReplaceable.class, xCellRange ); in doCellRangeSamples()
327 com.sun.star.util.XReplaceDescriptor xReplaceDesc = xReplace.createReplaceDescriptor(); in doCellRangeSamples()
339 com.sun.star.util.XMergeable xMerge = (com.sun.star.util.XMergeable) in doCellRangeSamples()
340 UnoRuntime.queryInterface( com.sun.star.util.XMergeable.class, xCellRange ); in doCellRangeSamples()
365 com.sun.star.table.XColumnRowRange xColRowRange = (com.sun.star.table.XColumnRowRange) in doCellRangeSamples()
366 UnoRuntime.queryInterface( com.sun.star.table.XColumnRowRange.class, xCellRange ); in doCellRangeSamples()
367 com.sun.star.table.XTableColumns xColumns = xColRowRange.getColumns(); in doCellRangeSamples()
370 xPropSet = (com.sun.star.beans.XPropertySet) UnoRuntime.queryInterface( in doCellRangeSamples()
371 com.sun.star.beans.XPropertySet.class, aColumnObj ); in doCellRangeSamples()
374 com.sun.star.container.XNamed xNamed = (com.sun.star.container.XNamed) in doCellRangeSamples()
375 UnoRuntime.queryInterface( com.sun.star.container.XNamed.class, aColumnObj ); 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()
496 com.sun.star.table.CellRangeAddress aFormulaRange = createCellRangeAddress( xSheet, "E26" ); in doCellRangeSamples()
497 com.sun.star.table.CellAddress aColCell = createCellAddress( xSheet, "E27" ); in doCellRangeSamples()
498 com.sun.star.table.CellAddress aRowCell = createCellAddress( xSheet, "F26" ); 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()
547 com.sun.star.lang.XMultiServiceFactory xDocFactory = in doCellRangesSamples()
548 (com.sun.star.lang.XMultiServiceFactory) UnoRuntime.queryInterface( in doCellRangesSamples()
549 com.sun.star.lang.XMultiServiceFactory.class, getDocument() ); in doCellRangesSamples()
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()
564 com.sun.star.container.XEnumerationAccess xCellsEA = xRangeCont.getCells(); in doCellRangesSamples()
565 com.sun.star.container.XEnumeration xEnum = xCellsEA.createEnumeration(); 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()
571 com.sun.star.table.CellAddress aAddr = xAddr.getCellAddress(); in doCellRangesSamples()
587 com.sun.star.sheet.XSheetCellRangeContainer xContainer, in insertRange()
591 com.sun.star.table.CellRangeAddress aAddress = new com.sun.star.table.CellRangeAddress(); in insertRange()
610 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellCursorSamples()
614 com.sun.star.table.XCellRange xRange = xSheet.getCellRangeByName( "F22" ); 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()
644 com.sun.star.table.XCellRange xCellRange; in doFormattingSamples()
645 com.sun.star.beans.XPropertySet xPropSet = null; in doFormattingSamples()
646 com.sun.star.container.XIndexAccess xRangeIA = null; in doFormattingSamples()
647 com.sun.star.lang.XMultiServiceFactory xDocServiceManager; in doFormattingSamples()
652 …com.sun.star.style.XStyleFamiliesSupplier xFamiliesSupplier = (com.sun.star.style.XStyleFamiliesSu… in doFormattingSamples()
653 … UnoRuntime.queryInterface( com.sun.star.style.XStyleFamiliesSupplier.class, getDocument() ); in doFormattingSamples()
654 com.sun.star.container.XNameAccess xFamiliesNA = xFamiliesSupplier.getStyleFamilies(); in doFormattingSamples()
656 … com.sun.star.container.XNameContainer xCellStylesNA = (com.sun.star.container.XNameContainer) in doFormattingSamples()
657 … UnoRuntime.queryInterface( com.sun.star.container.XNameContainer.class, aCellStylesObj ); in doFormattingSamples()
660 xDocServiceManager = (com.sun.star.lang.XMultiServiceFactory) in doFormattingSamples()
661 … UnoRuntime.queryInterface( com.sun.star.lang.XMultiServiceFactory.class, getDocument() ); in doFormattingSamples()
667 xPropSet = (com.sun.star.beans.XPropertySet) in doFormattingSamples()
668 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, aCellStyle ); in doFormattingSamples()
677 xPropSet = (com.sun.star.beans.XPropertySet) UnoRuntime.queryInterface( in doFormattingSamples()
678 com.sun.star.beans.XPropertySet.class, xCellRange ); in doFormattingSamples()
682 xPropSet = (com.sun.star.beans.XPropertySet) UnoRuntime.queryInterface( in doFormattingSamples()
683 com.sun.star.beans.XPropertySet.class, xCellRange ); 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()
700 … com.sun.star.container.XIndexAccess xRangesIA = xUniqueFormatSupp.getUniqueCellFormatRanges(); in doFormattingSamples()
705 xRangeIA = (com.sun.star.container.XIndexAccess) UnoRuntime.queryInterface( in doFormattingSamples()
706 com.sun.star.container.XIndexAccess.class, aRangesObj ); in doFormattingSamples()
715 com.sun.star.lang.XMultiComponentFactory xServiceManager = getServiceManager(); in doFormattingSamples()
719 com.sun.star.container.XNameContainer xAutoFormatsNA = in doFormattingSamples()
720 (com.sun.star.container.XNameContainer)UnoRuntime.queryInterface( in doFormattingSamples()
721 com.sun.star.container.XNameContainer.class, aAutoFormatsObj ); in doFormattingSamples()
740 com.sun.star.container.XIndexAccess xAutoFormatIA = in doFormattingSamples()
741 (com.sun.star.container.XIndexAccess)UnoRuntime.queryInterface( in doFormattingSamples()
742 com.sun.star.container.XIndexAccess.class, aAutoFormatObj ); in doFormattingSamples()
764 xPropSet = (com.sun.star.beans.XPropertySet) in doFormattingSamples()
766 com.sun.star.beans.XPropertySet.class, aFieldObj ); in doFormattingSamples()
773 com.sun.star.table.XAutoFormattable xAutoForm = (com.sun.star.table.XAutoFormattable) in doFormattingSamples()
774 UnoRuntime.queryInterface( com.sun.star.table.XAutoFormattable.class, xCellRange ); in doFormattingSamples()
791 xPropSet = (com.sun.star.beans.XPropertySet) in doFormattingSamples()
792 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.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()
799 com.sun.star.beans.PropertyValue[] aCondition = new com.sun.star.beans.PropertyValue[3]; in doFormattingSamples()
800 aCondition[0] = new com.sun.star.beans.PropertyValue(); in doFormattingSamples()
802 aCondition[0].Value = com.sun.star.sheet.ConditionOperator.GREATER; in doFormattingSamples()
803 aCondition[1] = new com.sun.star.beans.PropertyValue(); in doFormattingSamples()
806 aCondition[2] = new com.sun.star.beans.PropertyValue(); 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()
835 … com.sun.star.table.CellRangeAddress aSourceRange = createCellRangeAddress( xSheet, "A2:B3" ); in doDocumentSamples()
836 com.sun.star.table.CellAddress aDestCell = createCellAddress( xSheet, "D2" ); 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()
853 com.sun.star.beans.XPropertySet xPropSet = (com.sun.star.beans.XPropertySet) in doDocumentSamples()
854 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, getDocument() ); in doDocumentSamples()
864 com.sun.star.util.Date aDate = (com.sun.star.util.Date) in doDocumentSamples()
865 … aAnyConv.toObject(com.sun.star.util.Date.class, xPropSet.getPropertyValue( "NullDate" )); in doDocumentSamples()
874 com.sun.star.table.XCellRange xCellRange = xSheet.getCellRangeByName( "A7:C7" ); in doDocumentSamples()
875 com.sun.star.beans.XPropertySet xCellPropSet = (com.sun.star.beans.XPropertySet) in doDocumentSamples()
876 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, xCellRange ); in doDocumentSamples()
878 com.sun.star.beans.XPropertySet xValidPropSet = (com.sun.star.beans.XPropertySet) in doDocumentSamples()
879 UnoRuntime.queryInterface(com.sun.star.beans.XPropertySet.class, 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()
934 com.sun.star.table.XCellRange xCellRange = xSheet.getCellRangeByName( aRange ); 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()
939 … com.sun.star.table.CellRangeAddress[] aRangesSeq = new com.sun.star.table.CellRangeAddress[1]; 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()
990 com.sun.star.beans.XPropertySet xDocProp = (com.sun.star.beans.XPropertySet) in doNamedRangesSamples()
991 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, xDocument ); 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()
995 com.sun.star.table.CellAddress aRefPos = new com.sun.star.table.CellAddress(); in doNamedRangesSamples()
1008 com.sun.star.table.XCellRange xRange = xSheet.getCellRangeByPosition( 6, 47, 7, 49 ); 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()
1023 com.sun.star.table.CellRangeAddress aLabelArea = new com.sun.star.table.CellRangeAddress(); in doNamedRangesSamples()
1029 com.sun.star.table.CellRangeAddress aDataArea = new com.sun.star.table.CellRangeAddress(); in doNamedRangesSamples()
1050 com.sun.star.lang.XMultiComponentFactory xServiceManager = getServiceManager(); in getFirstDatabaseName()
1051 com.sun.star.container.XNameAccess xContext = in getFirstDatabaseName()
1052 (com.sun.star.container.XNameAccess) UnoRuntime.queryInterface( in getFirstDatabaseName()
1053 com.sun.star.container.XNameAccess.class, in getFirstDatabaseName()
1079 com.sun.star.lang.XMultiComponentFactory xServiceManager = getServiceManager(); in getFirstTableName()
1080 com.sun.star.container.XNameAccess xContext = (com.sun.star.container.XNameAccess) in getFirstTableName()
1081 UnoRuntime.queryInterface( com.sun.star.container.XNameAccess.class, in getFirstTableName()
1084 com.sun.star.sdb.XCompletedConnection xSource = in getFirstTableName()
1085 (com.sun.star.sdb.XCompletedConnection)UnoRuntime.queryInterface( in getFirstTableName()
1086 com.sun.star.sdb.XCompletedConnection.class, in getFirstTableName()
1088 com.sun.star.task.XInteractionHandler xHandler = in getFirstTableName()
1089 (com.sun.star.task.XInteractionHandler)UnoRuntime.queryInterface( in getFirstTableName()
1090 com.sun.star.task.XInteractionHandler.class, in getFirstTableName()
1093 com.sun.star.sdbcx.XTablesSupplier xSupplier = in getFirstTableName()
1094 (com.sun.star.sdbcx.XTablesSupplier)UnoRuntime.queryInterface( in getFirstTableName()
1095 com.sun.star.sdbcx.XTablesSupplier.class, in getFirstTableName()
1097 com.sun.star.container.XNameAccess xTables = xSupplier.getTables(); in getFirstTableName()
1115 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 2 ); in doDatabaseSamples()
1119 com.sun.star.table.XCellRange xRange = xSheet.getCellRangeByName( "B3:D24" ); 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()
1163 com.sun.star.beans.XPropertySet xFilterProp = (com.sun.star.beans.XPropertySet) in doDatabaseSamples()
1164 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, xFilterDesc ); in doDatabaseSamples()
1170 com.sun.star.table.XCellRange xCritRange = xSheet.getCellRangeByName( "B27:B28" ); 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()
1187 com.sun.star.table.TableSortField[] aSortFields = new com.sun.star.table.TableSortField[1]; in doDatabaseSamples()
1188 aSortFields[0] = new com.sun.star.table.TableSortField(); in doDatabaseSamples()
1194 com.sun.star.beans.PropertyValue[] aSortDesc = new com.sun.star.beans.PropertyValue[2]; in doDatabaseSamples()
1195 aSortDesc[0] = new com.sun.star.beans.PropertyValue(); in doDatabaseSamples()
1198 aSortDesc[1] = new com.sun.star.beans.PropertyValue(); in doDatabaseSamples()
1202 com.sun.star.util.XSortable xSort = ( com.sun.star.util.XSortable ) in doDatabaseSamples()
1203 UnoRuntime.queryInterface( com.sun.star.util.XSortable.class, xRange ); 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()
1225 … com.sun.star.beans.PropertyValue[] aImportDesc = new com.sun.star.beans.PropertyValue[3]; in doDatabaseSamples()
1226 aImportDesc[0] = new com.sun.star.beans.PropertyValue(); in doDatabaseSamples()
1229 aImportDesc[1] = new com.sun.star.beans.PropertyValue(); in doDatabaseSamples()
1231 aImportDesc[1].Value = com.sun.star.sheet.DataImportMode.TABLE; in doDatabaseSamples()
1232 aImportDesc[2] = new com.sun.star.beans.PropertyValue(); in doDatabaseSamples()
1236 com.sun.star.table.XCellRange xImportRange = xSheet.getCellRangeByName( "B35:B35" ); in doDatabaseSamples()
1237 com.sun.star.util.XImportable xImport = ( com.sun.star.util.XImportable ) in doDatabaseSamples()
1238 UnoRuntime.queryInterface( com.sun.star.util.XImportable.class, xImportRange ); in doDatabaseSamples()
1243 com.sun.star.beans.XPropertySet xDocProp = (com.sun.star.beans.XPropertySet) in doDatabaseSamples()
1244 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, getDocument() ); in doDatabaseSamples()
1246 com.sun.star.container.XNameAccess xRanges = in doDatabaseSamples()
1247 (com.sun.star.container.XNameAccess) UnoRuntime.queryInterface( in doDatabaseSamples()
1248 com.sun.star.container.XNameAccess.class, aRangesObj ); in doDatabaseSamples()
1254 com.sun.star.beans.XPropertySet xRangeProp = (com.sun.star.beans.XPropertySet) in doDatabaseSamples()
1255 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, aRangeObj ); 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()
1262 com.sun.star.table.XCellRange xResultRange = xRef.getReferredCells(); in doDatabaseSamples()
1263 com.sun.star.beans.XPropertySet xResultProp = (com.sun.star.beans.XPropertySet) in doDatabaseSamples()
1264 … UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, xResultRange ); 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()
1289 … com.sun.star.table.CellRangeAddress aSourceAddress = createCellRangeAddress( xSheet, "A10:C30" ); in doDataPilotSamples()
1292 com.sun.star.container.XIndexAccess xFields = xDPDesc.getDataPilotFields(); in doDataPilotSamples()
1294 com.sun.star.beans.XPropertySet xFieldProp; in doDataPilotSamples()
1297 xFieldProp = (com.sun.star.beans.XPropertySet) in doDataPilotSamples()
1298 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, aFieldObj ); in doDataPilotSamples()
1299 … xFieldProp.setPropertyValue( "Orientation", com.sun.star.sheet.DataPilotFieldOrientation.COLUMN ); in doDataPilotSamples()
1302 xFieldProp = (com.sun.star.beans.XPropertySet) in doDataPilotSamples()
1303 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, aFieldObj ); in doDataPilotSamples()
1304 … xFieldProp.setPropertyValue( "Orientation", com.sun.star.sheet.DataPilotFieldOrientation.ROW ); in doDataPilotSamples()
1307 xFieldProp = (com.sun.star.beans.XPropertySet) in doDataPilotSamples()
1308 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, aFieldObj ); 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()
1312 com.sun.star.table.CellAddress aDestAddress = createCellAddress( xSheet, "A40" ); in doDataPilotSamples()
1318 xDPDesc = (com.sun.star.sheet.XDataPilotDescriptor) in doDataPilotSamples()
1319 UnoRuntime.queryInterface( com.sun.star.sheet.XDataPilotDescriptor.class, aDPTableObj ); in doDataPilotSamples()
1323 xFieldProp = (com.sun.star.beans.XPropertySet) in doDataPilotSamples()
1324 UnoRuntime.queryInterface( com.sun.star.beans.XPropertySet.class, aFieldObj ); 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()
1334 com.sun.star.lang.XMultiComponentFactory xServiceManager = getServiceManager(); in doFunctionAccessSamples()
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()
1372 com.sun.star.beans.PropertyValue[] aProperties = in doFunctionAccessSamples()
1386 com.sun.star.lang.XMultiComponentFactory xServiceManager = getServiceManager(); in doApplicationSettingsSamples()
1392 com.sun.star.beans.XPropertySet xPropSet = in doApplicationSettingsSamples()
1393 (com.sun.star.beans.XPropertySet)UnoRuntime.queryInterface( in doApplicationSettingsSamples()
1394 com.sun.star.beans.XPropertySet.class, aSettings ); in doApplicationSettingsSamples()