Set comment width in pixels

2016-06-07 Thread Bengt Rodehav
Hello, I generated comments for some cells in the Excel document. But, it seems like the width of the comment depends on the width of the cell which is very unintuitive. I know how wide (in pixels) the comment need to be to work visually but sometimes it is attached to a wide cell and sometimes to

Re: Set comment width in pixels

2016-06-07 Thread Dominik Stadler
Hi, Did you try to work with the setDx1/setDy1/... methods? That might allow to do what you are looking for here when you take into account how it works. >From the xlsx-Spec: "... describes the placement of the drawing within the spreadsheet based upon offsets as well as a specified column and r

Re: Set comment width in pixels

2016-06-07 Thread Bengt Rodehav
Thanks for your reply Dominik. However, this only seems to enable putting the anchor in a certain place in a cell. What I would like is not to specify the width of the comment as "a number of cells" but as pixels (or some other unit). I need to know that the comment text actually fits into the com