Ingrid should i write then directly on calc, without bothering about the cells. How should i proceed.
On Wed, Nov 17, 2010 at 3:41 PM, Ingrid Halama <[email protected]>wrote: > Hi, > > > Thomas Lange wrote: > >> Hi, >> >> On 17.11.2010 07:46, anand warik wrote: >> >> Thank you. That worked, but i also needed a solution to tilt that object >>> 90 >>> degress so that the object can be printed on the paper. Is there a way to >>> do >>> it. >>> >> >> Writer drawing and OLE Object can't be rotated. >> >> However there are possible workarounds: >> - for Charts you can switch the the chart type between bar and column >> for example >> - for tables you need to set the page layout to landscape (this can be >> done for Charts as well), of course this will affect the text in Writer >> as well >> >> And there is always a rather broken way to achieve this: >> Open Draw and 'paste special' the chart/table in question while >> selecting 'GDI metafile' following that open the 'Position and Size' >> dialog and here Draw will now present you with a 'Rotation' tab page >> where you can do what you want. After you are done you can select the >> object from Draw and paste it into Writer. >> WARNING!!: This kind of approach has one big drawback when you paste the >> object as GDI metafile into Draw it ceases to be a chart or table and >> instead becomes a drawing object. That especially means it will no >> longer be updated if the original cells it was referring to get updated. >> >> >> @Ingrid: Any other idea? Maybe I have missed a point on Chart objects. >> >> > > In case of 3D charts one better uses real charts and not GDI metafiles. The > metafiles have a big drawback in case of 3D, as the 3D objects are stored as > resolution dependent bitmaps within the metafile. This then almost always > looks ugly when printed. Regarding the data connection, there is no > difference between the metafile and a pasted chart, as the data connection > is also lost, when a normal chart is pasted from calc to writer. > All in all I would choose landscape page layout here. > > Kind regards, > Ingrid > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- by anand warik 9773420635
