diff options
| author | Balazs Varga <balazs.varga991@gmail.com> | 2021-03-02 22:46:33 +0100 |
|---|---|---|
| committer | László Németh <nemeth@numbertext.org> | 2021-03-12 12:20:48 +0100 |
| commit | 26032e63abd01c3d5941a2728ef024da290d6b0a (patch) | |
| tree | 4a30aeec14215ffd5aef9804c2c0fbba4cf1f5f1 /sc/qa/uitest | |
| parent | 2fce798d70bb39fe1b1dc95e2661e5836026de1a (diff) | |
tdf#137626 XLSX import: fix missing datetime filters
by convert string representation of the datetime data
to ISO 8601 (with blank instead of T) datetime to
eliminate locale dependent behaviour when filtering
for datetimes.
Follow-up of commit 0e751d0cb816197f15a2448ec36c57df17387e40
(tdf#116818 sc,offapi,XLSX import: fix autofiltered date columns).
Change-Id: I3a0f41dbbf28a1a60a54fe7b2c8c338516edb079
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/111851
Tested-by: László Németh <nemeth@numbertext.org>
Reviewed-by: László Németh <nemeth@numbertext.org>
Diffstat (limited to 'sc/qa/uitest')
| -rw-r--r-- | sc/qa/uitest/autofilter/autofilter.py | 15 | ||||
| -rw-r--r-- | sc/qa/uitest/data/autofilter/tdf137626.xlsx | bin | 0 -> 11284 bytes |
2 files changed, 15 insertions, 0 deletions
diff --git a/sc/qa/uitest/autofilter/autofilter.py b/sc/qa/uitest/autofilter/autofilter.py index ca1871ee933c..2c4f36947929 100644 --- a/sc/qa/uitest/autofilter/autofilter.py +++ b/sc/qa/uitest/autofilter/autofilter.py @@ -309,4 +309,19 @@ class AutofilterTest(UITestCase): xOkBtn.executeAction("CLICK", tuple()) self.ui_test.close_doc() + + def test_tdf137626(self): + doc = self.ui_test.load_file(get_url_for_data_file("tdf137626.xlsx")) + + xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window") + + 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(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/tdf137626.xlsx b/sc/qa/uitest/data/autofilter/tdf137626.xlsx Binary files differnew file mode 100644 index 000000000000..eb5ce4da7b98 --- /dev/null +++ b/sc/qa/uitest/data/autofilter/tdf137626.xlsx |