diff options
author | Balazs Varga <balazs.varga991@gmail.com> | 2021-01-13 16:17:30 +0100 |
---|---|---|
committer | László Németh <nemeth@numbertext.org> | 2021-01-21 11:34:53 +0100 |
commit | 0e751d0cb816197f15a2448ec36c57df17387e40 (patch) | |
tree | ab6d0f66fbd75323641f381bdd5b38d20d31c233 /sc/qa | |
parent | d62ad3efe3c8778cfda00799f1cd7bb3349e0b75 (diff) |
tdf#116818 sc,offapi,XLSX import: fix autofiltered date columns
by importing dateGroupItem.
Add property IsDateValue to com::sun::star::sheet::FilterFieldValue.
Note: ODS import/export and XLSX export haven't been supported, yet.
To check/show the fix manually, run the test with
$ (cd sc && make -srj8 UITest_autofilter UITEST_TEST_NAME="autofilter.AutofilterTest.test_tdf116818" SAL_USE_VCLPLUGIN=gen)
Change-Id: I033f1915c710589ff11fe97e9b39e45251976dfc
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/109233
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/uitest/autofilter/autofilter.py | 31 | ||||
-rw-r--r-- | sc/qa/uitest/data/autofilter/tdf116818.xlsx | bin | 0 -> 17310 bytes |
2 files changed, 31 insertions, 0 deletions
diff --git a/sc/qa/uitest/autofilter/autofilter.py b/sc/qa/uitest/autofilter/autofilter.py index bef8d43c6ef6..bc6360b2940c 100644 --- a/sc/qa/uitest/autofilter/autofilter.py +++ b/sc/qa/uitest/autofilter/autofilter.py @@ -201,4 +201,35 @@ class AutofilterTest(UITestCase): self.assertFalse(is_row_hidden(document, 2)) self.ui_test.close_doc() + + def test_tdf116818(self): + doc = self.ui_test.load_file(get_url_for_data_file("tdf116818.xlsx")) + + xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window") + + xGridWin.executeAction("LAUNCH", mkPropertyValues({"AUTOFILTER": "", "COL": "0", "ROW": "0"})) + xFloatWindow = self.xUITest.getFloatWindow() + xCheckListMenu = xFloatWindow.getChild("check_list_menu") + xTreeList = xCheckListMenu.getChild("check_tree_box") + self.assertEqual(3, len(xTreeList.getChildren())) + xOkBtn = xFloatWindow.getChild("cancel") + xOkBtn.executeAction("CLICK", tuple()) + + xGridWin.executeAction("LAUNCH", mkPropertyValues({"AUTOFILTER": "", "COL": "1", "ROW": "0"})) + xFloatWindow = self.xUITest.getFloatWindow() + xCheckListMenu = xFloatWindow.getChild("check_list_menu") + xTreeList = xCheckListMenu.getChild("check_list_box") + self.assertEqual(5, len(xTreeList.getChildren())) + xOkBtn = xFloatWindow.getChild("cancel") + xOkBtn.executeAction("CLICK", tuple()) + + xGridWin.executeAction("LAUNCH", mkPropertyValues({"AUTOFILTER": "", "COL": "2", "ROW": "0"})) + xFloatWindow = self.xUITest.getFloatWindow() + xCheckListMenu = xFloatWindow.getChild("check_list_menu") + xTreeList = xCheckListMenu.getChild("check_list_box") + self.assertEqual(3, len(xTreeList.getChildren())) + xOkBtn = xFloatWindow.getChild("cancel") + xOkBtn.executeAction("CLICK", tuple()) + + self.ui_test.close_doc() # vim: set shiftwidth=4 softtabstop=4 expandtab: diff --git a/sc/qa/uitest/data/autofilter/tdf116818.xlsx b/sc/qa/uitest/data/autofilter/tdf116818.xlsx Binary files differnew file mode 100644 index 000000000000..060615cc0444 --- /dev/null +++ b/sc/qa/uitest/data/autofilter/tdf116818.xlsx |