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


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-formula] display position?

Hi Patrick,

On Saturday, 2010-01-23 12:41:20 -0500, Patrick Durusau wrote:

> Just curious, what is meant by "display position"?
>>         1.
>>             Storing a non-scalar result in a matrix is controlled by a
>>             few rules.
>>               1.
>>                   If the display position exists in the source data
>>                   use the source.
>>               2.
>>                   If the source data is 1 column wide the display
>>                   position uses the value in the 1st column. This
>>                   applies to
>>                   - scalars '3'
>>                   - singletons '{3}'
>>                   - column vectors '{1|2|3}'
>>               3.
>>                   If the source data is 1 row high all the display
>>                   position uses the value in the 1st row. This applies to
>>                   - scalars '3'
>>                   - singletons '{3}'
>>                   - row vectors '{1;2;3}'
> It occurs these three times and no where else in the draft.
> I am assuming it is a reference to the existence of a location in a  
> matrix for the storage of a value that is part of a matrix result but  
> why call it "display position?" Is there some significance to that?

In a spreadsheet, the result of an array/matrix formula is (or may be)
spread over several matrix cells. The array elements are displayed in
cells, with a position offset corresponding to the offset in the array.

If the array to be displayed is a single element or a vector, the
element respectively vector is repeated, e.g. a 1 row by 3 columns
vector is repeated if the cell matrix displaying it is more than 1 row

Now, it would be easy to say we are not concerned with spreadsheet
displays, but this logic is also applied if a vector is used in
a context where a larger matrix is expected (of same width or height as
the vector), then the corresponding element of the same column/row is
used. We may find another expression than "display position", but what
name would satisfy both uses?


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]