Home
last modified time | relevance | path

Searched refs:sheet (Results 26 – 50 of 1158) sorted by relevance

12345678910>>...47

/aoo42x/main/offapi/com/sun/star/sheet/
H A DSpreadsheetView.idl35 #include <com/sun/star/sheet/SpreadsheetViewPane.idl>
39 #include <com/sun/star/sheet/XSpreadsheetView.idl>
51 #include <com/sun/star/sheet/XViewSplitable.idl>
55 #include <com/sun/star/sheet/XViewFreezable.idl>
59 #include <com/sun/star/sheet/XRangeSelection.idl>
94 service com::sun::star::sheet::SpreadsheetViewPane;
96 /** provides access to the active sheet in the view.
98 interface com::sun::star::sheet::XSpreadsheetView;
124 interface com::sun::star::sheet::XViewSplitable;
128 interface com::sun::star::sheet::XViewFreezable;
[all …]
H A DSpreadsheetDocument.idl61 #include <com/sun/star/sheet/XCalculatable.idl>
65 #include <com/sun/star/sheet/XDocumentAuditing.idl>
69 #include <com/sun/star/sheet/XConsolidatable.idl>
73 #include <com/sun/star/sheet/XGoalSeek.idl>
90 #include <com/sun/star/sheet/XNamedRanges.idl>
94 #include <com/sun/star/sheet/XDatabaseRanges.idl>
98 #include <com/sun/star/sheet/XLabelRanges.idl>
106 #include <com/sun/star/sheet/XAreaLinks.idl>
110 #include <com/sun/star/sheet/XExternalDocLinks.idl>
183 interface com::sun::star::sheet::XCalculatable;
[all …]
H A DXExternalDocLink.idl30 #include <com/sun/star/sheet/XExternalSheetCache.idl>
32 module com { module sun { module star { module sheet {
38 @see com::sun::star::sheet::ExternalDocLink
51 link for a specified sheet name. If a sheet cache instance already
54 <p>Note that a sheet name lookup is performed in a case-insensitive
57 @param aSheetName sheet name
66 @return com::sun::star::sheet::XExternalSheetCache sheet cache instance
76 <type scope="com::sun::star::sheet">ExternalDocLink</type>. This
83 @see com::sun::star::sheet::ExternalDocLinks
84 @see com::sun::star::sheet::FormulaToken
[all …]
H A DXDataPilotTable2.idl40 #include <com/sun/star/sheet/XDataPilotTable.idl>
44 #include <com/sun/star/sheet/DataPilotOutputRangeType.idl>
48 #include <com/sun/star/sheet/DataPilotFieldFilter.idl>
51 #include <com/sun/star/sheet/DataPilotTablePositionData.idl>
54 module com { module sun { module star { module sheet {
62 @see com::sun::star::sheet::XDataPilotTable
90 @see com::sun::star::sheet::DataPilotTablePositionData
91 @see com::sun::star::sheet::DataPilotTableHeaderData
92 @see com::sun::star::sheet::DataPilotTableResultData
103 is empty, no new sheet is inserted.</p>
[all …]
/aoo42x/main/qadevOOo/objdsc/sc/
H A Dcom.sun.star.comp.office.ScSpreadsheetSettings.csv8 "ScSpreadsheetSettings";"com::sun::star::sheet::GlobalSheetSettings";"MoveSelection"
9 "ScSpreadsheetSettings";"com::sun::star::sheet::GlobalSheetSettings";"MoveDirection"
10 "ScSpreadsheetSettings";"com::sun::star::sheet::GlobalSheetSettings";"EnterEdit"
11 "ScSpreadsheetSettings";"com::sun::star::sheet::GlobalSheetSettings";"ExtendFormat"
12 "ScSpreadsheetSettings";"com::sun::star::sheet::GlobalSheetSettings";"RangeFinder"
14 "ScSpreadsheetSettings";"com::sun::star::sheet::GlobalSheetSettings";"MarkHeader"
15 "ScSpreadsheetSettings";"com::sun::star::sheet::GlobalSheetSettings";"UseTabCol"
16 "ScSpreadsheetSettings";"com::sun::star::sheet::GlobalSheetSettings";"Metric"
17 "ScSpreadsheetSettings";"com::sun::star::sheet::GlobalSheetSettings";"Scale"
18 "ScSpreadsheetSettings";"com::sun::star::sheet::GlobalSheetSettings";"DoAutoComplete"
[all …]
H A Dcom.sun.star.comp.office.ScTableValidationObj.csv1 "ScTableValidationObj";"com::sun::star::sheet::XSheetCondition";"getOperator()"
2 "ScTableValidationObj";"com::sun::star::sheet::XSheetCondition";"setOperator()"
3 "ScTableValidationObj";"com::sun::star::sheet::XSheetCondition";"getFormula1()"
4 "ScTableValidationObj";"com::sun::star::sheet::XSheetCondition";"setFormula1()"
5 "ScTableValidationObj";"com::sun::star::sheet::XSheetCondition";"getFormula2()"
6 "ScTableValidationObj";"com::sun::star::sheet::XSheetCondition";"setFormula2()"
9 "ScTableValidationObj";"com::sun::star::sheet::TableValidation";"Type"
11 "ScTableValidationObj";"com::sun::star::sheet::TableValidation";"InputTitle"
12 "ScTableValidationObj";"com::sun::star::sheet::TableValidation";"InputMessage"
14 "ScTableValidationObj";"com::sun::star::sheet::TableValidation";"ErrorTitle"
[all …]
H A Dcom.sun.star.comp.office.ScDataPilotTableObj.csv3 "ScDataPilotTableObj";"com::sun::star::sheet::XDataPilotDescriptor";"getTag()"
4 "ScDataPilotTableObj";"com::sun::star::sheet::XDataPilotDescriptor";"setTag()"
5 "ScDataPilotTableObj";"com::sun::star::sheet::XDataPilotDescriptor";"getSourceRange()"
6 "ScDataPilotTableObj";"com::sun::star::sheet::XDataPilotDescriptor";"setSourceRange()"
10 "ScDataPilotTableObj";"com::sun::star::sheet::XDataPilotDescriptor";"getRowFields()"
11 "ScDataPilotTableObj";"com::sun::star::sheet::XDataPilotDescriptor";"getPageFields()"
12 "ScDataPilotTableObj";"com::sun::star::sheet::XDataPilotDescriptor";"getDataFields()"
14 "ScDataPilotTableObj";"com::sun::star::sheet::XDataPilotTable";"getOutputRange()"
15 "ScDataPilotTableObj";"com::sun::star::sheet::XDataPilotTable";"refresh()"
16 "ScDataPilotTableObj";"com::sun::star::sheet::XDataPilotTable2";"getDrillDownData()"
[all …]
H A Dcom.sun.star.comp.office.ScCellRangeObj.csv33 "ScCellRangeObj";"com::sun::star::sheet::XSheetFilterable";"filter()"
107 "ScCellRangeObj";"com::sun::star::sheet::XSheetOperation";"clearContents()"
117 "ScCellRangeObj";"com::sun::star::sheet::XFormulaQuery";"queryDependents()"
118 "ScCellRangeObj";"com::sun::star::sheet::XFormulaQuery";"queryPrecedents()"
143 "ScCellRangeObj";"com::sun::star::sheet::SheetCellRange";"Position"
144 "ScCellRangeObj";"com::sun::star::sheet::SheetCellRange";"Size"
147 "ScCellRangeObj";"com::sun::star::sheet::SheetCellRange";"Validation"
210 "ScCellRangeObj";"com::sun::star::sheet::XCellRangeData";"getDataArray()"
211 "ScCellRangeObj";"com::sun::star::sheet::XCellRangeData";"setDataArray()"
218 "ScCellRangeObj";"com::sun::star::sheet::XCellSeries";"fillSeries()"
[all …]
H A Dcom.sun.star.comp.office.ScSpreadsheetSettingsObj.csv8 "ScSpreadsheetSettingsObj";"com::sun::star::sheet::SpreadsheetDocumentSettings";"IsIterationEnabled"
9 "ScSpreadsheetSettingsObj";"com::sun::star::sheet::SpreadsheetDocumentSettings";"IterationCount"
10 "ScSpreadsheetSettingsObj";"com::sun::star::sheet::SpreadsheetDocumentSettings";"IterationEpsilon"
11 "ScSpreadsheetSettingsObj";"com::sun::star::sheet::SpreadsheetDocumentSettings";"StandardDecimals"
12 "ScSpreadsheetSettingsObj";"com::sun::star::sheet::SpreadsheetDocumentSettings";"NullDate"
13 "ScSpreadsheetSettingsObj";"com::sun::star::sheet::SpreadsheetDocumentSettings";"DefaultTabStop"
14 "ScSpreadsheetSettingsObj";"com::sun::star::sheet::SpreadsheetDocumentSettings";"IgnoreCase"
15 "ScSpreadsheetSettingsObj";"com::sun::star::sheet::SpreadsheetDocumentSettings";"CalcAsShown"
16 "ScSpreadsheetSettingsObj";"com::sun::star::sheet::SpreadsheetDocumentSettings";"MatchWholeCell"
17 "ScSpreadsheetSettingsObj";"com::sun::star::sheet::SpreadsheetDocumentSettings";"SpellOnline"
[all …]
H A Dcom.sun.star.comp.office.ScDatabaseRangeObj.csv4 "ScDatabaseRangeObj";"com::sun::star::sheet::XCellRangeReferrer";"getReferredCells()"
5 "ScDatabaseRangeObj";"com::sun::star::sheet::XDatabaseRange";"getDataArea()"
6 "ScDatabaseRangeObj";"com::sun::star::sheet::XDatabaseRange";"setDataArea()"
7 "ScDatabaseRangeObj";"com::sun::star::sheet::XDatabaseRange";"getSortDescriptor()"
8 "ScDatabaseRangeObj";"com::sun::star::sheet::XDatabaseRange";"getFilterDescriptor()"
10 "ScDatabaseRangeObj";"com::sun::star::sheet::XDatabaseRange";"getImportDescriptor()"
11 "ScDatabaseRangeObj";"com::sun::star::sheet::XDatabaseRange";"refresh()"
21 "ScDatabaseRangeObj";"com::sun::star::sheet::DatabaseRange";"MoveCells"
22 "ScDatabaseRangeObj";"com::sun::star::sheet::DatabaseRange";"KeepFormats"
23 "ScDatabaseRangeObj";"com::sun::star::sheet::DatabaseRange";"StripData"
[all …]
/aoo42x/main/sc/inc/
H A Ddpsave.hxx36 namespace com { namespace sun { namespace star { namespace sheet { namespace
88 bool operator == (const ::com::sun::star::sheet::DataPilotFieldSortInfo &l, const ::com::sun::star:…
89 bool operator == (const ::com::sun::star::sheet::DataPilotFieldAutoShowInfo &l, const ::com::sun::s…
90 bool operator == (const ::com::sun::star::sheet::DataPilotFieldReference &l, const ::com::sun::star…
107 ::com::sun::star::sheet::DataPilotFieldReference* pReferenceValue;
108 ::com::sun::star::sheet::DataPilotFieldSortInfo* pSortInfo; // (level)
109 ::com::sun::star::sheet::DataPilotFieldAutoShowInfo* pAutoShowInfo; // (level)
110 ::com::sun::star::sheet::DataPilotFieldLayoutInfo* pLayoutInfo; // (level)
180 com::sun::star::sheet::XDimensionsSupplier>& xSource ,
259 com::sun::star::sheet::XDimensionsSupplier>& xSource );
[all …]
H A Dcellsuno.hxx158 public com::sun::star::sheet::XSheetOperation,
161 public com::sun::star::sheet::XCellRangesQuery,
162 public com::sun::star::sheet::XFormulaQuery,
599 public com::sun::star::sheet::XCellSeries,
710 ::com::sun::star::sheet::FillMode nFillMode,
989 public com::sun::star::sheet::XSpreadsheet,
998 public com::sun::star::sheet::XPrintAreas,
999 public com::sun::star::sheet::XSheetLinkable,
1000 public com::sun::star::sheet::XSheetAuditing,
1001 public com::sun::star::sheet::XSheetOutline,
[all …]
/aoo42x/main/odk/examples/DevelopersGuide/Spreadsheet/
H A DExampleDataPilotSource.java225 com.sun.star.sheet.XMembersSupplier,
226 com.sun.star.sheet.XDataPilotMemberResults,
262 public com.sun.star.sheet.MemberResult[] getResults() in getResults()
276 return new com.sun.star.sheet.MemberResult[0]; in getResults()
290 com.sun.star.sheet.MemberResult[] aResults = in getResults()
291 new com.sun.star.sheet.MemberResult[nSize]; in getResults()
346 return new com.sun.star.sheet.GeneralFunction[0]; in getPropertyValue()
426 com.sun.star.sheet.XLevelsSupplier
516 com.sun.star.sheet.XHierarchiesSupplier,
659 return com.sun.star.sheet.GeneralFunction.SUM; in getPropertyValue()
[all …]
H A DViewSample.java63 com.sun.star.sheet.XSpreadsheetDocument xDoc = getDocument(); in doSampleFunction()
70 com.sun.star.sheet.XViewFreezable xFreeze = (com.sun.star.sheet.XViewFreezable) in doSampleFunction()
71 UnoRuntime.queryInterface( com.sun.star.sheet.XViewFreezable.class, xController ); in doSampleFunction()
81 com.sun.star.sheet.XCellRangeReferrer xRefer = (com.sun.star.sheet.XCellRangeReferrer) in doSampleFunction()
82 UnoRuntime.queryInterface( com.sun.star.sheet.XCellRangeReferrer.class, aPane ); in doSampleFunction()
98 com.sun.star.sheet.XRangeSelection xRngSel = (com.sun.star.sheet.XRangeSelection) in doSampleFunction()
119 com.sun.star.sheet.XSpreadsheetView xView = (com.sun.star.sheet.XSpreadsheetView) in doSampleFunction()
121 com.sun.star.sheet.XSpreadsheet xSheet = xView.getActiveSheet(); in doSampleFunction()
131 private class ExampleRangeListener implements com.sun.star.sheet.XRangeSelectionListener
135 public void done( com.sun.star.sheet.RangeSelectionEvent aEvent ) in done()
[all …]
/aoo42x/main/offapi/
H A DUnoApi_offapi.mk143 offapi/com/sun/star/sheet/Solver \
787 offapi/com/sun/star/sheet/AddIn \
797 offapi/com/sun/star/sheet/Cells \
800 offapi/com/sun/star/sheet/DDELink \
801 offapi/com/sun/star/sheet/DDELinks \
847 offapi/com/sun/star/sheet/Scenario \
848 offapi/com/sun/star/sheet/Scenarios \
850 offapi/com/sun/star/sheet/Shape \
2845 offapi/com/sun/star/sheet/Border \
2922 offapi/com/sun/star/sheet/XAddIn \
[all …]
/aoo42x/main/qadevOOo/runner/util/
H A DValueChanger.java629 com.sun.star.sheet.GeneralFunction GF1 = com.sun.star.sheet.GeneralFunction.NONE; in changePValue()
633 com.sun.star.sheet.GeneralFunction GF5 = com.sun.star.sheet.GeneralFunction.MAX; in changePValue()
634 com.sun.star.sheet.GeneralFunction GF6 = com.sun.star.sheet.GeneralFunction.MIN; in changePValue()
635 com.sun.star.sheet.GeneralFunction GF7 = com.sun.star.sheet.GeneralFunction.AUTO; in changePValue()
672 com.sun.star.sheet.DataImportMode DIM1 = com.sun.star.sheet.DataImportMode.NONE; in changePValue()
674 com.sun.star.sheet.DataImportMode DIM3 = com.sun.star.sheet.DataImportMode.SQL; in changePValue()
727 com.sun.star.sheet.ValidationType VT1 = com.sun.star.sheet.ValidationType.ANY; in changePValue()
729 com.sun.star.sheet.ValidationType VT3 = com.sun.star.sheet.ValidationType.DATE; in changePValue()
731 com.sun.star.sheet.ValidationType VT5 = com.sun.star.sheet.ValidationType.LIST; in changePValue()
733 com.sun.star.sheet.ValidationType VT7 = com.sun.star.sheet.ValidationType.TIME; in changePValue()
[all …]
/aoo42x/main/odk/pack/copying/
H A Didl_chapter_refs.txt85 com.sun.star.sheet.XNamedRange
86 com.sun.star.sheet.Border
88 com.sun.star.sheet.NamedRange
682 com.sun.star.sheet.XAddIn
1232 com.sun.star.sheet
2071 com.sun.star.sheet
3417 com.sun.star.sheet.AddIn
6365 com.sun.star.sheet.AddIn
6367 com.sun.star.sheet.AddIn
6770 com.sun.star.sheet.Cells
[all …]
/aoo42x/test/testuno/source/fvt/uno/sc/chart/
H A DChartTitle.java47 import com.sun.star.sheet.XSpreadsheet;
48 import com.sun.star.sheet.XSpreadsheetDocument;
148 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCreateMainTitle() local
150 SCUtil.setValueToCellRange(sheet, 0, 0, numberData); in testCreateMainTitle()
168 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateMainTitle()
170 xChartDocument = SCUtil.getChartByName(sheet, chartName); in testCreateMainTitle()
205 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCreateSubTitle() local
207 SCUtil.setValueToCellRange(sheet, 0, 0, numberData); in testCreateSubTitle()
224 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateSubTitle()
268 SCUtil.setValueToCellRange(sheet, 0, 0, numberData); in testInputTitles()
[all …]
/aoo42x/main/sc/source/ui/vba/
H A Dvbaworksheet.cxx123 uno::Reference<sheet::XSpreadsheets> xSheets = xSpreadDoc->getSheets(); in removeAllSheets()
131 uno::Reference< sheet::XSpreadsheet > xSheet(xIndex->getByIndex(i), uno::UNO_QUERY); in removeAllSheets()
139 uno::Reference< sheet::XSpreadsheet > xSheet(xIndex->getByIndex(0), uno::UNO_QUERY); in removeAllSheets()
186 const uno::Reference< sheet::XSpreadsheet >& xSheet, in ScVbaWorksheet()
387 uno::Reference<sheet::XSheetOutline> xOutline(getSheet(),uno::UNO_QUERY_THROW); in Outline()
457 uno::Reference< sheet::XSpreadsheetView > xSpreadsheet( in Activate()
500 uno::Reference<sheet::XSpreadsheets> xSheets = xSpreadDoc->getSheets(); in Move()
535 uno::Reference<sheet::XSpreadsheets> xSheets = xSpreadDoc->getSheets(); in Copy()
564 uno::Reference<sheet::XSpreadsheets> xSheets = xSpreadDoc->getSheets(); in Delete()
699 uno::Reference< css::sheet::XSpreadsheet > xSheet = getSheet(); in PivotTables()
[all …]
H A Dvbarange.cxx1839 sheet::FillMode_SIMPLE, sheet::FillDateMode_FILL_DATE_DAY, 0, 0x7FFFFFFF); in FillLeft()
1846 sheet::FillMode_SIMPLE, sheet::FillDateMode_FILL_DATE_DAY, 0, 0x7FFFFFFF); in FillRight()
1853 sheet::FillMode_SIMPLE, sheet::FillDateMode_FILL_DATE_DAY, 0, 0x7FFFFFFF); in FillUp()
1860 sheet::FillMode_SIMPLE, sheet::FillDateMode_FILL_DATE_DAY, 0, 0x7FFFFFFF); in FillDown()
3643 sheet::CellDeleteMode mode = sheet::CellDeleteMode_NONE ; in Delete()
3653 mode = sheet::CellDeleteMode_UP; in Delete()
3668 mode = sheet::CellDeleteMode_UP; in Delete()
3670 mode = sheet::CellDeleteMode_LEFT; in Delete()
4483 sheet::FilterConnection nConn = sheet::FilterConnection_AND; in AutoFilter()
4642 sheet::CellInsertMode mode = sheet::CellInsertMode_NONE; in Insert()
[all …]
/aoo42x/main/scripting/examples/java/MemoryUsage/
H A DMemoryUsage.java39 import com.sun.star.sheet.*;
49 XSpreadsheet sheet = createSpreadsheet(ctxt); in updateMemoryUsage() local
59 addData(sheet, date.toString(), in updateMemoryUsage()
62 addChart(sheet); in updateMemoryUsage()
84 return sheet; in createSpreadsheet()
91 sheet.getCellByPosition(0, 0).setFormula("Used"); in addData()
92 sheet.getCellByPosition(0, 1).setFormula("Free"); in addData()
93 sheet.getCellByPosition(0, 2).setFormula("Total"); in addData()
96 sheet.getCellByPosition(1, 1).setValue(free); in addData()
97 sheet.getCellByPosition(1, 2).setValue(total); in addData()
[all …]
/aoo42x/main/qadevOOo/tests/java/ifc/sheet/
H A D_XCellSeries.java23 package ifc.sheet;
30 import com.sun.star.sheet.XCellSeries;
31 import com.sun.star.sheet.XSpreadsheet;
87 oObj.fillAuto(com.sun.star.sheet.FillDirection.TO_RIGHT, 1); in _fillAuto()
103 oObj.fillAuto(com.sun.star.sheet.FillDirection.TO_BOTTOM, 1); in _fillAuto()
141 oObj.fillSeries(com.sun.star.sheet.FillDirection.TO_RIGHT, in _fillSeries()
142 com.sun.star.sheet.FillMode.LINEAR, in _fillSeries()
164 oObj.fillSeries(com.sun.star.sheet.FillDirection.TO_RIGHT, in _fillSeries()
165 com.sun.star.sheet.FillMode.GROWTH, in _fillSeries()
188 com.sun.star.sheet.FillMode.LINEAR, in _fillSeries()
[all …]
/aoo42x/test/testuno/source/fvt/uno/sc/rowcolumn/
H A DResizeHideShowRowColumn.java33 import com.sun.star.sheet.XSpreadsheet;
34 import com.sun.star.sheet.XSpreadsheetDocument;
35 import com.sun.star.sheet.XSpreadsheets;
44 import com.sun.star.sheet.XSpreadsheetView;
84 sheetview.setActiveSheet(sheet); in testResizeColumn()
87 XCellRange CellRange = sheet.getCellRangeByPosition(0, 0, 1, 0); in testResizeColumn()
112 CellRange = sheet.getCellRangeByPosition(0, 0, 1, 0); in testResizeColumn()
142 CellRange = sheet.getCellRangeByPosition(0, 0, 1, 0); in testResizeColumn()
175 sheetview.setActiveSheet(sheet); in testResizeRow()
204 CellRange = sheet.getCellRangeByPosition(0, 0, 0, 1); in testResizeRow()
[all …]
H A DInsertDeleteRowAndColumn.java34 import com.sun.star.sheet.XSpreadsheet;
35 import com.sun.star.sheet.XSpreadsheetDocument;
36 import com.sun.star.sheet.XSpreadsheets;
83 sheet.getCellByPosition( 0, nRow ).setValue( nRow ); in testInsertDeleteRows()
91 XCell cell = sheet.getCellByPosition(0, 2); in testInsertDeleteRows()
101 XCell cellA3 = sheet.getCellByPosition(0, 2); in testInsertDeleteRows()
102 XCell cellA4 = sheet.getCellByPosition(0, 3); in testInsertDeleteRows()
129 sheet.getCellByPosition( 1, nRow ).setValue( nRow ); in testInsertDeleteColumns()
137 XCell cell = sheet.getCellByPosition(2, 1); in testInsertDeleteColumns()
147 XCell cellA3 = sheet.getCellByPosition(1, 2); in testInsertDeleteColumns()
[all …]
/aoo42x/main/scripting/examples/beanshell/MemoryUsage/
H A Dmemusage.bsh36 import com.sun.star.sheet.*;
55 sheet = (XSpreadsheet) AnyConverter.toObject(
58 return sheet;
61 addData(sheet, date, total, free)
64 sheet.getCellByPosition(0, 0).setFormula("Used");
65 sheet.getCellByPosition(0, 1).setFormula("Free");
70 sheet.getCellByPosition(1, 1).setValue(free);
71 sheet.getCellByPosition(1, 2).setValue(total);
74 addChart(sheet)
136 sheet = createSpreadsheet();
[all …]

Completed in 633 milliseconds

12345678910>>...47