help with XSpreadsheet

[Lee-106]

I want to change XSpreadsheet’s header and footer when print. What can i do ?

 

And how can I insert a Graphic into a XSpreadsheet?

I know a method below for this question, but I don’t know how to chang the graphic’s size and position.

 

Dim dispatcher As unoidl.com.sun.star.frame.XDispatchHelper = m_xMSFactory.createInstance("com.sun.star.frame.DispatchHelper")

Dim model As unoidl.com.sun.star.frame.XModel = xSheetDoc

dispatcher.executeDispatch(model.getCurrentController().getFrame(), ".uno:InsertGraphic", "", 0, args1)

 

I’m crazy about that. So expect for your help.

 

Thank you first!

[Cor Nouws]

Hi Lee,

Lee wrote (21-9-2009 9:01)
> I want to change XSpreadsheet’s header and footer when print. What can i do ?

Header/footer are properties of the page styles. So
        oPageStyles = oDoc.StyleFamilies.GetByName("PageStyles")
is the direction to start.

> And how can I insert a Graphic into a XSpreadsheet?
>
> I know a method below for this question, but I don’t know how to chang the graphic’s size and position.

Work in this direction:
        oGraph = oDrawPage.getByIndex(1)
        oGraph.Graphic.Size.Height

Have you seen the project & iki pages for API/Basic?
http://api.openoffice.org/
http://wiki.services.openoffice.org/wiki/API
http://wiki.services.openoffice.org/wiki/Extensions_development_basic
  (look for the xray tool) ??

Success & Best regards,
Cor


(added you as CC because you're not subscribed to the list. Pls mail to
the list only.
To subscribe, mail to dev-subscribe@...)

--
Cor Nouws
   - nl.OpenOffice.org marketing contact
   - Community Contributor Representative in the Community Council
Gevoel niet vrij te zijn? Zie www.nieuwsteversie.nl

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...