Another Office Open XML doc error

[David Thielen]

The sample for <is> (Excel inline string) shows <c r='A1'> when it should be
<c r="A1" t="inlineStr">

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Jialiang Ge [MSFT]]

Hello Dave,

According to Office Open Xml Part 4 - Markup Language Reference.pdf P1929:

"While a cell can have a formula element f and a value element v, when the
cell's type t is inlineStr then only the element is is allowed as a child
element."

That is to say, if t="inlineStr" is added to <c, it could only be <is> as a
child element. But if t="inlineStr" is not specified, not only <is>, but
also other elements could be its child. In that example, <is> is a child
element, therefore, t="inlineStr" is optional.

Sincerely,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[David Thielen]

That's how I read it too. But when I created a file that way Word 2007 said
it was corrupt.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Jialiang Ge [MSFT]]

Hello Dave,

You are right. I reproduce the issue when I remove the 'inlineStr'. A
possible reason might be that Microsoft Excel 2007 is not strictly
following this rule in Open XML Spec. I have submitted the issue to Office
Development team, to let them check the issue. In your side, please kindly
add the 'inlineStr' when you are developing. Sorry for the inconveniences
and many thanks to you for the issue report.

Have a nice day!

Sincerely,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[David Thielen]

Have a nice day!

You too!!!

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm