My program builds an XML spreadsheet that further should be opened in Excel. Everything fine, but the problem is with "comment" element. It opens in Excel as comment but it is shrinked. How can I make the "comment" text opened in Excel with all it's contents, not shrinked?

Example:
<Cell>
<Data ss:Type="String">Tra-lal-la</Data>
<Comment>
<ss:Data>
This is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment textThis is my comment text
</ss:Data>
</Comment>
</Cell>

This is not an XSLT issue. If you find out what the output should look like (by asking on an Excel forum for example) then we can help you produce that.



/- Sam Judson : Wrox Technical Editor -/

I'll try to clarify it. When you define a "comment" element in XML Spreadsheet and then open the XML file in Excel and put the mouse on the commented cell, the comment will appear as a yellow rectangle with text. But if my comment is a long one, the yellow rectangle will appear nevertheless with the same size, i.e. part of the comment text is not shown.

My question is: how do define the XML Spreadsheet "comment", so it will show it's whole text in Excel.

I don't know. Nor is anyone one this forum likely too, because your question is not an XSLT question, but an Excel question.

/- Sam Judson : Wrox Technical Editor -/