[Pyexcelerator-users] row height and vertical writing orientation

[<Oli...@bi...>]

Hi all,

=20

I find pyexcelerator very practical. I discovered it since a few days. I =
have formatting problems.

=20

1.	In the package there are "row_style"  samples which demonstrate how =
to set the height of a cell. This is accomplished by setting the height =
of the font. The formatting effect is not the same as setting the row's =
height: the cell's text does not appear really in the bottom of the cell =
but a little above (depending of the font's size used). Is it possible =
to set the "true" row's height otherwise?
2.	How is it possible to set the orientation of the text? I tried the =
following but with no success.

=20

=20

from pyExcelerator import *

=20

w =3D Workbook()

ws =3D w.add_sheet('Orientation Test')

s =3D XFStyle()

al =3D Alignment()

al.horz =3D Alignment.HORZ_CENTER

al.vert =3D Alignment.VERT_CENTER

al.orie =3D Alignment.ORIENTATION_90_CC

s.alignment =3D al

ws.write(0,0,'Test',s)

w.save('D:\\chx_06_filenet\\orientation_test.xls')

=20

A big thanks for your future help!

=20

Olivier Gaillard
Systemspezialist  =20
=20

Eidgen=F6ssisches Finanzdepartement EFD
Bundesamt f=FCr Informatik und Telekommunikation BIT
BIT Scanning Center / Datenerfassung KDDE

 Monbijoustrasse 74, CH-3003 Bern


Telefon +41 31 323 01 79
Telefax +41 31 323 59 78
oli...@bi... <mailto:oli...@bi...>=20

http://www.bit.admin.ch/kdde <http://www.bit.admin.ch/kdde>=20
www.bit.admin.ch <http://www.bit.admin.ch/>=20

Der Eisbrecher: die Kundenzeitung des BIT
www.bit.admin.ch/eisbrecher <http://www.bit.admin.ch/eisbrecher>=20




=20