RE: DR 14-0013 — SML: definedName attribute localSheetId

Chris Rae Chris.Rae at
Mon Feb 9 19:15:33 CET 2015

Thanks for taking a look at this! That's a good idea - I was struggling a bit with how to talk about local-scoped names which referred to references on different sheets without over-complicating the text.

I've updated the example to include the sheet definition, and changed it to refer to a locally-scoped name with a local reference. I think that should make it significantly clearer.

Revised version attached.


From: eb2mmrt at [mailto:eb2mmrt at] On Behalf Of MURATA Makoto
Sent: 07 February 2015 02:00
To: e-SC34-WG4 at
Subject: Re: DR 14-0013 — SML: definedName attribute localSheetId


I do not understand what is meant by "The sheet element with 
localSheetId equal to the value of this attribute".  An
example of such a sheet element would be nice as part of 
the first example.


2015-02-07 2:59 GMT+09:00 Chris Rae <Chris.Rae at>:

This DR concerns the localSheetID attribute of the SpreadsheetML definedName element, and states that the attribute's meaning is unclear.

After looking into this, I think the submitter is right and that it's not at all clear what this attribute is intended to represent. I've attached some proposed changes to the standard. A couple of notes:

* I think that the example mentioned by the submitter is poorly chosen. It mention a "data source" and "external database"  - the submitter is correct that this isn't the defined name required for a SpreadsheetML data connected range, and really I don't think any mention should be made of external data as it complicates the example and isn't relevant. I've reworded it as such.
* Revision records also contain defined names with the same attribute - they have much better descriptions. For example, in, the localSheetId is described as " An integer representing the id of the sheet to which this defined name belongs. This shall be used local defined names only." (sic)
* I notice that Microsoft's MS-OI29500 implementer notes ( already cover Excel's behaviour with this attribute - as the standard is not well-defined at all, many of my changes are from there.



Praying for the victims of the Japan Tohoku earthquake

-------------- next part --------------
A non-text attachment was scrubbed...
Name: DR 14-0013 changes.docx
Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Size: 24539 bytes
Desc: DR 14-0013 changes.docx
URL: <>

More information about the sc34wg4 mailing list