35 namespace drawing {
class XDrawPage; }
36 namespace sheet {
class XSpreadsheet; }
37 namespace table {
class XCell; }
38 namespace table {
class XCellRange; }
43 class AutoFilterBuffer;
45 class CondFormatBuffer;
48 class QueryTableBuffer;
50 class SheetDataBuffer;
51 class SheetViewSettings;
55 typedef ::std::map< OUString, ScDataBarFormatData* >
ExtLst;
187 const css::uno::Reference< css::sheet::XSpreadsheet >&
191 css::uno::Reference< css::table::XCell >
194 css::uno::Reference< css::table::XCellRange >
198 css::uno::Reference< css::drawing::XDrawPage >
202 css::awt::Point
getCellPosition( sal_Int32 nCol, sal_Int32 nRow )
const;
258 double fHeight,
bool bCustomHeight,
259 bool bHidden,
bool bThickTop,
bool bThickBottom );
284 const ScAddress& rAddr, sal_Int32 nSharedId,
285 const OUString& rCellValue, sal_Int32 nValueType );
291 sal_Int32 nSharedId,
const OUString& rTokens );
294 const ScAddress& rAddress,
const OUString& rValueStr, sal_Int32 nCellType );
Helper class to provide access to global workbook data.
HyperlinkModel()
Additional tooltip text.
static WorksheetGlobalsRef constructGlobals(const WorkbookHelper &rHelper, const ISegmentProgressBarRef &rxProgressBar, WorksheetType eSheetType, SCTAB nSheet)
SheetDataBuffer & getSheetData() const
Returns the buffer for cell contents and cell formatting.
virtual void setCustomRowProgress(const ISegmentProgressBarRef &rxRowProgress)=0
bool mbThickTop
True = row outline is collapsed.
void createSharedFormulaMapEntry(const ScAddress &rAddress, sal_Int32 nSharedId, const OUString &rTokens)
Contains string data and a list of formatting runs for a rich formatted string.
exports com.sun.star. awt
WorksheetGlobals & mrSheetGlob
ColumnModel()
True = column outline is collapsed.
sal_Int32 mnMax
Start of limited break.
bool mbCustomFormat
True = row has custom height.
ScDocument & getScDocument()
exports com.sun.star. table
css::uno::Reference< css::table::XCellRange > getCellRange(const ScRange &rRange) const
Returns the XCellRange interface for the passed cell range address.
WorksheetSettings & getWorksheetSettings() const
Returns the worksheet settings object.
virtual ISegmentProgressBarRef getRowProgress()=0
SheetViewSettings & getSheetViewSettings() const
Returns the view settings for this sheet.
void putFormulaTokens(const ScAddress &rAddress, const ApiTokenSequence &rTokens)
Inserts a formula cell directly into the Calc sheet.
const css::awt::Size & getDrawPageSize() const
Returns the size of the entire drawing page in 1/100 mm.
exports com.sun.star. sheet
void setHyperlink(const HyperlinkModel &rModel)
Inserts the hyperlink URL into the spreadsheet.
CondFormatBuffer & getCondFormats() const
Returns the conditional formatting in this sheet.
void extendShapeBoundingBox(const css::awt::Rectangle &rShapeRect)
Extends the shape bounding box by the position and size of the passed rectangle (in 1/100 mm)...
bool mbShowPhonetic
True = cells in row have explicit formatting.
void setBiffType(sal_uInt8 nType)
Sets the passed BIFF validation type.
bool mbCustomHeight
Row outline level.
std::shared_ptr< WorksheetGlobals > WorksheetGlobalsRef
Stores formatting data about a page break.
OUString maTooltip
The cell area containing the hyperlink.
bool mbCollapsed
True = row is hidden.
void setVmlDrawingPath(const OUString &rVmlDrawingPath)
Sets the path to the legacy VML drawing fragment of this sheet.
void setCellArrayFormula(const ScRange &rRangeAddress, const ScAddress &rTokenAddress, const OUString &rTokenStr)
void putRichString(const ScAddress &rAddress, const RichString &rString, const oox::xls::Font *pFirstPortionFont)
Inserts a rich-string cell directly into the Calc sheet.
CommentsBuffer & getComments() const
Returns the buffer for all cell comments in this sheet.
double mfHeight
0-based (!) column ranges of used cells.
static IWorksheetProgress * getWorksheetInterface(const WorksheetGlobalsRef &xRef)
sal_Int32 mnLevel
Column default formatting.
bool isMergeable(const ColumnModel &rModel) const
Returns true, if this entry can be merged with the passed column range (column settings are equal)...
void setCellFormulaValue(const ScAddress &rAddress, const OUString &rValueStr, sal_Int32 nCellType)
Stores settings and formatting data about a sheet row.
void setBiffOperator(sal_uInt8 nOperator)
Sets the passed BIFF operator.
double mfWidth
1-based (!) range of the described columns.
sal_Int32 mnXfId
Column width in number of characters.
bool mbHidden
True = cells in row show phonetic settings.
void setCellFormula(const ScAddress &rTokenAddress, const OUString &)
css::uno::Reference< css::drawing::XDrawPage > getDrawPage() const
Returns the XDrawPage interface of the draw page of the current sheet.
void setDrawingPath(const OUString &rDrawingPath)
Sets the path to the DrawingML fragment of this sheet.
bool mbHidden
True = cells in column show phonetic settings.
bool mbCollapsed
True = column is hidden.
PageBreakModel()
True = manual page break.
ApiTokenSequence maTokens2
ExtLst & getExtLst() const
Stores settings and formatting data about a range of sheet columns.
WorksheetType getSheetType() const
Returns the type of this sheet.
std::shared_ptr< ISegmentProgressBar > ISegmentProgressBarRef
void setPageBreak(const PageBreakModel &rModel, bool bRowBreak)
Sets a column or row page break described in the passed struct.
void insertColSpan(const ValueRange &rColSpan)
Inserts the passed column span into the row model.
void setBaseColumnWidth(sal_Int32 nWidth)
Sets base width for all columns (without padding pixels).
virtual ~IWorksheetProgress()
css::uno::Reference< css::table::XCell > getCell(const ScAddress &rAddress) const
Returns the XCell interface for the passed cell address.
void setDefaultRowSettings(double fHeight, bool bCustomHeight, bool bHidden, bool bThickTop, bool bThickBottom)
Sets default height and hidden state for all unused rows in the sheet.
::std::map< OUString, ScDataBarFormatData * > ExtLst
void initializeWorksheetImport()
Initial conversion before importing the worksheet.
QueryTableBuffer & getQueryTables() const
Returns the buffer for all web query tables in this sheet.
void setColumnModel(const ColumnModel &rModel)
Sets column settings for a specific range of columns.
void setValidation(const ValidationModel &rModel)
Inserts the data validation settings into the spreadsheet.
RowModel()
True = row has extra space below text.
sal_Int32 mnXfId
Row height in points.
css::uno::Sequence< ApiToken > ApiTokenSequence
Stores data about ranges with data validation settings.
void finalizeDrawingImport()
Final import of drawing objects.
void extendUsedArea(const ScAddress &rAddress)
Extends the used area of this sheet by the passed cell position.
bool isMergeable(const RowModel &rModel) const
Returns true, if this entry can be merged with the passed row range (row settings are equal)...
css::awt::Point getCellPosition(sal_Int32 nCol, sal_Int32 nRow) const
Returns the absolute cell position in 1/100 mm.
sal_Int32 mnMin
0-based (!) index of column/row.
const css::uno::Reference< css::sheet::XSpreadsheet > & getSheet() const
Returns the XSpreadsheet interface of the current sheet.
ValueRangeSet maColSpans
1-based (!) index of the described row.
SCTAB getSheetIndex() const
Returns the index of the current sheet.
bool mbShowPhonetic
Column outline level.
WorksheetHelper(WorksheetGlobals &rSheetGlob)
VmlDrawing & getVmlDrawing() const
Returns the VML drawing page for this sheet (OOXML/BIFF12 only).
Stores data about a hyperlink range.
sal_Int32 mnLevel
Row default formatting (see mbIsFormatted).
WorksheetType
An enumeration for all types of sheets in a workbook.
AutoFilterBuffer & getAutoFilters() const
Returns the auto filters for the sheet.
void finalizeWorksheetImport()
Final conversion after importing the worksheet.
bool mbThickBottom
True = row has extra space above text.
void setRowModel(const RowModel &rModel)
Sets row settings for a specific range of rows.
PageSettings & getPageSettings() const
Returns the page/print settings for this sheet.
Manages the cell contents and cell formatting of a sheet.
bool mbManual
End of limited break.
ApiTokenSequence maTokens1
void setDefaultColumnWidth(double fWidth)
Sets default width for all columns.
void setBiffErrorStyle(sal_uInt8 nErrorStyle)
Sets the passed BIFF error style.