S
Stefan Froehlich
I generate an Excel file from a templating system, thus I go with
XML. This works pretty fine, with one notable exception: I have not
yet figured out how to format cell comments:
| <Cell>
| <Data ss:Type="String">this is the content</Data>
| <Comment><ss
ata>this is a comment</ssata></Comment>
| </Cell>
If I write a comment in Excel and save the worksheet in native xls
format, the size and position of the comment are saved. If I construct
an XML file with the same contents, I can't find any tag or property
to set either size or position of the comment field. This is _very_
annoying for larger comments, as most of the text is hidden, and the
user has to manually resize each and every field.
Is there any help?
Bye,
Stefan
XML. This works pretty fine, with one notable exception: I have not
yet figured out how to format cell comments:
| <Cell>
| <Data ss:Type="String">this is the content</Data>
| <Comment><ss
ata>this is a comment</ssata></Comment>| </Cell>
If I write a comment in Excel and save the worksheet in native xls
format, the size and position of the comment are saved. If I construct
an XML file with the same contents, I can't find any tag or property
to set either size or position of the comment field. This is _very_
annoying for larger comments, as most of the text is hidden, and the
user has to manually resize each and every field.
Is there any help?
Bye,
Stefan