OASIS Open Document Format for Office Applications (OpenDocument) TC

Re: [office] Definition of cellAddress lacks apostrophe in tablename

  • 1.  Re: [office] Definition of cellAddress lacks apostrophe in tablename

    Posted 07-03-2006 02:47
     MHonArc v2.5.0b2 -->
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    

    office message

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


    Subject: Re: [office] Definition of cellAddress lacks apostrophe in tablename


    Hi, unfortunately I will not be able to make the teleconference
    on July 3rd due to a sudden schedule change.
    
    However, I promised to double-check on the cell naming
    issue, so here's what I found.  This dates back to an
    April 13, 2006 posting by Eike Rathke, and Eike is absolutely right.
    The problem is that the spec doesn't show how
    to include the single-quote in table names.  We solved this in
    the formula group with the typical convention of doubling single quotes,
    a common solution to the problem.
    
    So yes, please do fix the syntax for table names, so that a
    doubled ' is considered part of the table name.  Thanks.
    
    Eike Rathke wrote:
    > Hi,
    > 
    > According to the current ODF cellAddress definition in
    > 8.3.1 Referencing Table Cells
    > line 3838, the apostrophe character is not allowed in table names (I'm
    > using EBNF syntax here)
    > 
    > TableName   ::= [^\. ']+ | "'" [^']+ "'"
    > 
    > However, for spreadsheet context, embedded apostrophes must be allowed,
    > and could be doubled for storage.
    > 
    > SheetName   ::= [^\. ']+ | "'" ([^'] | "''")+ "'"
    > 
    > How can this be addressed in the ODF specification?
    
    --- David A. Wheeler
    


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