DR 14-0013: Proposed resolution

Rex Jaeschke rex at RexJaeschke.com
Tue Apr 11 20:47:32 CEST 2017



From: Aarti Nankani [mailto:anankani at microsoft.com] 
Sent: Tuesday, April 11, 2017 2:18 PM
To: Rex Jaeschke <rex at RexJaeschke.com>
Subject: DR 14-0013


Hi Rex,


I have updates from the Excel team for discussing tomorrow.


DR 14-0013 - SML: definedName attribute localSheetId

Here’s Excel’s recommendation for this.  It’s similar to Rex’s most recent
version with changes indicating that localSheetId is a 0-based index into
the elements within CT_Sheets and has no connection to the sheetId attribute
on the CT_Sheet.  Highlighting indicated changes:




localSheetId (Local Name Sheet Id)

Specifies that this defined name is a sheet-scoped reference, and specifies
the a parent sheet index in this workbook where data from an external
reference is displayed. The localSheetId specifies the 0-based index of the
parent sheet within the CT_Sheets element.  The combination of localSheetId
and name attributes shall be unique among all defined names.

[Example: In the following example, theA defined name, local scoped to the
sheet with sheetIdID 1 equal to 2upon which it resides, with its
accompanying sheet definition, refers to a range whose data source is an
external database called “Northwind_Database”:

<definedName name="Northwind_Database"


    <sheet name="Sheet1" sheetId="2" r:id="rId1"/>

    <sheet name="Sheet4" sheetId="0" r:id="rId2"/>

    <sheet name="Sheet5" sheetId="1" r:id="rId3"/>



end example]

[Note: Although not a typical use case, a name scoped to one particular
sheet may refer to a cell reference in another. End note]

For further information on local defined names, see §L.2.2.11.

The possible values for this attribute are defined by the W3C XML Schema
unsignedInt datatype.






-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.vse.cz/pipermail/sc34wg4/attachments/20170411/8dcf782f/attachment.html>

More information about the sc34wg4 mailing list