[Solved] VB : Different style in a cell

[OPENMSA]

Hello,

I am trying to set a cell with 3 different styles (fonts, size) in macro VB.

Is it possible?
How?

[Villeroy]

You just do not know what a style is.
https://wiki.openoffice.org/wiki/Docume ... _Templates

Code: Select all

objCell.CellStyle = "My_Sophisticated_Cell_Style_With_Dozends_of_Attributes"

[OPENMSA]

It seems style apply on the whole cell. Let's forget about style :
I am trying to set a cell with 3 differents fonts & size in macro VB.

Is it possible?
How?

[karolus]

Hallo

...in macro VB.

Is it possible?
How?

Yes, of course -- but what the hell is VB

Code: Select all

def word_formatter():
    doc = XSCRIPTCONTEXT.getDocument()
    sel = doc.CurrentSelection #works for one single selected Cell !!
    cursor = sel.createTextCursor()
    sentence = 'just three words'.split()
    sizes = (12,20,15)
    fonts = ('Carlito', 'Linux Biolinum Keyboard', 'Droid Sans')
    for word, size, font in zip(sentence, sizes, fonts):
        cursor = cursor.End
        cursor.CharHeight = size
        cursor.CharFontName = font
        cursor.Text.insertString(cursor, '%s ' % word, False)

Karolus

[OPENMSA]

Thanks you so much, it works!

Tip : change charWeight, charPosture after a insertControlCharacter (LINE_BREAK...)

[karolus]

Thanks you so much, it works!

Tip : change charWeight, charPosture after a insertControlCharacter (LINE_BREAK...)

change

Code: Select all

'%s '

to

Code: Select all

'%s\n'