Home
last modified time | relevance | path

Searched refs:xSheet (Results 1 – 25 of 57) sorted by relevance

123

/trunk/main/odk/examples/java/Spreadsheet/
H A DSCalc.java159 XSpreadsheet xSheet=null; in main() local
178 insertIntoCell(1,0,"JAN",xSheet,""); in main()
179 insertIntoCell(2,0,"FEB",xSheet,""); in main()
180 insertIntoCell(3,0,"MAR",xSheet,""); in main()
181 insertIntoCell(4,0,"APR",xSheet,""); in main()
182 insertIntoCell(5,0,"MAI",xSheet,""); in main()
183 insertIntoCell(6,0,"JUN",xSheet,""); in main()
184 insertIntoCell(7,0,"JUL",xSheet,""); in main()
185 insertIntoCell(8,0,"AUG",xSheet,""); in main()
186 insertIntoCell(9,0,"SEP",xSheet,""); in main()
[all …]
H A DEuroAdaption.java96 com.sun.star.sheet.XSpreadsheet xSheet = null; in main() local
103 xSheet = (XSpreadsheet) UnoRuntime.queryInterface( in main()
118 createExampleData( xSheet, xNumberFormats ); in main()
122 Convert( xSheet, xNumberFormats, "DM", "EUR", 1.95583f ); in main()
133 public static void Convert( XSpreadsheet xSheet, XNumberFormats xNumberFormats, in Convert() argument
150 XCellFormatRangesSupplier.class, xSheet ); in Convert()
268 public static void createExampleData( XSpreadsheet xSheet, in createExampleData() argument
288 xCell = xSheet.getCellByPosition( 2, 1 + iCounter ); in createExampleData()
290 xCellRange = xSheet.getCellRangeByPosition( 2, 1 + iCounter, in createExampleData()
/trunk/main/odk/examples/DevelopersGuide/Spreadsheet/
H A DSpreadsheetSample.java431 setValue( xSheet, "E10", 1 ); in doCellRangeSamples()
432 setValue( xSheet, "E11", 4 ); in doCellRangeSamples()
437 setValue( xSheet, "E16", 1 ); in doCellRangeSamples()
438 setValue( xSheet, "F16", 2 ); in doCellRangeSamples()
441 setValue( xSheet, "E18", 6 ); in doCellRangeSamples()
442 setValue( xSheet, "F18", 4 ); in doCellRangeSamples()
484 setValue( xSheet, "E27", 1 ); in doCellRangeSamples()
485 setValue( xSheet, "F26", 1 ); in doCellRangeSamples()
491 setValue( xSheet, "E34", 0 ); in doCellRangeSamples()
783 xSheet = getSpreadsheet( 0 ); in doFormattingSamples()
[all …]
H A DSpreadsheetDocHelper.java105 com.sun.star.sheet.XSpreadsheet xSheet = null; in getSpreadsheet() local
120 return xSheet; in getSpreadsheet()
132 com.sun.star.sheet.XSpreadsheet xSheet = null; in insertSpreadsheet() local
136 xSheet = (com.sun.star.sheet.XSpreadsheet) in insertSpreadsheet()
146 return xSheet; in insertSpreadsheet()
157 com.sun.star.sheet.XSpreadsheet xSheet, in setValue() argument
169 com.sun.star.sheet.XSpreadsheet xSheet, in setFormula() argument
183 com.sun.star.sheet.XSpreadsheet xSheet, in setDate() argument
213 com.sun.star.sheet.XSpreadsheet xSheet, in prepareRange() argument
238 xCellRange = xSheet.getCellRangeByPosition( in prepareRange()
[all …]
H A DGeneralTableSample.java70 xCell = xSheet.getCellByPosition( 0, 0 ); in doSampleFunction()
76 xSheet.getCellByPosition( 0, 1 ).setValue( nDblValue ); in doSampleFunction()
79 xCell = xSheet.getCellByPosition( 0, 2 ); in doSampleFunction()
90 xCell = xSheet.getCellByPosition( 0, 3 ); in doSampleFunction()
107 xCellRange = xSheet.getCellRangeByPosition( 2, 0, 3, 1 ); in doSampleFunction()
115 xCellRange = xSheet.getCellRangeByName( "C4:D5" ); in doSampleFunction()
127 xCellRange = xSheet.getCellRangeByName( "A1" ); in doSampleFunction()
132 xSheet.createCursorByRange( xSheetCellRange ); in doSampleFunction()
161 xSheet.getCellByPosition( 2, 2 ).setFormula( aText ); in doSampleFunction()
216 xSheet.getCellByPosition( 2, 8 ).setFormula( aText ); in doSampleFunction()
[all …]
/trunk/main/odk/examples/CLI/CSharp/Spreadsheet/
H A DSpreadsheetSample.cs372 setValue( xSheet, "E10", 1 ); in doCellRangeSamples()
373 setValue( xSheet, "E11", 4 ); in doCellRangeSamples()
377 setValue( xSheet, "K14", 10 ); in doCellRangeSamples()
378 setValue( xSheet, "E16", 1 ); in doCellRangeSamples()
379 setValue( xSheet, "F16", 2 ); in doCellRangeSamples()
382 setValue( xSheet, "E18", 6 ); in doCellRangeSamples()
383 setValue( xSheet, "F18", 4 ); in doCellRangeSamples()
442 setValue( xSheet, "E27", 1 ); in doCellRangeSamples()
443 setValue( xSheet, "F26", 1 ); in doCellRangeSamples()
451 setValue( xSheet, "E34", 0 ); in doCellRangeSamples()
[all …]
H A DGeneralTableSample.cs70 xCell = xSheet.getCellByPosition( 0, 0 ); in doSampleFunction()
76 xSheet.getCellByPosition( 0, 1 ).setValue( nDblValue ); in doSampleFunction()
79 xCell = xSheet.getCellByPosition( 0, 2 ); in doSampleFunction()
90 xCell = xSheet.getCellByPosition( 0, 3 ); in doSampleFunction()
116 xCellRange = xSheet.getCellRangeByName( "C4:D5" ); in doSampleFunction()
129 xCellRange = xSheet.getCellRangeByName( "A1" ); in doSampleFunction()
134 xSheet.createCursorByRange( xSheetCellRange ); in doSampleFunction()
151 (unoidl.com.sun.star.table.XColumnRowRange) xSheet; in doSampleFunction()
165 xSheet.getCellByPosition( 2, 2 ).setFormula( aText ); in doSampleFunction()
221 xSheet.getCellByPosition( 2, 8 ).setFormula( aText ); in doSampleFunction()
[all …]
H A DSpreadsheetDocHelper.cs84 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = in getSpreadsheet()
88 return xSheet; in getSpreadsheet()
103 unoidl.com.sun.star.sheet.XSpreadsheet xSheet = in insertSpreadsheet()
107 return xSheet; in insertSpreadsheet()
118 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in setValue() argument
131 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in setFormula() argument
146 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in setDate() argument
180 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in prepareRange() argument
211 xCellRange = xSheet.getCellRangeByPosition( in prepareRange()
238 unoidl.com.sun.star.sheet.XSpreadsheet xSheet, in createCellAddress() argument
[all …]
/trunk/test/testuno/source/fvt/uno/sc/cell/
H A DInsertDeleteCells.java140 cellC2 = xSheet.getCellByPosition(2, 1); in testInsertCells()
163 cellE2 = xSheet.getCellByPosition(4, 1); in testInsertCells()
165 cellC3 = xSheet.getCellByPosition(2, 2); in testInsertCells()
270 cellA2 = xSheet.getCellByPosition(0, 1); in testDeleteCells()
271 cellB2 = xSheet.getCellByPosition(1, 1); in testDeleteCells()
272 cellC2 = xSheet.getCellByPosition(2, 1); in testDeleteCells()
289 cellA2 = xSheet.getCellByPosition(0, 1); in testDeleteCells()
290 cellB2 = xSheet.getCellByPosition(1, 1); in testDeleteCells()
291 cellC2 = xSheet.getCellByPosition(2, 1); in testDeleteCells()
308 cellA2 = xSheet.getCellByPosition(0, 1); in testDeleteCells()
[all …]
H A DDeleteContents.java106 XSpreadsheet xSheet = SCUtil.getCurrentSheet(scDocument); in testDeleteContents() local
109 XCellRange xCellRange = xSheet.getCellRangeByPosition( 1, 4, 2, 14 ); in testDeleteContents()
113 XCell cellB5 = xSheet.getCellByPosition(1, 4); in testDeleteContents()
123 XCell cellB7 = xSheet.getCellByPosition(1, 6); in testDeleteContents()
132 XCell cellB8 = xSheet.getCellByPosition(1, 7); in testDeleteContents()
145 XSheetAnnotationsSupplier.class, xSheet); in testDeleteContents()
155 XCell cellB6 = xSheet.getCellByPosition(1, 5); in testDeleteContents()
156 XCell cellB10 = xSheet.getCellByPosition(1, 9); in testDeleteContents()
166 (XDrawPageSupplier)UnoRuntime.queryInterface(XDrawPageSupplier.class, xSheet); in testDeleteContents()
/trunk/main/testtools/source/cliversioning/
H A Dversion.cs71 setFormula( xSheet, "B5", "First cell" ); in doCellRangeSamples()
216 setValue( xSheet, "E10", 1 ); in doCellRangeSamples()
217 setValue( xSheet, "E11", 4 ); 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()
226 setValue( xSheet, "E18", 6 ); in doCellRangeSamples()
227 setValue( xSheet, "F18", 4 ); in doCellRangeSamples()
302 return xSheet; in getSpreadsheet()
[all …]
/trunk/main/sc/source/ui/vba/
H A Dvbaworksheets.cxx81 uno::Reference< sheet::XSpreadsheet > xSheet( *mIt++ ); in nextElement() local
82 return uno::makeAny( xSheet ) ; in nextElement()
201 uno::Reference< sheet::XSpreadsheet > xSheet( aSource, uno::UNO_QUERY ); in createCollectionObject() local
202 uno::Reference< XHelperInterface > xIf = excel::getUnoSheetModuleObj( xSheet ); in createCollectionObject()
260 uno::Reference< container::XNamed > xNamed( xSheet, uno::UNO_QUERY_THROW ); in Add()
304 xSheet->Delete(); in Delete()
343 if ( xSheet->getVisible() == sal_False ) in getVisible()
362 xSheet->setVisible( bState ); in setVisible()
388 ScVbaWorksheet* pSheet = dynamic_cast< ScVbaWorksheet* >( xSheet.get() ); in Select()
425 uno::Reference< container::XNamed > xName( xSheet, uno::UNO_QUERY_THROW ); in Item()
[all …]
H A Dexcelvbahelper.cxx247 getUnoSheetModuleObj( const uno::Reference< sheet::XSpreadsheet >& xSheet ) throw ( uno::RuntimeExc… in getUnoSheetModuleObj() argument
249 uno::Reference< beans::XPropertySet > xProps( xSheet, uno::UNO_QUERY_THROW ); in getUnoSheetModuleObj()
257 return getUnoDocModule( sCodeName, GetDocShellFromRange( xSheet ) ); in getUnoSheetModuleObj()
264 … uno::Reference< sheet::XSpreadsheet > xSheet( xSheetRange->getSpreadsheet(), uno::UNO_SET_THROW ); in getUnoSheetModuleObj() local
265 return getUnoSheetModuleObj( xSheet ); in getUnoSheetModuleObj()
281 … uno::Reference< sheet::XSpreadsheet > xSheet( xSheetRange->getSpreadsheet(), uno::UNO_SET_THROW ); in getUnoSheetModuleObj() local
282 return getUnoSheetModuleObj( xSheet ); in getUnoSheetModuleObj()
290 … uno::Reference< sheet::XSpreadsheet > xSheet( xSheets->getByIndex( nTab ), uno::UNO_QUERY_THROW ); in getUnoSheetModuleObj() local
291 return getUnoSheetModuleObj( xSheet ); in getUnoSheetModuleObj()
H A Dvbaworksheet.cxx132 uno::Reference< container::XNamed > xNamed( xSheet, uno::UNO_QUERY_THROW ); in removeAllSheets()
186 const uno::Reference< sheet::XSpreadsheet >& xSheet, in ScVbaWorksheet()
471 uno::Reference<excel::XWorksheet> xSheet; in Move() local
474 if (!(Before >>= xSheet) && !(After >>=xSheet)&& !(Before.hasValue()) && !(After.hasValue())) in Move()
495 if ( ScVbaWorksheets::nameExists (xSpreadDoc, xSheet->getName(), nDest) ) in Move()
508 uno::Reference<excel::XWorksheet> xSheet; in Copy() local
510 if (!(Before >>= xSheet) && !(After >>=xSheet)&& !(Before.hasValue()) && !(After.hasValue())) in Copy()
529 rtl::OUString aSheetName = xSheet->getName(); in Copy()
584 return new ScVbaWorksheet (getParent(), mxContext, xSheet, getModel()); in getSheetAtOffset()
699 uno::Reference< css::sheet::XSpreadsheet > xSheet = getSheet(); in PivotTables() local
[all …]
/trunk/main/qadevOOo/java/OOoRunner/src/main/java/ifc/sheet/
H A D_XDocumentAuditing.java53 XSpreadsheet[] xSheet = null; field in _XDocumentAuditing
61 xSheet = new XSpreadsheet[2]; in before()
70 xSheet[0] = oSheet; in before()
73 xSheet[1] = oSheet; in before()
119 xSheet[0].getCellByPosition(6, 6).setValue(9); in before()
120 XNamed xNamed = (XNamed)UnoRuntime.queryInterface(XNamed.class, xSheet[0]); in before()
122 xSheet[1].getCellByPosition(6, 6).setValue(16); in before()
123 xSheet[1].getCellByPosition(6, 7).setFormula("= SQRT(G7)"); in before()
152 result &= xSheet[1].getCellByPosition(6, 7).getValue() == 4; in _refreshArrows()
153 xSheet[1].getCellByPosition(6, 7).setFormula("= SQRT(" + sheetName + ".G7)"); in _refreshArrows()
[all …]
H A D_XDataPilotTable2.java222 XSpreadsheet xSheet = null; in _insertDrillDownSheet() local
225 xSheet = (XSpreadsheet)UnoRuntime.queryInterface( in _insertDrillDownSheet()
235 if (!checkDrillDownSheetContent(xSheet, data)) in _insertDrillDownSheet()
246 XNamed xNamed = (XNamed)UnoRuntime.queryInterface(XNamed.class, xSheet); in _insertDrillDownSheet()
472 private boolean checkDrillDownSheetContent(XSpreadsheet xSheet, Object[][] data) in checkDrillDownSheetContent() argument
474 CellAddress lastCell = getLastUsedCellAddress(xSheet, 0, 0); in checkDrillDownSheetContent()
490 xCR = xSheet.getCellRangeByPosition(0, 0, lastCell.Column, lastCell.Row); in checkDrillDownSheetContent()
547 private CellAddress getLastUsedCellAddress(XSpreadsheet xSheet, int nCol, int nRow) in getLastUsedCellAddress() argument
551 XCellRange xRng = xSheet.getCellRangeByPosition(nCol, nRow, nCol, nRow); in getLastUsedCellAddress()
555 XSheetCellCursor xCursor = xSheet.createCursorByRange(xSCR); in getLastUsedCellAddress()
H A D_XSheetAuditing.java77 XSpreadsheet xSheet = (XSpreadsheet)tEnv.getObjRelation("XSheetAuditing.Spreadsheet"); in before() local
78 if (xSheet == null) // query on their object in before()
79 xSheet = (XSpreadsheet)UnoRuntime.queryInterface(XSpreadsheet.class, oObj); in before()
80 if (xSheet == null) in before()
83 xAddress = xSheet.getCellByPosition(address.Column, address.Row); in before()
84 … xDependentAddress = xSheet.getCellByPosition(dependentAddress.Column, dependentAddress.Row); in before()
85 … xPrecedentAddress = xSheet.getCellByPosition(precedentAddress.Column, precedentAddress.Row); in before()
H A D_XGoalSeek.java41 XSpreadsheet xSheet = null; field in _XGoalSeek
54 xSheet = (XSpreadsheet) UnoRuntime.queryInterface( in before()
72 xSheet.getCellByPosition(3, 4).setValue(9); in before()
73 xSheet.getCellByPosition(3, 5).setFormula("= SQRT(D5)"); in before()
97 xSheet.getCellByPosition(3, 4).setValue(0.8); in _seekGoal()
98 xSheet.getCellByPosition(3, 5).setFormula("= (D5 ^ 2 - 1) / (D5 - 1)"); in _seekGoal()
H A D_Shape.java40 XSpreadsheet xSheet = null; in _Anchor() local
44 xSheet = (XSpreadsheet) UnoRuntime.queryInterface( in _Anchor()
47 xCell = xSheet.getCellByPosition(0, 0); in _Anchor()
56 testProperty("Anchor", xSheet, xCell); in _Anchor()
/trunk/main/connectivity/source/drivers/calc/
H A DCTable.cxx107 Reference<XSheetCellCursor> xCursor = xSheet->createCursor(); in lcl_GetDataArea()
136 Reference<XCellRange> xUsedRange = xSheet->getCellRangeByPosition( in lcl_GetDataArea()
144 Reference<XCellRange> xUsedRange = xSheet->getCellRangeByPosition( in lcl_GetDataArea()
177 Reference<XCell> xCell = xSheet->getCellByPosition( nDocColumn, nDocRow ); in lcl_GetUsedCell()
182 Reference<XCellRangeAddressable> xAddr( xSheet, UNO_QUERY ); in lcl_GetUsedCell()
217 Reference<XCellRangeAddressable> xAddr( xSheet, UNO_QUERY ); in lcl_HasTextInColumn()
251 Reference<XText> xHeaderText( xSheet->getCellByPosition( nDocColumn, nStartRow ), UNO_QUERY ); in lcl_GetColumnInfo()
261 Reference<XCell> xDataCell = lcl_GetUsedCell( xSheet, nDocColumn, nDataRow ); in lcl_GetColumnInfo()
270 … if ( eCellType == CellContentType_TEXT || lcl_HasTextInColumn( xSheet, nDocColumn, nDataRow ) ) in lcl_GetColumnInfo()
328 void lcl_SetValue( ORowSetValue& rValue, const Reference<XSpreadsheet>& xSheet, in lcl_SetValue() argument
[all …]
/trunk/test/testuno/source/fvt/uno/sc/rowcolumn/
H A DCreateShowHideEditDeleteComments.java103 XSpreadsheet xSheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj); in testCreateEditDeleteComments() local
106 xSheet = SCUtil.getCurrentSheet(scDocument); in testCreateEditDeleteComments()
112 XCell xCell = xSheet.getCellByPosition(0, nRow); in testCreateEditDeleteComments()
123 XSheetAnnotationsSupplier.class, xSheet); in testCreateEditDeleteComments()
132 XSheetAnnotationsSupplier.class, xSheet); in testCreateEditDeleteComments()
165 XSpreadsheet xSheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj); in testShowHideComments() local
168 xSheet = SCUtil.getCurrentSheet(scDocument); in testShowHideComments()
176 XCell xCell = xSheet.getCellByPosition(nColumn, nRow); in testShowHideComments()
184 XSheetAnnotationsSupplier.class, xSheet); in testShowHideComments()
/trunk/main/qadevOOo/java/OOoRunner/src/main/java/util/
H A DCalcTools.java62 XSpreadsheet xSheet = getSpreadSheetFromSheetDoc(xSheetDoc, sheetNumber); in fillCalcSheetWithContent() local
64 fillCalcSheetWithContent(xSheet, startCellX, startCellY, rangeLengthX, rangeLengthY); in fillCalcSheetWithContent()
82 public static void fillCalcSheetWithContent(XSpreadsheet xSheet, in fillCalcSheetWithContent() argument
96 xRange = xSheet.getCellRangeByPosition(startCellX, startCellY, in fillCalcSheetWithContent()
124 XSpreadsheet xSheet = null; in getSpreadSheetFromSheetDoc() local
136 xSheet = (XSpreadsheet) AnyConverter.toObject( in getSpreadSheetFromSheetDoc()
153 return xSheet; in getSpreadSheetFromSheetDoc()
/trunk/main/oox/source/xls/
H A Dworkbookhelper.cxx677 Reference< XSpreadsheet > xSheet; in getSheetFromDoc() local
681 xSheet.set( xSheetsIA->getByIndex( nSheet ), UNO_QUERY_THROW ); in getSheetFromDoc()
686 return xSheet; in getSheetFromDoc()
691 Reference< XSpreadsheet > xSheet; in getSheetFromDoc() local
695 xSheet.set( xSheetsNA->getByName( rSheet ), UNO_QUERY ); in getSheetFromDoc()
700 return xSheet; in getSheetFromDoc()
708 Reference< XSpreadsheet > xSheet( getSheetFromDoc( rAddress.Sheet ), UNO_SET_THROW ); in getCellFromDoc() local
709 xCell = xSheet->getCellByPosition( rAddress.Column, rAddress.Row ); in getCellFromDoc()
722 Reference< XSpreadsheet > xSheet( getSheetFromDoc( rRange.Sheet ), UNO_SET_THROW ); in getCellRangeFromDoc() local
723 …xRange = xSheet->getCellRangeByPosition( rRange.StartColumn, rRange.StartRow, rRange.EndColumn, rR… in getCellRangeFromDoc()
/trunk/test/testuno/source/fvt/uno/sc/object/
H A DDrawingObject.java136 XSpreadsheet xSheet = SCUtil.getCurrentSheet(scDocument); in testDrawingObject() local
138 (XDrawPageSupplier)UnoRuntime.queryInterface(XDrawPageSupplier.class, xSheet); in testDrawingObject()
157 xSheet = SCUtil.getCurrentSheet(scDocument); in testDrawingObject()
159 (XDrawPageSupplier)UnoRuntime.queryInterface(XDrawPageSupplier.class, xSheet); in testDrawingObject()
186 xSheet = SCUtil.getCurrentSheet(scDocument); in testDrawingObject()
188 (XDrawPageSupplier)UnoRuntime.queryInterface(XDrawPageSupplier.class, xSheet); in testDrawingObject()
/trunk/main/sc/workben/
H A Dtest.cxx670 XTableSheetRef xSheet = xSheets->getSheetByIndex(0); in lcl_Sheet() local
671 if (!xSheet) return; in lcl_Sheet()
922 XTableSheetRef xSheet = xSheets->getSheetByIndex(0); in lcl_Audi() local
923 if (!xSheet) return; in lcl_Audi()
1091 XTableSheetRef xSheet = xSheets->getSheetByIndex(0); in lcl_Outline() local
1092 if (!xSheet) return; in lcl_Outline()
1197 XTableSheetRef xSheet = xSheets->getSheetByIndex(0); in lcl_Notes() local
1198 if (!xSheet) return; in lcl_Notes()
1233 if (!xSheet) return; in lcl_Scenario()
1235 XScenariosRef xColl = xSheet->getScenarios(); in lcl_Scenario()
[all …]

Completed in 146 milliseconds

123