On 17 November 2010 08:46, Thomas Lange <[email protected]> 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. > > > I haven't played much in this area but it seems to me the following might work if you don't mind the object being on a separate page: - Create a new *section* in your Writer document (Insert>Section) - Orient the section's pages to landscape (Format>Page) - Now paste the object - If you need to continue the document in normal portrait mode, create a new section and orient its page to portrait In other words, a "section" can have its own page orientation (and other characteristics) different from the rest of the document (and/or from other sections). I do this when I want spreadsheet "tables" in landscape mode but I've never done it with charts. -- Harold Fuchs London, England Please reply *only* to [email protected]
