how to fix the alignment (veritcal/horizontal) for cell using ole2 [message #395681] |
Thu, 02 April 2009 04:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mm_kanish05
Messages: 493 Registered: January 2007 Location: Chennai
|
Senior Member |
![mm_kanish05%40yahoo.co.in](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi,
Please how to fix the alignment for the cell. Below code is not getting any effect.
Arg := ole2.create_arglist;
ole2.add_arg(Arg,1);
ole2.add_arg(Arg,1);
Cell := ole2.Get_Obj_Property(Worksheet,'Cells',Arg);
ole2.destroy_arglist(arg);
ole2.set_property(Cell,'Veritcal','center');
kanish
|
|
|
|
|
Re: how to fix the alignment (veritcal/horizontal) for cell using ole2 [message #395949 is a reply to message #395681] |
Fri, 03 April 2009 04:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mm_kanish05
Messages: 493 Registered: January 2007 Location: Chennai
|
Senior Member |
![mm_kanish05%40yahoo.co.in](/forum/theme/orafaq/images/yahoo.png)
|
|
correct Martin
Actually the function is 'verticalalignment'
even that also not working
Arg := ole2.create_arglist;
ole2.add_arg(Arg,1);
ole2.add_arg(Arg,1);
Cell := ole2.Get_Obj_Property(Worksheet,'Cells',Arg);
ole2.destroy_arglist(arg);
--ole2.set_property(Cell,'Wraptext','true');
--ole2.set_property(Cell,'HorizontalAlignment','xlGeneral');
ole2.set_property(Cell,'VerticalAlignment','Top');
Still i am working and searching for the same.
kanish
|
|
|
|