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.hensc...@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+h...@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+h...@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