Re: [libreoffice-users] Is There a Better Way to Paste Spreadsheet in Writer Table?

Hi Regina.

> If you use RTF or HTML-format when inserting, you get directly a table. In
> RTF some of the formattings of the Calc table are retained.

Pasting the data as RTF caused one of the columns to shrink until no data
could be read.

Pasting as HTML gave me a nicely expanded table which filled the entire
page. Nearly no formatting required.

Thank you for the prompt response!

On 18 April 2011 17:34, Regina Henschel <rb.henschel@t-online.de> wrote:

> Hi Rewarp,
>
> Rewarp schrieb:
>
> > I need to transfer spreadsheet data into a table, so that I may use the
> > Table caption in Writer. Consistency is very important as this is a
> > thesis,
> > so table data can't be captioned as Figure.
> >
> > The current way method I am employing is to:
> >
> >    1. select all data cells I wish to copy;
> >    2. Paste Special in Writer;
> >    3. Select all data that has been pasted, and click the Table icon;
> >    4. Select table, in Styles and Formatting, select Table Contents to
> > apply
> >    style;
> >    5. Caption.
> >
> >
> > Does anyone have a better suggestion?
> If you use RTF or HTML-format when inserting, you get directly a table. In
> RTF some of the formattings of the Calc table are retained.
>
> If you insert a picture–which might be necessary for 90°rotation of large
> tables–then you can choose category "table" in the caption dialog to get it
> count as table.
>
> Kind regards
> Regina
>
>
>
> --
> Unsubscribe instructions: E-mail to users+help@libreoffice.org
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/www/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted