Versions Compared

Old Version 1

changes.mady.by.user Hugo

Saved on

compared with

New Version 2

changes.mady.by.user Zhang Allen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColorgreen
borderWidth1
titleBGColor#ddffcc
borderStylesolid
titleDefinition

电子表格表单元素 允许用户根据用例在类似Excel的环境中执行许多操作。电子表格的几个使用示例是：

  • 数据库编辑
  • 配置控制
  • 数据合并
  • 人力规划
  • 销售报告
  • 财务分析
Spreadsheet Form Element allow users to perform many actions in an excel-like environment, depending on the use cases. A few examples of uses of spreadsheets are:
  • Database editing
  • Configuration controlling
  • Data merging
  • Workforce planning
  • Sales reporting
  • Financial analysis
Panel
borderColorpurple
borderWidth1
titleBGColor#ddccff
borderStylesolid
titleNew Feature

This is a new feature in Joget Workflow v6.这是Joget Workflow v6中的一个新功能。


Figure 1 : Sample Spreadsheet Form Element in the Userview图1：用户视图中的示例电子表格表单元素

Figure 2 : Spreadsheet Form Element Properties

图2：电子表格表单元素属性

名称描述NameDescription
SpreadsheetElement ID of the form element.表单元素的元素ID
LabelSpreadsheet label电子表格标签/title.标题
Columns

电子表格列在这里定义。

子元素描述

The spreadsheet column(s) is defined here.

Sub-elementDescription
ValueField ID of the column.列的字段ID。
LabelColumn header title/label.列标题标题/标签。
Format Type

Defines the type of input to store.

Default format type is Text.

Available Data Types:

  • Text - format the value as text
  • Numeric - accepts a numeric value (See Format documentation)
  • Date - accepts a date type value
  • Time - accepts a time type value
  • Checkbox - appears as a checkbox to check
  • Dropdown - appears as a dropdown menu to select options
  • Autocomplete - autocompletes any known phrases
  • Password - obscures any alphanumerical value into a password
  • Custom
Format

Defines the format to show data on the spreadsheet based on the chosen format type.

  • Numeric - Key in format accepted by numbrojs library.
  • Date - Key in format accepted by moment.js  library.
  • Time - Key in format accepted by moment.js library.
  • Dropdown - Key in Form ID that contains the equivalent dropdown element.
  • Autocomplete - See handsontable for samples.
  • Custom - See handsontable for samples.
Regex ValidationValidates input value to match the defined Regular Expression pattern.

定义要存储的输入的类型。

默认格式类型是文本。

可用的数据类型：

  • Text - 将文本的值格式化
  • Numeric - 接受数值（请参阅格式文档）
  • Date - 接受日期类型值
  • Time - 接受时间类型值
  • Checkbox - 显示为复选框以检查
  • Dropdown  -显示为下拉菜单选择选项
  • Autocomplete  - 自动完成任何已知的短语
  • Password  - 将任何字母数字值隐藏到密码中
  • Custom
Format

定义基于所选格式类型在电子表格中显示数据的格式。

  • Numeric -键入 numbrojs 库支持的格式
  • Date - 键入 moment.js  库支持的格式
  • Time - 键入 moment.js  库支持的格式
  • Dropdown - 键入包含等效下拉元素的表单ID。
  • Autocomplete - 参阅 handsontable 示例.
  • Custom - 参阅 handsontable 示例.
Regex Validation验证输入值以匹配定义的正则表达式模式。
Formula

定义执行处理的公式。

Formula

Defines a formula to perform processing.

Info
titleSample

Example: sales + profit-loss例如：销售额+利润损失

 

 

ReadonlyDefines if the column is editable.定义列是否可编辑。

Figure 3 : Spreadsheet Form Element Properties 图3： 电子表格表单元素属性 -  UI

 

NameDescription
Enable Header Sorting?Determines if users can sort spreadsheet data by column in ascending or descending order.确定用户是否可以按升序或降序排列电子表格数据。
Data Order Field IDField to keep the ordering sequence. Must correspond with a field id in the target form.字段保持排序顺序。必须与目标表单中的字段ID相对应。
ReadonlyDefines if the entire spreadsheet is editable.定义整个电子表格是否可编辑。
Disable Add FeatureDetermines if a new row can be added.确定是否可以添加新行。
Disable Delete FeatureDetermines if a row can be removed.确定是否可以删除一行。
Show Row Numbering?

Show additional column on the leftmost to denote numbering.在最左边显示附加列来表示编号。

Info
titleSample

Row numbering checked.行编号检查。

Number of columns to fixed on left

允许指定表格左侧固定（或冻结）列的数量。

默认值：0

Allows to specify the number of fixed (or frozen) columns on the left of the table.

Default Value: 0

Number of spare rows

Number of spare row to be added automatically after lines with values.在有值的行之后自动添加的备用行数。

Info
titleSample

1 spare row备用行

 

 

Custom Settings (JSON)-

 

Figure 4 : Spreadsheet Form Element Properties - Validation & Data Binder图4：  电子表格表单元素属性 - 验证和数据 绑定器

 

Name名称Description描述
Validator

Attach a Validator plugin to validate the input value.附加一个Validator插件来验证输入值。

Info
titleWhen will validation takes place?

Validation will takes place whenever form is submitted except when it is submitted as "Save as Draft".除非提交表格为“另存为草稿”，否则将在提交表格时进行验证。

Min Number of Row Validation (Integer)Defines the minimum number of rows required for input.定义输入所需的最小行数。
Max Number of Row Validation (Integer)Defines the maximum number of rows possible for input.定义输入可能的最大行数。
Error MessageError message to be shown when row requirements set above is not met.当不满足上述行要求时，将显示错误消息。
Load BinderOption by default. Grid data will be saved/loaded in JSON format in its defined database cell.默认选项。表格数据将在其定义的数据库单元中以JSON格式保存/加载。
Store BinderOption by default. Grid data will be saved/loaded in JSON format in its defined database cell.默认选项。表格数据将在其定义的数据库单元中以JSON格式保存/加载。