/aoo42x/main/offapi/com/sun/star/sheet/ |
H A D | SpreadsheetView.idl | 35 #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 D | SpreadsheetDocument.idl | 61 #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 D | XExternalDocLink.idl | 30 #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 D | XDataPilotTable2.idl | 40 #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 D | com.sun.star.comp.office.ScSpreadsheetSettings.csv | 8 "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 D | com.sun.star.comp.office.ScTableValidationObj.csv | 1 "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 D | com.sun.star.comp.office.ScDataPilotTableObj.csv | 3 "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 D | com.sun.star.comp.office.ScCellRangeObj.csv | 33 "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 D | com.sun.star.comp.office.ScSpreadsheetSettingsObj.csv | 8 "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 D | com.sun.star.comp.office.ScDatabaseRangeObj.csv | 4 "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 D | dpsave.hxx | 36 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 D | cellsuno.hxx | 158 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 D | ExampleDataPilotSource.java | 225 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 D | ViewSample.java | 63 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 D | UnoApi_offapi.mk | 143 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 D | ValueChanger.java | 629 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 D | idl_chapter_refs.txt | 85 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 D | ChartTitle.java | 47 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 D | vbaworksheet.cxx | 123 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 D | vbarange.cxx | 1839 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 D | MemoryUsage.java | 39 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.java | 23 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 D | ResizeHideShowRowColumn.java | 33 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 D | InsertDeleteRowAndColumn.java | 34 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 D | memusage.bsh | 36 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 …]
|