[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-1812) ISO/IEC JTC 1/SC 34N 1078 : DEFECT REPORT NUMBER JP2-21
[ http://tools.oasis-open.org/issues/browse/OFFICE-1812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16122#action_16122 ]
Michael Brauer commented on OFFICE-1812:
----------------------------------------
A proposal for specifying the syntax is:
--
The defined conditions are:
- cell-content-text-length() op value, where op is one of the relational operators '<', '>', '<=', '>=', '=' or '!=': true if the length of the cell's text compared to the value specified in the condition by value using the relational operator op evaluates to true.
- cell-content-text-length-is-between(value1, value2): true if the length of the cell's text is between value1 and value2.
- cell-content-text-length-is-not-between(value1, value2): true if the length of the cell's text is not between value1 and value2.
- cell-content-is-in-list(list), where list is one or more string entries, separated by ';', or a formula: true if the cell's content is in list.
-cell-content-is-decimal-number() and condition, where condition is one of the value conditions below: true if the cell has a numeric value and condition is true.
- cell-content-is-whole-number() and condition, where condition is one of the value conditions below: true if the cell's cell has a whole value and condition is true.
- cell-content-is-date() and condition, where condition is one of the value conditions below: true if the cell has a date value and condition is true.
- cell-content-is-time() and condition, where condition is one of the value conditions below: true if the cell has a time value and condition is true.
The defined value conditions are:
- cell-content() op value, where op is one of the relational operators '<', '>', '<=', '>=', '=' or '!=': true if the cell's value compared to the value specified in the condition by value using the relational operator op evaluates to true.
- cell-content-is-between(value1, value2): true if the cell's value is between value1 and value2.
- cell-content-is-not-between(value1, value2): true if the cell's value is not between value1 and value2.
The defined variables are:
- value , value1 and value2 are a numberValue, a string or a formula.
- numberValue is a whole or decimal number. The number shall not contain comma separators for numbers of 1000 or greater.
- string comprises one or more characters surrounded by quotation marks.
- formula is a formula (see 18.644) without the equals (=) sign at the beginning.
---
A detail that is not yet covered by this proposal is whether the individual formulas or the expression itself shall have an (possible optional) namespace prefix. The description of the syntax is similar to what we have for style:condition.
> ISO/IEC JTC 1/SC 34 N 1078 : DEFECT REPORT NUMBER JP2-21
> ---------------------------------------------------------
>
> Key: OFFICE-1812
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-1812
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Affects Versions: ODF 1.0 (second edition)
> Reporter: Robert Weir
> Assignee: Patrick Durusau
> Fix For: ODF 1.0 Errata 02, ODF 1.2
>
>
> Transcribed from http://www.itscj.ipsj.or.jp/sc34/open/1078.htm
> Original author: "MURATA Makoto (FAMILY Given)" <eb2m-mrt@asahi-net.or.jp>
> DEFECT REPORT NUMBER JP2-21
> QUALIFIER clarification required
> REFERENCES IN DOCUMENT "Condition" in Clause 8.5.3 (original text incorrectly said '8.5.2'
> NATURE OF DEFECT The BNF in this subclause is very unclear. Where is whitespace allowed? Which symbol is a non-terminal symbol and which is a terminal symbol?
> SOLUTION PROPOSED BY THE SUBMITTER Use ISO 14977.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]