您有一种简洁的方法来确定表中每个单元格的内容和样式。
You have an elegant way to determine both the content and the style of each cell in the table.
为了理解它是如何运作的的,您可以将 MC 看作一个电子表格,它的单元格是度量标准。
To understand how that works, you can think of an MC as a spreadsheet, whose cells are the metrics.
在这个转换中,许多代码清单都具有空单元格。
In this conversion, many of the code lists have empty cells.
我们实现了内容单元格排序。
这就相当于从左上侧进入空白单元格。
This corresponds to entering the blank cell from the above-left.
清单6显示了该工作表的单元格提要。
表1展示了单元格边界样式的通用规则。
Table 1 shows the generalized rules for the cell border styles.
单元格是这些城市的联赛球队。
产生的提要仅包含指定范围的单元格。
The resulting feed contains only the cells in the specified range.
有些单元格包含数值。
清单6.循环所有单元格并打印值。
列表和单元格提要被绑定到一个特定的工作表,其中包含组成工作表的行和单元格。
The list and cell feeds are tied to a specific worksheet and contain the rows and cells that make up that worksheet.
还可以过滤列表提要或单元格提要的内容,从而使提要只返回匹配特定条件的行或单元格。
You also can filter the contents of a list feed or a cell feed, such that the feed returns only rows or cells matching specific criteria.
单元格提要,返回包含组成工作表的单元格的提要。
The cell feed, which returns a feed containing the individual cells of a worksheet.
清单8处理一个单元格提要,因此从单元格提要提取数据的方法与清单7中的方法稍有不同。
Listing 8 operates on a cell feed, and so the method of extracting data from it differs slightly from that in Listing 7.
您可以使用该索引来将格式应用于单元格样式以及将单元格样式应用于单元格,如清单18所示。
You can use that index to apply the formatting to the cell style and apply the cell style to the cell, as in Listing 18.
利用这种格式,行和单元格都很清楚。
就是说第2和第3列中每个单元格的ID的最后一个数字都和为该单元格本身生成的数字相同。
That means the IDs for every cell in columns 2 and 3 end with the same number you generate for the cell itself.
这些嵌套表有两个单元格:第一个单元格为蓝色,第二个单元格为白色。
These nested tables have two cells: the first is colored blue, and the second is white.
向行添加的第一个单元格是一个水平标题栏单元格;向行添加的其他单元格是内容单元格。
The first cell added to a row is a horizontal header's cell; other cells added to a row are content cells.
在这个示例中,新的数值可能来自不止一个单元格,所以可以任选一个:例如左上侧单元格。
In this case, where the new number could have come from more than one cell, pick an arbitrary one: the one to the above-left, say.
在本文的后面,我们将使用两个术语:标题栏单元格和内容单元格。
Further in the article we will use two terms: a header cell and a content cell.
该方法将返回嵌套的单元格数据数组,其中每个单元格使用它的行坐标和列坐标进行索引。
This method returns a nested array of cell data, with each cell indexed by its row and column coordinates.
比较困难的部分是格式化单元格。
用户指定输入单元格、输出单元格及其它参数。
The user specifies input cells, output cells and other parameters.
特别是,注意单元格条目对象的标题将返回被更新的单元格的字母数字坐标。
In particular, notice that the title of the cell entry object returns the alphanumeric coordinates of the cell that was updated.
该函数根据单元格中的文本将列单元格排序(排序不包含标记)。
The function sorts the column cells based on the text in the cells (mark up is excluded from the sorting).
回想一下,任何单元格中的数字都是该单元格所在行之上和列之前的字符串的LCS长度。
Recall that the number in any cell is the length of an LCS of the string prefixes above and below that end in the column and row of that cell.
单元格字符串类型进一步定义单元格,把其中的值限制为1到9的值和点号。
The cell string type further defines the cell by enforcing the constraint that a cell can only contain a value of 1 through 9 and a period.
单元格类型还有一个属性,它根据行、列和子网格限制表示这个单元格是否有效,见图7。
The cell type also has an attribute that represents whether the cell is valid based on the row, column, and grid requirements, as shown in Figure 7.
应用推荐