[Basic] [Calc] CharHeight inside an Cell Annotation

[julien_lharidon]

Hi there,

I am developing a Calc macro and I've been stuck for several days on that issue :
When I add an annotation in calc, the default font size is way too big. Using xray an the web I found the .charheight property. Unfortunately, it does not do what is is supposed to. Even worse, the annotation disappears, I just see the arrow supposed to link the annotation to the cell.
I read in a French forum that somebody had the same issue. It was suggested that it was a bug, but I found no confirmation of that.
Has anybody managed to change the font size of an annotation in Calc with Basic?
I 'm trying to see if I can do it with Java but I still have some trouble using my java function in Calc, and if it a bug, it is likely it won't solve anything ...
Has anybody managed to change the font of an annotation at all?

Here is the kind of code I use:

[julien_lharidon]

I've found a trick : I take a cell I will never use, I add manually an annotation (cell A). When I want to add an annotation to the cell B, I copy its properties (value, color etc ...), I copy Cell A at the Cell B address, I restore the original properties and I modify the annotation using the following command:

[skyzone]

I have exactly the same problem - setting annotation text on a previously un-annotated cell starts out with a *huge* font in the pop-up, and I don't know how to change it.

CharHeight only seems to affect the permanently unhidden annotation - not the mouse-hover.

[satabau]