Lines Matching refs:xSheet
75 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellSamples()
79 prepareRange( xSheet, "A1:C7", "Cells and Cell Ranges" ); in doCellSamples()
82 xCell = xSheet.getCellByPosition( 1, 2 ); in doCellSamples()
167 (unoidl.com.sun.star.sheet.XSheetAnnotationsSupplier) xSheet; in doCellSamples()
186 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellRangeSamples()
192 setFormula( xSheet, "B5", "First cell" ); in doCellRangeSamples()
193 setFormula( xSheet, "B6", "Second cell" ); in doCellRangeSamples()
195 xCellRange = xSheet.getCellRangeByPosition( 1, 4, 1, 5 ); in doCellRangeSamples()
229 xCellRange = xSheet.getCellRangeByName( "F3:G6" ); in doCellRangeSamples()
230 prepareRange( xSheet, "E1:H7", "XMergeable" ); in doCellRangeSamples()
255 xCellRange = xSheet.getCellRangeByName( "B1" ); in doCellRangeSamples()
272 prepareRange( xSheet, "A9:C30", "XCellRangeData" ); in doCellRangeSamples()
274 xCellRange = xSheet.getCellRangeByName( "A10:C30" ); in doCellRangeSamples()
372 setValue( xSheet, "E10", 1 ); in doCellRangeSamples()
373 setValue( xSheet, "E11", 4 ); in doCellRangeSamples()
374 setDate( xSheet, "E12", 30, 1, 2002 ); in doCellRangeSamples()
375 setFormula( xSheet, "I13", "Text 10" ); in doCellRangeSamples()
376 setFormula( xSheet, "E14", "Jan" ); in doCellRangeSamples()
377 setValue( xSheet, "K14", 10 ); in doCellRangeSamples()
378 setValue( xSheet, "E16", 1 ); in doCellRangeSamples()
379 setValue( xSheet, "F16", 2 ); in doCellRangeSamples()
380 setDate( xSheet, "E17", 28, 2, 2002 ); in doCellRangeSamples()
381 setDate( xSheet, "F17", 28, 1, 2002 ); in doCellRangeSamples()
382 setValue( xSheet, "E18", 6 ); in doCellRangeSamples()
383 setValue( xSheet, "F18", 4 ); in doCellRangeSamples()
388 xSeries = getCellSeries( xSheet, "E10:I11" ); in doCellRangeSamples()
394 xSeries = getCellSeries( xSheet, "E12:I12" ); in doCellRangeSamples()
401 xSeries = getCellSeries( xSheet, "E13:I13" ); in doCellRangeSamples()
408 xSeries = getCellSeries( xSheet, "E14:I14" ); in doCellRangeSamples()
415 xSeries = getCellSeries( xSheet, "K10:K14" ); in doCellRangeSamples()
422 xSeries = getCellSeries( xSheet, "E16:K18" ); in doCellRangeSamples()
426 prepareRange( xSheet, "E9:K18", "XCellSeries" ); in doCellRangeSamples()
430 xCellRange = xSheet.getCellRangeByName( "E21:G23" ); in doCellRangeSamples()
431 prepareRange( xSheet, "E20:G23", "XArrayFormulaRange" ); in doCellRangeSamples()
441 setFormula( xSheet, "E26", "=E27^F26" ); in doCellRangeSamples()
442 setValue( xSheet, "E27", 1 ); in doCellRangeSamples()
443 setValue( xSheet, "F26", 1 ); in doCellRangeSamples()
444 getCellSeries( xSheet, "E27:E31" ).fillAuto( in doCellRangeSamples()
446 getCellSeries( xSheet, "F26:J26" ).fillAuto( in doCellRangeSamples()
448 setFormula( xSheet, "F33", "=SIN(E33)" ); in doCellRangeSamples()
449 setFormula( xSheet, "G33", "=COS(E33)" ); in doCellRangeSamples()
450 setFormula( xSheet, "H33", "=TAN(E33)" ); in doCellRangeSamples()
451 setValue( xSheet, "E34", 0 ); in doCellRangeSamples()
452 setValue( xSheet, "E35", 0.2 ); in doCellRangeSamples()
453 getCellSeries( xSheet, "E34:E38" ).fillAuto( in doCellRangeSamples()
455 prepareRange( xSheet, "E25:J38", "XMultipleOperation" ); in doCellRangeSamples()
458 createCellRangeAddress( xSheet, "E26" ); in doCellRangeSamples()
460 createCellAddress( xSheet, "E27" ); in doCellRangeSamples()
462 createCellAddress( xSheet, "F26" ); in doCellRangeSamples()
464 xCellRange = xSheet.getCellRangeByName( "E26:J31" ); in doCellRangeSamples()
471 aFormulaRange = createCellRangeAddress( xSheet, "F33:H33" ); in doCellRangeSamples()
472 aColCell = createCellAddress( xSheet, "E33" ); in doCellRangeSamples()
475 xCellRange = xSheet.getCellRangeByName( "E34:H38" ); in doCellRangeSamples()
483 xCellRange = xSheet.getCellRangeByName( "A10:C30" ); in doCellRangeSamples()
499 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, String aRange ) in getCellSeries() argument
502 xSheet.getCellRangeByName( aRange ); in getCellSeries()
583 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellCursorSamples()
588 xSheet.getCellRangeByName( "F22" ); in doCellCursorSamples()
592 xSheet.createCursorByRange( xCellRange ); in doCellCursorSamples()
619 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 1 ); in doFormattingSamples()
656 xCellRange = xSheet.getCellRangeByName( "D2:F2" ); in doFormattingSamples()
660 xCellRange = xSheet.getCellRangeByName( "A3:G3" ); in doFormattingSamples()
665 xCellRange = xSheet.getCellRangeByName( "A1:G3" ); in doFormattingSamples()
752 xCellRange = xSheet.getCellRangeByName( "A5:H25" ); in doFormattingSamples()
763 xSheet = getSpreadsheet( 0 ); in doFormattingSamples()
764 prepareRange( xSheet, "K20:K23", "Cond. Format" ); in doFormattingSamples()
765 setValue( xSheet, "K21", 1 ); in doFormattingSamples()
766 setValue( xSheet, "K22", 2 ); in doFormattingSamples()
767 setValue( xSheet, "K23", 3 ); in doFormattingSamples()
770 xCellRange = xSheet.getCellRangeByName( "K21:K23" ); in doFormattingSamples()
808 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = in doDocumentSamples()
813 prepareRange( xSheet, "A1:B3", "Copy from" ); in doDocumentSamples()
814 prepareRange( xSheet, "D1:E3", "To" ); in doDocumentSamples()
815 setValue( xSheet, "A2", 123 ); in doDocumentSamples()
816 setValue( xSheet, "B2", 345 ); in doDocumentSamples()
817 setFormula( xSheet, "A3", "=SUM(A2:B2)" ); in doDocumentSamples()
818 setFormula( xSheet, "B3", "=FORMULA(A3)" ); in doDocumentSamples()
821 (unoidl.com.sun.star.sheet.XCellRangeMovement) xSheet; in doDocumentSamples()
823 createCellRangeAddress( xSheet, "A2:B3" ); in doDocumentSamples()
825 createCellAddress( xSheet, "D2" ); in doDocumentSamples()
831 (unoidl.com.sun.star.sheet.XSheetPageBreak) xSheet; in doDocumentSamples()
861 prepareRange( xSheet, "A5:C7", "Validation" ); in doDocumentSamples()
862 setFormula( xSheet, "A6", "Insert values between 0.0 and 5.0 below:" ); in doDocumentSamples()
865 xSheet.getCellRangeByName( "A7:C7" ); in doDocumentSamples()
912 xSheet, "B10:C11", aValues, in doDocumentSamples()
920 xSheet, "B10:C11", aValues, in doDocumentSamples()
928 xSheet, "B10:C11", aValues, in doDocumentSamples()
932 showScenario( xSheet, "Second Scenario" ); in doDocumentSamples()
943 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in insertScenario() argument
951 xSheet.getCellRangeByName( aRange ); in insertScenario()
962 (unoidl.com.sun.star.sheet.XScenariosSupplier) xSheet; in insertScenario()
977 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in showScenario() argument
982 (unoidl.com.sun.star.sheet.XScenariosSupplier) xSheet; in showScenario()
1000 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = in doNamedRangesSamples()
1005 prepareRange( xSheet, "G42:H45", "Named ranges" ); in doNamedRangesSamples()
1006 xSheet.getCellByPosition( 6, 42 ).setValue( 1 ); in doNamedRangesSamples()
1007 xSheet.getCellByPosition( 6, 43 ).setValue( 2 ); in doNamedRangesSamples()
1008 xSheet.getCellByPosition( 7, 42 ).setValue( 3 ); in doNamedRangesSamples()
1009 xSheet.getCellByPosition( 7, 43 ).setValue( 4 ); in doNamedRangesSamples()
1025 xSheet.getCellByPosition( 6, 44 ).setFormula( "=ExampleName" ); in doNamedRangesSamples()
1026 xSheet.getCellByPosition( 7, 44 ).setFormula( "=ExampleName" ); in doNamedRangesSamples()
1030 prepareRange( xSheet, "G47:I50", "Label ranges" ); in doNamedRangesSamples()
1032 xSheet.getCellRangeByPosition( 6, 47, 7, 49 ); in doNamedRangesSamples()
1067 xSheet.getCellByPosition( 8, 48 ).setFormula( "=Apples+Oranges" ); in doNamedRangesSamples()
1068 xSheet.getCellByPosition( 8, 49 ).setFormula( "=Apples+Oranges" ); in doNamedRangesSamples()
1123 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 2 ); in doDatabaseSamples()
1128 xSheet.getCellRangeByName( "B3:D24" ); in doDatabaseSamples()
1226 xSheet.getCellRangeByName( "B27:B28" ); in doDatabaseSamples()
1302 xSheet.getCellRangeByName( "B35:B35" ); in doDatabaseSamples()
1350 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doDataPilotSamples()
1354 prepareRange( xSheet, "A38:C38", "Data Pilot" ); in doDataPilotSamples()
1356 (unoidl.com.sun.star.sheet.XDataPilotTablesSupplier) xSheet; in doDataPilotSamples()
1363 createCellRangeAddress( xSheet, "A10:C30" ); in doDataPilotSamples()
1401 createCellAddress( xSheet, "A40" ); in doDataPilotSamples()