DR 16-0007 - specific requests for clarification from the Excel team

[MURATA Makoto]

Folks,

Francis and I have done done some homeworks.

First, schema changes proposed by Francis are incorporated
into a git branch for this DR, available at
https://muratamakoto24.visualstudio.com/_git/OOXMLSchemas/commits?itemPath=
%2F&itemVersion=GBDR_16-0007

But you need an account of VSTS.  See

https://www.visualstudio.com/en-us/docs/setup-admin/team-
services/sign-up-for-visual-studio-team-services

Second, Francis has made several test documents.
They are available at https://1drv.ms/f/s!An5Z79wj5AZBgfFjKhXM5DVq9djwug

Regards,
Makoto



2017-09-01 0:15 GMT+09:00 Francis Cave <francis at franciscave.com>:

> Hi Aarti
>
>
>
> Following the discussions on the WG 4 call yesterday, I have compiled a
> list of questions to the Excel team, requesting clarification of various
> points which don’t appear to be covered by implementer notes in MS-OI29500.
> References are to sections in IS 29500.
>
>
>
> Kind regards,
>
>
>
> Francis
>
>
>
>
>
> §18.8.34 rgbColor
>
>
>
> The attribute @rgb on element rgbColor is optional in the SpreadsheetML
> schema, but the element rgbColor would appear to be meaningless without the
> attribute having a value. Can the Excel team confirm whether or not this
> attribute is required by Excel, and if not, how Excel interprets its
> omission?
>
>
>
> §18.10.1.8 calculatedItem
>
>
>
> The attribute @field on element calculatedItem is optional in the
> SpreadsheetML schema. Since there has to be some mechanism for referencing
> the PivotTable field to which the formula (specified by @formula) is to be
> applied, can the Excel team clarify whether @field is in fact required by
> Excel, or whether there could be some alternative mechanism (e.g. using the
> contents of a child extLst element) for locating the field in question, in
> which case @field would be omitted?
>
>
>
> §18.13.3 dbPr
>
>
>
> The attribute @command on element dbPr is optional in the SpreadsheetML
> schema. Can the Excel team explain under what circumstances this attribute
> may be omitted? In particular, would it be omitted if the external data
> connection had been deleted?
>
>
>
> §18.14.5 definedName
>
>
>
> The attribute @refersTo on element definedName is optional in the
> SpreadsheetML schema. Can the Excel team confirm whether or not Excel
> requires this attribute and, if not, how its omission is interpreted when a
> document is opened?
>



-- 

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/20171017/ff957569/attachment.html>