summaryrefslogtreecommitdiff
path: root/sc/qa
diff options
context:
space:
mode:
authorTünde Tóth <toth.tunde@nisz.hu>2021-03-24 14:07:15 +0100
committerLászló Németh <nemeth@numbertext.org>2021-03-30 13:36:24 +0200
commitae60c27f936642ecd4391d11fcd73a6d461d0b7f (patch)
tree66cbd17e135fdfd74578c17a04b3d1df8836f184 /sc/qa
parent7622d225efa0459ceaecbf947c0912823b5ff5c8 (diff)
tdf#99913 XLSX import: set filtered flag for rows
hidden by AutoFilter to support copying the result of filtering. Unlike ODS and XLS, XLSX doesn't differentiates filtered and manually hidden rows, and without this fix, copy of the unupdated data of the loaded filtering contained the hidden rows, too. Change-Id: I390d1a84b9bf275f3d3782756553b2f236487758 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/113040 Tested-by: László Németh <nemeth@numbertext.org> Reviewed-by: László Németh <nemeth@numbertext.org>
Diffstat (limited to 'sc/qa')
-rw-r--r--sc/qa/unit/uicalc/data/tdf99913.xlsxbin0 -> 8829 bytes
-rw-r--r--sc/qa/unit/uicalc/uicalc.cxx9
2 files changed, 9 insertions, 0 deletions
diff --git a/sc/qa/unit/uicalc/data/tdf99913.xlsx b/sc/qa/unit/uicalc/data/tdf99913.xlsx
new file mode 100644
index 000000000000..3fd18a12984a
--- /dev/null
+++ b/sc/qa/unit/uicalc/data/tdf99913.xlsx
Binary files differ
diff --git a/sc/qa/unit/uicalc/uicalc.cxx b/sc/qa/unit/uicalc/uicalc.cxx
index 818361ec9d83..48cde55df479 100644
--- a/sc/qa/unit/uicalc/uicalc.cxx
+++ b/sc/qa/unit/uicalc/uicalc.cxx
@@ -1387,6 +1387,15 @@ CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf116215)
CPPUNIT_ASSERT_EQUAL(OUString("=SUM(A2:B2)"), aFormula);
}
+CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf99913)
+{
+ ScModelObj* pModelObj = createDoc("tdf99913.xlsx");
+ ScDocument* pDoc = pModelObj->GetDocument();
+ CPPUNIT_ASSERT(pDoc);
+
+ CPPUNIT_ASSERT(pDoc->RowFiltered(2, 0));
+}
+
CPPUNIT_PLUGIN_IMPLEMENT();
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */