[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]