命令:BMBOMPANELOPEN,BMBOMPANELCLOSE,BMBOM
物料清单管理器允许您浏览,创建和编辑当前工程图中的物料清单(BOM)。使用管理器以交互方式配置新的和现有的物料清单。您可以将物料清单的配置保存为模板文件,并稍后在其他工程图中重复使用。您还可以添加未链接到工程图中的表格的材料明细表。
使用物料清单经理,您可以:
- 浏览工程图中的现有材料明细表。
- 使用标准类型(例如顶层,底层,层次结构)或现有BOM表模板创建新的物料清单。
- 编辑物料清单:
- 添加或删除列(包括公式列)。
- 将选定的列移到新位置。
- 重命名列。
- 配置BOM表的排序方式。
- 为每个单独的列配置页脚值。
- 配置单位以及每列的显示方式。
- 使用列属性配置每列的宽度。
- 配置每个单独列的可见性。
- 使用过滤器表达式过滤组件。
- 更改标题行和页脚行的标题。
- 在表中搜索组件。
- 突出显示并选择组件实例。
- 将BOM表配置另存为模板文件。
- 从模板文件加载BOM表配置。
- 将BOM表放置在工程图中。
- 删除BOM表。
修改或创建物料清单需要获得机械许可证或终极许可证。但是,经理可以使用Pro许可证。
打开物料清单经理
请执行以下任一操作:
- 将光标放在工具栏上,然后单击鼠标右键,然后从上下文菜单中选择“ BOM管理器”。
- 启动BMBOMPANELOPEN命令。
工具
管理器中的大多数配置操作都可以在主菜单中找到。上下文菜单可用于选定的列或行。您也可以在管理器的“属性”部分中更改所选列的属性和BOM表本身。要使用特定列,请在BOM表网格中选择它。可以同时选择多个列。
主菜单
单击BOM表管理器面板右上角的菜单按钮(
)。新物料清单 | 打开一个子菜单:
| |
文档中的BOM表 | 打开一个子菜单:
| |
放置/更新BOM表 | 在图形中开始表格的交互式放置。如果表格已经放置在图形中,它将更新表格。 注意:所有编辑操作都会自动更新图形中的关联表。 | |
导出为CSV | 将当前表的内容保存到CSV文件。 打开一个对话框以选择CSV文件的位置: 注意:您可以使用表格属性来调整CSV值的分隔符。 | |
从模板替换 | 用选定的模板替换当前的BOM表配置。 打开一个对话框以选择模板文件。 | |
另存为模板 | 将当前BOM表的配置另存为模板。 打开一个对话框以选择新模板文件的位置。 | |
删除当前物料清单 | 从文档中删除当前BOM表。 | |
设置过滤器 | 打开一个对话框来配置主过滤器: | |
刷新 | 更新当前BOM表并列出工程图中的所有BOM表。 | |
在之后插入列 | 如果选择了列:将列选择器中的列插入表中选定的列之后。 如果未选择任何列:在表的最后一列之后添加一个新列。 | |
在前面插入列 | 如果选择了列:将列选择器中的列插入表中所选列的前面。 如果未选择任何列:则将新列添加为表中的第一列。 | |
插入公式列 | 打开一个对话框来配置公式列: 单击“确定”以在所选列之后添加新的公式列。如果未选择任何列,则在表的最后一列之后添加一个新的公式列。 | |
插入模板列 | 打开一个对话框来配置模板列: 单击“确定”在选定的模板列之后添加新的模板列。如果未选择任何列,则在表的最后一列之后添加一个新的模板列。 | |
编辑评估列 | 打开一个对话框,以编辑选定的公式或模板列。 | |
删除栏 | 从表中删除选定的列。 您还可以在BOM表网格中选择一列,然后按Delete键以删除一列。 | |
向左移动列 | 将选定的列向左移动一列。 | |
向右移动列 | Moves the selected column(s) one column to the right. | |
Make column visible | Shows the selected column in the associated table in the drawing. | |
Make column invisible | Removes the selected column from the associated table. Invisible columns remain visible in the BOM manager but are marked with a diagonal hatch pattern in the background. | |
Associated table | Opens a submenu:
| |
Footer | Opens a submenu: For each of the selected columns:
See the Bill of Materials/Footer for more details. | |
Sorting | Opens a submenu:
有关更多详细信息,请参见材料明细表/排序。 | |
禁用/启用警告 | 控制在BOM表创建或更新期间警告消息的显示。 |
工具栏
主菜单 | 打开主菜单。 | |
BOM选择器 | 选择当前的BOM表。选择存储在图形中。关闭并重新打开工程图后,选定的BOM将恢复到管理器中。选中后,表格将更新为工程图的当前状态。 | |
刷新 | 更新当前BOM表和工程图中所有BOM表的列表。 | |
放置/更新表 | 开始在图形中交互放置表格。 更新表(如果已存在)。 注意:所有编辑操作都会自动更新图形中的关联表。 | |
类别选择器 | 选择一个属性类别。 | |
列选择器 | 选择要添加到当前BOM表的列。 您也可以使用它为公式字段输入公式。 要添加公式,请键入以“ =”开头的表达式,例如“ = <Mass> * <Quantity>”。该公式可能会引用其他列。使用显示在<>中的显示名称。 | |
在之后插入列 | 如果选择了列:将列选择器中的列插入表中所选列的后面。 如果未选择任何列:将新列添加到表中的最后一列之后。 | |
找 | 打开和关闭搜索字段。 Ctrl + F还会切换搜索字段。 | |
搜寻栏位 | 输入搜索字符串;支持通配符。 | |
查找上一个 | 在BOM表中选择上一个匹配项。 您也可以使用Ctrl + F3。 | |
找下一个 | 在BOM表中选择下一个匹配项。 您也可以使用F3。 | |
选择所有找到的 | 在BOM表中选择所有匹配项。 |
列上下文菜单
右键单击列标签以打开上下文菜单。该列将添加到当前选择中。
添加所选模板列 | 打开一个对话框以配置新的模板列。选定的列将自动添加到模板表达式中。 | |
删除栏 | 从表中删除选定的列。 您还可以在BOM表网格中选择一列,然后按Delete键。 | |
页脚 | 打开一个子菜单: 对于选定的列:
See Bill of Materials/Footer for more details. | |
Sorting | Opens a submenu:
See Bill of Materials/Sorting for more details. | |
Aggregate function | Opens a submenu: For the selected column(s):
| |
列角色 | 打开一个子菜单: 对于选定的列: | |
格式 | 设置选定列的指定格式。 打开一个对话框: | |
设置列过滤器 | 打开一个对话框来配置列过滤器: | |
使列可见 | 显示图形中关联表中的选定列。 | |
使列不可见 | 从关联的表中删除选定的列。不可见的列在BOM表管理器中仍然可见,但在背景中用斜线阴影线标记。 | |
适合栏 | 使所选列的宽度适合其内容。 除非手动更改了宽度,否则列宽将自动适合内容。 | |
适合所有列 | 使所有列的宽度适合其内容。 除非手动更改了宽度,否则列宽将自动适合内容。 |
行上下文菜单
右键单击任何单元格以打开上下文菜单。
放大到 | 缩放到模型中的选定零件 | |
选择 | 选择零件。替换现有选择。 | |
添加到选择 | 将零件添加到选择中。 | |
从选择中删除 | Removes the parts from the selection. | |
Remove highlighting | Removes highlighting. | |
Clear selection | Clears a selection. | |
Collapse | Collapses the subassembly group in the BOM grid. | |
Expand | Expands the subassembly group in the BOM grid. | |
Expand this level | Expands all subassembly groups at the same level of the assembly tree as the current one. | |
Collapse this level | Collapses all subassembly groups at the same level of the assembly tree as the current one. | |
Expand all | Expands all subassembly groups in the current BOM. | |
Collapse all | Collapses all subassembly groups in the current BOM. | |
Limit by this level | Sets the current level as the maximal level for hierarchical BOM tables. | |
Show all levels | Removes the maximal level limit for hierarchical BOM tables. |
BOM Title
Displays the title of the current BOM, as displayed in the drawing. Left-click on this control to edit the drawing. In this mode, the BOM title control shows the title template instead. The title template is a string that may contain a <NAME> placeholder, which will be replaced by the assembly name.
Grid
The grid displays the content of the selected BOM table. Each row is linked with its corresponding instances. When a row is selected, the corresponding parts are highlight in the drawing. Use the context menu, to select corresponding parts, add or remove them from the current selection and to zoom to those parts. Double-click on any cell in the row to zoom to the corresponding parts.
Moving a column
To move a column in the BOM table drag and drop it to its new position.
Visible and invisible columns
You can make any column in the BOM table invisible, so it does not show in the resulting table, invisible. Invisible columns remain visible in the BOM grid with a hatched background. You can change the visibility of columns in the main menu, the column context menu or by editing the Visible property of a column in the Properties grid.
Width adjustment
You can adjust the width of any column in the BOM grid, which is independent from the width in the associated table. If the width of the column is less than needed to display the text of the cell, the height of the corresponding row increases to fit the text.
When the column width is adjusted manually, the width remains the same regardless of the content of the table. The width is also stored in the BOM configuration. All adjusted column widths remain the same even when the drawing is closed and reopened.
To fit the column width to the content automatically, do one of the following:
- Select the column(s) and right-click the context menu. Then select Fit column(s).
or - Double-click the separator in the column header.
Sorting a BOM
Use the grid to control how the table of content should be sorted. Double-click a column label to change the order between ascending, descending, and unordered. If a column is used to sort the table, its label has a symbol added (▲ for ascending and ▼ for descending). Double-click the label to revert the sorting order.
You can use multiple columns to sort. The sort symbols of these columns have a subscript to denote the sort order. For example, if you want to sort by quantity in descending order and then by component name in ascending order, the Quantity column will have a ▼₁ symbol and the Component column will have a ▲₂ symbol.
Expand/collapse groups
In hierarchical BOMs, each subassembly forms a group that can be collapsed or expanded in the BOM grid.
To collapse or expand a group, do one of the following:
- Click on the node icon in the first column of the BOM grid
or - Right-click on the row, then select Collapse or Expand from the context menu.
You can also collapse or expand all groups or all groups corresponding to the same assembly level using the context menu.
NOTE | The subassembly group status (collapsed or expanded) is not stored within the document. When the BOM table is closed and reopened, all subassembly groups are expanded by default. |
Properties
The properties grid is located at the bottom of the manager's panel. To adjust its size, use the splitter control, located between the grid and the properties grid.
The properties grid contains the properties of the current table; title, type, filter, sorting mode and footer title. If any columns are selected, the grid will also display their common properties. You can change any common property for all the selected columns at once. Column properties change the title, visibility, and width of the column.
For numerical values, you can set the footer type, unit placement, and the units mode (if the column has units that can be changed).
The unit placement defines where the units are displayed: in the column title, in the same cell as the value itself or in its own column.
The units mode defines how the displayed unit should be obtained; the best unit for all values, the best unit to display a particular value in the cell, or a specified unit. You can choose the Units mode for distance, area, volume or mass properties.
Filter
It is possible to add a custom filter to the current BOM. To apply a filter, do one of the following:
- use the Filter property in the Bill of materials properties section of the Property grid
or - use the Set filter command from the Main menu.
In both cases, the filter dialog box displays:
Each row in this dialog represents an elementary condition. It is possible also to add groups to group several elementary conditions and/or groups together. Groups allow to create complex filters.
Adding a new elementary condition
Do the following:
- (Optional) If necessary, choose the required category to limit the list of properties to that particular category.
- Select the required property from the list of properties. When selected, a condition for the property is added automatically.
- (Optional) Set the required condition type:
- Not equal to
- Less than
- Greater than
- Not less than
- Not greater than
- Set the target value. For text values, you can select the target value from the drop-down list of all possible values. For numerical values, you can specify the unit of the target value. The value will be automatically converted to the document unit.
Removing one or more conditions
Do the following:
- Select the conditions to remove. You can use the Ctrl-key to select several conditions, and Shift-key to select a range of conditions.
- Click the Delete tool ( )
or
Right click the row you want to delete and select Remove condition in the context menu.
Adding a new group of conditions
Do the following:
- Click the Add tool ( ).
- Select Add "All of" group to add a new "All of" group
or
Select Add "Any of" group to add a new "Any of" group. - Add the necessary conditions.
Grouping selected conditions
Do the following:
- Select the conditions to remove. You may use Ctrl-key to select several conditions, and Shift-key to select a range of conditions.
- Right-click the row you want to group, then:
select Form "All of" group from selected to form a new "All of" group
or
select Form "Any of" group from selected to form a new "Any of" group.
To apply the filter, click Ok.
For more details, see Bill of Materials/Filtering.
See also: To set a custom filter for the current BOM.
Column filters
Column filters allow you to set the conditions on which rows to include in the table. Each column filter sets a condition that column values should meet in order to be included. For example, you may set a column filter to include only parts with quantities larger than a certain number, or parts which names contain Nozzle. A column can have no more than one filter; however, it is possible to simultaneously set filters for as many columns as you need. Columns with active filters are marked with a filter icon ( ) in their title.
To add a column filter, right click the column title and select Set column filter in the context menu. A Column filter dialog box displays:
Select the required filter type. Next, you will need to set the target value(s) for the filter, depending on the filter type and the column content.
For columns with numerical content, you can set the unit for the target value. The target value will be automatically converted to the document unit internally.
For text filters, you can choose between ignore case and match case options. In and Not in filters show you the list of all possible values for this column (with respect to already applied filters). Check the values that you want to be included or excluded correspondingly. You can also check all values, uncheck all values or invert the current selection by using the corresponding buttons on toolbars or commands from the context menu.
To apply the column filter, click OK.
To remove a column filter, right click on the column title and select Remove column filter from the context menu.
For more details, see Bill of Materials/Filtering.
Sort
BOM tables support several sort modes (see Bill of Materials/Sorting for more details).
To switch between these modes, use the Sorting mode property in the Bill of materials properties section of the Properties grid. Use the Sorting mode drop-down menu or double-click the column labels in the Grid to toggle between ascending, descending or natural order for the respective column.
Column units
It is possible to change the Unit placement and Units mode for most numerical properties with units. Select the required columns in the Grid and use the Column properties section of the Properties grid to change the Unit placement and the Units mode. For more details, see Bill of Materials/Column units.
See also: Change the units and unit placement modes for the column.
Evaluated columns
A BOM supports evaluated columns. There are two types of evaluated columns: formula and template columns. For more details about formula fields, such as expression syntax, see Bill of Materials/Evaluated columns
See also: Add an evaluated column
Formula columns
To add a formula column, do the following:
- Select the Evaluated column category using the Category selector.
- Select Formula column in the Column selector.
- Use Insert column after or Insert column before tools.
or
Use the Insert formula column option from the Main menu.
In both cases, an Expression configurator dialog displays:
The Expression configurator dialog box.
This dialog allows you to configure the title, unit and expression for the formula column. It also shows a preview of the formula results. The expression field supports autocompletion. To add a reference to a column or a property to the expression at the cursor position, select the required property from the list of properties. You can also click the Add column reference tool ( ) and select the property from the menu, or click the Add function tool ( )vto select the required function.
To add a formula column to the BOM table, click Ok.
Template column
To add a formula column, do one of the following:
- Select "<Evaluated column>" category using the Category selector.
- 在“列”选择器中选择“ <模板列>”。
- 在工具之后使用“插入列”或在工具之前使用“插入列”。
或者
- 使用“主”菜单中的“插入模板列”选项。
在这两种情况下,都会显示“模板配置器”对话框。
该模板配置对话框。
此对话框使您可以配置模板列的标题,表达式以及必要时的单位。它还显示了结果的预览。表达式字段支持自动补全。
模板列可能包含多个模板子表达式。在这种情况下,将对它们进行从头到尾的评估,并使用产生非空结果的第一个子表达式。该模板配置器允许您添加,删除和使用工具栏模板子表达式之间进行切换。它还允许更改模板子表达式的顺序。请注意,在表达式字段中,一次显示所有子表达式,其中每个子表达式都用{}括起来。
要添加子表达式,请单击
。要删除当前子表达式,请使用单击
。请注意,删除最后一个子表达式后,实际上会将其替换为空的子表达式。要更改当前子表达式,请从下拉列表中选择所需子表达式的编号。
使用
和 更改子表达式的顺序。可以使用“模板”部分配置当前选择的子表达式。本节中的每一列都代表模板表达式的一项,您可以对其进行更改。
模板项目的类型为:
- 列引用:表示对BOM表列或属性的引用。要添加列引用,请从属性列表中选择所需的列。它会自动添加到最后选择的列之后,或者,如果没有选择列,则自动添加到最后一列之后。如有必要,定界符将自动添加到“列”引用的前面。
- Delimiter: represents a separator between two items. The delimiter text will appear in the final result only if the text on both sides of it is not empty. For example, if you have PartNumber and Length column references with the "X" delimiter between them, the "X" will be added to the final text only if both PartNumber and Length are not empty. In most cases, delimiters are added automatically. However, you can add delimiters by using the button and selecting Add delimiter from the drop-down list. Alternatively, you can add a delimiter from the context menu.
- Text: represents a custom text. You can add custom text by clicking and selecting Add text from the drop-down list. Alternatively, you can add a custom text from the context menu.
- Evaluated text: represents an item that should be added to the final expression as is. Evaluated text may contain functions or other special symbols that will modify the result. You can add an evaluated text by using the button and selecting Add expression from the drop-down list. Alternatively, you can add an evaluated text from the context menu.
At any moment, you can change the content of any item in the template. You can also delete items by selecting them and using the button, or by choosing Delete column in the context menu. To move an item, select a column in the template and then drag and drop it at the desired position. Any modifications of the template will be reflected in the expression field. Similarly, any changes in the expression field will be reflected in the template area.
To add a template column to the BOM table, click Ok.
Footer row
A BOM table can include a footer row. To add a footer row, specify the footer type for one or more columns. By default, the title of the footer row is TOTAL:. Change the footer title with the Footer title property in the Bill of materials property section of the Properties grid.
For more information about a footer row in a BOM, see Bill of Materials/Footer.
See also: Add a footer for the column.
Aggregated columns
In top-level and bottom-level BOM tables, almost any column can be assigned with an aggregate function. Aggregate functions group values of several rows in a BOM (that differ only in those values) into a single value. For example, aggregate functions can be used to compute the total length of pipes with respect to their size and thickness, or to concatenate all sizes of bolts and nuts used in the assembly in a single cell. For more details, see Bill of Materials/Columns.
To set an aggregate function, do one of the following:
- Right-click on the column title and select the required aggregate function from the Aggregate function submenu.
or - Select the column and change the aggregate function in the corresponding column property.
Aggregated columns are marked with the ∑ symbol in their title.
Templates
You can save BOM configurations as templates. Use the BOM manager to create a new table from a template and to replace the current table configuration with one from a template. You can save the configuration as a template at any moment. You can change a loaded template configuration with the regular tools and save it as another template.
For more information about BOM templates, see Bill of Materials/Templates
Searching
The BOM manager has a search field that allows you to search for a particular value in the table. You can also use Wildcard characters in the search field. By default, BricsCAD searches the entire table. To limit the search area select the required columns. If the value is found, the cursor moves to that cell. If no columns are selected, the row is selected. The Grid automatically scrolls to make the cell visible. To find another value, use the or buttons. You can also use F3 or Ctrl+F3. To select all found results, use button.
By default, the text in the search field is searched for. However, you can also use wildcard characters. The following special symbols are supported:
Name | Character | Description |
Back quote | ` | Escapes the next character (takes it literally). |
Comma | , | Separates patterns. |
Asterisk | * | Matches any character sequence, including a null sequence, anywhere |
Question Mark | ? | Matches a single character. |
Period | . | Matches a single non-alphanumeric character. |
At sign | @ | Matches a single alphabetic character. |
Pound sign | # | Matches a single numeric character. |
Tilda | ~ | If the first character in a pattern matches anything but the pattern. |
Brackets | [...] | Matches a single enclosed character. |
Tilda brackets | [~...] | Matches a single non-enclosed character. |
Hyphen | - | In brackets, matches a single character in the specified range. |
To open the search field, use the Search tool on the toolbar or use Ctrl+F.
Associated table
Each BOM table in the manager can have an associated table in the document, which updates when the BOM configuration is changed. A BOM table can have one associated table only. However, you can create BOM tables that do not have an associated table in the document.
To create an associated table, use Place/Update table. If the BOM table was created with BmBom, the associated table is created automatically.
You can locate the associated table in the document with Associated table - Zoom to or Associated table - Select. If necessary, the active layout switches to the associated table layout.
You can delete the associated table with Associated table - Delete. Alternatively, you can detach the associated table from the BOM table with Associated table - Detach. After it is detached, the associated table loses its link to the BOM table and will not update with the BOM.
Updating the BOM
From BricsCAD V20.2, the BOM manager automatically updates the table content in the panel when the assembly is modified or updated. For large assemblies, this may be inconvenient. The BOM manager automatically updates the table when active. To avoid the automatic update, close the BOM manager to make the BOM Manager panel inactive.
You can manually refresh the BOM manager content using Refresh.
NOTE | The associated table is not updated automatically when the assembly is changed or modified. Use Place/Update table to update the associated table. |
Adding a new bill of materials
- Use the New BOM submenu of the Main menu:
- Select the BOM type or select From template to choose the template file for a BOM.
Selecting the current BOM
Use the BOM selector to select an existing bill of materials.
NOTE | The table will automatically update to the current state of the assembly and the associated table in the drawing (if it exists). |
Changing the type of the current BOM
Change the Type property in the Bill of materials properties section of the Properties grid.
Changing the property set of the current BOM
Change the Property set property in the Bill of materials properties section of the Properties grid.
Changing the counting mode of an hierarchical BOM
Change the Counting mode property in the Bill of materials properties section of the Properties grid.
Changing the grouping mode of top- or bottom-level BOM
Change the Grouping mode property in the Bill of materials properties section of the Properties grid.
Setting a custom filter for the current BOM
- Select the Set filter option from the Main menu.
A Filter Configurator dialog box displays. - Configure the filter using the dialog tool.
See Filter for details. - Press OK to apply the filter.
Adding new columns to the current BOM
- (optional) Use the Category selector to select the category of the properties you want to add:
- Select the property to add from the list of the available columns. This list contains all columns from the selected category which are not yet added to the BOM. If you start to type the name of the field BricsCAD automatically suggests names to you. Click to select it from the list.
- (optional) Select the column in the BOM you want to place the new column next to.
- Click the Insert the column after button ( ) to place the new column after the selected one, or the Insert the column before button ( ) to place the new column before the selected one.
If no column is selected, the new column is placed as the last or the first position respectively.
Adding an evaluated column
- Select the Evaluated columns category using the Category selector.
- Select Formula column to create a formula column or select Template column to create a template column.
- 单击在按钮后插入列(
如果未选择任何列,则将新列分别放置为最后一个或第一个位置。
将显示一个对话框,用于配置评估列。 )将新列放置在所选列的后面,或单击在按钮前插入列( )将新列放置在所选的列之前。 - 更改列的标题。
- 如有必要,请更改单位。
- 使用对话框工具配置表达式。
- 按确定以将列添加到BOM表中。
从选定的列添加模板列
- 选择要合并到模板列中的列。使用Ctrl键选择多个列,或使用Shift键选择列的范围。
- 右键单击所选列之一的标题。
- 从上下文菜单中选择添加模板列。
将显示一个对话框,用于配置评估列。 - 更改列的标题。
- 如有必要,请更改单位。
- 使用对话框工具配置表达式。
- 按确定以将列添加到BOM表中。
- 如有必要,请删除或隐藏不再需要的列。
更改评估列
- 右键单击BOM表网格中的列标题。
- 从上下文菜单中选择“编辑列表达式”。将显示一个对话框,用于配置评估列。
- 根据需要修改列标题,单位和表达式。
- 按确定以应用更改。
从当前BOM表中删除列
- 选择网格中的列。
- 单击删除列工具(
或
按Delete键。 )
更改物料清单标题
使用BOM标题编辑标题
或
使用标题在属性材料性质的法案的部分属性网格。
您可以使用<NAME>占位符来引用程序集名称。
更改页脚行标题
在“属性”网格的“材料明细表”属性部分中使用“页脚标题”属性。
给数字添加前缀或后缀
- 选择数字列。
- 在“列属性”部分中选择“ Number p refix”属性。
- 如有必要,输入新的前缀字符串。
- 在“列属性”部分中选择“数字后缀”属性。
- 如有必要,输入新的后缀字符串。
在分层BOM表中的数字之间更改定界符
- 选择数字列。
- 在“列属性”部分中选择“定界符”属性。
- 输入新的定界符字符串。
Changing the number type in hierarchical BOM
- Select the Number column.
- Select Number type property in the Column properties section.
- Select the required number type.
Change the column title
- Select the column in the BOM grid.
- Select Title property in the Column properties section.
- Change the Title property value to the new title of the column.
Change the column format
- Select the column(s).
- Right click on the title of a selected column.
- Select Format in the context menu.
The Format dialog displays. - Define the desired format.
- Click Ok to apply the changes.
更改列的单位和单位放置模式
- 选择列。
- (可选)在“列属性”部分中更改“单元放置”属性。
- (可选)在“列属性”部分中更改“单位”模式属性。
- (可选)更改标题格式。
- <标题>添加列标题
- <Unit>添加列单位。
- 使用“ \ n”添加换行符。
将页脚添加到列
- 选择列。
- 使用主菜单的页脚子菜单选择页脚值的类型,
或
右键单击列标签,然后选择页脚子菜单:
可以使用以下类型:- 和
- 平均值
- 最低价值
- 最大价值
- 没有页脚(将从页脚中删除该列。如果没有其他页脚类型的列,则该页脚行将被完全删除)
或者:
- 选择列。
- 在“属性”网格中,选择“页脚类型”属性,然后选择页脚类型。
笔记 | 要在“总和”和“无页脚”之间切换,请按“ 页脚”按钮。 |
将当前配置另存为模板
- 选择另存为模板(
显示用于选择模板文件的名称和位置的对话框: )在主菜单( )。 - 指定模板文件的名称和位置。
- 单击保存按钮。
将当前表导出为CSV
- (可选)调整表的CSV分隔符属性:
- 在主菜单()中选择“导出为CSV ” 。
显示用于选择CSV文件的名称和位置的对话框。 - 指定CSV文件的名称和位置。
- 单击保存按钮。