diff --git a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs index 16ec9c6..6d9b658 100644 --- a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs +++ b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs @@ -45,6 +45,17 @@ } [Test] + public void CanSuccessfullyLoadLOFiles() + { + var files = TestHelper.ListResourceFiles(s => s.Contains(".LO.")).ToArray(); + + foreach (var file in files) + { + TestHelper.LoadFile(file); + } + } + + [Test] public void CanLoadAndManipulateFileWithEmptyTable() { using (var stream = TestHelper.GetStreamFromResource(TestHelper.GetResourcePath(@"Misc\EmptyTable.xlsx"))) diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsm/pass/CVE-2016-0122-1.xlsm b/ClosedXML_Tests/Resource/Misc/LO/xlsm/pass/CVE-2016-0122-1.xlsm new file mode 100644 index 0000000..a86f92f --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsm/pass/CVE-2016-0122-1.xlsm Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsm/tdf111974.xlsm b/ClosedXML_Tests/Resource/Misc/LO/xlsm/tdf111974.xlsm new file mode 100644 index 0000000..bb6ac6d --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsm/tdf111974.xlsm Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsm/vba-user-function.xlsm b/ClosedXML_Tests/Resource/Misc/LO/xlsm/vba-user-function.xlsm new file mode 100644 index 0000000..a43a8eb --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsm/vba-user-function.xlsm Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/ProtecteSheet1234Pass.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/ProtecteSheet1234Pass.xlsx new file mode 100644 index 0000000..509ebe2 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/ProtecteSheet1234Pass.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/TextColor.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/TextColor.xlsx new file mode 100644 index 0000000..4de9387 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/TextColor.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/activex_checkbox.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/activex_checkbox.xlsx new file mode 100644 index 0000000..b37bf59 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/activex_checkbox.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/autofilter.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/autofilter.xlsx new file mode 100644 index 0000000..a8287c1 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/autofilter.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/bnc762542.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/bnc762542.xlsx new file mode 100644 index 0000000..1cda1fd --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/bnc762542.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/bug-fixes.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/bug-fixes.xlsx new file mode 100644 index 0000000..e0e179f --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/bug-fixes.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/built-in_ranges.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/built-in_ranges.xlsx new file mode 100644 index 0000000..b18a486 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/built-in_ranges.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/ceiling-floor.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/ceiling-floor.xlsx new file mode 100644 index 0000000..a98a355 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/ceiling-floor.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/cell-anchored-hidden-shapes.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cell-anchored-hidden-shapes.xlsx new file mode 100644 index 0000000..7e79cc3 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cell-anchored-hidden-shapes.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/cell-borders.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cell-borders.xlsx new file mode 100644 index 0000000..ed9c2e2 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cell-borders.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/cell-value.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cell-value.xlsx new file mode 100644 index 0000000..70c8d0d --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cell-value.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/check-boolean.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/check-boolean.xlsx new file mode 100644 index 0000000..a7643d1 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/check-boolean.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/colorscale.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/colorscale.xlsx new file mode 100644 index 0000000..c70a207 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/colorscale.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/colorscale_num_with_ref.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/colorscale_num_with_ref.xlsx new file mode 100644 index 0000000..931fe7a --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/colorscale_num_with_ref.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/column-style-autofilter.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/column-style-autofilter.xlsx new file mode 100644 index 0000000..67b2dd4 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/column-style-autofilter.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/column-style.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/column-style.xlsx new file mode 100644 index 0000000..57afe3e --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/column-style.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/column_style.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/column_style.xlsx new file mode 100644 index 0000000..d228443 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/column_style.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/complex_icon_set.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/complex_icon_set.xlsx new file mode 100644 index 0000000..32f1e52 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/complex_icon_set.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_format_formula_listener.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_format_formula_listener.xlsx new file mode 100644 index 0000000..97d7845 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_format_formula_listener.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_format_theme_color2.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_format_theme_color2.xlsx new file mode 100644 index 0000000..61c0d58 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_format_theme_color2.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_format_theme_color3.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_format_theme_color3.xlsx new file mode 100644 index 0000000..2e97684 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_format_theme_color3.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_parent.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_parent.xlsx new file mode 100644 index 0000000..90f9007 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/cond_parent.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/condformat_theme_color.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/condformat_theme_color.xlsx new file mode 100644 index 0000000..8bab237 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/condformat_theme_color.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/customxml.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/customxml.xlsx new file mode 100644 index 0000000..53619ae --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/customxml.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/data-table/multi-table.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/data-table/multi-table.xlsx new file mode 100644 index 0000000..c2bf488 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/data-table/multi-table.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/data-table/one-variable.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/data-table/one-variable.xlsx new file mode 100644 index 0000000..7ff098b --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/data-table/one-variable.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/databar.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/databar.xlsx new file mode 100644 index 0000000..bf43cd6 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/databar.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/database.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/database.xlsx new file mode 100644 index 0000000..646b79d --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/database.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/different-column-width-excel2010.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/different-column-width-excel2010.xlsx new file mode 100644 index 0000000..93f133f --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/different-column-width-excel2010.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/empty-noconf.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/empty-noconf.xlsx new file mode 100644 index 0000000..21f80b4 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/empty-noconf.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/empty.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/empty.xlsx new file mode 100644 index 0000000..c186485 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/empty.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/enhanced-protection.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/enhanced-protection.xlsx new file mode 100644 index 0000000..d9225a2 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/enhanced-protection.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/external-refs.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/external-refs.xlsx new file mode 100644 index 0000000..805e36c --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/external-refs.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/fontSize.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/fontSize.xlsx new file mode 100644 index 0000000..8811df7 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/fontSize.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/formats.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/formats.xlsx new file mode 100644 index 0000000..c75bbc7 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/formats.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/functions-excel-2010.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/functions-excel-2010.xlsx new file mode 100644 index 0000000..152fbbc --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/functions-excel-2010.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/hiddenShape.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/hiddenShape.xlsx new file mode 100644 index 0000000..3f38909 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/hiddenShape.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/hidden_sheets.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/hidden_sheets.xlsx new file mode 100644 index 0000000..771de7f --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/hidden_sheets.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/hyperlink.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/hyperlink.xlsx new file mode 100644 index 0000000..059e649 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/hyperlink.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/hyperlinks.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/hyperlinks.xlsx new file mode 100644 index 0000000..5faea7d --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/hyperlinks.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/matrix-multiplication.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/matrix-multiplication.xlsx new file mode 100644 index 0000000..f79d6b6 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/matrix-multiplication.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/miscrowheights.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/miscrowheights.xlsx new file mode 100644 index 0000000..dbdbc13 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/miscrowheights.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/named-ranges-global.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/named-ranges-global.xlsx new file mode 100644 index 0000000..fe90d6d --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/named-ranges-global.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/new_cond_format_test.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/new_cond_format_test.xlsx new file mode 100644 index 0000000..0750188 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/new_cond_format_test.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/new_cond_format_test_export.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/new_cond_format_test_export.xlsx new file mode 100644 index 0000000..0750188 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/new_cond_format_test_export.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/page_scale.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/page_scale.xlsx new file mode 100644 index 0000000..070f218 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/page_scale.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pass/CVE-2017-0199-1.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pass/CVE-2017-0199-1.xlsx new file mode 100644 index 0000000..39645bc --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pass/CVE-2017-0199-1.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pass/CVE-2017-0199-2.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pass/CVE-2017-0199-2.xlsx new file mode 100644 index 0000000..262c4be --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pass/CVE-2017-0199-2.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/many-fields-in-cache.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/many-fields-in-cache.xlsx new file mode 100644 index 0000000..2b39849 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/many-fields-in-cache.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-dategroup.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-dategroup.xlsx new file mode 100644 index 0000000..60cbd66 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-dategroup.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-group-field.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-group-field.xlsx new file mode 100644 index 0000000..2bc5cdd --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-group-field.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-nested-dategroup.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-nested-dategroup.xlsx new file mode 100644 index 0000000..4dfb55d --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-nested-dategroup.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-numgroup.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-numgroup.xlsx new file mode 100644 index 0000000..36f36ef --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/shared-numgroup.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/two-data-fields.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/two-data-fields.xlsx new file mode 100644 index 0000000..793af59 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/two-data-fields.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/with-strings-integers-and-dates.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/with-strings-integers-and-dates.xlsx new file mode 100644 index 0000000..882ed1a --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot-table/with-strings-integers-and-dates.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot_table_first_header_row.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot_table_first_header_row.xlsx new file mode 100644 index 0000000..664637d --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivot_table_first_header_row.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_bool_field_filter.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_bool_field_filter.xlsx new file mode 100644 index 0000000..8fcdb1b --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_bool_field_filter.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_date_field_filter.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_date_field_filter.xlsx new file mode 100644 index 0000000..316f201 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_date_field_filter.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_double_field_filter.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_double_field_filter.xlsx new file mode 100644 index 0000000..f2d3597 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_double_field_filter.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_duplicated_member_filter.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_duplicated_member_filter.xlsx new file mode 100644 index 0000000..21291a4 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_duplicated_member_filter.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_error_item_filter.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_error_item_filter.xlsx new file mode 100644 index 0000000..19d9b3c --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_error_item_filter.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_outline_mode.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_outline_mode.xlsx new file mode 100644 index 0000000..6b575c0 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_outline_mode.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_rowcolpage_field_filter.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_rowcolpage_field_filter.xlsx new file mode 100644 index 0000000..4aaa327 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_rowcolpage_field_filter.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_string_field_filter.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_string_field_filter.xlsx new file mode 100644 index 0000000..3bb6a77 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_string_field_filter.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_tabular_mode.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_tabular_mode.xlsx new file mode 100644 index 0000000..0bcfe17 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/pivottable_tabular_mode.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/preserve-whitespace.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/preserve-whitespace.xlsx new file mode 100644 index 0000000..c9f9794 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/preserve-whitespace.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/preserve_space.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/preserve_space.xlsx new file mode 100644 index 0000000..401a908 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/preserve_space.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/ref_string.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/ref_string.xlsx new file mode 100644 index 0000000..08076cb --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/ref_string.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/row-index-1-based.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/row-index-1-based.xlsx new file mode 100644 index 0000000..1f60c3b --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/row-index-1-based.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/shared-formula/3d-reference.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/shared-formula/3d-reference.xlsx new file mode 100644 index 0000000..2fb95b5 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/shared-formula/3d-reference.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/shared-formula/basic.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/shared-formula/basic.xlsx new file mode 100644 index 0000000..64d0501 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/shared-formula/basic.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/shared-formula/text-results.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/shared-formula/text-results.xlsx new file mode 100644 index 0000000..3f59bc3 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/shared-formula/text-results.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/sheet-names.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/sheet-names.xlsx new file mode 100644 index 0000000..97e0488 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/sheet-names.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/sheet-tab-color.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/sheet-tab-color.xlsx new file mode 100644 index 0000000..896bc3b --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/sheet-tab-color.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/singlecontrol.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/singlecontrol.xlsx new file mode 100644 index 0000000..513c05b --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/singlecontrol.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/strike-through.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/strike-through.xlsx new file mode 100644 index 0000000..ca56768 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/strike-through.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf100709.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf100709.xlsx new file mode 100644 index 0000000..87698bb --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf100709.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf104310-2.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf104310-2.xlsx new file mode 100644 index 0000000..dc5e9ac --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf104310-2.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf104310.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf104310.xlsx new file mode 100644 index 0000000..95570d3 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf104310.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf105840_allRowsHidden.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf105840_allRowsHidden.xlsx new file mode 100644 index 0000000..e2c22cd --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf105840_allRowsHidden.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf110440.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf110440.xlsx new file mode 100644 index 0000000..da849d0 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf110440.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf111876.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf111876.xlsx new file mode 100644 index 0000000..a12f14c --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf111876.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf112106.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf112106.xlsx new file mode 100644 index 0000000..37203d1 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf112106.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf81939.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf81939.xlsx new file mode 100644 index 0000000..6614a1e --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf81939.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf83672.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf83672.xlsx new file mode 100644 index 0000000..0469682 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf83672.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf89139_pivot_table.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf89139_pivot_table.xlsx new file mode 100644 index 0000000..83d5b3d --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf89139_pivot_table.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf97598_scenarios.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf97598_scenarios.xlsx new file mode 100644 index 0000000..ba3f43f --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/tdf97598_scenarios.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/textbox-CharKerningSpace.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/textbox-CharKerningSpace.xlsx new file mode 100644 index 0000000..64b6856 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/textbox-CharKerningSpace.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/textbox-CondensedCharacterSpace.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/textbox-CondensedCharacterSpace.xlsx new file mode 100644 index 0000000..fb46fef --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/textbox-CondensedCharacterSpace.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/textbox-hyperlink.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/textbox-hyperlink.xlsx new file mode 100644 index 0000000..bbebca9 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/textbox-hyperlink.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/track-changes/simple-cell-changes.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/track-changes/simple-cell-changes.xlsx new file mode 100644 index 0000000..29e8027 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/track-changes/simple-cell-changes.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/underlineColor.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/underlineColor.xlsx new file mode 100644 index 0000000..124391b --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/underlineColor.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/universal-content-strict.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/universal-content-strict.xlsx new file mode 100644 index 0000000..32beb4d --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/universal-content-strict.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/universal-content.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/universal-content.xlsx new file mode 100644 index 0000000..687a583 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/universal-content.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/writingMode.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/writingMode.xlsx new file mode 100644 index 0000000..3cf9512 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/writingMode.xlsx Binary files differ diff --git a/ClosedXML_Tests/Resource/Misc/LO/xlsx/xf_default_values.xlsx b/ClosedXML_Tests/Resource/Misc/LO/xlsx/xf_default_values.xlsx new file mode 100644 index 0000000..79aaea7 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/LO/xlsx/xf_default_values.xlsx Binary files differ