20 #ifndef INCLUDED_SC_SOURCE_FILTER_INC_WORKBOOKHELPER_HXX
21 #define INCLUDED_SC_SOURCE_FILTER_INC_WORKBOOKHELPER_HXX
24 #include <string_view>
30 namespace rtl {
template <
class reference_type>
class Reference; }
33 namespace container {
class XNameContainer; }
34 namespace sheet {
class XDatabaseRange; }
35 namespace sheet {
class XSpreadsheet; }
36 namespace sheet {
class XSpreadsheetDocument; }
37 namespace sheet {
struct FormulaToken; }
38 namespace style {
class XStyle; }
39 namespace table {
class XCellRange; }
43 class SegmentProgressBar;
48 class FragmentHandler;
66 bool operator()(
const OUString& rName1, std::u16string_view rName2 )
const;
143 const css::uno::Reference< css::sheet::XSpreadsheetDocument >&
147 css::uno::Reference< css::sheet::XSpreadsheet >
150 css::uno::Reference< css::sheet::XSpreadsheet >
154 css::uno::Reference< css::table::XCellRange >
158 css::uno::Reference< css::container::XNameContainer >
161 css::uno::Reference< css::style::XStyle >
162 getStyleObject(
const OUString& rStyleName,
bool bPageStyle )
const;
169 const css::uno::Sequence< css::sheet::FormulaToken>& rTokens,
171 sal_Int32 nNameFlags )
const;
178 const css::uno::Sequence< css::sheet::FormulaToken>& rTokens,
180 sal_Int32 nNameFlags, sal_Int32 nTab )
const;
185 css::uno::Reference< css::sheet::XDatabaseRange >
188 const ScRange& rRangeAddr )
const;
192 css::uno::Reference< css::sheet::XDatabaseRange >
194 const ScRange& rRangeAddr )
const;
200 css::uno::Reference< css::style::XStyle >
202 OUString& orStyleName,
203 bool bPageStyle )
const;
Helper class to provide access to global workbook data.
void setCurrentSheetIndex(SCTAB nSheet)
Sets the index of the current Calc sheet, if filter currently processes a sheet.
ScDocumentImport & getDocImport()
virtual ~WorkbookHelper()
ScenarioBuffer & getScenarios() const
Returns the scenarios collection.
oox::drawingml::chart::ChartConverter * getChartConverter() const
Returns the chart object converter.
Stores information about all sheets in a spreadsheet document.
UnitConverter & getUnitConverter() const
Returns the measurement unit converter.
bool isGeneratorKnownGood() const
Returns true when reading a file generated by a known good generator.
css::uno::Reference< css::style::XStyle > getStyleObject(const OUString &rStyleName, bool bPageStyle) const
Returns the specified cell or page style from the Calc document.
Collects all strings from the shared strings substream.
exports com.sun.star. table
Helper class that provides functions to convert values from and to different units.
WorkbookGlobals & mrBookGlob
css::uno::Reference< css::table::XCellRange > getCellRangeFromDoc(const ScRange &rRange) const
Returns the XCellRange interface for the passed cell range address.
WorkbookHelper(WorkbookGlobals &rBookGlob)
rtl_TextEncoding getTextEncoding() const
Returns the text encoding used to import/export byte strings.
std::shared_ptr< StorageBase > StorageRef
Accessor class to ScDocument.
StylesBuffer & getStyles() const
Returns all cell formatting objects read from the styles substream.
WorkbookSettings & getWorkbookSettings() const
Returns the global workbook settings object.
bool importOoxFragment(const rtl::Reference< oox::core::FragmentHandler > &rxHandler)
Imports a fragment using the passed fragment handler, which contains the full path to the fragment st...
exports com.sun.star. sheet
exports com.sun.star. container
ViewSettings & getViewSettings() const
Returns the workbook and sheet view settings object.
css::uno::Reference< css::style::XStyle > createStyleObject(OUString &orStyleName, bool bPageStyle) const
Creates and returns a com.sun.star.style.Style object for cells or pages.
ScDBData * findDatabaseRangeByIndex(sal_uInt16 nIndex) const
Finds the (already existing) database range of the given formula token index.
::oox::core::FilterBase & getBaseFilter() const
Returns the base filter object (base class of all filters).
PivotCacheBuffer & getPivotCaches() const
Returns the collection of pivot caches.
sal_Int16 getCurrentSheetIndex() const
Returns the index of the current Calc sheet, if filter currently processes a sheet.
void useInternalChartDataTable(bool bInternal)
ScRangeData * createLocalNamedRangeObject(OUString &orName, const css::uno::Sequence< css::sheet::FormulaToken > &rTokens, sal_Int32 nIndex, sal_Int32 nNameFlags, sal_Int32 nTab) const
Creates and returns a defined name on-the-fly in the sheet.
void finalizeWorkbookImport()
Final conversion after importing the workbook.
PageSettingsConverter & getPageSettingsConverter() const
Returns the page and print settings converter.
const css::uno::Reference< css::sheet::XSpreadsheetDocument > & getDocument() const
Returns a reference to the source/target spreadsheet document model.
css::uno::Reference< css::container::XNameContainer > getCellStyleFamily() const
Returns the cell styles container from the Calc document.
ExternalLinkBuffer & getExternalLinks() const
Returns the external links read from the external links substream.
ScDocument & getScDocument()
FormulaParser * createFormulaParser() const
Returns an unshared import formula parser (import filter only!).
::oox::core::XmlFilterBase & getOoxFilter() const
Returns the base OOXML/BIFF12 filter object.
SegmentProgressBar & getProgressBar() const
Returns the filter progress bar.
std::shared_ptr< WorkbookGlobals > WorkbookGlobalsRef
ScRangeData * createNamedRangeObject(OUString &orName, const css::uno::Sequence< css::sheet::FormulaToken > &rTokens, sal_Int32 nIndex, sal_Int32 nNameFlags) const
Creates and returns a defined name on-the-fly in the Calc document.
ScEditEngineDefaulter & getEditEngine() const
exports com.sun.star. style
static WorkbookGlobalsRef constructGlobals(ExcelFilter &rFilter)
bool operator()(const OUString &rName1, std::u16string_view rName2) const
Converter for cell addresses and cell ranges for OOXML and BIFF filters.
css::uno::Reference< css::sheet::XDatabaseRange > createDatabaseRangeObject(OUString &orName, const ScRange &rRangeAddr) const
Creates and returns a database range on-the-fly in the Calc document.
SharedStringsBuffer & getSharedStrings() const
Returns the shared strings read from the shared strings substream.
ConnectionsBuffer & getConnections() const
Returns the collection of external data connections.
TableBuffer & getTables() const
Returns the tables collection (equivalent to Calc's database ranges).
FormulaParser & getFormulaParser() const
Returns a shared import formula parser (import filter only!).
css::uno::Reference< css::sheet::XSpreadsheet > getSheetFromDoc(sal_Int32 nSheet) const
Returns a reference to the specified spreadsheet in the document model.
PivotTableBuffer & getPivotTables() const
Returns the collection of pivot tables.
ThemeBuffer & getTheme() const
Returns the office theme object read from the theme substorage.
void setVbaProjectStorage(const StorageRef &rxVbaPrjStrg)
Sets the VBA project storage used to import VBA source code and forms.
css::uno::Reference< css::sheet::XDatabaseRange > createUnnamedDatabaseRangeObject(const ScRange &rRangeAddr) const
Creates and returns an unnamed database range on-the-fly in the Calc document.
WorkbookHelper & operator=(WorkbookHelper const &)=delete
DefinedNamesBuffer & getDefinedNames() const
Returns the defined names read from the workbook globals.
AddressConverter & getAddressConverter() const
Returns the converter for string to cell address/range conversion.
FormulaBuffer & getFormulaBuffer() const
Functor for case-insensitive string comparison, usable in maps etc.
WorksheetBuffer & getWorksheets() const
Returns the worksheet buffer containing sheet names and properties.