[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-1187) Conversion toNumberSequence
[ http://tools.oasis-open.org/issues/browse/OFFICE-1187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=19080#action_19080 ]
David Wheeler commented on OFFICE-1187:
----------------------------------------
Here is what I suggest.
Add a new "Heading 3" section at the end of 3.11 (making 3.11.11).
TITLE:
"Sequences (NumberSequence, NumberSequenceList, DateSequence, LogicalSequence, and ComplexSequence)"
TEXT:
"Some functions accept a sequence, i.e., a value that is to be treated as a sequential series of values. The following are sequences: NumberSequence, NumberSequenceList, DateSequence, LogicalSequence, and ComplexSequence.
When evaluating a function that accepts a sequence, the evaluator shall follow the rules for that sequence as defined in section 5.3. When processing a ReferenceList, the references are processed in order (first, second if any, and so on). In a cuboid, the first sheet is first processed, followed by later sheets (if any) in order. Inside a sheet, it is implementation-defined as to whether the values are processed row-at-a-time or column-at-a-time, but it must be one of these two processing orders. If processing row-at-a-time, the sequence must be produced by processing each row in turn, from smallest to largest column value (e.g., A1, B1, C1). If processing column-at-a-time, the sequence must be produced by processing each column at a time, from the smallest to the largest row value (e.g., A1, A2, A3)."
Also, just before "Conversion to Text" (5.4.13), insert a new "Heading 3" with
TITLE:
"Conversion to LogicalSequence"
TEXT:
If the expected type is LogicalSequence, then if value is of type:
* Number or Logical, handle as Conversion to Logical (creating a sequence of length 1).
* Reference, create a sequence of logical values from the values of the referenced cells that only includes the values of type Logical and Error. If the Logical type is not a distinguished type, then include values of type Number, converting each to a Logical value as described in Conversion to Logical. Empty cells are not included in a LogicalSequence.
Also, in the section 3.8 (Reference), somehow the first sentence got merged into the title.
The title is "Reference"; the text beginning "A cell strip..." is its first sentence.
> Conversion to NumberSequence
> ----------------------------
>
> Key: OFFICE-1187
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-1187
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: OpenFormula
> Reporter: Robert Weir
> Assignee: David Wheeler
> Priority: Minor
> Fix For: ODF 1.2
>
>
> Copied from office-comment list
> Original author: "David King" <openoffice@drking.plus.com>
> Original date: 23 Dec 2008 06:12:44 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200812/msg00046.html
> Original subject: Re: [office-comment] ODFF: more suggestions: CORREL
--
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]