Home » Developer & Programmer » Forms » how to fix the alignment (veritcal/horizontal) for cell using ole2 (forms 6i)
how to fix the alignment (veritcal/horizontal) for cell using ole2 [message #395681] Thu, 02 April 2009 04:20 Go to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

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 #395887 is a reply to message #395681] Fri, 03 April 2009 00:11 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
This is a Microsoft Excel question. Search their forum.

David
Re: how to fix the alignment (veritcal/horizontal) for cell using ole2 [message #395888 is a reply to message #395887] Fri, 03 April 2009 00:12 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Spelling 'vertical' correctly may help.

David
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 messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

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
Re: how to fix the alignment (veritcal/horizontal) for cell using ole2 [message #396274 is a reply to message #395681] Sun, 05 April 2009 23:57 Go to previous message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Hi,

I got some lead

This is the solution. We should use the numric constant for top,center what ever it is.

ole2.set_property(Cell,'VerticalAlignment',-4160);


kanish

Previous Topic: Commit Statement
Next Topic: how to install oracle 6i forms& reports
Goto Forum:
  


Current Time: Sun Feb 09 11:00:50 CST 2025