diff options
Diffstat (limited to 'src/libixion/document_test.cpp')
| -rw-r--r-- | src/libixion/document_test.cpp | 190 |
1 files changed, 190 insertions, 0 deletions
diff --git a/src/libixion/document_test.cpp b/src/libixion/document_test.cpp new file mode 100644 index 0000000..fb14264 --- /dev/null +++ b/src/libixion/document_test.cpp @@ -0,0 +1,190 @@ +/* -*- 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 "test_global.hpp" // This must be the first header to be included. + +#include <ixion/document.hpp> +#include <ixion/address.hpp> +#include <ixion/macros.hpp> +#include <ixion/cell_access.hpp> + +#include <iostream> +#include <cassert> +#include <sstream> + +using namespace std; +using namespace ixion; + +namespace { + +bool equal(double v1, double v2) +{ + // To work around the floating point rounding errors, convert the values to + // strings then compare as string numbers. + std::ostringstream os1, os2; + os1 << v1; + os2 << v2; + return os1.str() == os2.str(); +} + +} + +void test_basic_calc() +{ + IXION_TEST_FUNC_SCOPE; + + abs_address_t A1(0, 0, 0); + abs_address_t A2(0, 1, 0); + abs_address_t A3(0, 2, 0); + + document doc; + doc.append_sheet("test"); + doc.set_numeric_cell("A1", 1.1); + doc.set_numeric_cell(A2, 1.2); + doc.set_numeric_cell({IXION_ASCII("A3")}, 1.3); + + assert(doc.get_numeric_value(A1) == 1.1); + assert(doc.get_numeric_value("A2") == 1.2); + assert(doc.get_numeric_value(A3) == 1.3); + + doc.set_formula_cell("B4", "SUM(A1:A3)"); + doc.calculate(0); + + double v = doc.get_numeric_value("B4"); + assert(equal(v, 3.6)); + + doc.empty_cell(A2); + doc.calculate(0); + v = doc.get_numeric_value("B4"); + assert(equal(v, 2.4)); +} + +void test_string_io() +{ + IXION_TEST_FUNC_SCOPE; + + document doc; + doc.append_sheet("test"); + + std::string B3("B3"), C4("C4"), D5("D5"), D5_value("Cell D5 value"); + doc.set_string_cell(B3, "Cell B3"); + doc.set_string_cell(C4, "Cell C4"); + doc.set_string_cell(D5, D5_value); + + std::string_view s = doc.get_string_value(B3); + assert(s == "Cell B3"); + + s = doc.get_string_value(C4); + assert(s == "Cell C4"); + + s = doc.get_string_value(D5); + assert(s == D5_value); + + doc.set_formula_cell("A10", "CONCATENATE(B3, \" and \", C4)"); + doc.calculate(0); + + s = doc.get_string_value("A10"); + assert(s == "Cell B3 and Cell C4"); + + doc.empty_cell(C4); + doc.calculate(0); + + s = doc.get_string_value("A10"); + assert(s == "Cell B3 and "); +} + +void test_boolean_io() +{ + IXION_TEST_FUNC_SCOPE; + + document doc; + doc.append_sheet("test1"); + doc.append_sheet("test2"); + + doc.set_boolean_cell("test2!B2", true); + doc.set_boolean_cell("test2!C3", false); + + doc.set_formula_cell("test1!A1", "SUM(test2!A1:D4)"); + doc.calculate(0); + double v = doc.get_numeric_value("test1!A1"); + assert(v == 1.0); + + // Trigger recalculation. + doc.set_boolean_cell("test2!C4", true); + doc.calculate(0); + v = doc.get_numeric_value("test1!A1"); + assert(v == 2.0); + + cell_access ca = doc.get_cell_access("test2!B2"); + assert(ca.get_type() == celltype_t::boolean); + assert(ca.get_value_type() == cell_value_t::boolean); + + ca = doc.get_cell_access("test2!C3"); + assert(ca.get_type() == celltype_t::boolean); + assert(ca.get_value_type() == cell_value_t::boolean); +} + +void test_custom_cell_address_syntax() +{ + IXION_TEST_FUNC_SCOPE; + + document doc(formula_name_resolver_t::excel_r1c1); + doc.append_sheet("MySheet"); + + doc.set_numeric_cell("R3C3", 345.0); + abs_address_t R3C3(0, 2, 2); + double v = doc.get_numeric_value(R3C3); + assert(v == 345.0); +} + +void test_rename_sheets() +{ + IXION_TEST_FUNC_SCOPE; + + document doc(formula_name_resolver_t::excel_r1c1); + doc.append_sheet("Sheet1"); + doc.append_sheet("Sheet2"); + doc.append_sheet("Sheet3"); + doc.set_numeric_cell("Sheet3!R3C3", 456.0); + + double v = doc.get_numeric_value("Sheet3!R3C3"); + assert(v == 456.0); + + doc.set_sheet_name(0, "S1"); + doc.set_sheet_name(1, "S2"); + doc.set_sheet_name(2, "S3"); + + v = doc.get_numeric_value("S3!R3C3"); + assert(v == 456.0); + + doc.set_numeric_cell("S2!R4C2", 789.0); + v = doc.get_numeric_value("S2!R4C2"); + assert(v == 789.0); + + try + { + doc.get_numeric_value("Sheet3!R3C3"); + assert(!"Exception should've been thrown."); + } + catch (const std::invalid_argument&) + { + // correct exception + } +} + +int main() +{ + test_basic_calc(); + test_string_io(); + test_boolean_io(); + test_custom_cell_address_syntax(); + test_rename_sheets(); + + return EXIT_SUCCESS; +} + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |