Hi Andi, Interesting code in the URL you mentioned. It was quite hard to follow though...
I wasn't sure how I could use this for comments. Does Excel support specifiying the width of a commnent in pixels and not in number of columns? Is it just a limitation in POI or is it a limitation in Excel? If Excel supports it, I would love an API for this. I don't need exact positioning but I need to be able to specify the size (in my case the width) of the comment independent of the columns' widths. /Bengt 2016-06-08 9:40 GMT+02:00 Andreas Beeker <kiwiwi...@apache.org>: > Hi Bengt, > > I guess comments are similar to pictures, but I haven't tested it out yet. > > > Question then is how do you determine the width of a column in pixels? > This is how you do it for pictures: > org.apache.poi.ss.util.ImageUtils.setPreferredSize(...) > > I only had a quickview through the ecma schemas, but when it comes to > exact positioning, > it looks like there's no such thing as anchors (only refs) for comments, > otherwise a > OneCellAnchor (http://stackoverflow.com/questions/19291948) might be > another solution ... > (If this would work and is interesting to you, we can change the > visibility of the methods, to get rid of the reflections ...) > > Andi > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > >
