Hello Andre,

Andre Heine escribió:
Hello all,

does anyone know how I could set the size of an embedded XSpreadsheet?

For example:

I write a calc table with hand, select the columns/rows and copy the selected area into an swriter document. When I do so, the OLE Object is automatically fit like a glove to the size from the sheet .

At this time I insert an calc TextEmbeddedObject in my writer document. Get the XSpreadsheet from the Object, insert some values and format it.

But I must fit the size with my mouse...

It's possible to "autofit" the sheet in an OLE-Object like the "OptimalWidth" property of an cell?

Or must I use another way like copy/paste/dispatch/etc?

Any hints?

see if you can get something useful from this

http://www.ArielConstenlaHaile.com.ar/ooo/temp/EmbeddedCalcResizer.zip

you will find answers in http://api.openoffice.org/docs/common/ref/com/sun/star/embed/module-ix.html

specially in http://api.openoffice.org/docs/common/ref/com/sun/star/embed/XVisualObject.html

Good luck.

Regards,
Ariel.


--
Ariel Constenla-Haile
La Plata, Argentina

[EMAIL PROTECTED]
[EMAIL PROTECTED]

http://www.ArielConstenlaHaile.com.ar/ooo/



"Aus der Kriegsschule des Lebens
                - Was mich nicht umbringt,
        macht mich härter."
                Nietzsche Götzendämmerung, Sprüche und Pfeile, 8.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to