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

[MURATA Makoto]

Thanks.  This is much better.  Should localSheetId be sheetId?

Regards,
Makoto

2015-02-10 3:15 GMT+09:00 Chris Rae <Chris.Rae at microsoft.com>:

> 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.
>
> Chris
>
> From: eb2mmrt at gmail.com [mailto:eb2mmrt at gmail.com] On Behalf Of MURATA
> Makoto
> Sent: 07 February 2015 02:00
> To: e-SC34-WG4 at ecma-international.org
> Subject: Re: DR 14-0013 — SML: definedName attribute localSheetId
>
> Chris,
>
> 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.
>
> Regards,
> Makoto
>
>
> 2015-02-07 2:59 GMT+09:00 Chris Rae <Chris.Rae at microsoft.com>:
>
> https://onedrive.live.com/view.aspx/Public%20Documents/2014/DR-14-0013.docx?cid=C8BA0861DC5E4ADC
>
> 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 18.11.1.13, 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 (
> https://msdn.microsoft.com/en-us/library/ee908652(v=office.12).aspx)
> already cover Excel's behaviour with this attribute - as the standard is
> not well-defined at all, many of my changes are from there.
>
> Chris
>
>
>
>
> --
>
> Praying for the victims of the Japan Tohoku earthquake
>
> Makoto
>



-- 

Praying for the victims of the Japan Tohoku earthquake

Makoto
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.vse.cz/pipermail/sc34wg4/attachments/20150210/6f402da5/attachment.html>