SpreadsheetML <ss:Data> using spaces and cr/lf

[David Thielen]

Hi;

I am trying to find the right mananged NG to ask questions about
SpreadsheetML. I am hoping this is it. (microsoft.public.office.xml is not a
managed group.)

SpreadsheetML file uses all of the cr/lf and spaces inside <ssata> ...
</ssata> - they are part of the cell text.

While this is allowed with xml, the standard as I understand it is to set
xml:space="preserve" for the element. Yet I see nothing in the schema for
this.

Is this not possible to set in a schema? Or am I missing something?

 

[Peter Huang [MSFT]]

Hi

I think we can not change the behavior because the namespace is published
and maintianed by microsoft. If someone changed it, the other user(Excel
client) will not be notified.
Also I think the feature is defined in a more deeped root xml namespace
which is not published.

Hope this helps.

Best regards,

Perter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[David Thielen]

Hi;

If there is a more deeply rooted namespace - how can I get the schema for
that? Because if Excel is using that namespace then the only way to create an
xml file that is correct for Excel is to have that schema.

Also, without the preserve attribute, I think it would be considered
invalid, or at least inaccurate xml. Can you please report that to the Excel
group as they could then change this for the next release of the spec.

??? - thanks - dave

 

[Peter Huang [MSFT]]

Hi

Thank you for your feedback, I will report it to our product team.

Best regards,

Perter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.