Hello, I got a new "Problem" with Comments. Iam creating Comments and also apply a Autofilter, if the user now selects a autofilter and some rows are collapsed the comments arent displayed correct.
When I create the comments I set an Anchor: Example: row1 comment ok row2 row3 comment ok ... after Filter: row1 comment not ok row3 comment ok ... because the row1 comment is strained over row 1 and row 2? Is there a workaround to handle this? In Excel I got a VB-Macro End Sub after running this it works fine. But this macro is not very performant and it took a while, also it isnt very nice to for the user to run the macro first. Now my Question is it possible to set this flag for a Comment? I looked at the HSSFComment/Shape classes but I didnt really understand how to access some Flags like this. Maybe you can help me or provide me with further informations. With the new xlsx format the problem doesnt occur. Greetings Stefan -- View this message in context: http://apache-poi.1045710.n5.nabble.com/HSSFComment-autosize-tp4891743p4891743.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
