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-3452) ODF 1.2 CD05 Part 2- Syntax for Named Range not Identified



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

Dennis Hamilton commented on OFFICE-3452:
-----------------------------------------

I am assuming that, if there is something that is a named range, it has a syntax, in OpenFormula, whereby it can be used anywhere a reference can be used (possibly with restriction on the semantics).

So it seems to me that a named-expressioin would not work for this case.

But I am guessing.

If it has something to do with labels, I am still mystified.

4.11.8 exceeds my comprehension.

The paragraph in 3.2 mentions some other things that I am uncertain about their being referenceable as well.  I agree with that.

I tried "variable" and found weirdness in 6.9.1 and the database function prototypes that refer back to 4.11.8 and 4.11.10.  Other uses of variables are benign.

Perhaps the prudent thing to do is remove all mention of named ranges from OpenFormula?  Section 3.2 needs a slight lobotomy with regard toother notions as well, perhaps.

ANALYSIS

In CD05-1 9.4.12 <table:named-range> we have a way of naming a range within a single table.  It seems from 9.4.12 that <table:named-range> is found in the <table:named-expressions> element of a given of a variety of elements.  I suppose the use with <office:spreadsheet> and <table:table> are the ones that interest us in terms of OpenFormula 

The description of the table:name attribute in 19.675.10 talks about databases when there seems to be no inherent connection to databases for <table:named-range>.   The name is allowed to be any string, which is not particularly helpful for OpenFormula.  

The definition of the table:base-cell-address attribute in 19.588 is also odd, though it is handy that it is a value of type cellAddress.  Section  19.595.7 also exceeds my comprehension with regard to table:cell-range-address in <table:named-range> elements, since it talks about a [relative] cell address, not the cell range address.  However, the value of tale:cell-range-address is a cellRangeAddress and I suppose the business about relativity to the cell in which the named range is used could be extended to occurrences in OpenFormula, whatever that means exactly.  It appears that the provisions of 19.702 table:range-usable-as is not relevant to whether OpenFormula can reach out to one of these.

If X is a named range in some appropriate syntax, does =SUM(X) deliver the expected?  MIN(X)?  I have no idea.





> ODF 1.2 CD05 Part 2 - Syntax for Named Range not Identified
> -----------------------------------------------------------
>
>                 Key: OFFICE-3452
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3452
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula, Part 2 (Formulas)
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Dennis Hamilton
>             Fix For: ODF 1.2 CD 06
>
>
> In ODF 1.2 CD05 Part 2, the term "named range" is used in many places.
> We believe, in conjunction with OFFICE-3446, that this is a job for HOST-REFERENCE-RESOLVER. 
> However, there is nowhere in the description of OpenFormula expressions where any construct is identified as being a mention of a named range.
> Is this intended to be a case of named-expression?  This may create limitations on where a named range can be referenced.  It would seem that a named-range reference could be anywhere that a Reference can be.  
> This needs to be resolved explicitly.

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