ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting of Cell Comments with XML-Files (https://www.excelbanter.com/excel-discussion-misc-queries/119759-formatting-cell-comments-xml-files.html)

Stefan Froehlich

Formatting of Cell Comments with XML-Files
 
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.

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 the user has to manually resize each
and every field.

Is there any help?

Bye,
Stefan

--
http://kontaktinser.at/ - die kostenlose Kontaktboerse fuer Oesterreich

Vergnügen, mehr als man glaubt. Stefan: spannend und begast.
(Sloganizer)


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com