-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution:
Duplicate
-
Affects Version/s:
None
-
-
-
I'm trying to discern which parts of the specification are affected by the Table:search-criteria-must-apply-to-whole-cell Setting. The only specific mention is in section "4.9.8 Criteria". Based on section 4.9.8, I gather that this setting is meant to apply to database query functions (DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP) that use Criteria.
I propose that we be more specific, adding a note to the functions that are affected, similar to the following note that we add for other calculation settings:
Note that in an OpenDocument table (such as a spreadsheet), this function's search criteria is impacted by table:use-regular-expressions or table:use-wildcards.
In addition to the Database Query functions, are any other functions influenced by this setting? Are other comparisons within formulas using = or <>?
{"report":{"apdex":1,"isInitial":true,"journeyId":"bcc99189-8ffe-48c1-a813-2e613422c3cf","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":642.1999999992549,"redirectCount":0,"resourceLoadedEnd":721.1999999992549,"resourceLoadedStart":157.10000000149012,"resourceTiming":[{"duration":110.69999999925494,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":157.10000000149012,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":267.80000000074506,"responseStart":0,"secureConnectionStart":0},{"duration":110.80000000074506,"initiatorType":"link","name":"https://issues.oasis-open.org/s/7d2823769c2e7b66e860863fe879b7f8-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/9aebb1c0aaa4c36289529757ec9dbb54/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":157.30000000074506,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.30000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":268.1000000014901,"responseStart":0,"secureConnectionStart":0},{"duration":111.19999999925494,"initiatorType":"link","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/8.0.5/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":157.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":268.69999999925494,"responseStart":0,"secureConnectionStart":0},{"duration":111.5,"initiatorType":"link","name":"https://issues.oasis-open.org/s/645acc233eb869f48a571293b8358a7d-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":157.69999999925494,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":269.19999999925494,"responseStart":0,"secureConnectionStart":0},{"duration":112.5,"initiatorType":"link","name":"https://issues.oasis-open.org/s/a0dd6509771c1de0667aae5429c04cda-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":157.80000000074506,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":270.30000000074506,"responseStart":0,"secureConnectionStart":0},{"duration":162.19999999925494,"initiatorType":"script","name":"https://issues.oasis-open.org/s/e5479157e7a0c08b005e6522f2f04104-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":158,"connectEnd":158,"connectStart":158,"domainLookupEnd":158,"domainLookupStart":158,"fetchStart":158,"redirectEnd":0,"redirectStart":0,"requestStart":158,"responseEnd":320.19999999925494,"responseStart":320.19999999925494,"secureConnectionStart":158},{"duration":195.19999999925494,"initiatorType":"script","name":"https://issues.oasis-open.org/s/83514d5d4e8543747b02042eafcdc99c-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/9aebb1c0aaa4c36289529757ec9dbb54/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":158.19999999925494,"connectEnd":158.19999999925494,"connectStart":158.19999999925494,"domainLookupEnd":158.19999999925494,"domainLookupStart":158.19999999925494,"fetchStart":158.19999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":158.19999999925494,"responseEnd":353.3999999985099,"responseStart":353.3999999985099,"secureConnectionStart":158.19999999925494},{"duration":197.20000000298023,"initiatorType":"script","name":"https://issues.oasis-open.org/s/70bb2263e59e7e1f04fbd137c80b895b-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":158.39999999850988,"connectEnd":158.39999999850988,"connectStart":158.39999999850988,"domainLookupEnd":158.39999999850988,"domainLookupStart":158.39999999850988,"fetchStart":158.39999999850988,"redirectEnd":0,"redirectStart":0,"requestStart":158.39999999850988,"responseEnd":355.6000000014901,"responseStart":355.6000000014901,"secureConnectionStart":158.39999999850988},{"duration":197.69999999925494,"initiatorType":"script","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":158.5,"connectEnd":158.5,"connectStart":158.5,"domainLookupEnd":158.5,"domainLookupStart":158.5,"fetchStart":158.5,"redirectEnd":0,"redirectStart":0,"requestStart":158.5,"responseEnd":356.19999999925494,"responseStart":356.19999999925494,"secureConnectionStart":158.5},{"duration":198,"initiatorType":"script","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":158.80000000074506,"connectEnd":158.80000000074506,"connectStart":158.80000000074506,"domainLookupEnd":158.80000000074506,"domainLookupStart":158.80000000074506,"fetchStart":158.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":158.80000000074506,"responseEnd":356.80000000074506,"responseStart":356.80000000074506,"secureConnectionStart":158.80000000074506},{"duration":198.5,"initiatorType":"script","name":"https://issues.oasis-open.org/s/cda37faab827dbdf305de8efe8282062-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/8.0.5/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":159,"connectEnd":159,"connectStart":159,"domainLookupEnd":159,"domainLookupStart":159,"fetchStart":159,"redirectEnd":0,"redirectStart":0,"requestStart":159,"responseEnd":357.5,"responseStart":357.5,"secureConnectionStart":159},{"duration":303.0999999977648,"initiatorType":"link","name":"https://issues.oasis-open.org/s/07245784f53abc49bad9d9d4d36c577a-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/cadc4f20cc5c138dee060d42cf85f220/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":159.30000000074506,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":159.30000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":462.3999999985099,"responseStart":0,"secureConnectionStart":0},{"duration":198.70000000298023,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":159.39999999850988,"connectEnd":159.39999999850988,"connectStart":159.39999999850988,"domainLookupEnd":159.39999999850988,"domainLookupStart":159.39999999850988,"fetchStart":159.39999999850988,"redirectEnd":0,"redirectStart":0,"requestStart":159.39999999850988,"responseEnd":358.1000000014901,"responseStart":358.1000000014901,"secureConnectionStart":159.39999999850988},{"duration":268.1000000014901,"initiatorType":"link","name":"https://issues.oasis-open.org/s/f77fd89aa211a76b20e9b0e63564383c-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/4a9288299d147101bf66484f4be48925/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":194.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":194.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":462.6000000014901,"responseStart":0,"secureConnectionStart":0},{"duration":235.09999999776483,"initiatorType":"script","name":"https://issues.oasis-open.org/s/41525c48ddceeb9b11e54085268fc285-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/4a9288299d147101bf66484f4be48925/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":194.80000000074506,"connectEnd":194.80000000074506,"connectStart":194.80000000074506,"domainLookupEnd":194.80000000074506,"domainLookupStart":194.80000000074506,"fetchStart":194.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":194.80000000074506,"responseEnd":429.8999999985099,"responseStart":429.8999999985099,"secureConnectionStart":194.80000000074506}],"threshold":1000,"fetchStart":1,"domainLookupStart":52,"domainLookupEnd":52,"connectStart":52,"connectEnd":102,"secureConnectionStart":77,"requestStart":102,"responseStart":151,"responseEnd":226,"domLoading":156,"domInteractive":745,"domContentLoadedEventStart":745,"domContentLoadedEventEnd":792,"domComplete":971,"loadEventStart":971,"loadEventEnd":974,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"9615a03bb82852","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":93,"dbReadsTimeInMs":21,"dbConnsTimeInMs":24,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
This listing makes only sense when OpenFormula is used. If anotehr formula language is used than that setting may apply to other functions.