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-3445) ODF 1.2 CD05 Part 119.285 form:linked-cell use of References



    [ http://tools.oasis-open.org/issues/browse/OFFICE-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21549#action_21549 ] 

Dennis Hamilton commented on OFFICE-3445:
-----------------------------------------

I started searching the schema for use of cellAddress and there are a bunch.  I also see that the allowing cellAddress or string is seriously ambigous and it looks like spaces and other goodies are allowed in sheet names, if that's what comes in front of the last ".".  Not sure what to make of all this.  It looks like a cellRangeAddress can do a cuboid, including one of full columns or full rows.

Here's the schema:

    <define name="cellAddress">
        <data type="string">
            <param name="pattern">($?([^\. ']+|'([^']|'')+'))?\.$?[A-Z]+$?[0-9]+</param>
        </data>
    </define>
    <define name="cellRangeAddress">
        <choice>
            <data type="string">
                <param name="pattern">($?([^\. ']+|'([^']|'')+'))?\.$?[A-Z]+$?[0-9]+(:($?([^\. ']+|'([^']|'')+'))?\.$?[A-Z]+$?[0-9]+)?</param>
            </data>
            <data type="string">
                <param name="pattern">($?([^\. ']+|'([^']|'')+'))?\.$?[0-9]+:($?([^\. ']+|'([^']|'')+'))?\.$?[0-9]+</param>
            </data>
            <data type="string">
                <param name="pattern">($?([^\. ']+|'([^']|'')+'))?\.$?[A-Z]+:($?([^\. ']+|'([^']|'')+'))?\.$?[A-Z]+</param>
            </data>
        </choice>
    </define>
    <define name="cellRangeAddressList">
    <!-- Value is a space separated list of "cellRangeAddress" patterns -->
        <data type="string"/>
    </define>

> ODF 1.2 CD05 Part 1 19.285 form:linked-cell use of References
> -------------------------------------------------------------
>
>                 Key: OFFICE-3445
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3445
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: Forms, OpenFormula, Part 1 (Schema)
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Dennis Hamilton
>             Fix For: ODF 1.2 CD 06
>
>
> the definition of form:linked-cell allows cell address or a "plain" string (note the ambiguity).    There is no indication that this might be used with a spreadsheet cell and that references, etc., may be more elaborate than described her.  
> The potential interaction with OpenFormula needs to be discussed.  Is this potentially a place where a namespace prefix and the option of using an OpenFormula Reference should be provided?

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