poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Beardsley <markbrd...@tiscali.co.uk>
Subject Re: Set comment width in pixels
Date Fri, 10 Jun 2016 14:38:33 GMT
Why not try it to find out what information is stored in the file - the xml
based .xlsx file format would be best for this.

Looking at
https://support.office.com/en-us/article/Annotate-a-worksheet-by-using-comments-3b7065dd-531a-4ffe-8f18-8d047a6ccae7#bm4
it is certainly possible to resize a comment. Knowing this, I would create a
workbook with a worksheet that has a comment on a single cell and then save
this away. Resize the comment and save the workbook away again under a
different name. Unzip both and look to see what information is stored in the
files and how they differ one from the other. This should point to the areas
of the xml markup that need to be addressed and they can then be exposed
through the api.

Once you know how the size of the comment can be specified, it might then be
possible to move on to setting those dimensions using pixels as the unit.



--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Set-comment-width-in-pixels-tp5723247p5723321.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message