diff options
author | Kohei Yoshida <kohei.yoshida@gmail.com> | 2018-08-27 11:06:17 -0400 |
---|---|---|
committer | Kohei Yoshida <libreoffice@kohei.us> | 2018-09-01 01:34:10 +0200 |
commit | 1d0727a104d76210814f41c1169df318e40c9d80 (patch) | |
tree | 71ab897459c4f20df93c4ba8cb8032b08339a4d8 /sc | |
parent | d7c16324b58c08ca6fdd231b145b77f999800d28 (diff) |
Update orcus to 0.14.0.
And make all necessary adjustments for the new version of orcus.
Change-Id: I0dc207162a3ddfaad6da198a3d13b65f530757d5
Reviewed-on: https://gerrit.libreoffice.org/59884
Tested-by: Jenkins
Reviewed-by: Kohei Yoshida <libreoffice@kohei.us>
Diffstat (limited to 'sc')
-rw-r--r-- | sc/source/filter/inc/orcusinterface.hxx | 107 | ||||
-rw-r--r-- | sc/source/filter/orcus/interface.cxx | 322 | ||||
-rw-r--r-- | sc/source/filter/orcus/xmlcontext.cxx | 5 |
3 files changed, 320 insertions, 114 deletions
diff --git a/sc/source/filter/inc/orcusinterface.hxx b/sc/source/filter/inc/orcusinterface.hxx index 028fb4126f01..dce0d5b0a64e 100644 --- a/sc/source/filter/inc/orcusinterface.hxx +++ b/sc/source/filter/inc/orcusinterface.hxx @@ -54,6 +54,7 @@ public: ScOrcusGlobalSettings(ScDocumentImport& rDoc); virtual void set_origin_date(int year, int month, int day) override; + virtual void set_character_set(orcus::character_set_t cs) override; virtual void set_default_formula_grammar(orcus::spreadsheet::formula_grammar_t grammar) override; virtual orcus::spreadsheet::formula_grammar_t get_default_formula_grammar() const override; @@ -181,7 +182,7 @@ public: virtual ~ScOrcusAutoFilter() override; - virtual void set_range(const char* p_ref, size_t n_ref) override; + virtual void set_range(const orcus::spreadsheet::range_t& range) override; virtual void set_column(orcus::spreadsheet::col_t col) override; @@ -214,22 +215,95 @@ public: virtual void set_merge_cell_range(const orcus::spreadsheet::range_t& range) override; }; +class ScOrcusSheet; + +class ScOrcusFormula : public orcus::spreadsheet::iface::import_formula +{ + enum class ResultType { NotSet, String, Value, Empty }; + + friend class ScOrcusSheet; + + ScOrcusSheet& mrSheet; + + SCCOL mnCol; + SCROW mnRow; + OUString maFormula; + formula::FormulaGrammar::Grammar meGrammar; + size_t mnSharedFormulaIndex; + bool mbShared; + + ResultType meResType; + size_t mnResult; // result string index. + double mfResult; + + void reset(); + +public: + ScOrcusFormula( ScOrcusSheet& rSheet ); + virtual ~ScOrcusFormula() override; + + virtual void set_position(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col) override; + virtual void set_formula(orcus::spreadsheet::formula_grammar_t grammar, const char* p, size_t n) override; + virtual void set_shared_formula_index(size_t index) override; + virtual void set_result_value(double value) override; + virtual void set_result_string(size_t sindex) override; + virtual void set_result_empty() override; + virtual void set_result_bool(bool value) override; + virtual void commit() override; +}; + +class ScOrcusArrayFormula : public orcus::spreadsheet::iface::import_array_formula +{ + friend class ScOrcusSheet; + + ScOrcusSheet& mrSheet; + + SCCOL mnCol; + SCROW mnRow; + uint32_t mnColRange; + uint32_t mnRowRange; + OUString maFormula; + formula::FormulaGrammar::Grammar meGrammar; + + void reset(); + +public: + ScOrcusArrayFormula( ScOrcusSheet& rSheet ); + virtual ~ScOrcusArrayFormula() override; + + virtual void set_range(const orcus::spreadsheet::range_t& range) override; + virtual void set_formula(orcus::spreadsheet::formula_grammar_t grammar, const char* p, size_t n) override; + virtual void set_result_value(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, double value) override; + virtual void set_result_string(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, size_t sindex) override; + virtual void set_result_empty(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col) override; + virtual void set_result_bool(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, bool value) override; + virtual void commit() override; +}; + class ScOrcusSheet : public orcus::spreadsheet::iface::import_sheet { + friend class ScOrcusFormula; + friend class ScOrcusArrayFormula; + ScDocumentImport& mrDoc; SCTAB mnTab; ScOrcusFactory& mrFactory; ScOrcusStyles& mrStyles; sc::SharedFormulaGroups maFormulaGroups; + ScOrcusAutoFilter maAutoFilter; ScOrcusSheetProperties maProperties; ScOrcusConditionalFormat maConditionalFormat; ScOrcusNamedExpression maNamedExpressions; + ScOrcusFormula maFormula; + ScOrcusArrayFormula maArrayFormula; int mnCellCount; void cellInserted(); + ScDocumentImport& getDoc(); + public: ScOrcusSheet(ScDocumentImport& rDoc, SCTAB nTab, ScOrcusFactory& rFactory); @@ -238,6 +312,8 @@ public: virtual orcus::spreadsheet::iface::import_sheet_properties* get_sheet_properties() override; virtual orcus::spreadsheet::iface::import_conditional_format* get_conditional_format() override; virtual orcus::spreadsheet::iface::import_named_expression* get_named_expression() override; + virtual orcus::spreadsheet::iface::import_formula* get_formula() override; + virtual orcus::spreadsheet::iface::import_array_formula* get_array_formula() override; // Orcus import interface virtual void set_auto(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, const char* p, size_t n) override; @@ -251,33 +327,13 @@ public: virtual void set_format(orcus::spreadsheet::row_t row_start, orcus::spreadsheet::col_t col_start, orcus::spreadsheet::row_t row_end, orcus::spreadsheet::col_t col_end, size_t xf_index) override; - virtual void set_formula(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, orcus::spreadsheet::formula_grammar_t grammar, const char* p, size_t n) override; - virtual void set_formula_result(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, const char* p, size_t n) override; - virtual void set_formula_result(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, double val) override; - - virtual void set_shared_formula( - orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, orcus::spreadsheet::formula_grammar_t grammar, size_t sindex, - const char* p_formula, size_t n_formula) override; - - virtual void set_shared_formula( - orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, orcus::spreadsheet::formula_grammar_t grammar, size_t sindex, - const char* p_formula, size_t n_formula, const char* p_range, size_t n_range) override; - - virtual void set_shared_formula(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, size_t sindex) override; - - virtual void set_array_formula( - orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, orcus::spreadsheet::formula_grammar_t grammar, - const char* p, size_t n, orcus::spreadsheet::row_t array_rows, orcus::spreadsheet::col_t array_cols) override; - - virtual void set_array_formula( - orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, orcus::spreadsheet::formula_grammar_t grammar, - const char* p, size_t n, const char* p_range, size_t n_range) override; - virtual orcus::spreadsheet::range_size_t get_sheet_size() const override; SCTAB getIndex() const { return mnTab; } const sc::SharedFormulaGroups& getSharedFormulaGroups() const; + sc::SharedFormulaGroups& getSharedFormulaGroups(); + ScOrcusFactory& getFactory(); }; class ScOrcusStyles : public orcus::spreadsheet::iface::import_styles @@ -312,7 +368,7 @@ private: struct fill { - OUString maPattern; + orcus::spreadsheet::fill_pattern_t mePattern; Color maFgColor; Color maBgColor; @@ -446,7 +502,7 @@ public: // fill virtual void set_fill_count(size_t n) override; - virtual void set_fill_pattern_type(const char* s, size_t n) override; + virtual void set_fill_pattern_type(orcus::spreadsheet::fill_pattern_t fp) override; virtual void set_fill_fg_color(orcus::spreadsheet::color_elem_t alpha, orcus::spreadsheet::color_elem_t red, orcus::spreadsheet::color_elem_t green, orcus::spreadsheet::color_elem_t blue) override; virtual void set_fill_bg_color(orcus::spreadsheet::color_elem_t alpha, orcus::spreadsheet::color_elem_t red, orcus::spreadsheet::color_elem_t green, orcus::spreadsheet::color_elem_t blue) override; virtual size_t commit_fill() override; @@ -580,6 +636,7 @@ public: size_t appendString(const OUString& rStr); size_t addString(const OUString& rStr); + const OUString* getString(size_t nIndex) const; void pushCellStoreAutoToken( const ScAddress& rPos, const OUString& rVal ); void pushCellStoreToken( const ScAddress& rPos, uint32_t nStrIndex ); diff --git a/sc/source/filter/orcus/interface.cxx b/sc/source/filter/orcus/interface.cxx index dcf3e83d7eae..7b8425d3007d 100644 --- a/sc/source/filter/orcus/interface.cxx +++ b/sc/source/filter/orcus/interface.cxx @@ -101,6 +101,11 @@ void ScOrcusGlobalSettings::set_origin_date(int year, int month, int day) mrDoc.setOriginDate(year, month, day); } +void ScOrcusGlobalSettings::set_character_set(orcus::character_set_t /*cs*/) +{ + // TODO +} + void ScOrcusGlobalSettings::set_default_formula_grammar(os::formula_grammar_t grammar) { meCalcGrammar = getCalcGrammarFromOrcus(grammar); @@ -463,6 +468,11 @@ size_t ScOrcusFactory::addString(const OUString& rStr) return appendString(rStr); } +const OUString* ScOrcusFactory::getString(size_t nIndex) const +{ + return nIndex < maStrings.size() ? &maStrings[nIndex] : nullptr; +} + void ScOrcusFactory::pushCellStoreAutoToken( const ScAddress& rPos, const OUString& rVal ) { maCellStoreTokens.emplace_back(rPos, CellStoreToken::Type::Auto); @@ -816,10 +826,197 @@ ScOrcusSheet::ScOrcusSheet(ScDocumentImport& rDoc, SCTAB nTab, ScOrcusFactory& r maProperties(mnTab, mrDoc), maConditionalFormat(mnTab, rDoc.getDoc()), maNamedExpressions(rDoc, rFactory.getGlobalSettings(), nTab), + maFormula(*this), + maArrayFormula(*this), mnCellCount(0) { } +void ScOrcusFormula::reset() +{ + mnCol = -1; + mnRow = -1; + maFormula.clear(); + meGrammar = formula::FormulaGrammar::GRAM_UNSPECIFIED; + mnSharedFormulaIndex = 0; + mbShared = false; + meResType = ResultType::NotSet; + mnResult = 0; + mfResult = 0.0; +} + +ScOrcusFormula::ScOrcusFormula( ScOrcusSheet& rSheet ) : + mrSheet(rSheet), + mnCol(-1), + mnRow(-1), + meGrammar(formula::FormulaGrammar::GRAM_UNSPECIFIED), + mnSharedFormulaIndex(0), + mbShared(false), + meResType(ResultType::NotSet), + mnResult(0), + mfResult(0.0) {} + +ScOrcusFormula::~ScOrcusFormula() {} + +void ScOrcusFormula::set_position(os::row_t row, os::col_t col) +{ + mnCol = col; + mnRow = row; +} + +void ScOrcusFormula::set_formula(os::formula_grammar_t grammar, const char* p, size_t n) +{ + maFormula = OUString(p, n, RTL_TEXTENCODING_UTF8); + meGrammar = getCalcGrammarFromOrcus(grammar); +} + +void ScOrcusFormula::set_shared_formula_index(size_t index) +{ + mnSharedFormulaIndex = index; + mbShared = true; +} + +void ScOrcusFormula::set_result_value(double value) +{ + meResType = ResultType::Value; + mfResult = value; +} + +void ScOrcusFormula::set_result_string(size_t sindex) +{ + meResType = ResultType::String; + mnResult = sindex; +} + +void ScOrcusFormula::set_result_empty() +{ + meResType = ResultType::Empty; +} + +void ScOrcusFormula::set_result_bool(bool value) +{ + meResType = ResultType::Value; + mfResult = value ? 1.0 : 0.0; +} + +void ScOrcusFormula::commit() +{ + ScOrcusFactory& rFactory = mrSheet.getFactory(); + sc::SharedFormulaGroups& rGroups = mrSheet.getSharedFormulaGroups(); + ScAddress aPos(mnCol, mnRow, mrSheet.getIndex()); + + if (mbShared) + { + if (maFormula.isEmpty()) + { + // shared formula that references existing formula token. + const ScTokenArray* pArray = rGroups.get(mnSharedFormulaIndex); + if (!pArray) + return; + } + else + { + // topmost shared formula with new formula token. + + // Compile the formula expression into tokens. + ScCompiler aComp(&mrSheet.getDoc().getDoc(), aPos, meGrammar); + ScTokenArray* pArray = aComp.CompileString(maFormula); + if (!pArray) + // Tokenization failed. + return; + + rGroups.set(mnSharedFormulaIndex, pArray); + } + rFactory.pushSharedFormulaToken(aPos, mnSharedFormulaIndex); + } + else + { + // non-shared formula + rFactory.pushCellStoreToken(aPos, maFormula, meGrammar); + } + + switch (meResType) + { + case ResultType::String: + { + const OUString* pStr = rFactory.getString(mnResult); + if (pStr) + rFactory.pushFormulaResult(aPos, *pStr); + break; + } + case ResultType::Value: + rFactory.pushFormulaResult(aPos, mfResult); + break; + default: + ; + } + + mrSheet.cellInserted(); +} + +void ScOrcusArrayFormula::reset() +{ + mnCol = -1; + mnRow = -1; + mnColRange = 0; + mnRowRange = 0; + + maFormula.clear(); + meGrammar = formula::FormulaGrammar::GRAM_UNSPECIFIED; +} + +ScOrcusArrayFormula::ScOrcusArrayFormula( ScOrcusSheet& rSheet ) : + mrSheet(rSheet), + mnCol(-1), + mnRow(-1), + mnColRange(0), + mnRowRange(0), + meGrammar(formula::FormulaGrammar::GRAM_UNSPECIFIED) {} + +ScOrcusArrayFormula::~ScOrcusArrayFormula() {} + +void ScOrcusArrayFormula::set_range(const os::range_t& range) +{ + mnCol = range.first.column; + mnRow = range.first.row; + + mnColRange = range.last.column - range.first.column + 1; + mnRowRange = range.last.row - range.first.column + 1; +} + +void ScOrcusArrayFormula::set_formula(os::formula_grammar_t grammar, const char* p, size_t n) +{ + meGrammar = getCalcGrammarFromOrcus(grammar); + maFormula = OUString(p, n, RTL_TEXTENCODING_UTF8); +} + +void ScOrcusArrayFormula::set_result_value(os::row_t /*row*/, os::col_t /*col*/, double /*value*/) +{ + // TODO : implement result cache for matrix +} + +void ScOrcusArrayFormula::set_result_string(os::row_t /*row*/, os::col_t /*col*/, size_t /*sindex*/) +{ + // TODO : implement result cache for matrix +} + +void ScOrcusArrayFormula::set_result_empty(os::row_t /*row*/, os::col_t /*col*/) +{ + // TODO : implement result cache for matrix +} + +void ScOrcusArrayFormula::set_result_bool(os::row_t /*row*/, os::col_t /*col*/, bool /*value*/) +{ + // TODO : implement result cache for matrix +} + +void ScOrcusArrayFormula::commit() +{ + ScAddress aPos(mnCol, mnRow, mrSheet.getIndex()); + mrSheet.getFactory().pushMatrixFormulaToken(aPos, maFormula, meGrammar, mnRowRange, mnColRange); + mrSheet.cellInserted(); +} + void ScOrcusSheet::cellInserted() { ++mnCellCount; @@ -830,6 +1027,11 @@ void ScOrcusSheet::cellInserted() } } +ScDocumentImport& ScOrcusSheet::getDoc() +{ + return mrDoc; +} + os::iface::import_auto_filter* ScOrcusSheet::get_auto_filter() { return &maAutoFilter; @@ -855,6 +1057,18 @@ os::iface::import_named_expression* ScOrcusSheet::get_named_expression() return &maNamedExpressions; } +os::iface::import_formula* ScOrcusSheet::get_formula() +{ + maFormula.reset(); + return &maFormula; +} + +os::iface::import_array_formula* ScOrcusSheet::get_array_formula() +{ + maArrayFormula.reset(); + return &maArrayFormula; +} + void ScOrcusSheet::set_auto(os::row_t row, os::col_t col, const char* p, size_t n) { OUString aVal(p, n, RTL_TEXTENCODING_UTF8); @@ -921,83 +1135,6 @@ void ScOrcusSheet::set_format(os::row_t row_start, os::col_t col_start, mrDoc.getDoc().ApplyPatternAreaTab(col_start, row_start, col_end, row_end, mnTab, aPattern); } -void ScOrcusSheet::set_formula( - os::row_t row, os::col_t col, os::formula_grammar_t grammar, const char* p, size_t n) -{ - OUString aFormula(p, n, RTL_TEXTENCODING_UTF8); - mrFactory.pushCellStoreToken( - ScAddress(col, row, mnTab), aFormula, getCalcGrammarFromOrcus(grammar)); - cellInserted(); -} - -void ScOrcusSheet::set_formula_result(os::row_t row, os::col_t col, const char* p, size_t n) -{ - OUString aResult( p, n, RTL_TEXTENCODING_UTF8); - mrFactory.pushFormulaResult(ScAddress(col, row, mnTab), aResult); -} - -void ScOrcusSheet::set_formula_result(os::row_t row, os::col_t col, double val) -{ - mrFactory.pushFormulaResult(ScAddress(col, row, mnTab), val); -} - -void ScOrcusSheet::set_shared_formula( - os::row_t row, os::col_t col, os::formula_grammar_t grammar, size_t sindex, - const char* p_formula, size_t n_formula) -{ - ScAddress aPos(col, row, mnTab); - OUString aFormula(p_formula, n_formula, RTL_TEXTENCODING_UTF8); - formula::FormulaGrammar::Grammar eGram = getCalcGrammarFromOrcus(grammar); - - // Compile the formula expression into tokens. - ScCompiler aComp(&mrDoc.getDoc(), aPos, eGram); - ScTokenArray* pArray = aComp.CompileString(aFormula); - if (!pArray) - // Tokenization failed. - return; - - maFormulaGroups.set(sindex, pArray); - - mrFactory.pushSharedFormulaToken(aPos, sindex); - cellInserted(); -} - -void ScOrcusSheet::set_shared_formula( - os::row_t row, os::col_t col, os::formula_grammar_t grammar, size_t sindex, - const char* p_formula, size_t n_formula, const char* /*p_range*/, size_t /*n_range*/) -{ - set_shared_formula(row, col, grammar, sindex, p_formula, n_formula); -} - -void ScOrcusSheet::set_shared_formula(os::row_t row, os::col_t col, size_t sindex) -{ - ScAddress aPos(col, row, mnTab); - - const ScTokenArray* pArray = maFormulaGroups.get(sindex); - if (!pArray) - return; - - mrFactory.pushSharedFormulaToken(aPos, sindex); - cellInserted(); -} - -void ScOrcusSheet::set_array_formula( - os::row_t row, os::col_t col, os::formula_grammar_t grammar, - const char* p, size_t n, os::row_t array_rows, os::col_t array_cols) -{ - OUString aFormula(p, n, RTL_TEXTENCODING_UTF8); - formula::FormulaGrammar::Grammar eGrammar = getCalcGrammarFromOrcus(grammar); - - ScAddress aPos(col, row, mnTab); - mrFactory.pushMatrixFormulaToken(aPos, aFormula, eGrammar, array_rows, array_cols); -} - -void ScOrcusSheet::set_array_formula( - os::row_t /*row*/, os::col_t /*col*/, os::formula_grammar_t /*grammar*/, - const char* /*p*/, size_t /*n*/, const char* /*p_range*/, size_t /*n_range*/) -{ -} - orcus::spreadsheet::range_size_t ScOrcusSheet::get_sheet_size() const { orcus::spreadsheet::range_size_t ret; @@ -1012,6 +1149,16 @@ const sc::SharedFormulaGroups& ScOrcusSheet::getSharedFormulaGroups() const return maFormulaGroups; } +sc::SharedFormulaGroups& ScOrcusSheet::getSharedFormulaGroups() +{ + return maFormulaGroups; +} + +ScOrcusFactory& ScOrcusSheet::getFactory() +{ + return mrFactory; +} + ScOrcusSharedStrings::ScOrcusSharedStrings(ScOrcusFactory& rFactory) : mrFactory(rFactory) {} @@ -1087,7 +1234,7 @@ ScOrcusStyles::font::font(): } ScOrcusStyles::fill::fill(): - maPattern(""), + mePattern(orcus::spreadsheet::fill_pattern_t::none), maFgColor(COL_WHITE), maBgColor(COL_WHITE), mbHasFillAttr(false) @@ -1143,13 +1290,13 @@ void ScOrcusStyles::font::applyToItemSet(SfxItemSet& rSet) const void ScOrcusStyles::fill::applyToItemSet(SfxItemSet& rSet) const { - if (maPattern.equalsIgnoreAsciiCase("none")) + if (mePattern == orcus::spreadsheet::fill_pattern_t::none) { SAL_INFO("sc.orcus.style", "no fill style"); return; } - if (maPattern.equalsIgnoreAsciiCase("solid")) + if (mePattern == orcus::spreadsheet::fill_pattern_t::solid) rSet.Put(SvxBrushItem(maFgColor, ATTR_BACKGROUND)); } @@ -1575,10 +1722,9 @@ void ScOrcusStyles::set_fill_count(size_t /*n*/) // needed at all? } -void ScOrcusStyles::set_fill_pattern_type(const char* s, size_t n) +void ScOrcusStyles::set_fill_pattern_type(orcus::spreadsheet::fill_pattern_t fp) { - maCurrentFill.maPattern = OUString(s, n, RTL_TEXTENCODING_UTF8); - maCurrentFill.mbHasFillAttr = true; + maCurrentFill.mePattern = fp; } void ScOrcusStyles::set_fill_fg_color( @@ -1962,12 +2108,12 @@ ScOrcusAutoFilter::~ScOrcusAutoFilter() { } -void ScOrcusAutoFilter::set_range(const char* p_ref, size_t n_ref) +void ScOrcusAutoFilter::set_range(const orcus::spreadsheet::range_t& range) { - OUString aRange(p_ref, n_ref, RTL_TEXTENCODING_UTF8); - SAL_INFO("sc.orcus.autofilter", "set_range: " << aRange); - - maRange.Parse(aRange); + maRange.aStart.SetRow(range.first.row); + maRange.aStart.SetCol(range.first.column); + maRange.aEnd.SetRow(range.last.row); + maRange.aEnd.SetCol(range.last.column); } void ScOrcusAutoFilter::set_column(orcus::spreadsheet::col_t col) diff --git a/sc/source/filter/orcus/xmlcontext.cxx b/sc/source/filter/orcus/xmlcontext.cxx index e47b862c2138..5494ddefc434 100644 --- a/sc/source/filter/orcus/xmlcontext.cxx +++ b/sc/source/filter/orcus/xmlcontext.cxx @@ -24,6 +24,7 @@ #include <orcus/orcus_xml.hpp> #include <orcus/global.hpp> #include <orcus/sax_parser_base.hpp> +#include <orcus/stream.hpp> #include <com/sun/star/ucb/XCommandEnvironment.hpp> #include <comphelper/processfactory.hxx> @@ -289,7 +290,9 @@ void ScOrcusXMLContextImpl::importXML(const ScOrcusImportXMLParam& rParam) } } - filter.read_file(path); + std::string content = orcus::load_file_content(path); + filter.read_stream(content.data(), content.size()); + aFactory.finalize(); } catch (const std::exception&) |