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 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
Re: [libreoffice-users] Is There a Better Way to Paste Spreadsheet in Writer Table?
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
[libreoffice-users] Is There a Better Way to Paste Spreadsheet in Writer Table?
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? -- 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
