setComments

Topics: Developer Forum, Project Management Forum, User Forum
May 16, 2013 at 8:51 PM
Edited May 16, 2013 at 8:59 PM
Hello,

1.
with this:
$objPHPExcel->getActiveSheet()->getComment('A1')->getText()->createTextRun('Text');

i can add a comment.
It is ok.

But when i click on "all comments show" in excelsheet then all comments in the upper left corner.
You can adjust this?


2.
And you can adjust the size from commentbox of the text extent?


Thanks for your help.
May 19, 2013 at 3:09 PM
1 : setMarginTop(), setMarginLeft()
2 : setWidth(), setHeight()

It should be noted the unit (pt, px, in,...). Given the coordinate system, this can be annoying to get to place comments in the desired location.
May 23, 2013 at 2:00 PM
Edited May 23, 2013 at 3:27 PM
Ok thanks, it works!

But i have still a question.
How i can adjust, that the comments show on display and print as default?

Thanks for your help.
May 24, 2013 at 11:02 AM
setVisible(true) on each comment.