ISO/IEC JTC 1/SC 34 N 1078 : DEFECT REPORT NUMBER JP2-17

8.4.3 Detective Replace: "The <table:detective> element has two purposes. One the one hand, it contains information about relations that exist between table cells because of formulas and that should be highlighted in the UI. On the other hand, the element contains information about cells that are highlighted currently in the UI either because of the relations mentioned above or because of error conditions." with "The <table:detective> element contains information about what relationships between the current cell and other cells are revealed in the presentation of the table." 8.4.4 Detective Operation Replace: "The <table:operation> element specifies that certain relations that exist between the cell the element is a child of and other cells should be made visible or invisible in the UI. One and the same detective operation can be applied multiple times to the same cell. In this case, the second operation is applied to the resulting cells of the first operation and so on. This means that an operation not necessarily is applied to the cell the operation is defined in, but also to other cells, and that it therefor can interact with operations defined in other cells. This especially applies to operations that make relations invisible. To get a determinate behavior, operations have an index and are applied in the order of that index. The attributes associated with the <table:operation> element are:" with "The <table:operation> element specifies both the type of detective operation that leads to the discovery of relationships between cells (table:name attribute) and the order which those operations are applied (table:index attribute). Once relationships between cells have been discovered, those cells are highlighted to show those relationships. The attributes associated with the <table:operation> element are:" 8.4.4 Name Replace "The table:name attribute specifies the name of the detective operation. Possible names are trace-dependents , remove-dependents, trace-precedents, remove-precedents and trace-errors. trace-dependents and remove-dependents displays or hides cells that use the value of the current cell in their formula. Trace-precedents and remove-precedents displays or hides cells whose value is used in the formula of the current cell. Trace-errors displays cells that cause an error while calculating the result of the current cell's formula." with "The table:name attribute specifies the name of a detective operation. The defined values for the table:name attribute are: remove-dependents: removes highlighting from cells that use the value of the current cell in their formula. remove-precedents: removes highlighting from cells whose values are use in the formula of the current cell. trace-dependents: highlights cells that use the value of the current cell in their formula. trace-errors: highlights cells that cause an error while calculating the result of the current cell's formula. trace-precedents: highlights cells whose values are use in the formula of the current cell. The nature of the highlighting imposed or removed from cells as the result of detective operations is implementation dependent."