Lines Matching refs:xSheet
65 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = getSpreadsheet( 0 ); in doCellRangeSamples()
71 setFormula( xSheet, "B5", "First cell" ); in doCellRangeSamples()
72 setFormula( xSheet, "B6", "Second cell" ); in doCellRangeSamples()
74 xCellRange = xSheet.getCellRangeByPosition( 1, 4, 1, 5 ); in doCellRangeSamples()
106 xCellRange = xSheet.getCellRangeByName( "F3:G6" ); in doCellRangeSamples()
107 prepareRange( xSheet, "E1:H7", "XMergeable" ); in doCellRangeSamples()
114 xCellRange = xSheet.getCellRangeByName( "B1" ); in doCellRangeSamples()
128 prepareRange( xSheet, "A9:C30", "XCellRangeData" ); in doCellRangeSamples()
130 xCellRange = xSheet.getCellRangeByName( "A10:C30" ); in doCellRangeSamples()
216 setValue( xSheet, "E10", 1 ); in doCellRangeSamples()
217 setValue( xSheet, "E11", 4 ); in doCellRangeSamples()
218 setDate( xSheet, "E12", 30, 1, 2002 ); in doCellRangeSamples()
219 setFormula( xSheet, "I13", "Text 10" ); in doCellRangeSamples()
220 setFormula( xSheet, "E14", "Jan" ); in doCellRangeSamples()
221 setValue( xSheet, "K14", 10 ); in doCellRangeSamples()
222 setValue( xSheet, "E16", 1 ); in doCellRangeSamples()
223 setValue( xSheet, "F16", 2 ); in doCellRangeSamples()
224 setDate( xSheet, "E17", 28, 2, 2002 ); in doCellRangeSamples()
225 setDate( xSheet, "F17", 28, 1, 2002 ); in doCellRangeSamples()
226 setValue( xSheet, "E18", 6 ); in doCellRangeSamples()
227 setValue( xSheet, "F18", 4 ); in doCellRangeSamples()
236 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, String aRange ) in getCellSeries() argument
239 xSheet.getCellRangeByName( aRange ); in getCellSeries()
298 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = in getSpreadsheet()
302 return xSheet; in getSpreadsheet()
317 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = in insertSpreadsheet()
321 return xSheet; in insertSpreadsheet()
332 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in setValue() argument
336 xSheet.getCellRangeByName( aCellName ).getCellByPosition( in setValue()
345 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in setFormula() argument
349 xSheet.getCellRangeByName( aCellName ).getCellByPosition( in setFormula()
360 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in setDate() argument
366 xSheet.getCellRangeByName( aCellName ).getCellByPosition( 0, 0 ); in setDate()
394 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in prepareRange() argument
401 xCellRange = xSheet.getCellRangeByName( aRange ); in prepareRange()
425 xCellRange = xSheet.getCellRangeByPosition( in prepareRange()
452 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in createCellAddress() argument
457 xSheet.getCellRangeByName( aCell ).getCellByPosition( 0, 0 ); in createCellAddress()
466 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, String aRange ) in createCellRangeAddress() argument
470 xSheet.getCellRangeByName( aRange ); in createCellRangeAddress()
513 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = in getCellRangeAddressString()
516 (unoidl.com.sun.star.container.XNamed) xSheet; in getCellRangeAddressString()