Lines Matching refs:xSheet
195 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellSamples() local
199 prepareRange( xSheet, "A1:C7", "Cells and Cell Ranges" ); in doCellSamples()
202 xCell = xSheet.getCellByPosition( 1, 2 ); in doCellSamples()
282 com.sun.star.sheet.XSheetAnnotationsSupplier.class, xSheet ); in doCellSamples()
298 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellRangeSamples() local
305 setFormula( xSheet, "B5", "First cell" ); in doCellRangeSamples()
306 setFormula( xSheet, "B6", "Second cell" ); in doCellRangeSamples()
308 xCellRange = xSheet.getCellRangeByPosition( 1, 4, 1, 5 ); in doCellRangeSamples()
337 xCellRange = xSheet.getCellRangeByName( "F3:G6" ); in doCellRangeSamples()
338 prepareRange( xSheet, "E1:H7", "XMergeable" ); in doCellRangeSamples()
364 xCellRange = xSheet.getCellRangeByName( "B1" ); in doCellRangeSamples()
380 prepareRange( xSheet, "A9:C30", "XCellRangeData" ); in doCellRangeSamples()
382 xCellRange = xSheet.getCellRangeByName( "A10:C30" ); in doCellRangeSamples()
431 setValue( xSheet, "E10", 1 ); in doCellRangeSamples()
432 setValue( xSheet, "E11", 4 ); in doCellRangeSamples()
433 setDate( xSheet, "E12", 30, 1, 2002 ); in doCellRangeSamples()
434 setFormula( xSheet, "I13", "Text 10" ); in doCellRangeSamples()
435 setFormula( xSheet, "E14", "Jan" ); in doCellRangeSamples()
436 setValue( xSheet, "K14", 10 ); in doCellRangeSamples()
437 setValue( xSheet, "E16", 1 ); in doCellRangeSamples()
438 setValue( xSheet, "F16", 2 ); in doCellRangeSamples()
439 setDate( xSheet, "E17", 28, 2, 2002 ); in doCellRangeSamples()
440 setDate( xSheet, "F17", 28, 1, 2002 ); in doCellRangeSamples()
441 setValue( xSheet, "E18", 6 ); in doCellRangeSamples()
442 setValue( xSheet, "F18", 4 ); in doCellRangeSamples()
446 xSeries = getCellSeries( xSheet, "E10:I11" ); in doCellRangeSamples()
450 xSeries = getCellSeries( xSheet, "E12:I12" ); in doCellRangeSamples()
454 xSeries = getCellSeries( xSheet, "E13:I13" ); in doCellRangeSamples()
458 xSeries = getCellSeries( xSheet, "E14:I14" ); in doCellRangeSamples()
462 xSeries = getCellSeries( xSheet, "K10:K14" ); in doCellRangeSamples()
466 xSeries = getCellSeries( xSheet, "E16:K18" ); in doCellRangeSamples()
469 prepareRange( xSheet, "E9:K18", "XCellSeries" ); in doCellRangeSamples()
473 xCellRange = xSheet.getCellRangeByName( "E21:G23" ); in doCellRangeSamples()
474 prepareRange( xSheet, "E20:G23", "XArrayFormulaRange" ); in doCellRangeSamples()
483 setFormula( xSheet, "E26", "=E27^F26" ); in doCellRangeSamples()
484 setValue( xSheet, "E27", 1 ); in doCellRangeSamples()
485 setValue( xSheet, "F26", 1 ); 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()
488 setFormula( xSheet, "F33", "=SIN(E33)" ); in doCellRangeSamples()
489 setFormula( xSheet, "G33", "=COS(E33)" ); in doCellRangeSamples()
490 setFormula( xSheet, "H33", "=TAN(E33)" ); in doCellRangeSamples()
491 setValue( xSheet, "E34", 0 ); in doCellRangeSamples()
492 setValue( xSheet, "E35", 0.2 ); in doCellRangeSamples()
493 … getCellSeries( xSheet, "E34:E38" ).fillAuto( com.sun.star.sheet.FillDirection.TO_BOTTOM, 2 ); in doCellRangeSamples()
494 prepareRange( xSheet, "E25:J38", "XMultipleOperation" ); 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()
500 xCellRange = xSheet.getCellRangeByName( "E26:J31" ); in doCellRangeSamples()
506 aFormulaRange = createCellRangeAddress( xSheet, "F33:H33" ); in doCellRangeSamples()
507 aColCell = createCellAddress( xSheet, "E33" ); in doCellRangeSamples()
510 xCellRange = xSheet.getCellRangeByName( "E34:H38" ); in doCellRangeSamples()
518 xCellRange = xSheet.getCellRangeByName( "A10:C30" ); in doCellRangeSamples()
533 com.sun.star.sheet.XSpreadsheet xSheet, String aRange ) in getCellSeries() argument
536 com.sun.star.sheet.XCellSeries.class, xSheet.getCellRangeByName( aRange ) ); in getCellSeries()
610 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellCursorSamples() local
614 com.sun.star.table.XCellRange xRange = xSheet.getCellRangeByName( "F22" ); in doCellCursorSamples()
617 com.sun.star.sheet.XSheetCellCursor xCursor = xSheet.createCursorByRange( xCellRange ); in doCellCursorSamples()
643 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 1 ); in doFormattingSamples() local
676 xCellRange = xSheet.getCellRangeByName( "D2:F2" ); in doFormattingSamples()
681 xCellRange = xSheet.getCellRangeByName( "A3:G3" ); in doFormattingSamples()
687 xCellRange = xSheet.getCellRangeByName( "A1:G3" ); in doFormattingSamples()
772 xCellRange = xSheet.getCellRangeByName( "A5:H25" ); in doFormattingSamples()
783 xSheet = getSpreadsheet( 0 ); in doFormattingSamples()
784 prepareRange( xSheet, "K20:K23", "Cond. Format" ); in doFormattingSamples()
785 setValue( xSheet, "K21", 1 ); in doFormattingSamples()
786 setValue( xSheet, "K22", 2 ); in doFormattingSamples()
787 setValue( xSheet, "K23", 3 ); in doFormattingSamples()
790 xCellRange = xSheet.getCellRangeByName( "K21:K23" ); in doFormattingSamples()
822 com.sun.star.sheet.XSpreadsheet xSheet = insertSpreadsheet( "A new sheet", (short)0x7FFF ); in doDocumentSamples() local
826 prepareRange( xSheet, "A1:B3", "Copy from" ); in doDocumentSamples()
827 prepareRange( xSheet, "D1:E3", "To" ); in doDocumentSamples()
828 setValue( xSheet, "A2", 123 ); in doDocumentSamples()
829 setValue( xSheet, "B2", 345 ); in doDocumentSamples()
830 setFormula( xSheet, "A3", "=SUM(A2:B2)" ); in doDocumentSamples()
831 setFormula( xSheet, "B3", "=FORMULA(A3)" ); 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()
842 UnoRuntime.queryInterface( com.sun.star.sheet.XSheetPageBreak.class, xSheet ); in doDocumentSamples()
871 prepareRange( xSheet, "A5:C7", "Validation" ); in doDocumentSamples()
872 setFormula( xSheet, "A6", "Insert values between 0.0 and 5.0 below:" ); in doDocumentSamples()
874 com.sun.star.table.XCellRange xCellRange = xSheet.getCellRangeByName( "A7:C7" ); in doDocumentSamples()
901 insertScenario( xSheet, "B10:C11", aValues, "First Scenario", "The first scenario." ); in doDocumentSamples()
907 insertScenario( xSheet, "B10:C11", aValues, "Second Scenario", "The visible scenario." ); in doDocumentSamples()
913 insertScenario( xSheet, "B10:C11", aValues, "Third Scenario", "The last scenario." ); in doDocumentSamples()
916 showScenario( xSheet, "Second Scenario" ); in doDocumentSamples()
927 com.sun.star.sheet.XSpreadsheet xSheet, in insertScenario() argument
934 com.sun.star.table.XCellRange xCellRange = xSheet.getCellRangeByName( aRange ); in insertScenario()
944 UnoRuntime.queryInterface( com.sun.star.sheet.XScenariosSupplier.class, xSheet ); in insertScenario()
958 com.sun.star.sheet.XSpreadsheet xSheet, in showScenario() argument
963 UnoRuntime.queryInterface( com.sun.star.sheet.XScenariosSupplier.class, xSheet ); in showScenario()
979 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doNamedRangesSamples() local
983 prepareRange( xSheet, "G42:H45", "Named ranges" ); in doNamedRangesSamples()
984 xSheet.getCellByPosition( 6, 42 ).setValue( 1 ); in doNamedRangesSamples()
985 xSheet.getCellByPosition( 6, 43 ).setValue( 2 ); in doNamedRangesSamples()
986 xSheet.getCellByPosition( 7, 42 ).setValue( 3 ); in doNamedRangesSamples()
987 xSheet.getCellByPosition( 7, 43 ).setValue( 4 ); in doNamedRangesSamples()
1002 xSheet.getCellByPosition( 6, 44 ).setFormula( "=ExampleName" ); in doNamedRangesSamples()
1003 xSheet.getCellByPosition( 7, 44 ).setFormula( "=ExampleName" ); in doNamedRangesSamples()
1007 prepareRange( xSheet, "G47:I50", "Label ranges" ); in doNamedRangesSamples()
1008 com.sun.star.table.XCellRange xRange = xSheet.getCellRangeByPosition( 6, 47, 7, 49 ); in doNamedRangesSamples()
1038 xSheet.getCellByPosition( 8, 48 ).setFormula( "=Apples+Oranges" ); in doNamedRangesSamples()
1039 xSheet.getCellByPosition( 8, 49 ).setFormula( "=Apples+Oranges" ); in doNamedRangesSamples()
1115 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 2 ); in doDatabaseSamples() local
1119 com.sun.star.table.XCellRange xRange = xSheet.getCellRangeByName( "B3:D24" ); in doDatabaseSamples()
1170 com.sun.star.table.XCellRange xCritRange = xSheet.getCellRangeByName( "B27:B28" ); in doDatabaseSamples()
1236 com.sun.star.table.XCellRange xImportRange = xSheet.getCellRangeByName( "B35:B35" ); in doDatabaseSamples()
1279 com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doDataPilotSamples() local
1283 prepareRange( xSheet, "A38:C38", "Data Pilot" ); in doDataPilotSamples()
1285 UnoRuntime.queryInterface( com.sun.star.sheet.XDataPilotTablesSupplier.class, xSheet ); in doDataPilotSamples()
1289 … com.sun.star.table.CellRangeAddress aSourceAddress = createCellRangeAddress( xSheet, "A10:C30" ); in doDataPilotSamples()
1312 com.sun.star.table.CellAddress aDestAddress = createCellAddress( xSheet, "A40" ); in doDataPilotSamples()