Home
last modified time | relevance | path

Searched refs:setFormula (Results 1 – 25 of 123) sorted by relevance

12345

/trunk/main/qadevOOo/java/OOoRunner/src/main/java/mod/_sc/
H A DScDataPilotFieldGroupsObj.java163 oSheet.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
164 oSheet.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
165 oSheet2.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
166 oSheet2.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
178 oSheet.getCellByPosition (1, 1).setFormula ("aName"); in createTestEnvironment()
179 oSheet.getCellByPosition (1, 2).setFormula ("otherName"); in createTestEnvironment()
180 oSheet.getCellByPosition (1, 3).setFormula ("una"); in createTestEnvironment()
181 oSheet.getCellByPosition (1, 4).setFormula ("otherName"); in createTestEnvironment()
182 oSheet.getCellByPosition (1, 5).setFormula ("somethingelse"); in createTestEnvironment()
H A DScDataPilotFieldGroupItemObj.java164 oSheet.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
165 oSheet.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
166 oSheet2.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
167 oSheet2.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
179 oSheet.getCellByPosition (1, 1).setFormula ("aName"); in createTestEnvironment()
180 oSheet.getCellByPosition (1, 2).setFormula ("otherName"); in createTestEnvironment()
181 oSheet.getCellByPosition (1, 3).setFormula ("una"); in createTestEnvironment()
182 oSheet.getCellByPosition (1, 4).setFormula ("otherName"); in createTestEnvironment()
183 oSheet.getCellByPosition (1, 5).setFormula ("somethingelse"); in createTestEnvironment()
H A DScDataPilotFieldGroupObj.java163 oSheet.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
164 oSheet.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
165 oSheet2.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
166 oSheet2.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
178 oSheet.getCellByPosition (1, 1).setFormula ("aName"); in createTestEnvironment()
179 oSheet.getCellByPosition (1, 2).setFormula ("otherName"); in createTestEnvironment()
180 oSheet.getCellByPosition (1, 3).setFormula ("una"); in createTestEnvironment()
181 oSheet.getCellByPosition (1, 4).setFormula ("otherName"); in createTestEnvironment()
182 oSheet.getCellByPosition (1, 5).setFormula ("somethingelse"); in createTestEnvironment()
H A DScTableSheetObj.java224 oSheet.getCellByPosition(8, 8).setFormula("= B5 + C1"); in createTestEnvironment()
228 oSheet.getCellByPosition(8, 6).setFormula("= SUM(G7:H7)"); in createTestEnvironment()
229 oSheet.getCellByPosition(9, 6).setFormula("= G7*I7"); in createTestEnvironment()
343 oTable.getCellByPosition(0, 1).setFormula("b"); in createTestEnvironment()
H A DScDataPilotFieldObj.java176 oSheet.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
177 oSheet.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
178 oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
179 oSheet2.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
H A DScDataPilotItemObj.java177 oSheet.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
178 oSheet.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
179 oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
180 oSheet2.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
H A DScDataPilotItemsObj.java177 oSheet.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
178 oSheet.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
179 oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
180 oSheet2.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
H A DScIndexEnumeration_DataPilotItemsEnumeration.java179 oSheet.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
180 oSheet.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
181 oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
182 oSheet2.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
H A DScAccessibleSpreadsheet.java139 xCell.setFormula(text); in createTestEnvironment()
156 fCell.setFormula("firing event"); in createTestEnvironment()
157 fCell.setFormula(text); in createTestEnvironment()
/trunk/main/qadevOOo/java/OOoRunner/src/main/java/ifc/sheet/
H A D_XCellSeries.java88 oSheet.getCellByPosition(0, 4).setFormula("=sum(A1:D1)"); in _fillAuto()
104 oSheet.getCellByPosition(4, 0).setFormula("=sum(A1:A4)"); in _fillAuto()
144 oSheet.getCellByPosition(0, 4).setFormula("=sum(A1:D1)"); in _fillSeries()
168 oSheet.getCellByPosition(0, 4).setFormula("=sum(A1:D1)"); in _fillSeries()
190 oSheet.getCellByPosition(4, 0).setFormula("=sum(A1:A4)"); in _fillSeries()
213 oSheet.getCellByPosition(4, 0).setFormula("=sum(A1:A4)"); in _fillSeries()
H A D_XCellRangesQuery.java112 oSheet.getCellByPosition(2, 1).setFormula("=B2+B3"); in before()
113 oSheet.getCellByPosition(1, 3).setFormula("=B2+B4"); in before()
114 oSheet.getCellByPosition(3, 2).setFormula(""); in before()
115 oSheet.getCellByPosition(3, 3).setFormula(""); in before()
H A D_XSubTotalCalculatable.java63 oSheet.getCellByPosition(0, 0).setFormula("first"); in _applySubTotals()
64 oSheet.getCellByPosition(1, 0).setFormula("second"); in _applySubTotals()
65 oSheet.getCellByPosition(0, 3).setFormula(""); in _applySubTotals()
H A D_XSheetFilterable.java85 oSheet.getCellByPosition(1, 0).setFormula("A"); in _filter()
86 oSheet.getCellByPosition(1, 1).setFormula("D"); in _filter()
87 oSheet.getCellByPosition(1, 2).setFormula("B"); in _filter()
H A D_XFormulaQuery.java115 mxCell.setFormula("=sum(A1:D1)"); in _queryDependents()
154 mxCell.setFormula("=sum(A1:D1)"); in _queryPrecedents()
159 oSheet.getCellByPosition(1, 2).setFormula("=A16*2"); in _queryPrecedents()
/trunk/main/odk/examples/CLI/CSharp/Spreadsheet/
H A DGeneralTableSample.cs81 xCell.setFormula( "=1/0" ); in doSampleFunction()
142 xCursor.getCellByPosition( 0, 0 ).setFormula( in doSampleFunction()
165 xSheet.getCellByPosition( 2, 2 ).setFormula( aText ); in doSampleFunction()
181 xSheet.getCellByPosition( 2, 6 ).setFormula( "What a big cell." ); in doSampleFunction()
221 xSheet.getCellByPosition( 2, 8 ).setFormula( aText ); in doSampleFunction()
224 xSheet.getCellByPosition( 2, 9 ).setFormula( aText ); in doSampleFunction()
H A DSpreadsheetSample.cs192 setFormula( xSheet, "B5", "First cell" ); in doCellRangeSamples()
193 setFormula( xSheet, "B6", "Second cell" ); in doCellRangeSamples()
375 setFormula( xSheet, "I13", "Text 10" ); in doCellRangeSamples()
376 setFormula( xSheet, "E14", "Jan" ); in doCellRangeSamples()
441 setFormula( xSheet, "E26", "=E27^F26" ); 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()
817 setFormula( xSheet, "A3", "=SUM(A2:B2)" ); in doDocumentSamples()
818 setFormula( xSheet, "B3", "=FORMULA(A3)" ); in doDocumentSamples()
[all …]
H A DSpreadsheetDocHelper.cs130 public void setFormula( in setFormula() method in SpreadsheetDocHelper
136 0, 0 ).setFormula( aFormula ); in setFormula()
154 xCell.setFormula( aDateStr ); in setDate()
221 xCell.setFormula( aHeadline ); in prepareRange()
/trunk/main/odk/examples/DevelopersGuide/Spreadsheet/
H A DGeneralTableSample.java81 xCell.setFormula( "=1/0" ); in doSampleFunction()
140 xCursor.getCellByPosition( 0, 0 ).setFormula( "Beyond of the last filled cell." ); in doSampleFunction()
161 xSheet.getCellByPosition( 2, 2 ).setFormula( aText ); in doSampleFunction()
178 xSheet.getCellByPosition( 2, 6 ).setFormula( "What a big cell." ); in doSampleFunction()
216 xSheet.getCellByPosition( 2, 8 ).setFormula( aText ); in doSampleFunction()
219 xSheet.getCellByPosition( 2, 9 ).setFormula( aText ); in doSampleFunction()
H A DSpreadsheetSample.java305 setFormula( xSheet, "B5", "First cell" ); in doCellRangeSamples()
306 setFormula( xSheet, "B6", "Second cell" ); in doCellRangeSamples()
434 setFormula( xSheet, "I13", "Text 10" ); in doCellRangeSamples()
435 setFormula( xSheet, "E14", "Jan" ); in doCellRangeSamples()
483 setFormula( xSheet, "E26", "=E27^F26" ); 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()
830 setFormula( xSheet, "A3", "=SUM(A2:B2)" ); in doDocumentSamples()
831 setFormula( xSheet, "B3", "=FORMULA(A3)" ); in doDocumentSamples()
[all …]
/trunk/main/testtools/source/cliversioning/
H A Dversion.cs71 setFormula( xSheet, "B5", "First cell" ); in doCellRangeSamples()
72 setFormula( xSheet, "B6", "Second cell" ); in doCellRangeSamples()
219 setFormula( xSheet, "I13", "Text 10" ); in doCellRangeSamples()
220 setFormula( xSheet, "E14", "Jan" ); in doCellRangeSamples()
344 public void setFormula( in setFormula() method in cliversion.SpreadsheetDocHelper
350 0, 0 ).setFormula( aFormula ); in setFormula()
368 xCell.setFormula( aDateStr ); in setDate()
435 xCell.setFormula( aHeadline ); in prepareRange()
/trunk/main/qadevOOo/java/OOoRunner/src/main/java/ifc/table/
H A D_XCell.java70 oObj.setFormula("=sqrt(-2)") ; // incorrect formula in _getError()
89 oObj.setFormula("=2+2"); in _getFormula()
139 oObj.setFormula("=2/6") ; in _setFormula()
/trunk/main/odk/examples/OLE/vbscript/
H A DWriterDemo.vbs89 objTable.getCellByName("D2").setFormula"sum <A2:C2>"
94 objTable.getCellByName("D3").setFormula "sum <A3:C3>"
99 objTable.getCellByName("D4").setFormula "sum <A4:C4>"
/trunk/main/pyuno/demo/
H A Dswriter.py89 table.getCellByName("D2").setFormula("sum <A2:C2>")
94 table.getCellByName("D3").setFormula("sum <A3:C3>")
99 table.getCellByName("D4").setFormula("sum <A4:C4>")
H A Dswritercomp.py91 table.getCellByName("D2").setFormula("sum <A2:C2>")
96 table.getCellByName("D3").setFormula("sum <A3:C3>")
101 table.getCellByName("D4").setFormula("sum <A4:C4>")
/trunk/main/scripting/examples/python/pythonSamples/
H A DTableSample.py80 table.getCellByName("D2").setFormula("sum <A2:C2>")
85 table.getCellByName("D3").setFormula("sum <A3:C3>")
90 table.getCellByName("D4").setFormula("sum <A4:C4>")

Completed in 163 milliseconds

12345