[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-2170) From Office-662-'NumberSequence' is not properly defined
[ http://tools.oasis-open.org/issues/browse/OFFICE-2170?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=19077#action_19077 ]
David Wheeler commented on OFFICE-2170:
----------------------------------------
Array semantics are in the array section. If there's a problem with them, I think they should be fixed in that section; is that inadequate? If so, suggestions?
As far as what happens in a rectangular range, the quick answer is that the rectangular area is transformed into a sequence. Different implementations do it differently, though. E.G., Excel 2007 seems to do "row at a time", while OpenOffice.org 3.2.0 does it a "column at a time". Given that difference, and the fact that no one seems to notice, I would leave row-at-a-time vs. column-at-a-time as an implementation-defined option. See below for more detail.
I intend to add a section noting what Sequences are, see OFFICE-1187 for more about that.
== DETAILS ==
As promised, here is more detail about row-at-a-time vs. column-at-a-time processing for sequences.
Microsoft Excel 2007 seems to convert a cuboid reference to a sequence this way ("row at a time"):
Start at the initial sheet, initial row, initial column. Process each *row* in turn, from smallest to largest column value (e.g., A1, B1, C1).
Once a row has been completely processed, go on to the next row. When all rows on a sheet have been processed, go to the
next sheet and start over if there is a next sheet.
OpenOffice.org seems to convert a cuboid reference to a sequence this way ("column at a time"):
Start at the initial sheet, initial row, initial column. Process each *column* in turn, from smallest to largest row value (e.g., A1, A2, A3).
Once a column has been completely processed, go on to the next column. When all columns on a sheet have been processed, go to the
next sheet and start over if there is a next sheet.
Presumably, if there's a concatenation of cuboids, they would process the first concatenation this way, then add the next concatenated cuboid to the sequence, and so on.
I didn't test that.
I determined this by creating a test Sheet1 with:
1 2 3
4 5 #DIV/0! #N/A
7 #N/A 9
And test Sheet2 with:
1 2 3
#N/A 5 6
All starting at A1.
In my tests, I presume that if an error is encountered, the FIRST error encountered is returned.
That's true for operators, and I don't know why it would be different for ranges.
If that's false, please let me know!
In Excel 2007:
=SUM(A1:C3) gives #DIV/0 - so it does a row, then the next row, etc.
=SUM(A2:D2) gives #DIV/0 - so inside a row, it does "left to right".
I say that in quotes because it RTL languages, like Arabic or Hebrew, that
will actually *display* right to left, but it'll still compute inside a row from
lowest to highest column value.
=SUM(Sheet1:Sheet2!A1:C3) gives #DIV/0, so it does a whole sheet before
going on to the next sheet.
In OpenOffice.org 3.2.0:
=SUM(A1:C3) gives =NA(), so it computes by COLUMNS.
I also checked, and inside a column it computes lowest to highest value row.
> From Office-662- 'NumberSequence' is not properly defined
> ---------------------------------------------------------
>
> Key: OFFICE-2170
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-2170
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: OpenFormula
> Reporter: Eric Patterson
> Assignee: David Wheeler
> Priority: Minor
> Fix For: ODF 1.2
>
>
> 'NumberSequence' is not properly defined - it does not specify
> what happens in an array, nor what happens for a rectangular
> range (more than one row / column). There is no section actually
> defining it - merely a 'Conversion to...' section.
--
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]