sc/qa/uitest/calc_tests3/tdf96499.py | 48 +
sc/qa/uitest/data/tdf96499.html | 889 +++++++++++++++++++++++++++++++++++
2 files changed, 937 insertions(+)
New commits:
commit 9d02b1edafd44b75a8996a97c329fdd4967e8f54
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Mon Feb 7 16:32:33 2022 +0100
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Mon Feb 7 20:10:04 2022 +0100
tdf#96499: sc: Add UItest
Change-Id: Ie81d5cfd493cb25698b48f406f5eaaa68e14e2e3
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/129604
Tested-by: Xisco Fauli <xiscofa...@libreoffice.org>
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/uitest/calc_tests3/tdf96499.py
b/sc/qa/uitest/calc_tests3/tdf96499.py
new file mode 100644
index 000000000000..b96225c18dc4
--- /dev/null
+++ b/sc/qa/uitest/calc_tests3/tdf96499.py
@@ -0,0 +1,48 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This file is part of the LibreOffice project.
+#
+# 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/.
+#
+
+from uitest.framework import UITestCase
+from uitest.uihelper.common import get_state_as_dict
+from uitest.uihelper.common import select_pos
+from libreoffice.uno.propertyvalue import mkPropertyValues
+from uitest.uihelper.common import get_url_for_data_file
+from libreoffice.calc.document import get_cell_by_position
+
+class tdf96499(UITestCase):
+
+ def test_tdf96499(self):
+
+ with self.ui_test.create_doc_in_start_center("calc") as document:
+
+ with
self.ui_test.execute_dialog_through_command(".uno:InsertExternalDataSource",
close_button="") as xDialog:
+ xUrl = xDialog.getChild("url")
+
+ xUrl.executeAction("TYPE", mkPropertyValues({"TEXT":
get_url_for_data_file("tdf96499.html")}))
+
+ with self.ui_test.execute_blocking_action(
+ xUrl.executeAction, args=("TYPE",
mkPropertyValues({"KEYCODE": "RETURN"}))):
+ pass
+
+ xRanges = xDialog.getChild("ranges")
+
+ self.assertEqual("3", get_state_as_dict(xRanges)["Children"])
+
+ # FIXME: close_dialog_through_button fails here
+ xOkBtn = xDialog.getChild("ok")
+ xOkBtn.executeAction("CLICK", tuple())
+
+ self.assertEqual("银行卡号", get_cell_by_position(document, 0, 0,
0).getString())
+ self.assertEqual("身份证号", get_cell_by_position(document, 0, 1,
0).getString())
+
+ for i in range (1, 10):
+ # Without the fix in place, this test would have failed with
+ # AssertionError: '4100025601074122197' !=
'4,10002560107412E+018'
+ self.assertEqual("4100025601074122197",
get_cell_by_position(document, 0, 0, i).getString())
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/data/tdf96499.html b/sc/qa/uitest/data/tdf96499.html
new file mode 100644
index 000000000000..74c4791c9c06
--- /dev/null
+++ b/sc/qa/uitest/data/tdf96499.html
@@ -0,0 +1,889 @@
+<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40";>
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
+ <meta name="ProgId" content="Excel.Sheet"/>
+ <meta name="Generator" content="WPS Office ET"/>
+ <!--[if gte mso 9]>
+ <xml>
+ <o:DocumentProperties>
+ <o:Created>2015-12-09T15:31:18</o:Created>
+ <o:LastAuthor>a</o:LastAuthor>
+ <o:LastSaved>2015-12-09T15:32:11</o:LastSaved>
+ </o:DocumentProperties>
+ <o:CustomDocumentProperties>
+ <o:KSOProductBuildVer
dt:dt="string">2052-10.1.0.5399</o:KSOProductBuildVer>
+ </o:CustomDocumentProperties>
+ </xml>
+ <![endif]-->
+ <style>
+<!-- @page
+ {margin:0.98in 0.75in 0.98in 0.75in;
+ mso-header-margin:0.51in;
+ mso-footer-margin:0.51in;}
+tr
+ {mso-height-source:auto;
+ mso-ruby-visibility:none;}
+col
+ {mso-width-source:auto;
+ mso-ruby-visibility:none;}
+br
+ {mso-data-placement:same-cell;}
+.font0
+ {color:windowtext;
+ font-size:12.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:134;}
+.font1
+ {color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:134;}
+.font2
+ {color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font3
+ {color:#44546A;
+ font-size:15.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:134;}
+.font4
+ {color:#44546A;
+ font-size:13.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:134;}
+.font5
+ {color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font6
+ {color:#9C0006;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font7
+ {color:#9C6500;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font8
+ {color:#3F3F76;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font9
+ {color:#44546A;
+ font-size:11.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:134;}
+.font10
+ {color:#0000FF;
+ font-size:12.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:underline;
+ text-underline-style:single;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:134;}
+.font11
+ {color:#800080;
+ font-size:12.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:underline;
+ text-underline-style:single;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:134;}
+.font12
+ {color:#FF0000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font13
+ {color:#44546A;
+ font-size:18.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:134;}
+.font14
+ {color:#7F7F7F;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:italic;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font15
+ {color:#3F3F3F;
+ font-size:11.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font16
+ {color:#FA7D00;
+ font-size:11.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font17
+ {color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font18
+ {color:#FA7D00;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font19
+ {color:#000000;
+ font-size:11.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.font20
+ {color:#006100;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:"宋体";
+ mso-generic-font-family:auto;
+ mso-font-charset:0;}
+.style0
+ {mso-number-format:"General";
+ text-align:general;
+ vertical-align:middle;
+ white-space:nowrap;
+ mso-rotate:0;
+ color:windowtext;
+ font-size:12.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-font-charset:134;
+ border:none;
+ mso-protection:locked visible;
+ mso-style-name:"常规";
+ mso-style-id:0;}
+.style16
+ {mso-number-format:"_ \0022\00A5\0022* \#\,\#\#0_ \;_ \0022\00A5\0022*
\\-\#\,\#\#0_ \;_ \0022\00A5\0022* \0022-\0022_ \;_ \@_ ";
+ mso-style-name:"货币[0]";
+ mso-style-id:7;}
+.style17
+ {mso-pattern:auto none;
+ background:#EDEDED;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"20% - 强调文字颜色 3";}
+.style18
+ {mso-pattern:auto none;
+ background:#FFCC99;
+ color:#3F3F76;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ border:.5pt solid #7F7F7F;
+ mso-style-name:"输入";}
+.style19
+ {mso-number-format:"_ \0022\00A5\0022* \#\,\#\#0\.00_ \;_
\0022\00A5\0022* \\-\#\,\#\#0\.00_ \;_ \0022\00A5\0022* \0022-\0022??_ \;_ \@_
";
+ mso-style-name:"货币";
+ mso-style-id:4;}
+.style20
+ {mso-number-format:"_ * \#\,\#\#0_ \;_ * \\-\#\,\#\#0_ \;_ *
\0022-\0022_ \;_ \@_ ";
+ mso-style-name:"千位分隔[0]";
+ mso-style-id:6;}
+.style21
+ {mso-pattern:auto none;
+ background:#DBDBDB;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"40% - 强调文字颜色 3";}
+.style22
+ {mso-pattern:auto none;
+ background:#FFC7CE;
+ color:#9C0006;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"差";}
+.style23
+ {mso-number-format:"_ * \#\,\#\#0\.00_ \;_ * \\-\#\,\#\#0\.00_ \;_ *
\0022-\0022??_ \;_ \@_ ";
+ mso-style-name:"千位分隔";
+ mso-style-id:3;}
+.style24
+ {mso-pattern:auto none;
+ background:#C9C9C9;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"60% - 强调文字颜色 3";}
+.style25
+ {color:#0000FF;
+ font-size:12.0pt;
+ text-decoration:underline;
+ text-underline-style:single;
+ font-family:宋体;
+ mso-style-name:"超链接";
+ mso-style-id:8;}
+.style26
+ {mso-number-format:"0%";
+ mso-style-name:"百分比";
+ mso-style-id:5;}
+.style27
+ {color:#800080;
+ font-size:12.0pt;
+ text-decoration:underline;
+ text-underline-style:single;
+ font-family:宋体;
+ mso-style-name:"已访问的超链接";
+ mso-style-id:9;}
+.style28
+ {mso-pattern:auto none;
+ background:#FFFFCC;
+ border:.5pt solid #B2B2B2;
+ mso-style-name:"注释";}
+.style29
+ {mso-pattern:auto none;
+ background:#F4B084;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"60% - 强调文字颜色 2";}
+.style30
+ {color:#44546A;
+ font-size:11.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:134;
+ mso-style-name:"标题 4";}
+.style31
+ {color:#FF0000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"警告文本";}
+.style32
+ {color:#44546A;
+ font-size:18.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:134;
+ mso-style-name:"标题";}
+.style33
+ {color:#7F7F7F;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:italic;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"解释性文本";}
+.style34
+ {color:#44546A;
+ font-size:15.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:134;
+ border-bottom:1.0pt solid #5B9BD5;
+ mso-style-name:"标题 1";}
+.style35
+ {color:#44546A;
+ font-size:13.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:134;
+ border-bottom:1.0pt solid #5B9BD5;
+ mso-style-name:"标题 2";}
+.style36
+ {mso-pattern:auto none;
+ background:#9BC2E6;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"60% - 强调文字颜色 1";}
+.style37
+ {color:#44546A;
+ font-size:11.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:134;
+ border-bottom:1.0pt solid #ACCCEA;
+ mso-style-name:"标题 3";}
+.style38
+ {mso-pattern:auto none;
+ background:#FFD966;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"60% - 强调文字颜色 4";}
+.style39
+ {mso-pattern:auto none;
+ background:#F2F2F2;
+ color:#3F3F3F;
+ font-size:11.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ border:.5pt solid #3F3F3F;
+ mso-style-name:"输出";}
+.style40
+ {mso-pattern:auto none;
+ background:#F2F2F2;
+ color:#FA7D00;
+ font-size:11.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ border:.5pt solid #7F7F7F;
+ mso-style-name:"计算";}
+.style41
+ {mso-pattern:auto none;
+ background:#A5A5A5;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ border:2.0pt double #3F3F3F;
+ mso-style-name:"检查单元格";}
+.style42
+ {mso-pattern:auto none;
+ background:#E2EFDA;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"20% - 强调文字颜色 6";}
+.style43
+ {mso-pattern:auto none;
+ background:#ED7D31;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"强调文字颜色 2";}
+.style44
+ {color:#FA7D00;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ border-bottom:2.0pt double #FF8001;
+ mso-style-name:"链接单元格";}
+.style45
+ {color:#000000;
+ font-size:11.0pt;
+ font-weight:700;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ border-top:.5pt solid #5B9BD5;
+ border-bottom:2.0pt double #5B9BD5;
+ mso-style-name:"汇总";}
+.style46
+ {mso-pattern:auto none;
+ background:#C6EFCE;
+ color:#006100;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"好";}
+.style47
+ {mso-pattern:auto none;
+ background:#FFEB9C;
+ color:#9C6500;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"适中";}
+.style48
+ {mso-pattern:auto none;
+ background:#D9E1F2;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"20% - 强调文字颜色 5";}
+.style49
+ {mso-pattern:auto none;
+ background:#5B9BD5;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"强调文字颜色 1";}
+.style50
+ {mso-pattern:auto none;
+ background:#DDEBF7;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"20% - 强调文字颜色 1";}
+.style51
+ {mso-pattern:auto none;
+ background:#BDD7EE;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"40% - 强调文字颜色 1";}
+.style52
+ {mso-pattern:auto none;
+ background:#FCE4D6;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"20% - 强调文字颜色 2";}
+.style53
+ {mso-pattern:auto none;
+ background:#F8CBAD;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"40% - 强调文字颜色 2";}
+.style54
+ {mso-pattern:auto none;
+ background:#A5A5A5;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"强调文字颜色 3";}
+.style55
+ {mso-pattern:auto none;
+ background:#FFC000;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"强调文字颜色 4";}
+.style56
+ {mso-pattern:auto none;
+ background:#FFF2CC;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"20% - 强调文字颜色 4";}
+.style57
+ {mso-pattern:auto none;
+ background:#FFE699;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"40% - 强调文字颜色 4";}
+.style58
+ {mso-pattern:auto none;
+ background:#4472C4;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"强调文字颜色 5";}
+.style59
+ {mso-pattern:auto none;
+ background:#B4C6E7;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"40% - 强调文字颜色 5";}
+.style60
+ {mso-pattern:auto none;
+ background:#8EA9DB;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"60% - 强调文字颜色 5";}
+.style61
+ {mso-pattern:auto none;
+ background:#70AD47;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"强调文字颜色 6";}
+.style62
+ {mso-pattern:auto none;
+ background:#C6E0B4;
+ color:#000000;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"40% - 强调文字颜色 6";}
+.style63
+ {mso-pattern:auto none;
+ background:#A9D08E;
+ color:#FFFFFF;
+ font-size:11.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-style-name:"60% - 强调文字颜色 6";}
+td
+ {mso-style-parent:style0;
+ padding-top:1px;
+ padding-right:1px;
+ padding-left:1px;
+ mso-ignore:padding;
+ mso-number-format:"General";
+ text-align:general;
+ vertical-align:middle;
+ white-space:nowrap;
+ mso-rotate:0;
+ color:windowtext;
+ font-size:12.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:宋体;
+ mso-font-charset:134;
+ border:none;
+ mso-protection:locked visible;}
+.xl65
+ {mso-style-parent:style0;
+ white-space:normal;
+ mso-font-charset:134;
+ border:.5pt solid #000000;}
+.xl66
+ {mso-style-parent:style0;
+ white-space:normal;
+ mso-font-charset:134;
+ border-top:.5pt solid #000000;
+ border-right:.5pt solid #000000;
+ border-bottom:.5pt solid #000000;}
+.xl67
+ {mso-style-parent:style0;
+ mso-number-format:"\@";
+ white-space:normal;
+ mso-font-charset:134;
+ border-left:.5pt solid #000000;
+ border-right:.5pt solid #000000;
+ border-bottom:.5pt solid #000000;}
+.xl68
+ {mso-style-parent:style0;
+ mso-number-format:"\@";
+ white-space:normal;
+ mso-font-charset:134;
+ border-right:.5pt solid #000000;
+ border-bottom:.5pt solid #000000;}
+ --> </style>
+ <!--[if gte mso 9]>
+ <xml>
+ <x:ExcelWorkbook>
+ <x:ExcelWorksheets>
+ <x:ExcelWorksheet>
+ <x:Name>离职</x:Name>
+ <x:WorksheetOptions>
+ <x:DefaultRowHeight>285</x:DefaultRowHeight>
+ <x:Selected/>
+ <x:Panes>
+ <x:Pane>
+ <x:Number>3</x:Number>
+ <x:ActiveCol>8</x:ActiveCol>
+ <x:ActiveRow>17</x:ActiveRow>
+ <x:RangeSelection>I18</x:RangeSelection>
+ </x:Pane>
+ </x:Panes>
+ <x:DoNotDisplayGridlines/>
+ <x:ProtectContents>False</x:ProtectContents>
+ <x:ProtectObjects>False</x:ProtectObjects>
+ <x:ProtectScenarios>False</x:ProtectScenarios>
+ <x:PageBreakZoom>100</x:PageBreakZoom>
+ <x:Print>
+ <x:PaperSizeIndex>9</x:PaperSizeIndex>
+ </x:Print>
+ </x:WorksheetOptions>
+ </x:ExcelWorksheet>
+ </x:ExcelWorksheets>
+ <x:ProtectStructure>False</x:ProtectStructure>
+ <x:ProtectWindows>False</x:ProtectWindows>
+ <x:SelectedSheets>0</x:SelectedSheets>
+ <x:WindowHeight>12435</x:WindowHeight>
+ <x:WindowWidth>19095</x:WindowWidth>
+ </x:ExcelWorkbook>
+ </xml>
+ <![endif]-->
+ </head>
+ <body link="blue" vlink="purple">
+ <table width="337" border="0" cellpadding="0" cellspacing="0"
style='width:252.75pt;border-collapse:collapse;table-layout:fixed;'>
+ <col width="173" style='mso-width-source:userset;mso-width-alt:5536;'/>
+ <col width="164" style='mso-width-source:userset;mso-width-alt:5248;'/>
+ <tr height="19" style='height:14.25pt;'>
+ <td class="xl65" height="19" width="173"
style='height:14.25pt;width:129.75pt;' x:str>银行卡号</td>
+ <td class="xl66" width="164" style='width:123.00pt;' x:str>身份证号</td>
+ </tr>
+ <tr height="19" style='height:14.25pt;'>
+ <td class="xl67" height="19" style='height:14.25pt;'
x:str>4100025601074122197</td>
+ <td class="xl68" x:str>350627197809253585</td>
+ </tr>
+ <tr height="19" style='height:14.25pt;'>
+ <td class="xl67" height="19" style='height:14.25pt;'
x:str>4100025601074122197</td>
+ <td class="xl68" x:str>522226198707114824</td>
+ </tr>
+ <tr height="19" style='height:14.25pt;'>
+ <td class="xl67" height="19" style='height:14.25pt;'
x:str>4100025601074122197</td>
+ <td class="xl68" x:str>522221199410104927</td>
+ </tr>
+ <tr height="19" style='height:14.25pt;'>
+ <td class="xl67" height="19" style='height:14.25pt;'
x:str>4100025601074122197</td>
+ <td class="xl68" x:str>411502199103159021</td>
+ </tr>
+ <tr height="19" style='height:14.25pt;'>
+ <td class="xl67" height="19" style='height:14.25pt;'
x:str>4100025601074122197</td>
+ <td class="xl68" x:str>42062519890201532X</td>
+ </tr>
+ <tr height="19" style='height:14.25pt;'>
+ <td class="xl67" height="19" style='height:14.25pt;'
x:str>4100025601074122197</td>
+ <td class="xl68" x:str>350426198609203513</td>
+ </tr>
+ <tr height="19" style='height:14.25pt;'>
+ <td class="xl67" height="19" style='height:14.25pt;'
x:str>4100025601074122197</td>
+ <td class="xl68" x:str>430481197909111223</td>
+ </tr>
+ <tr height="19" style='height:14.25pt;'>
+ <td class="xl67" height="19" style='height:14.25pt;'
x:str>4100025601074122197</td>
+ <td class="xl68" x:str>452524197106103880</td>
+ </tr>
+ <tr height="19" style='height:14.25pt;'>
+ <td class="xl67" height="19" style='height:14.25pt;'
x:str>4100025601074122197</td>
+ <td class="xl68" x:str>350628198907113536</td>
+ </tr>
+ <![if supportMisalignedColumns]>
+ <tr width="0" style='display:none;'>
+ <td width="173" style='width:130;'></td>
+ <td width="164" style='width:123;'></td>
+ </tr>
+ <![endif]>
+ </table>
+ </body>
+</html>
