[Scribus] Importing OO2 Spreadsheet Graphs into Scribus

[unknown]

Hi

I'm struggling finding a good way of importing (as a vector preferably)
an OO2 spreadsheet graph into Scribus 1.2.3

I can't cut and paste; I tried exporting just the graph as a SVG but
this seems to try and export the whole spreadsheet, which is far too
much for Scribus to cope with.

I tried importing a OO2 created sxd file, but that doesn't seem to work
for me either, it won't import into Scribus at all.

I really need a solution, otherwise I can't see I that I can convince
others where I work, that this is a better solution than simply copying
an pasting an MS Excel graph into MS Word and creating a PDF from there
!!! I really don't won't them to keep using MS Word to do DTP stuff in !!


Julian

[unknown]

Hi Julian,

Post by unknown
Hi
I'm struggling finding a good way of importing (as a vector preferably)
an OO2 spreadsheet graph into Scribus 1.2.3
I can't cut and paste; I tried exporting just the graph as a SVG but
this seems to try and export the whole spreadsheet, which is far too
much for Scribus to cope with.
I tried importing a OO2 created sxd file, but that doesn't seem to work
for me either, it won't import into Scribus at all.
I really need a solution, otherwise I can't see I that I can convince
others where I work, that this is a better solution than simply copying
an pasting an MS Excel graph into MS Word and creating a PDF from there
!!! I really don't won't them to keep using MS Word to do DTP stuff in !!

Please have look here:

http://wiki.scribus.net/index.php/Complex_tables_in_Scribus_1.2x


This should provide a working solution for you, since it should also
work with spreadsheet graphs. Most important is the sequence Calc (Copy)
-> Draw (Paste, SVG export) -> Inkscape (EPS export) -> Scribus.

Cheers,

Christoph

[unknown]

Post by unknown
Hi
I'm struggling finding a good way of importing (as a vector
preferably) an OO2 spreadsheet graph into Scribus 1.2.3
I can't cut and paste; I tried exporting just the graph as a SVG
but this seems to try and export the whole spreadsheet, which is
far too much for Scribus to cope with.
I tried importing a OO2 created sxd file, but that doesn't seem to
work for me either, it won't import into Scribus at all.
I really need a solution, otherwise I can't see I that I can
convince others where I work, that this is a better solution than
simply copying an pasting an MS Excel graph into MS Word and
creating a PDF from there !!! I really don't won't them to keep
using MS Word to do DTP stuff in !!
Julian

Hi,

Look here: http://docs.scribus.net/index.php?lang=en&page=importhints3

This should work. I tested this with both OO. 1.1.4 and OO.2.0

Cheers,
Peter

[unknown]

Hi Julian,

Date: Thu, 03 Nov 2005 17:47:24 +0000
From: Julian Robbins <julian.robbins at q-par.com>
Subject: [Scribus] Importing OO2 Spreadsheet Graphs into Scribus
To: scribus at nashi.altmuehlnet.de
Message-ID: <436A4D2C.3040703 at q-par.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi
I'm struggling finding a good way of importing (as a vector preferably)
an OO2 spreadsheet graph into Scribus 1.2.3
I can't cut and paste; I tried exporting just the graph as a SVG but
this seems to try and export the whole spreadsheet, which is far too
much for Scribus to cope with.

Ok, what I do is select the graph in OO calc (spreadsheet), and
copy-n-paste it into OO Draw, and then export to a scribus-recognised
format from OO Draw.

OO Draw supports multiple export formats: EPS, SVG, PDF, etc.

So far, when importing into Scribus, my best results have been using
EPS. To import SVG containing text, I have had to convert all text to
paths (Inkscape does this with a single command). However, I have still
had problems with some pieces of text being huge, misplaced or unfindable.

If you are going to import as EPS but still want to edit the graph
before importing it, you can export it from OO Draw into SVG, edit it
with Inkscape, and then 'Save As' in Inkscape to EPS.

I tried importing a OO2 created sxd file, but that doesn't seem to work
for me either, it won't import into Scribus at all.

You're on the right track. You need to export from OO2 sxd into a
scribus-recognised format. As mentioned above, EPS has fewer problems
than SVG.

As I recently found out, you can import EPS into scribus as *either*
vector data, or raster data. The raster data is *much* smaller inside
scribus, and much more easily manipulated (scaled, positioned, etc). The
vector representation consumes large amounts of memory within scribus,
and causes the scribus file to become very large. The benefit is that
the result can be edited using the scribus vector tools.

To import EPS as raster, create an image frame, and use "Right-Click |
Get Pictire", and select your EPS.

To import EPS as vector, select "File | Import | EPS". The result is a
new frame containing the vector information.

*Note: I have found that the scribus 1.3.2cvs snapshot is significantly
better and faster at manipulating (scaling, positioning) EPS vector data.

I really need a solution, otherwise I can't see I that I can convince
others where I work, that this is a better solution than simply copying
an pasting an MS Excel graph into MS Word and creating a PDF from there
!!! I really don't won't them to keep using MS Word to do DTP stuff in !!

With the approach we've just discussed, your users will probably be
tempted to cut-n-paste into OO Draw, and then create a PFD from there, I
guess. :o(


Cheers!
Nik.