OASIS Open Document Format for Office Applications (OpenDocument) TC

 View Only
Expand all | Collapse all

Spreadsheet Table Protection Options

  • 1.  Spreadsheet Table Protection Options

    Posted 05-01-2009 21:18
    Hi there,
    
    I have just revised the following proposal
    
    http://wiki.oasis-open.org/office/Spreadsheet_Table_Protection_Options
    
    The changes include:
    
    1) section number updates
    2) use http://www.oasis-open.org/committees/office/legacy-hash-excel as
    the URI to refer to the legacy hash algorithm used by the older versions
    of Excel.
    3) inclusion of the legacy hash algorithm as a C code snippet.
    
    I have decided to propose inclusion of the hash algorithm in the spec
    because the published final ECMA 376 specification no longer includes
    the hash algorithm I previously referenced.
    
    Comments are welcome.
    
    Kohei
    
    -- 
    Kohei Yoshida - OpenOffice.org Engineer - Novell, Inc.
    


  • 2.  Re: [office] Spreadsheet Table Protection Options

    Posted 05-06-2009 22:57
    On Fri, 2009-05-01 at 17:17 -0400, Kohei Yoshida wrote:
    > Hi there,
    > 
    > I have just revised the following proposal
    > 
    > http://wiki.oasis-open.org/office/Spreadsheet_Table_Protection_Options
    > 
    > The changes include:
    > 
    > 1) section number updates
    > 2) use http://www.oasis-open.org/committees/office/legacy-hash-excel as
    > the URI to refer to the legacy hash algorithm used by the older versions
    > of Excel.
    > 3) inclusion of the legacy hash algorithm as a C code snippet.
    
    I have further edited the proposal to 
    
    4) remove default values from the schema, and
    5) allow double-hashing for the document passwords as well as the table
    passwords
    6) change the default value for table:protection-key-digest-algorithm-2
    so that an absence of this attribute means the application should not
    double-hash the password.
    
    I would at least like someone to confirm that it's okay to use
    the http://www.oasis-open.org/committees/office/legacy-hash-excel URI
    to identify the legacy Excel hash.  It's a made-up URI and doesn't lead
    to any existing content.  I made that one up only because the
    table:protection-key-digest-algorithm attribute (and the -2 variant)
    requires an URI.
    
    Thanks.
    
    Kohei
    
    -- 
    Kohei Yoshida - OpenOffice.org Engineer - Novell, Inc.
    


  • 3.  Re: [office] Spreadsheet Table Protection Options

    Posted 05-06-2009 23:37
    OASIS has some guidelines related to namespace and URI management in OASIS 
    standards here:
    
    http://docs.oasis-open.org/specGuidelines/namingGuidelines/resourceNaming.html
    
    I have not deeply immersed myself in that document, but a cursory glance 
    suggest that they want the URI to rooted as 
    http://docs.oasis-open.org/office/path/foo
    
    Also, do we need a version number or something in the URI?  Or do all 
    legacy versions of Excel use the same algorithm?
    
    -Rob
    
    Kohei Yoshida 


  • 4.  Re: [office] Spreadsheet Table Protection Options

    Posted 05-07-2009 00:04
    Not quite; http://docs.oasis-open.org/ns/office/path/foo or http://docs.oasis-open.org/office/ns/path/foo 
    .
    
    Mary
    
    Mary P McRae
    Director, Standards Development
    Technical Committee Administrator
    OASIS: Advancing open standards for the information society
    email: mary.mcrae@oasis-open.org
    web: www.oasis-open.org
    twitter: fiberartisan  #oasisopen
    phone: 1.603.232.9090
    
    Standards are like parachutes: they work best when they're open.
    
    
    
    
    
    
    
    
    On May 6, 2009, at 7:38 PM, robert_weir@us.ibm.com wrote:
    
    > OASIS has some guidelines related to namespace and URI management in  
    > OASIS
    > standards here:
    >
    > http://docs.oasis-open.org/specGuidelines/namingGuidelines/resourceNaming.html
    >
    > I have not deeply immersed myself in that document, but a cursory  
    > glance
    > suggest that they want the URI to rooted as
    > http://docs.oasis-open.org/office/path/foo
    >
    > Also, do we need a version number or something in the URI?  Or do all
    > legacy versions of Excel use the same algorithm?
    >
    > -Rob
    >
    > Kohei Yoshida 


  • 5.  Re: [office] Spreadsheet Table Protection Options

    Posted 05-07-2009 00:09
    I'm assuming "ns" is taken literally, and "path" and "foo" are place 
    holders?
    
    -Rob
    
    Mary McRae 


  • 6.  Re: [office] Spreadsheet Table Protection Options

    Posted 05-07-2009 00:17
    yes :-)
    
    Note that absolutely nothing lives under the ns path - the namespace  
    document itself as well as any DTDs, schemas, etc. live in the normal  
    directory structure (without the 'ns'). The namespace URI resolves to  
    the namespace document, which then identifies each of the components  
    of the specification itself.
    
    Regards,
    
    Mary
    
    Mary P McRae
    Director, Standards Development
    Technical Committee Administrator
    OASIS: Advancing open standards for the information society
    email: mary.mcrae@oasis-open.org
    web: www.oasis-open.org
    twitter: fiberartisan  #oasisopen
    phone: 1.603.232.9090
    
    Standards are like parachutes: they work best when they're open.
    
    
    
    
    
    
    
    
    On May 6, 2009, at 8:11 PM, robert_weir@us.ibm.com wrote:
    
    > I'm assuming "ns" is taken literally, and "path" and "foo" are place
    > holders?
    >
    > -Rob
    >
    > Mary McRae 


  • 7.  Re: [office] Spreadsheet Table Protection Options

    Posted 05-07-2009 03:02
    On Wed, 2009-05-06 at 20:16 -0400, Mary McRae wrote:
    > yes :-)
    > 
    > Note that absolutely nothing lives under the ns path - the namespace  
    > document itself as well as any DTDs, schemas, etc. live in the normal  
    > directory structure (without the 'ns'). The namespace URI resolves to  
    > the namespace document, which then identifies each of the components  
    > of the specification itself.
    
    Thanks for this clarification, Mary.
    
    With this information, let me revise my proposal and update the URI that
    meets these resource naming guidelines....
    
    Kohei
    
    


  • 8.  Re: [office] Spreadsheet Table Protection Options

    Posted 05-07-2009 03:09
    You're welcome!
    
    Mary
    
    Mary P McRae
    Director, Standards Development
    Technical Committee Administrator
    OASIS: Advancing open standards for the information society
    email: mary.mcrae@oasis-open.org
    web: www.oasis-open.org
    twitter: fiberartisan  #oasisopen
    phone: 1.603.232.9090
    
    Standards are like parachutes: they work best when they're open.
    
    
    
    
    
    
    
    
    On May 6, 2009, at 11:01 PM, Kohei Yoshida wrote:
    
    > On Wed, 2009-05-06 at 20:16 -0400, Mary McRae wrote:
    >> yes :-)
    >>
    >> Note that absolutely nothing lives under the ns path - the namespace
    >> document itself as well as any DTDs, schemas, etc. live in the normal
    >> directory structure (without the 'ns'). The namespace URI resolves to
    >> the namespace document, which then identifies each of the components
    >> of the specification itself.
    >
    > Thanks for this clarification, Mary.
    >
    > With this information, let me revise my proposal and update the URI  
    > that
    > meets these resource naming guidelines....
    >
    > Kohei
    >
    
    


  • 9.  Re: [office] Spreadsheet Table Protection Options

    Posted 05-07-2009 03:53
    On Wed, 2009-05-06 at 23:01 -0400, Kohei Yoshida wrote:
    > With this information, let me revise my proposal and update the URI
    > that meets these resource naming guidelines....
    
    Ok.  I took the liberty of being the first one (?) to create an own URI
    for this TC, which is a bit scary especially when there is no precedents
    to follow.
    
    Anyway, I've renamed the URI to
    http://docs.oasis-open.org/office/ns/table/legacy-hash-excel and updated
    the proposal.  I hope this is a good one to use.
    
    Kohei
    
    
    


  • 10.  Re: [office] Spreadsheet Table Protection Options

    Posted 05-07-2009 02:54
    On Wed, 2009-05-06 at 19:38 -0400, robert_weir@us.ibm.com wrote:
    > OASIS has some guidelines related to namespace and URI management in OASIS 
    > standards here:
    > 
    > http://docs.oasis-open.org/specGuidelines/namingGuidelines/resourceNaming.html
    
    Ah, nice.  Thanks for this pointer!
    
    > Also, do we need a version number or something in the URI?  Or do all 
    > legacy versions of Excel use the same algorithm?
    
    Not to the best of my knowledge.  I have dealt with reading and writing
    a variety of legacy Excel documents of different versions, from 97 to
    2003, and so far this algorithm has been used consistently across these
    versions.  Daniel Rentz of Sun, who is their Excel file format guru,
    even mentions that the same hash algorithm was used in Excel 95.
    
    Kohei
    
    


  • 11.  Re: [office] Spreadsheet Table Protection Options

    Posted 05-07-2009 04:06
    On Wed, 2009-05-06 at 22:53 -0400, Kohei Yoshida wrote:
    > On Wed, 2009-05-06 at 19:38 -0400, robert_weir@us.ibm.com wrote:
    > > OASIS has some guidelines related to namespace and URI management in OASIS 
    > > standards here:
    > > 
    > > http://docs.oasis-open.org/specGuidelines/namingGuidelines/resourceNaming.html
    > 
    > Ah, nice.  Thanks for this pointer!
    > 
    > > Also, do we need a version number or something in the URI?  Or do all 
    > > legacy versions of Excel use the same algorithm?
    > 
    > Not to the best of my knowledge.
    
    Just to clarify, this was in response to the "do we need a version
    number or something in the URI?"  Sorry, bad quoting here. :-P
    
    Kohei