OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[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).
"Sequences (NumberSequence, NumberSequenceList, DateSequence, LogicalSequence, and ComplexSequence)"

"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
"Conversion to LogicalSequence"

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]