Michael Brauer added a comment - 26/Aug/09 09:15 AM

Michael Brauer added a comment - 26/Aug/09 09:15 AM This issue is for ODF 1.2 only. There is an additional issue OFFICE-1811 regarding the ODF 1.0 Errata 2. This contains a discussion of the issue. There is also OFFICE-2033 which covers the OpenFormula specific aspect of the search criteria spreadsheet setting.

Patrick Durusau added a comment - 24/Sep/09 08:10 AM

Patrick Durusau added a comment - 24/Sep/09 08:10 AM Michael, I thought we had fixed this but in 18.709 it still reads: "The table:search-criteria-must-apply-to-whole-cell attribute specifies whether or not the specified search criteria, according to the regular expression used, must apply to the entire cell contents." This is a child of <table:calculation-settings> but none of its sibling attributes contain the "search criteria." And it is not readily apparent how any of the parent elements of <table:calculation-settings> would have the search criteria.

Michael Brauer added a comment - 24/Sep/09 08:26 AM

Michael Brauer added a comment - 24/Sep/09 08:26 AM Patrick: There is a proposal for this issue in OFFICE-1811 which should be applicable to ODF 1.2, too, but there is also a longer discussion. Eike worked out the proposal. I'm assigning the issue to him therefore.

Eike Rathke added a comment - 30/Sep/09 10:07 AM

Eike Rathke added a comment - 30/Sep/09 10:07 AM Copying from OFFICE-1811 here to have it in one place: The setting influences string queries that compare cell content against a text search criteria (pattern). If the value of table:search-criteria-must-apply-to-whole-cell is "true", the search pattern must match the entire cell content; if the attribute's value is "false", the search pattern can match a substring at any position within the cell. The setting is used with the <table:filter-condition> element if the table:data-type attribute has the value "text" and the table:operator attribute is one of match (matches) !match (does not match) = (Equal to) != (Not equal to) Furthermore, the following OpenFormula spreadsheet functions use search criteria: DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP COUNTIF COUNTIFS SUMIF SUMIFS LOOKUP VLOOKUP HLOOKUP MATCH Note: In addition to OFFICE-1811 added COUNTIFS and SUMIFS.

Eike Rathke added a comment - 30/Sep/09 12:45 PM

Eike Rathke added a comment - 30/Sep/09 12:45 PM I think adding the text from my previous comment will resolve this issue. @Patrick: if you find a better wording, please go ahead.

Patrick Durusau added a comment - 05/Oct/09 06:30 AM

Patrick Durusau added a comment - 05/Oct/09 06:30 AM Correction will appear in OpenDocument-v1.2-part-1-cd03-rev03.