summaryrefslogtreecommitdiffstats
path: root/src/spreadsheet/document_impl.cpp
diff options
context:
space:
mode:
Diffstat (limited to 'src/spreadsheet/document_impl.cpp')
-rw-r--r--src/spreadsheet/document_impl.cpp232
1 files changed, 232 insertions, 0 deletions
diff --git a/src/spreadsheet/document_impl.cpp b/src/spreadsheet/document_impl.cpp
new file mode 100644
index 0000000..db6050a
--- /dev/null
+++ b/src/spreadsheet/document_impl.cpp
@@ -0,0 +1,232 @@
+/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
+/*
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ */
+
+#include "document_impl.hpp"
+
+#include <algorithm>
+
+namespace orcus { namespace spreadsheet { namespace detail {
+
+namespace {
+
+class find_column_by_name
+{
+ std::string_view m_name;
+public:
+ find_column_by_name(std::string_view name) : m_name(name) {}
+
+ bool operator() (const table_column_t& col) const
+ {
+ return col.name == m_name;
+ }
+};
+
+void adjust_row_range(ixion::abs_range_t& range, const table_t& tab, ixion::table_areas_t areas)
+{
+ bool headers = (areas & ixion::table_area_headers);
+ bool data = (areas & ixion::table_area_data);
+ bool totals = (areas & ixion::table_area_totals);
+
+ if (headers)
+ {
+ if (data)
+ {
+ if (totals)
+ {
+ // All areas.
+ return;
+ }
+
+ // Headers + data
+ range.last.row -= tab.totals_row_count;
+ return;
+ }
+
+ if (totals)
+ {
+ // Header + total is invalid.
+ range = ixion::abs_range_t(ixion::abs_range_t::invalid);
+ return;
+ }
+
+ // Headers only.
+ range.last.row = range.first.row;
+ return;
+ }
+
+ if (data)
+ {
+ ++range.first.row;
+
+ if (totals)
+ {
+ // Data + total
+ return;
+ }
+
+ // Data only
+ range.last.row -= tab.totals_row_count;
+ return;
+ }
+
+ if (totals)
+ {
+ // Total only
+ if (!tab.totals_row_count)
+ {
+ // This table has not total rows. Return empty range.
+ range = ixion::abs_range_t();
+ return;
+ }
+
+ range.first.row = range.last.row - tab.totals_row_count - 1;
+ return;
+ }
+
+ // Empty range.
+ range = ixion::abs_range_t();
+}
+
+}
+
+sheet_item::sheet_item(document& doc, std::string_view _name, sheet_t sheet_index) :
+ name(_name), data(doc, sheet_index) {}
+
+
+const table_t* ixion_table_handler::find_table(const ixion::abs_address_t& pos) const
+{
+ auto it = m_tables.begin(), it_end = m_tables.end();
+ for (; it != it_end; ++it)
+ {
+ const table_t* p = it->second.get();
+ if (p->range.contains(pos))
+ return p;
+ }
+
+ return nullptr;
+}
+
+std::string_view ixion_table_handler::get_string(ixion::string_id_t sid) const
+{
+ if (sid == ixion::empty_string_id)
+ return std::string_view{};
+
+ const std::string* p = m_context.get_string(sid);
+ if (!p || p->empty())
+ return std::string_view{};
+
+ return std::string_view(p->data(), p->size());
+}
+
+col_t ixion_table_handler::find_column(const table_t& tab, std::string_view name, size_t offset) const
+{
+ if (offset >= tab.columns.size())
+ return -1;
+
+ table_t::columns_type::const_iterator it_beg = tab.columns.begin();
+ table_t::columns_type::const_iterator it_end = tab.columns.end();
+
+ std::advance(it_beg, offset);
+ table_t::columns_type::const_iterator it =
+ std::find_if(it_beg, it_end, find_column_by_name(name));
+
+ if (it == it_end)
+ // not found.
+ return -1;
+
+ size_t dist = std::distance(tab.columns.begin(), it);
+ return tab.range.first.column + dist;
+}
+
+ixion::abs_range_t ixion_table_handler::get_range_from_table(
+ const table_t& tab, ixion::string_id_t column_first, ixion::string_id_t column_last,
+ ixion::table_areas_t areas) const
+{
+ if (column_first != ixion::empty_string_id)
+ {
+ std::string_view col1_name = get_string(column_first);
+ if (col1_name.empty())
+ return ixion::abs_range_t(ixion::abs_range_t::invalid);
+
+ col_t col1_index = find_column(tab, col1_name, 0);
+ if (col1_index < 0)
+ return ixion::abs_range_t(ixion::abs_range_t::invalid);
+
+ if (column_last != ixion::empty_string_id)
+ {
+ std::string_view col2_name = get_string(column_last);
+ if (!col2_name.empty())
+ {
+ // column range table reference.
+ col_t col2_index = find_column(tab, col2_name, col1_index);
+ ixion::abs_range_t range = tab.range;
+ range.first.column = col1_index;
+ range.last.column = col2_index;
+ adjust_row_range(range, tab, areas);
+ return range;
+ }
+ }
+
+ // single column table reference.
+ ixion::abs_range_t range = tab.range;
+ range.first.column = range.last.column = col1_index;
+ adjust_row_range(range, tab, areas);
+ return range;
+ }
+
+ return ixion::abs_range_t();
+}
+
+ixion_table_handler::ixion_table_handler(const ixion::model_context& cxt, const table_store_type& tables) :
+ m_context(cxt), m_tables(tables) {}
+
+ixion::abs_range_t ixion_table_handler::get_range(
+ const ixion::abs_address_t& pos, ixion::string_id_t column_first, ixion::string_id_t column_last,
+ ixion::table_areas_t areas) const
+{
+ const table_t* tab = find_table(pos);
+ if (!tab)
+ return ixion::abs_range_t(ixion::abs_range_t::invalid);
+
+ return get_range_from_table(*tab, column_first, column_last, areas);
+
+}
+
+ixion::abs_range_t ixion_table_handler::get_range(
+ ixion::string_id_t table, ixion::string_id_t column_first, ixion::string_id_t column_last,
+ ixion::table_areas_t areas) const
+{
+ std::string_view tab_name = get_string(table);
+ if (tab_name.empty())
+ // no table name given.
+ return ixion::abs_range_t(ixion::abs_range_t::invalid);
+
+ auto it = m_tables.find(tab_name);
+ if (it == m_tables.end())
+ // no table by this name found.
+ return ixion::abs_range_t(ixion::abs_range_t::invalid);
+
+ const table_t* tab = it->second.get();
+ return get_range_from_table(*tab, column_first, column_last, areas);
+}
+
+document_impl::document_impl(document& _doc, const range_size_t& sheet_size) :
+ doc(_doc),
+ context({sheet_size.rows, sheet_size.columns}),
+ styles_store(),
+ ss_store(context),
+ pivots(doc),
+ name_resolver_global(ixion::formula_name_resolver::get(ixion::formula_name_resolver_t::excel_a1, &context)),
+ grammar(formula_grammar_t::xlsx),
+ table_handler(context, tables)
+{
+ context.set_table_handler(&table_handler);
+}
+
+}}}
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */