Hi Alex,
alex sato wrote (07-01-12 13:27)
I wish to know how to change the size of the box where the cells comments
is displayed using macro.
Is it possible?
Probably.
I have done some simple things with notes (comments).
See some code lines below.
oSheet = ThisComponent.Sheets.getByName("Blad1")
oAnnotations = oSheet.Annotations
oCell = ThisComponent.Sheets.getByName("Blad1").getCellByPosition(1,3)
msgBox oCell.annotation.String
oCell.annotation.isVisible = FALSE
So when you have the annotation object, there should be other
objects/properties that may help you.
Do you know Xray, that helps to inspect objects & properties?
Cheers,
--
- Cor
- http://nl.libreoffice.org
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
