CellHelp.html 92.2 KB

Raw Blame History Permalink

<html>

<head>
<meta http-equiv=Content-Type content="text/html; charset=UTF-8">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<title>目录</title>
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Wingdings;
	panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
	{font-family:宋体;
	panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
	{font-family:"\@宋体";
	panose-1:2 1 6 0 3 1 1 1 1 1;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	text-align:justify;
	text-justify:inter-ideograph;
	font-size:10.5pt;
	font-family:"Times New Roman";}
p.MsoToc1, li.MsoToc1, div.MsoToc1
	{margin:0cm;
	margin-bottom:.0001pt;
	text-align:justify;
	text-justify:inter-ideograph;
	font-size:10.5pt;
	font-family:"Times New Roman";}
p.MsoHeader, li.MsoHeader, div.MsoHeader
	{margin:0cm;
	margin-bottom:.0001pt;
	text-align:center;
	layout-grid-mode:char;
	border:none;
	padding:0cm;
	font-size:9.0pt;
	font-family:"Times New Roman";}
p.MsoFooter, li.MsoFooter, div.MsoFooter
	{margin:0cm;
	margin-bottom:.0001pt;
	layout-grid-mode:char;
	font-size:9.0pt;
	font-family:"Times New Roman";}
p.MsoBodyText, li.MsoBodyText, div.MsoBodyText
	{margin-right:0cm;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:宋体;}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
	{margin:0cm;
	margin-bottom:.0001pt;
	text-align:justify;
	text-justify:inter-ideograph;
	font-size:9.0pt;
	font-family:"Times New Roman";}
 /* Page Definitions */
 @page Section1
	{size:595.3pt 841.9pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;
	layout-grid:15.6pt;}
div.Section1
	{page:Section1;}
 /* List Definitions */
 ol
	{margin-bottom:0cm;}
ul
	{margin-bottom:0cm;}
-->
</style>

</head>

<body lang=ZH-CN link=blue vlink=purple style='text-justify-trim:punctuation'>

<div class=Section1 style='layout-grid:15.6pt'>

<p class=MsoNormal align=center style='text-align:center'><b><span
style='font-size:16.0pt;font-family:宋体'>目录</span></b></p>

<p class=MsoNormal align=center style='text-align:center'><b><span lang=EN-US
style='font-size:16.0pt'>&nbsp;</span></b></p>

<p class=MsoToc1><span
lang=EN-US style='font-size:10.0pt'><span class=MsoHyperlink><a
href="#_Toc144631746"><b><span lang=EN-US style='font-family:宋体'><span
lang=EN-US>一、</span></span></b><span style='color:windowtext;text-decoration:
none'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span
lang=EN-US style='font-family:宋体'><span lang=EN-US>流程表单设计器说明</span></span></b><span
style='color:windowtext;display:none;text-decoration:none'>.... </span><span
style='color:windowtext;display:none;text-decoration:none'>3</span></a></span></span></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoToc1><span class=MsoHyperlink><span lang=EN-US style='font-size:
10.0pt'><a href="#_Toc144631747"><b><span lang=EN-US style='font-family:宋体'><span
lang=EN-US>二、</span></span></b><span style='color:windowtext;text-decoration:
none'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span
lang=EN-US style='font-family:宋体'><span lang=EN-US>流程表单设计器的组成部分：</span></span></b><span
style='color:windowtext;display:none;text-decoration:none'>.... </span><span
style='color:windowtext;display:none;text-decoration:none'>3</span></a></span></span></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoToc1><span class=MsoHyperlink><span lang=EN-US style='font-size:
10.0pt'><a href="#_Toc144631748"><b><span lang=EN-US style='font-family:宋体'><span
lang=EN-US>三、</span></span></b><span style='color:windowtext;text-decoration:
none'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span
lang=EN-US style='font-family:宋体'><span lang=EN-US>流程表单设计的步骤：</span></span></b><span
style='color:windowtext;display:none;text-decoration:none'>.... </span><span
style='color:windowtext;display:none;text-decoration:none'>4</span></a></span></span></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoToc1><span class=MsoHyperlink><span lang=EN-US style='font-size:
10.0pt'><a href="#_Toc144631749"><b><span lang=EN-US style='font-family:宋体'><span
lang=EN-US>四、</span></span></b><span style='color:windowtext;text-decoration:
none'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span
lang=EN-US style='font-family:宋体'><span lang=EN-US>流程表单设计器编辑工具说明</span></span></b><span
style='color:windowtext;display:none;text-decoration:none'>.... </span><span
style='color:windowtext;display:none;text-decoration:none'>9</span></a></span></span></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoToc1><span class=MsoHyperlink><span lang=EN-US style='font-size:
10.0pt'><a href="#_Toc144631750"><b><span lang=EN-US style='font-family:宋体'><span
lang=EN-US>五、</span></span></b><span style='color:windowtext;text-decoration:
none'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span
lang=EN-US style='font-family:宋体'><span lang=EN-US>报表编辑器使<span lang=EN-US>用<span
lang=EN-US>注意事项</span></span></span></span></b><span style='color:windowtext;
display:none;text-decoration:none'>.... </span><span
style='color:windowtext;display:none;text-decoration:none'>13</span></a></span></span></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoToc1><span class=MsoHyperlink><span lang=EN-US style='font-size:
10.0pt'><a href="#_Toc144631751"><b><span lang=EN-US style='font-family:宋体'><span
lang=EN-US>六、</span></span></b><span style='color:windowtext;text-decoration:
none'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span
lang=EN-US style='font-family:宋体'><span lang=EN-US>单元变参说明</span></span></b><span
style='color:windowtext;display:none;text-decoration:none'>.... </span><span
style='color:windowtext;display:none;text-decoration:none'>14</span></a></span></span></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:21.0pt;text-indent:-21.0pt'><a
name="_Toc144631746"><b><span lang=EN-US>一、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></b><b><span style='font-family:宋体'>流程表单设计器说明</span></b></a></p>

<p class=MsoNormal><b><span lang=EN-US>&nbsp;</span></b></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>e-cology</span><span
style='font-size:10.0pt;font-family:宋体'>系统中提供了流程表单模板编辑工具――报表设计器。通过报表设计器可以将系统中流程的表单显示或打印样式根据企业的需求进行设计。一方面让系统流程表单显示更加美化，另一方面让流程表单的表现样式符合企业用户使用习惯。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体;color:red'>报表设计器的作用是设计系统流程表单显示样式和打印样式。在系统中使用报表设计器是在流程表单、流程路径都设置完成的基础上来设置所需要的流程表单表现样式。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;color:red'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>系统中表单模板分为显示模板和打印模板，显示模板用于用户在系统中处理流程时所显示的样式，打印模板用于用户在某个节点打印流程表单时所显示的样式。在一个流程中每个节点的显示模板和打印模板需要分别设置，也就是说一个流程的每个节点都可以设置不同的显示样式或者打印样式。</span></p>

<p class=MsoNormal><b><span lang=EN-US>&nbsp;</span></b></p>

<p class=MsoNormal style='margin-left:21.0pt;text-indent:-21.0pt'><a
name="_Toc144631747"><b><span lang=EN-US>二、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></b><b><span style='font-family:宋体'>流程表单设计器的组成部分：</span></b></a></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>显示模板和打印模板和打印模板的设置方法相同，以下为流程表单模板编辑工具――报表设计器的操作界面。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal align=center style='text-align:center'><b><span lang=EN-US><img
width=554 height=399 src="helpimage/image001_wev8.jpg"></span></b></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>1、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>表单主字段：系统中你设置的当前表单主字段。</span></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>2、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>表单明细字段：系统中你设置的当前表单明细字段，当有多个明细字段时按“明细</span><span
lang=EN-US style='font-size:10.0pt'>1</span><span style='font-size:10.0pt;
font-family:宋体'>”、“明细</span><span lang=EN-US style='font-size:10.0pt'>2</span><span
style='font-size:10.0pt;font-family:宋体'>”</span><b><span lang=EN-US
style='font-size:10.0pt'>……</span></b><span style='font-size:10.0pt;font-family:
宋体'>分别显示。在明细字段中以红色显示的为表单必须功能项，在每个明细表中都必须使用到。</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-15.0pt'><span
lang=EN-US style='font-size:10.0pt;font-family:Wingdings'>&Oslash;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp; </span></span><span
style='font-size:10.0pt;font-family:宋体'>增加按钮：用于添加明细表的输入行；</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-15.0pt'><span
lang=EN-US style='font-size:10.0pt;font-family:Wingdings'>&Oslash;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp; </span></span><span
style='font-size:10.0pt;font-family:宋体'>删除按钮：用于删除明细表的输入行；</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-15.0pt'><span
lang=EN-US style='font-size:10.0pt;font-family:Wingdings'>&Oslash;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp; </span></span><span
style='font-size:10.0pt;font-family:宋体'>选择框标签：用于选择需要删除的明细表的输入行；</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-15.0pt'><span
lang=EN-US style='font-size:10.0pt;font-family:Wingdings'>&Oslash;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp; </span></span><span
style='font-size:10.0pt;font-family:宋体'>表头标签：用于表示一个明细表的开始，当有多个明细表时每个明细都需要设置表头标签；</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-15.0pt'><span
lang=EN-US style='font-size:10.0pt;font-family:Wingdings'>&Oslash;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp; </span></span><span
style='font-size:10.0pt;font-family:宋体'>表尾标签：用于表示一个明细表的结束，当有多个明细表时每个明细都需要设置表尾标签；</span></p>

<p class=MsoNormal style='margin-left:27.0pt'><span style='font-size:10.0pt;
font-family:宋体'>说明：因为明细表示可以添加多行的，在设置表单模板时无法固定行数就是以表头标签和表尾标签来告诉系统当点击添加时在这个行范围内增加行。</span></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>3、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>流程节点：当前流程所设置的节点，用于在表单上显示出节点操作人处理流程时在签字栏中输入的审批意见。这部分只有在流程节点中设置表单样式时会显示，如果在表中设置中直接设置显示</span><span
lang=EN-US style='font-size:10.0pt'>/</span><span style='font-size:10.0pt;
font-family:宋体'>打印样式将不显示内容。</span></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>4、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>表单样式编辑区：表单样式编辑区，在设置设置表单样式。</span></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>5、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>表单样式编辑工具：在编辑表单样式时可以使用的一些工具，可以设置字体、颜色、图片等样式。</span></p>

<p class=MsoNormal><b><span lang=EN-US>&nbsp;</span></b></p>

<p class=MsoNormal style='margin-left:21.0pt;text-indent:-21.0pt'><a
name="_Toc144631748"><b><span lang=EN-US>三、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></b><b><span style='font-family:宋体'>流程表单设计的步骤：</span></b></a></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>1、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>在设计标单模板前，需要在系统中将流程表单设置好，也就是表单的普通模式已经设置完成的基础上才能设置表单的显示和打印模板。</span></p>

<p class=MsoNormal style='margin-left:27.0pt'><span style='font-size:10.0pt;
font-family:宋体'>在流程路径设置中选择需要设置表单模板样式的工作流，进入流程“节点信息”中，点击要设置表单模板样式节点的“节点表单字段”</span></p>

<p class=MsoNormal align=center style='text-align:center'><span lang=EN-US
style='font-size:10.0pt'><img width=553 height=399
src="helpimage/image002_wev8.jpg"></span></p>

<p class=MsoNormal style='margin-left:9.0pt'><span style='font-size:10.0pt;
font-family:宋体'>系统默认的表单显示类型都为“普通模式”，通过下拉菜单将显示类型选择为“模板模式”</span></p>

<p class=MsoNormal align=center style='margin-left:9.0pt;text-align:center'><span
lang=EN-US style='font-size:10.0pt'><img width=553 height=401
src="helpimage/image003_wev8.jpg"></span></p>

<p class=MsoNormal style='margin-left:9.0pt'><span style='font-size:10.0pt;
font-family:宋体'>根据需要设置显示模板或打印模板，“添加”用于将已经存在的模板添加到当前节点，系统会自动以一个新的模板保存到当前节点，添加并保存后您可以在添加的模板基础上修改，这个修改不会影响所选择的模板而只是修改系统自动保存的新模板。“新建”用于在当前节点新建表单模板。</span></p>

<p class=MsoNormal style='margin-left:9.0pt'><span lang=EN-US style='font-size:
10.0pt'>&nbsp;</span></p>

<p class=MsoNormal align=center style='margin-left:9.0pt;text-align:center'><span
lang=EN-US style='font-size:10.0pt'><img width=553 height=221
src="helpimage/image004_wev8.jpg"></span></p>

<p class=MsoNormal align=center style='margin-left:9.0pt;text-align:center'><span
lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>2、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>在设置表单模板前需要设计出你所需要的样式，可以在</span><span
lang=EN-US style='font-size:10.0pt'>Excel</span><span style='font-size:10.0pt;
font-family:宋体'>中按照需要设计出表单的样式，也可以直接在报表设计器中直接设计。我们以费用报销单为例，先在</span><span
lang=EN-US style='font-size:10.0pt'>Excel</span><span style='font-size:10.0pt;
font-family:宋体'>中画出所需要的表单样式（见下图）：</span></p>

<p class=MsoNormal style='margin-left:9.0pt'><span lang=EN-US style='font-size:
10.0pt'>&nbsp;</span></p>

<p class=MsoNormal align=center style='margin-left:8.9pt;text-align:center'><b><span
lang=EN-US><img width=553 height=245 src="helpimage/image005_wev8.jpg"></span></b></p>

<p class=MsoNormal style='margin-left:14.9pt;text-indent:12.1pt'><span
lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:14.9pt;text-indent:12.1pt'><span
style='font-size:10.0pt;font-family:宋体'>因为这个表单是有明细表的，所以我们还要设计出明细表必须功能项的放置位置，如下图：</span></p>

<p class=MsoNormal><b><span lang=EN-US>&nbsp;</span></b></p>

<p class=MsoNormal><b><span lang=EN-US><img width=553 height=246
src="helpimage/image006_wev8.jpg"></span></b></p>

<p class=MsoNormal><b><span lang=EN-US>&nbsp;</span></b></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>3、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>当所需要的表单样式设计好以后，可以在报表设计器中通过</span><span
lang=EN-US style='font-size:10.0pt'>Excel</span><span style='font-size:10.0pt;
font-family:宋体'>文件导入模板样式：</span></p>

<p class=MsoNormal style='margin-left:9.0pt'><span style='font-size:10.0pt;
font-family:宋体'>（见下图）</span></p>

<p class=MsoNormal><b><span lang=EN-US><img width=553 height=397
src="helpimage/image007_wev8.jpg"></span></b></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>4、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>这个时候我们所需要做的是将导入到报表设计器中的模板进行编辑，因为报表设计器和</span><span
lang=EN-US style='font-size:10.0pt'>Excel</span><span style='font-size:10.0pt;
font-family:宋体'>为不同的软件，从</span><span lang=EN-US style='font-size:10.0pt'>Excel</span><span
style='font-size:10.0pt;font-family:宋体'>中导入的样式肯定会存在一些设计样式丢失或改变，如字体、颜色等。</span></p>

<p class=MsoNormal style='margin-left:9.0pt'><span lang=EN-US style='font-size:
10.0pt'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>5、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>编辑完成后将表单字段插入到模板中设计好的输入单元格中，如下图：</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'><img width=553
height=294 src="helpimage/image008_wev8.jpg"></span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>设置方法为先选择字段所在的单元格，然后点击右边相应的字段，则将所选自动放置到表单中相应的位置，对于明细表中的必须功能项和流程节点也是相同的操作。</span></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>6、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>当设置完成后需要社长这些表单字段的编辑属性，在某个字段上点击右键会出现“显示”、“可编辑”、“必填”选择，用于设置当前节点操作人（因为表单是在节点上设置的）这些字段是否可以编辑或必须编辑。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'><img width=553
height=298 src="helpimage/image009_wev8.jpg"></span></p>

<p class=MsoNormal><b><span lang=EN-US>&nbsp;</span></b></p>

<p class=MsoNormal style='margin-left:27.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>7、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>到此我们的表单模板也就设置完成了，点击文件菜单下的“保存到服务器”既可将这个模板保存到系统中，下面可以根据需要设置打印模板或者其他节点的模板。</span></p>

<p class=MsoNormal><b><span lang=EN-US>&nbsp;</span></b></p>

<p class=MsoNormal style='margin-left:27.0pt'><span style='font-size:10.0pt;
font-family:宋体'>接下来我们看一下表单设置中的公式设置功能，利用报表设计器的单元变参功能我们可以设置一些单元格的计算公式，以实现特殊需求。如下图中的报销金额合计数就可以使用公式</span><span
lang=EN-US style='font-size:10.0pt'>=SUM</span><span style='font-size:10.0pt;
font-family:宋体'>（</span><span lang=EN-US style='font-size:10.0pt'>J0:J11</span><span
style='font-size:10.0pt;font-family:宋体'>）自动计算出来。关于单元变参相信说明请参考</span><span
lang=EN-US style='font-size:10.0pt;font-family:宋体;color:red'><a href="#单元变参说明"><span
lang=EN-US><span lang=EN-US>第六部分单元变参说明</span></span></a></span><span
style='font-size:10.0pt;font-family:宋体'>。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:27.0pt'><span style='font-size:10.0pt;
font-family:宋体;color:red'>我们所需要注意的是这些公式的设置和就计算结果仅用于表单上显示，对于系统流程和数据没有任何关系，不能用户系统的统计和流程出口判断。如下图我们利用单元变参计算出来的报销金额合计只能用于在表单上的显示，这些数据是不会进入系统数据库的。</span></p>

<p class=MsoNormal style='margin-left:27.0pt'><span lang=EN-US
style='font-size:10.0pt;color:red'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:27.0pt'><span style='font-size:10.0pt;
font-family:宋体;color:red'>如果需要计算结果能进行统计，请在流程表单中利用附加条件、行计算规则和列计算规则进行设置。即将需要计算的结果作用普通模式时表单中的一个字段，并利用系统所带计算功能设置。</span></p>

<p class=MsoNormal><b><span lang=EN-US><img border=0 width=553 height=289
src="helpimage/image010_wev8.jpg"></span></b></p>

<p class=MsoNormal><b><span lang=EN-US>&nbsp;</span></b></p>

<p class=MsoNormal><b><span lang=EN-US>&nbsp;</span></b></p>

<p class=MsoNormal style='margin-left:21.0pt;text-indent:-21.0pt'><a
name="_Toc144631749"><b><span lang=EN-US>四、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></b><b><span style='font-family:宋体'>流程表单设计器编辑工具说明</span></b></a></p>

<p class=MsoNormal><b><span lang=EN-US>&nbsp;</span></b></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-21.0pt'><b><span
lang=EN-US>(一)<span style='font:7.0pt "Times New Roman"'>&nbsp; </span></span></b><b><span
style='font-family:宋体'>文件功能</span></b></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>1、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>新建：创建一个新的报表文件。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>2、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>打开文件：打开一个已有的报表文件，在这里可以打开以前保存在本地的模板文件或者打开一个</span><span
lang=EN-US style='font-size:10.0pt'>Excel</span><span style='font-size:10.0pt;
font-family:宋体'>文件，导入</span><span lang=EN-US style='font-size:10.0pt'>Excel</span><span
style='font-size:10.0pt;font-family:宋体'>文件中的表单样式。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>3、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>模版格式检查：可以检查模版中字段是否有效，特殊标识“增加、删除、选择框标签、表头标识、表尾标识”是否配对。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>4、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>保存到本地：将编辑的报表文件作为本地文件保存，已</span><span
lang=EN-US style='font-size:10.0pt'>tab</span><span style='font-size:10.0pt;
font-family:宋体'>格式文件保存，保存后可以再次打开编辑。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>5、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>保存到服务器：将编辑好的模板文件保存到系统中，只有保存到系统中的模板才能在流程中使用。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>6、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>打印：打印当前设置的报表文件。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>7、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>打印预览：打印预览当前设置的报表文件。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>8、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>属性：查看或编辑这个报表文件的属性。</span></p>

<p class=MsoNormal style='margin-left:42.0pt'><span lang=EN-US
style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-21.0pt'><b><span
lang=EN-US>(二)<span style='font:7.0pt "Times New Roman"'>&nbsp; </span></span></b><b><span
style='font-family:宋体'>编辑功能</span></b></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>1、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>拷贝：拷贝选中的内容到剪切板。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>2、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>剪切：剪切选中的内容到剪切板。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>3、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>粘贴：把剪切板的内容粘贴到报表之中。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>4、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>单元定位：通过弹出对话框，可以选择光标跳到指定的单元或指定的行列。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>5、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>插入行：下级菜单中的“前插行”是在当前活动单元前插入行；“后插行”是在当前活动单元后插入行；“插入格式行”通过弹出对话框可以把指定行区域的内容和格式插入到新的指定行区域；“拷贝格式行”通过弹出对话框可</span><span
style='font-size:10.0pt;font-family:宋体'>以</span><span style='font-size:10.0pt;
font-family:宋体'>把指定行区域的内容和格式拷贝到新的指定行区域。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>6、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>插入列：</span><span
style='font-size:10.0pt;font-family:宋体'>下级</span><span style='font-size:10.0pt;
font-family:宋体'>菜单中</span><span style='font-size:10.0pt;font-family:宋体'>的</span><span
style='font-size:10.0pt;font-family:宋体'>“前插列”是在当前活动单元前插入列；“后插列”是在当前活动单元后插入列；“插入格式列”</span><span
style='font-size:10.0pt;font-family:宋体'>通过</span><span style='font-size:10.0pt;
font-family:宋体'>弹出对话框可</span><span style='font-size:10.0pt;font-family:宋体'>以</span><span
style='font-size:10.0pt;font-family:宋体'>把指定行区域的内容和格式插入到新的指定列区域；“拷贝格式列”</span><span
style='font-size:10.0pt;font-family:宋体'>通过</span><span style='font-size:10.0pt;
font-family:宋体'>弹出对话框可</span><span style='font-size:10.0pt;font-family:宋体'>以</span><span
style='font-size:10.0pt;font-family:宋体'>把指定列区域的内容和格式拷贝到新的指定列区域。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>7、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>插入单元：</span><span
style='font-size:10.0pt;font-family:宋体'>下级</span><span style='font-size:10.0pt;
font-family:宋体'>菜单</span><span style='font-size:10.0pt;font-family:宋体'>中</span><span
style='font-size:10.0pt;font-family:宋体'>的“插入单元”是弹出插入单元对话框，选择对应的选项后进行单元插入操作；“插入单元后下移”是指在当前选中区域块中插入单元后原区域的单元往下移动；“插入单元后右移”是把指在当前选中区域块中插入单元后原区域的单元往右移动。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>8、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>清除单元：</span><span
style='font-size:10.0pt;font-family:宋体'>下级</span><span style='font-size:10.0pt;
font-family:宋体'>菜单</span><span style='font-size:10.0pt;font-family:宋体'>中</span><span
style='font-size:10.0pt;font-family:宋体'>的“清除单元所有内容”用于将活动单元内的内容全部清除；“清除单元文字”用于将活动单元内的文字清除。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>9、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>删除行：删除活动单元行。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>10、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>删除列：删除活动单元列。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>11、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>删除单元：</span><span
style='font-size:10.0pt;font-family:宋体'>下级</span><span style='font-size:10.0pt;
font-family:宋体'>菜单</span><span style='font-size:10.0pt;font-family:宋体'>中</span><span
style='font-size:10.0pt;font-family:宋体'>的“删除单元”是弹出删除单元对话框，选择对应的选项后进行单元删除操作；“删除单元后左移”是指删除单元当前选中区域的单元后，右边的单元往左移；“删除单元后上移”是指删除当前选中区域的单元后，下面的单元往上移。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>12、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>按活动单元行排序：</span><span
style='font-size:10.0pt;font-family:宋体'>下级</span><span style='font-size:10.0pt;
font-family:宋体'>菜单</span><span style='font-size:10.0pt;font-family:宋体'>中</span><span
style='font-size:10.0pt;font-family:宋体'>的“选中区域升序”是对选中区域按列进行升序排序；“选中区域降序”是对选中区域按列进行降序排序；“升序</span><span
lang=EN-US style='font-size:10.0pt'>-</span><span style='font-size:10.0pt;
font-family:宋体'>整行交换”是对选中区域的行按列进行升序排序</span><span lang=EN-US style='font-size:
10.0pt'>,</span><span style='font-size:10.0pt;font-family:宋体'>也就是说在排序的时候是整行交换；“降序</span><span
lang=EN-US style='font-size:10.0pt'>-</span><span style='font-size:10.0pt;
font-family:宋体'>整行交换”是对选中区域的行按列进行降序排序</span><span lang=EN-US style='font-size:
10.0pt'>,</span><span style='font-size:10.0pt;font-family:宋体'>也就是说在排序的时候是整行交换</span><span
style='font-size:10.0pt'> </span><span style='font-size:10.0pt;font-family:
宋体'>。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>13、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>按活动单元列排序：</span><span
style='font-size:10.0pt;font-family:宋体'>下级</span><span style='font-size:10.0pt;
font-family:宋体'>菜单</span><span style='font-size:10.0pt;font-family:宋体'>中</span><span
style='font-size:10.0pt;font-family:宋体'>的“选中区域升序”是对选中区域按行进行升序排序；“选中区域降序”是对选中区域按行进行降序排序；“升序</span><span
lang=EN-US style='font-size:10.0pt'>-</span><span style='font-size:10.0pt;
font-family:宋体'>整列交换”是对选中区域的列按行进行升序排序</span><span lang=EN-US style='font-size:
10.0pt'>,</span><span style='font-size:10.0pt;font-family:宋体'>也就是说在排序的时候是整列交换；“降序</span><span
lang=EN-US style='font-size:10.0pt'>-</span><span style='font-size:10.0pt;
font-family:宋体'>整列交换”是对选中区域的列按行进行降序排序</span><span lang=EN-US style='font-size:
10.0pt'>,</span><span style='font-size:10.0pt;font-family:宋体'>也就是说在排序的时候是整列交换</span><span
style='font-size:10.0pt'> </span><span style='font-size:10.0pt;font-family:
宋体'>。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-21.0pt'><b><span
lang=EN-US>(三)<span style='font:7.0pt "Times New Roman"'>&nbsp; </span></span></b><b><span
style='font-family:宋体'>设置功能</span></b></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>1、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>表格行列数：设置表格的最大行数和列数，如果行数或列数小于当前已有的行数或列数，则超出的行数或列数会被删除。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>2、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>页面背景色：通过</span><span
style='font-family:宋体'>弹出对话框设置表格页面的背景色。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>3、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置系统表格线型：通过</span><span
style='font-family:宋体'>弹出对话框设置系统表格线的颜色和线型。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>4、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置单元保护或隐藏：弹出对话框，设置或取消当前活动区域块的单元格隐藏或保护，保护后就不能修改单元格内容。该设置对插入了表单字段的单元格不起作用。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>5、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置行高自动调整：设置行高是否能够自动调整，如果该菜单项打勾，则表示行高能够自动调整。设置行高自动调整的操作后只对以后输入文字的行有用。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>6、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>按回车光标自动跳转方向：下级菜单中的“跳到下一列”，如果该菜单项打勾，则表示按回车跳到下一列。“跳到下一行”，如果该菜单项打勾，则表示按回车跳到下一行。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>7、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>头尾单元跳转时自动换行或列：如果该菜单项打勾，则表示光标在头尾单元时，会自动换到下一行或列或者上一行或列。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>8、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>在按键时跳过该单元：设置或取消当按回车在单元格间跳转时遇到选中区域单元是否在按回车键时跳过。如果该菜单项打勾，则表示当前活动单元会在按键时跳过。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>9、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>计算时显示错误提示：设置或取消选是否在计算的时候显示错误提示窗口。如果该菜单项打勾，则表示在计算时显示错误提示。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>10、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设计模式：设置或取消报表设计模式。如果该菜单项打勾，则表示报表处于设计模式。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>11、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>显示行列头：设置或取消报表行列头的显示。如果该菜单项打勾，则表示报表显示行列头。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>12、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>显示表格线：设置或取消报表表格线的显示。如果该菜单项打勾，则表示报表显示行列头。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>13、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>整表单元保护：设置或取消报表整表单元保护。如果该菜单项打勾，则表示整个报表单元被保护。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>14、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>整表单元保护时出现光标：设置是否在报表整表单元保护时出现光标。如果该菜单项打勾，则表示整表单元保护时出现光标。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>15、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>是否显示弹出菜单：设置是否显示右键弹出菜单。如果该菜单项打勾，则点击右键时可以出现右键菜单。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>16、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>允许鼠标对行高进行调整：设置是否允许鼠标对行高进行调整。如果该菜单项打勾，则允许鼠标对行高进行调整。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>17、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>允许鼠标对列宽进行调整：设置是否允许鼠标对列宽进行调整。如果该菜单项打勾，则允许鼠标对列宽进行调整。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>18、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>双击表头自动排序：设置是否允许双击表头时自动按双击的列进行排序。如果该菜单项打勾，则表示允许。</span></p>

<p class=MsoNormal style='margin-left:42.0pt'><span lang=EN-US
style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-21.0pt'><b><span
lang=EN-US>(四)<span style='font:7.0pt "Times New Roman"'>&nbsp; </span></span></b><b><span
style='font-family:宋体'>格式功能</span></b></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>1、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>单元内文字显示间距：通过弹出对话框来设置活动单元格内显示文字的上间距、下间距、左间距、右间距、行间距、字间距。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>2、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>单元控件类型：置各种单元控件类型。可以设置单选框、下拉框、复合单元、日期时间输入控件、超级链接、数字输入等控件，可以通过删除控件类型来删除控件。该设置对插入了表单字段的单元格不起作用。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>3、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>财务格式类型：设置各种财务格式类型。可以设置财务表头、财务表览、财务大写和删除财务类型等功能。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>4、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置单元为</span><span
lang=EN-US style='font-size:10.0pt'>3D</span><span style='font-size:10.0pt;
font-family:宋体'>形状：设置或取消选中的单元区域为</span><span lang=EN-US style='font-size:10.0pt'>3D</span><span
style='font-size:10.0pt;font-family:宋体'>形状，</span><span lang=EN-US
style='font-size:10.0pt'>3D</span><span style='font-size:10.0pt;font-family:
宋体'>形状与表头的形状完全一样。如果要设置自己的行表头，并且表头形状和系统表头一样，就可以使用这个功能来设置。该设置对插入了表单字段的单元格不起作用。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>5、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>线形设置：通过弹出对话框，设置当前活动区域块单元格的线型。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>6、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>数据绑定单元文字颜色、背景颜色：通过弹出对话框对选中区域设置单元数据绑定背景颜色和文字颜色。根据设定可以以不同的字体颜色和单元格背景色来显示数据。该设置对插入了表单字段的单元格不起作用。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>7、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>单元数字显示格式：通过弹出对话框，设置当前活动区域块的单元格显示格式。该设置对插入了表单字段的单元格不起作用。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>8、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>表行：下级菜单中的“行高”是弹出对话框设置选中区域的行高；“隐藏”是对选中区域行隐藏不显示；“取消隐藏”是对选中区域行不隐藏；“最适合的行高”是调整指定区域内行高为最适合的行高；“自动调整高度太小的行高”是调整指定区域内行高太小的行为最适合的行高，行高大于最适合的行高的行不做调整。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>9、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>表列：下级菜单中的“列宽”是弹出对话框设置选中区域的列宽。“隐藏”是对选中区域列隐藏不显示。“取消隐藏”是对选中区域列不隐藏。“最适合的列宽”是调整指定区域内列宽为最适合的列宽。“自动调整高度太小的列宽”是调整指定区域内列宽太小的列为最适合的列宽，列宽大于最适合的列宽的列不做调整。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>10、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>单元组合：组合当前选中区域的单元格。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>11、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>单元取消组合：取消当前选中区域的已组合的单元格。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>12、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>斜线设置：通过弹出对话框，在当前活动区域块单元格中画斜线。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>13、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>缺省设置：通过弹出对话框，设置当前表格的缺省行高、列宽、字体、对齐方式、数字显示格式等。表格中没有调整过行高和列宽的行或列、没有设置过字体、对齐方式、数字显示格式的单元按缺省值显示。</span></p>

<p class=MsoNormal style='margin-left:42.0pt'><span lang=EN-US
style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-21.0pt'><b><span
lang=EN-US>(五)<span style='font:7.0pt "Times New Roman"'>&nbsp; </span></span></b><b><span
style='font-family:宋体'>公式脚本</span></b></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>1、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>函数列表：显示函数列表对话框，它是在报表中设置公式时用到的函数</span><span
style='font-size:10.0pt'> </span><span style='font-size:10.0pt;font-family:
宋体'>。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>2、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>求和：下级菜单中的“纵向求和”是纵向对选中区域的单元求和；“横向求和”是横向对选中区域的单元求和；“双向求和”是对选中区域进行双向求和。该设置对插入了表单字段的单元格不起作用。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>3、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>整表计算：对整表所有公式全部进行计算。</span></p>

<p class=MsoNormal style='margin-left:42.0pt'><span lang=EN-US
style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-21.0pt'><b><span
lang=EN-US>(六)<span style='font:7.0pt "Times New Roman"'>&nbsp; </span></span></b><b><span
style='font-family:宋体'>图形图表</span></b></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>1、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>图表向导：通过该向导在表格中插入柱状图、饼状图、线形图等图表。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>2、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>画线：使用该工具在表格中点击鼠标可以进行线条的绘制。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>3、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>画矩形：使用该工具在表格中点击鼠标可以进行矩形的绘制。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>4、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>画圆角矩形：使用该工具在表格中点击鼠标可以进行圆角矩形的绘制。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>5、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>画椭圆：使用该工具在表格中点击鼠标可以进行椭圆的绘制。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>6、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>边框颜色：设置选中图形的边框颜色进行设置，所设置图形是通过上述工具所绘制的图形。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>7、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>填充颜色：设置选中图形的填充颜色进行设置，所设置图形是通过上述工具所绘制的图形。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>8、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>移到最顶层：将选择对象移到最上层，所设置对象是通过上述工具所绘制的图形。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>9、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>移到最底层：将选择对象移到最底层，所设置对象是通过上述工具所绘制的图形。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>10、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>移到上一层：将选择对象移到上移一层，所设置对象是通过上述工具所绘制的图形。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>11、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>移到下一层：将选择对象移到下移一层，所设置对象是通过上述工具所绘制的图形。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>12、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>刷新所有图表：对整个报表内的所有图表对象进行刷新。</span></p>

<p class=MsoNormal style='margin-left:42.0pt'><span lang=EN-US
style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-21.0pt'><b><span
lang=EN-US>(七)<span style='font:7.0pt "Times New Roman"'>&nbsp; </span></span></b><b><span
style='font-family:宋体'>图片功能</span></b></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>1、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>在表格上放置图片：弹出选择图片文件对话框，插入图片对象，图片放置在表格上面。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>2、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>在单元中插入图片：弹出选择图片文件对话框，插入图片对象，图片放置在表格活动单元中。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>3、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置单元中图片大小：设置通过单元中插入图片功能的图片对象的大小，有两种，一种按图片原始大小，另一种是按单元格大小。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>4、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>删除单元中图片：删除在单元格中插入的图片。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>5、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>插入背景图片：弹出选择图片文件对话框在整个报表中插入背景图片，背景图片的大小有两种，一种按图片原始大小，另一种是按表格大小插入。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>6、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置背景图片：改变报表中插入背景图片大小，有两种方式一种按图片原始大小，另一种是按表格大小。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>7、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>删除背景图片：删除插入的报表背景图片。</span></p>

<p class=MsoNormal style='margin-left:42.0pt'><span lang=EN-US
style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-21.0pt'><b><span
lang=EN-US>(八)<span style='font:7.0pt "Times New Roman"'>&nbsp; </span></span></b><b><span
style='font-family:宋体'>打印设置功能</span></b></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>1、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置</span><span
lang=EN-US style='font-size:10.0pt'>/</span><span style='font-size:10.0pt;
font-family:宋体'>取消每页打印的行表头：设置选定的行为行表头，在打印时从第一行开始到选定的行作为行表头，行表头在打印中每页都会显示。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>2、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置</span><span
lang=EN-US style='font-size:10.0pt'>/</span><span style='font-size:10.0pt;
font-family:宋体'>取消每页打印的列表头：设置选定的列为列表头，在打印时从第一列开始到选定的列作为列表头，列表头在打印中每页都会显示。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>3、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置打印页前脚行数：设置页前脚的行数，设置为页前脚的行将在打印或打印预览时在每页的数据后面显示。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>4、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置打印页脚行数：设置页脚的行数，设置为页脚的行将在打印或打印预览时在每页的数据后面显示。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>5、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置打印每页行数：设置每页打印的行数，不包括表头、表尾页脚、页前脚的行数。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>6、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>页面设置：当前表格打印页面设置，包括页边距、页眉页脚、打印尺寸、硬分页设置等。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>7、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>打印设置：设置纸张大小或选择打印机。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>8、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置不打印单元格：</span><span
style='font-family:宋体'>设置选中区域的单元格在打印时是否显示。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>9、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置只打印单元格文字：设置选中区域的单元格在打印时是否只打印文字。默认所有的单元格在打印时会打印所有的内容。如果要不打印某些单元格的背景、线形，则需要调用此函数。</span><span
style='font-size:10.0pt'> </span><span style='font-size:10.0pt;font-family:
宋体'>此功能只有在选中区域的单元被打印时才起作用。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>10、<span style='font:7.0pt "Times New Roman"'>&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>设置打印表格背景：设置是否打印表格背景，设置背景不打印时将不打印背景图片和背景颜色。</span></p>

<p class=MsoNormal style='margin-left:42.0pt;text-indent:-21.0pt'><b><span
lang=EN-US>(九)<span style='font:7.0pt "Times New Roman"'>&nbsp; </span></span></b><b><span
style='font-family:宋体'>帮助功能</span></b></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>1、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>本机版本：获得用户当前机器的设计器版本。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>2、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>服务器版本：获得</span><span
lang=EN-US style='font-size:10.0pt'>ecology</span><span style='font-size:10.0pt;
font-family:宋体'>服务器的设计器版本。</span></p>

<p class=MsoNormal style='margin-left:60.0pt;text-indent:-18.0pt'><span
lang=EN-US style='font-size:10.0pt'>3、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;
</span></span><span style='font-size:10.0pt;font-family:宋体'>使用帮助：使用帮助。</span></p>

<p class=MsoNormal><b><span lang=EN-US>&nbsp;</span></b></p>

<p class=MsoNormal style='margin-left:21.0pt;text-indent:-21.0pt'><a
name="_Toc144631750"><b><span lang=EN-US>五、<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></b><b><span style='font-family:宋体'>报表编辑器使用注意事项</span></b></a></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>1</span><span
style='font-size:10.0pt;font-family:宋体'>、输入框使用时必须输入完后按回车或者鼠标左键点击到其它单元格上，此次的输入内容才会起效。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>现在发生的问题：用户输入内容后直接点击右健提交，提交后该内容为空。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>2</span><span
style='font-size:10.0pt;font-family:宋体'>、浏览框使用时点击浏览图标后，需等浏览框出来后才移动鼠标至浏览框，否则容易出现浏览框变小现象（系统慢时）。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>现发生的问题：浏览框变小，无法进行选择</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal align=left style='margin-left:18.0pt;text-align:left;
text-indent:-18.0pt'><span lang=EN-US style='font-size:10.0pt'>3</span><span
style='font-size:10.0pt;font-family:宋体'>、模版设计使用注意问题</span></p>

<p class=MsoNormal align=left style='margin-left:42.0pt;text-align:left;
text-indent:-21.0pt'><span lang=EN-US style='font-size:10.0pt'>a)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style='font-size:10.0pt;font-family:宋体'>禁止对选择进来的字段进行复制、粘贴操作</span></p>

<p class=MsoNormal align=left style='margin-left:42.0pt;text-align:left;
text-indent:-21.0pt'><span lang=EN-US style='font-size:10.0pt'>b)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style='font-size:10.0pt;font-family:宋体'>禁止通过键盘的</span><span
lang=EN-US style='font-size:10.0pt'>delete</span><span style='font-size:10.0pt;
font-family:宋体'>进行删除选择进来的字段</span><span lang=EN-US style='font-size:10.0pt'>,</span><span
style='font-size:10.0pt;font-family:宋体'>需要用模版上的</span><span lang=EN-US
style='font-size:10.0pt'>”X”</span><span style='font-size:10.0pt;font-family:
宋体'>来清除</span></p>

<p class=MsoNormal align=left style='margin-left:42.0pt;text-align:left;
text-indent:-21.0pt'><span lang=EN-US style='font-size:10.0pt'>c)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style='font-size:10.0pt;font-family:宋体'>修改了表单的字段类型和改变了字段</span><span
lang=EN-US style='font-size:10.0pt'>,</span><span style='font-size:10.0pt;
font-family:宋体'>需要对引用到该字段的模版进行修改</span></p>

<p class=MsoNormal align=left style='margin-left:42.0pt;text-align:left;
text-indent:-21.0pt'><span lang=EN-US style='font-size:10.0pt'>d)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style='font-size:10.0pt;font-family:宋体'>有明细时应注意“表头标识”和“表尾标识”必须在“选择框标签”上和下，中间不能有空白行，如果明细字段有多行时，“选择框标签”必须为明细行数的合并行</span></p>

<p class=MsoNormal align=left style='margin-left:18.0pt;text-align:left;
text-indent:-18.0pt'><span lang=EN-US style='font-size:10.0pt'>4</span><span
style='font-size:10.0pt;font-family:宋体'>、使用小诀窍</span></p>

<p class=MsoNormal align=left style='margin-left:42.0pt;text-align:left;
text-indent:-21.0pt'><span lang=EN-US style='font-size:10.0pt'>a)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style='font-size:10.0pt;font-family:宋体'>删除字段时可以用鼠标拖动选择一个区域的字段点“</span><span
lang=EN-US style='font-size:10.0pt'>X</span><span style='font-size:10.0pt;
font-family:宋体'>”进行清除</span></p>

<p class=MsoNormal align=left style='margin-left:42.0pt;text-align:left;
text-indent:-21.0pt'><span lang=EN-US style='font-size:10.0pt'>b)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style='font-size:10.0pt;font-family:宋体'>字段替换功能，例如某个字段选择错了，或者需要放别的字段，不需要先删除再添加，可以选中设计表单中的这个字段，然后从右边列表中选择需要替换成的字段即可</span></p>

<p class=MsoNormal align=left style='margin-left:42.0pt;text-align:left;
text-indent:-21.0pt'><span lang=EN-US style='font-size:10.0pt'>c)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style='font-size:10.0pt;font-family:宋体'>对于表单线条，和字体样式，格式等都可以选择区域，对这个区域进行设置</span></p>

<p class=MsoNormal align=left style='margin-left:42.0pt;text-align:left;
text-indent:-21.0pt'><span lang=EN-US style='font-size:10.0pt'>d)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style='font-size:10.0pt;font-family:宋体'>设置模版时可以先在</span><span
lang=EN-US style='font-size:10.0pt'>excle</span><span style='font-size:10.0pt;
font-family:宋体'>中设计好后，用模版打开，直接加入字段即可。</span></p>

<p class=MsoNormal align=left style='margin-left:42.0pt;text-align:left;
text-indent:-21.0pt'><span lang=EN-US style='font-size:10.0pt'>e)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style='font-size:10.0pt;font-family:宋体'>如果流程中各节点的模版样式都基本一样，建议在表单上建立表单模版，在各节点上选择表单模版后，再进行简单修改，这样减少很多工作量。</span></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoNormal style='margin-left:21.0pt;text-indent:-21.0pt'><a
name="_Toc144631751"></a><a name=单元变参说明></a><b><span lang=EN-US>六、<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></b><b><span style='font-family:宋体'>单元变参说明</span></b></p>

<p class=MsoNormal><span lang=EN-US>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>单元变参对于数据库函数中某一列的值进行求和非常方便。由于数据库函数的执行的结果返回的行数不固定，</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>这样用单元变参就非常方便的对变动的行进行求和</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span><span
style='font-size:10.0pt;font-family:宋体'>表示方法</span><span lang=EN-US
style='font-size:10.0pt'>1</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>单元变参的表示方法是以列标</span><span
lang=EN-US style='font-size:10.0pt'>+0</span><span style='font-size:10.0pt;
font-family:宋体'>表示，如</span><span lang=EN-US style='font-size:10.0pt'>A0</span><span
style='font-size:10.0pt;font-family:宋体'>，</span><span lang=EN-US
style='font-size:10.0pt'>B0</span><span style='font-size:10.0pt;font-family:
宋体'>，</span><span lang=EN-US style='font-size:10.0pt'>C0</span><span
style='font-size:10.0pt;font-family:宋体'>。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>其中列标表示该单元变参所在的列，</span><span
lang=EN-US style='font-size:10.0pt'>0</span><span style='font-size:10.0pt;
font-family:宋体'>表示当前单元变参所在行的前一行。当有行增删时，这个值也会随行的</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>增删的变化而变化。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span><span
style='font-size:10.0pt;font-family:宋体'>举例说明</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>如在</span><span
lang=EN-US style='font-size:10.0pt'>B5</span><span style='font-size:10.0pt;
font-family:宋体'>单元中有公式</span><span lang=EN-US style='font-size:10.0pt'>&quot;=A0&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>，则该变参表示的值应该是第四行</span><span lang=EN-US
style='font-size:10.0pt'>A4</span><span style='font-size:10.0pt;font-family:
宋体'>的单元值，如果在第</span><span lang=EN-US style='font-size:10.0pt'>5</span><span
style='font-size:10.0pt;font-family:宋体'>行前插入了</span><span lang=EN-US
style='font-size:10.0pt'>3</span><span style='font-size:10.0pt;font-family:
宋体'>行，则</span><span lang=EN-US style='font-size:10.0pt'>B8</span><span
style='font-size:10.0pt;font-family:宋体'>中</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>该公式的值变为第七行</span><span
lang=EN-US style='font-size:10.0pt'>A7</span><span style='font-size:10.0pt;
font-family:宋体'>的单元值。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>如在</span><span
lang=EN-US style='font-size:10.0pt'>B3</span><span style='font-size:10.0pt;
font-family:宋体'>单元中有公式</span><span lang=EN-US style='font-size:10.0pt'>&quot;=sum(B2:B0)&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>，则该公式表示从</span><span lang=EN-US
style='font-size:10.0pt'>B2</span><span style='font-size:10.0pt;font-family:
宋体'>到此公式前一行的所有单元进行求和。一般在第二行</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>会放置一个数据库函数，该函数执行时会在第二行后自动插入行，该公式就会对</span><span
lang=EN-US style='font-size:10.0pt'>B2</span><span style='font-size:10.0pt;
font-family:宋体'>及插入的行的这一列进行求和。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span><span
style='font-size:10.0pt;font-family:宋体'>表示方法</span><span lang=EN-US
style='font-size:10.0pt'>2</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>单元变参的表示方法是以列标</span><span
lang=EN-US style='font-size:10.0pt'>+00</span><span style='font-size:10.0pt;
font-family:宋体'>表示，如</span><span lang=EN-US style='font-size:10.0pt'>A00</span><span
style='font-size:10.0pt;font-family:宋体'>，</span><span lang=EN-US
style='font-size:10.0pt'>B00</span><span style='font-size:10.0pt;font-family:
宋体'>，</span><span lang=EN-US style='font-size:10.0pt'>C00</span><span
style='font-size:10.0pt;font-family:宋体'>。此单元变参只能用在</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>区域求和的单元区域表示中的起始单元。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>其中列标表示该单元变参所在的列，</span><span
lang=EN-US style='font-size:10.0pt'>00</span><span style='font-size:10.0pt;
font-family:宋体'>表示区域中的结束行开始往上是数字单元的</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>起始单元行。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span><span
style='font-size:10.0pt;font-family:宋体'>举例说明</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>如在</span><span
lang=EN-US style='font-size:10.0pt'>B5</span><span style='font-size:10.0pt;
font-family:宋体'>单元中有公式</span><span lang=EN-US style='font-size:10.0pt'>&quot;=sum(b00:b0)&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>，其中</span><span lang=EN-US
style='font-size:10.0pt'>b1</span><span style='font-size:10.0pt;font-family:
宋体'>内容是</span><span lang=EN-US style='font-size:10.0pt'>&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>年龄</span><span lang=EN-US
style='font-size:10.0pt'>&quot;</span><span style='font-size:10.0pt;font-family:
宋体'>，</span><span lang=EN-US style='font-size:10.0pt'>b2</span><span
style='font-size:10.0pt;font-family:宋体'>内容是</span><span lang=EN-US
style='font-size:10.0pt'>&quot;25&quot;</span><span style='font-size:10.0pt;
font-family:宋体'>，</span><span lang=EN-US style='font-size:10.0pt'>b3</span><span
style='font-size:10.0pt;font-family:宋体'>内</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>容是</span><span
lang=EN-US style='font-size:10.0pt'>&quot;35&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>，</span><span lang=EN-US
style='font-size:10.0pt'>b4</span><span style='font-size:10.0pt;font-family:
宋体'>内容是</span><span lang=EN-US style='font-size:10.0pt'>&quot;26&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>，则其中</span><span lang=EN-US
style='font-size:10.0pt'>b0</span><span style='font-size:10.0pt;font-family:
宋体'>表示的是当前单元的上一行，即</span><span lang=EN-US style='font-size:10.0pt'>b4</span><span
style='font-size:10.0pt;font-family:宋体'>，</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>而</span><span
lang=EN-US style='font-size:10.0pt'>b00</span><span style='font-size:10.0pt;
font-family:宋体'>是从</span><span lang=EN-US style='font-size:10.0pt'>b4</span><span
style='font-size:10.0pt;font-family:宋体'>单元开始，往上判断是数字单元的最上面的一行。从</span><span
lang=EN-US style='font-size:10.0pt'>b4</span><span style='font-size:10.0pt;
font-family:宋体'>单元开始判</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>断，</span><span
lang=EN-US style='font-size:10.0pt'>b3,b2</span><span style='font-size:10.0pt;
font-family:宋体'>都是数字，所以</span><span lang=EN-US style='font-size:10.0pt'>b00</span><span
style='font-size:10.0pt;font-family:宋体'>是</span><span lang=EN-US
style='font-size:10.0pt'>b2</span><span style='font-size:10.0pt;font-family:
宋体'>。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>具体可以参考报表设计器中“汇总报表”中的“主从报表”中“数量小计”的</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>公式。它的功能是完成对每一组的数量的求和。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span><span
style='font-size:10.0pt;font-family:宋体'>表示方法</span><span lang=EN-US
style='font-size:10.0pt'>3</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>单元变参的表示方法只是以列标表示，如</span><span
lang=EN-US style='font-size:10.0pt'>A</span><span style='font-size:10.0pt;
font-family:宋体'>，</span><span lang=EN-US style='font-size:10.0pt'>B</span><span
style='font-size:10.0pt;font-family:宋体'>，</span><span lang=EN-US
style='font-size:10.0pt'>C</span><span style='font-size:10.0pt;font-family:
宋体'>。此单元变参可以跟其他单元</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>变量一样使用。表示公式行所在单元的指定列标的单元。这个表示法对于有行插入</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>需要横向求和的单元非常有用。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span><span
style='font-size:10.0pt;font-family:宋体'>举例说明</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>如在</span><span
lang=EN-US style='font-size:10.0pt'>E2</span><span style='font-size:10.0pt;
font-family:宋体'>单元中有公式</span><span lang=EN-US style='font-size:10.0pt'>&quot;=b*c&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>，则该公式的实际表示</span><span lang=EN-US
style='font-size:10.0pt'>b2*c2</span><span style='font-size:10.0pt;font-family:
宋体'>。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>具体可以参考报表设计器中“汇总报表”中的“主从报表”中“金额”的</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>公式。它的功能是完成对同行中的两个单元乘积。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span><span
style='font-size:10.0pt;font-family:宋体'>表示方法</span><span lang=EN-US
style='font-size:10.0pt'>4</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>单元变参的表示方法只是以下划线和数字或者只是下划线表示，如</span><span
lang=EN-US style='font-size:10.0pt'>_2</span><span style='font-size:10.0pt;
font-family:宋体'>，</span><span lang=EN-US style='font-size:10.0pt'>_0</span><span
style='font-size:10.0pt;font-family:宋体'>，</span><span lang=EN-US
style='font-size:10.0pt'>__2</span><span style='font-size:10.0pt;font-family:
宋体'>，</span><span lang=EN-US style='font-size:10.0pt'>__</span><span
style='font-size:10.0pt;font-family:宋体'>，</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>___2</span><span
style='font-size:10.0pt;font-family:宋体'>，</span><span lang=EN-US
style='font-size:10.0pt'>___</span><span style='font-size:10.0pt;font-family:
宋体'>。此单元变参可以跟其他单元变量一样使用。其中</span><span lang=EN-US style='font-size:10.0pt'>'_'</span><span
style='font-size:10.0pt;font-family:宋体'>表示公式所在单元的列，</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>'__'</span><span
style='font-size:10.0pt;font-family:宋体'>表示公式所在单元的前一列，</span><span lang=EN-US
style='font-size:10.0pt'>'___'</span><span style='font-size:10.0pt;font-family:
宋体'>表示公式所在单元的后一列，对于有列插入和公式</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>随着列变动的时候非常有用。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span><span
style='font-size:10.0pt;font-family:宋体'>举例说明</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>如在</span><span
lang=EN-US style='font-size:10.0pt'>B5</span><span style='font-size:10.0pt;
font-family:宋体'>单元中有公式</span><span lang=EN-US style='font-size:10.0pt'>&quot;=sum(_4:_0)&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>，则该公式的实际表示</span><span lang=EN-US
style='font-size:10.0pt'>&quot;=sum(b4:b0)&quot;</span><span style='font-size:
10.0pt;font-family:宋体'>。当然如何该列</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>和变动时，公式也会跟着列变动。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>如在</span><span
lang=EN-US style='font-size:10.0pt'>C5</span><span style='font-size:10.0pt;
font-family:宋体'>单元中有公式</span><span lang=EN-US style='font-size:10.0pt'>&quot;=sum(b:__)&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>，则该公式的实际含义是</span><span lang=EN-US
style='font-size:10.0pt'>B</span><span style='font-size:10.0pt;font-family:
宋体'>列和当前所在单元的前一</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>列之间的区间进行求和。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>具体可以参考报表设计器中“汇总报表”中的“交叉报表”中“合计”的公式。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span><span
style='font-size:10.0pt;font-family:宋体'>表示方法</span><span lang=EN-US
style='font-size:10.0pt'>5</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>单元变参的表示方法是以列标</span><span
lang=EN-US style='font-size:10.0pt'>+000</span><span style='font-size:10.0pt;
font-family:宋体'>表示，如</span><span lang=EN-US style='font-size:10.0pt'>A000</span><span
style='font-size:10.0pt;font-family:宋体'>，</span><span lang=EN-US
style='font-size:10.0pt'>B000</span><span style='font-size:10.0pt;font-family:
宋体'>，</span><span lang=EN-US style='font-size:10.0pt'>C000</span><span
style='font-size:10.0pt;font-family:宋体'>。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>其中列标表示该单元变参所在的列，</span><span
lang=EN-US style='font-size:10.0pt'>000</span><span style='font-size:10.0pt;
font-family:宋体'>表示当前单元变参所在行的下一行。当有行增删时，这个值也会随行的</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>增删的变化而变化。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span><span
style='font-size:10.0pt;font-family:宋体'>举例说明</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>如在</span><span
lang=EN-US style='font-size:10.0pt'>B5</span><span style='font-size:10.0pt;
font-family:宋体'>单元中有公式</span><span lang=EN-US style='font-size:10.0pt'>&quot;=sum(c000:e000)&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>，则该公式的实际表示</span><span lang=EN-US
style='font-size:10.0pt'>&quot;=sum(b6:e6)&quot;</span><span style='font-size:
10.0pt;font-family:宋体'>。当然如何该列</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>和变动时，公式也会跟着列变动。如有该公式的</span><span
lang=EN-US style='font-size:10.0pt'>B5</span><span style='font-size:10.0pt;
font-family:宋体'>单元由于在前面插入了</span><span lang=EN-US style='font-size:10.0pt'>2</span><span
style='font-size:10.0pt;font-family:宋体'>行，变成了</span><span lang=EN-US
style='font-size:10.0pt'>B7</span><span style='font-size:10.0pt;font-family:
宋体'>单元，</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>则该公式在计算的时候实际表示</span><span
lang=EN-US style='font-size:10.0pt'>&quot;=sum(b8:e8)&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>如在</span><span
lang=EN-US style='font-size:10.0pt'>C3</span><span style='font-size:10.0pt;
font-family:宋体'>单元中有公式</span><span lang=EN-US style='font-size:10.0pt'>&quot;=sum_userval_down(c000:c000,1)&quot;</span><span
style='font-size:10.0pt;font-family:宋体'>，则该公式的实际含义是从</span><span lang=EN-US
style='font-size:10.0pt'>C4</span><span style='font-size:10.0pt;font-family:
宋体'>开始</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal><span style='font-size:10.0pt;font-family:宋体'>向下对</span><span
lang=EN-US style='font-size:10.0pt'>C</span><span style='font-size:10.0pt;
font-family:宋体'>列</span><span lang=EN-US style='font-size:10.0pt'>userval</span><span
style='font-size:10.0pt;font-family:宋体'>为</span><span lang=EN-US
style='font-size:10.0pt'>1</span><span style='font-size:10.0pt;font-family:
宋体'>的单元求和，如果某个单元的</span><span lang=EN-US style='font-size:10.0pt'>userval</span><span
style='font-size:10.0pt;font-family:宋体'>值不为</span><span lang=EN-US
style='font-size:10.0pt'>1</span><span style='font-size:10.0pt;font-family:
宋体'>，则停止计算。</span></p>

<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'>&nbsp;</span></p>

<p class=MsoNormal align=right style='text-align:right'><b><span lang=EN-US
style='font-size:10.0pt'>&nbsp;</span></b></p>

<p class=MsoNormal align=right style='text-align:right'><b><span
style='font-size:10.0pt;font-family:宋体'>泛微软件</span></b></p>

<p class=MsoNormal align=right style='text-align:right'><b><span lang=EN-US
style='font-size:10.0pt'>2006</span></b><b><span style='font-size:10.0pt;
font-family:宋体'>年</span></b><b><span lang=EN-US style='font-size:10.0pt'>11</span></b><b><span
style='font-size:10.0pt;font-family:宋体'>月</span></b></p>

</div>

</body>

</html>