[users] Re: Spreadsheet to word processor table
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (R N D Martin) wrote: *From:* [EMAIL PROTECTED] (R N D Martin) *To:* users@openoffice.org *Date:* Wed, 16 Apr 2008 14:11 +0100 (BST) In article [EMAIL PROTECTED], [EMAIL PROTECTED] (R N D Martin) wrote: *From:* [EMAIL PROTECTED] (R N D Martin) *To:* users@openoffice.org *Date:* Tue, 15 Apr 2008 18:02 +0100 (BST) In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Ahromi Irawan) wrote: *From:* Ahromi Irawan [EMAIL PROTECTED] *To:* users@openoffice.org *Date:* Tue, 15 Apr 2008 10:00:11 +0700 Pada Tanggal 04/14/2008 09:26 PM, R N D Martin Menulis: In Lotus I am used to creating a table and then using cop and paste to batch paste direct to the cells in the table, but in OO I seem to have to paste special into the document as text, and then turn what I have pasted into a table. I find this rather long winded and awkward. Have I missed something? Niall Martin Edit | Paste Special | Formatted Text HTH -- Ahromi Irawan Cirebon Thanks. I'll try that again, but my memory is that it pasted an image of the bit of the spreadsheet rather than distributing the items over the fields. Niall Martin I repeated the operation, and found it pasted everything in column 1 of the table I created, definitely not what I wanted. Niall Martin I've had some off list correspondence with Barbara Duprey which I'm pasting below, as it seems to add something to the discussion. her second last sentence seems to enlighten. Niall Martin Thanks, Niall. Yes, it does, and I think we may be getting closer here. If you click *below* the table you're working with (I generally add an empty paragraph before my paste point), rather than inside the table, then do the Paste Special for formatted text, you should get an independent table that looks pretty much like what you had in Calc. If you want to append the data from that copy to your existing, nicely formatted table, just add an empty row at the bottom of the formatted one. Then click somewhere in the copied table, Table Select Table, and Ctrl-C. Now you have all your spreadsheet data in a good form for normal pasting. Click in the first cell (or whichever one is to be the top left of the appended data) of the empty new row of the formatted table, then Ctrl-V. Your data should populate the formatted table in the appropriate columns, adding all the rows it needs. Now you can delete the copied temporary table. That should do it, I hope, though you may have to do a little more to get the copied data to match the existing table's format. I do a very similar thing getting data from Base tables and queries into Writer tables. Unfortunately, the clipboard formats for Writer, Calc, and Base seem to be incompatible without the intermediate step. (By the way, let's keep all this on the list so others can help, too.) Niall Martin wrote: Thanks for your message.. Initially I created my table, then did paste special on to it. No go. I then explored the other options. DDE seemed to give the wrong answer. Paste special taking the formatted text option put everything in a single column of the table, instead of distributing the items in the appropriate columns. What succeeded was paste special, taking the unformatted text option, highlighting the pasted text, followed by table/convert to table. It does seem a roundabout way of doing things, particularly if having set up the table you then want to add more data to it. I hope this clarifies the process. On 16 Apr 2008 at 14:20, Barbara Duprey wrote: Date sent: Wed, 16 Apr 2008 14:20:01 -0500 From:Barbara Duprey [EMAIL PROTECTED] To: users@openoffice.org, [EMAIL PROTECTED] *Subject: * *Re: [users] Re: Spreadsheet to word processor table* R N D Martin wrote: In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Brian Barker) wrote: *From:* Brian Barker [EMAIL PROTECTED] *To:* users@openoffice.org *Date:* Tue, 15 Apr 2008 22:55:54 +0100 At 15:26 14/04/2008 +0100, Niall Martin wrote: In Lotus I am used to creating a table and then using copy and paste to batch paste direct to the cells in the table, but in OO I seem to have to paste special into the document as text, and then turn what I have pasted into a table. I find this rather long winded and awkward. Have I missed something? Possibly. I think that, in Writer, this is even easier than you hope. Don't create any table first. Instead, copy the cells from your spreadsheet and then use Edit | Paste Special... (or Ctrl+Shift+V), selecting DDE link from the options. This creates a table with your imported values, which you can then format as you require. Note
[users] Re: Spreadsheet to word processor table
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Brian Barker) wrote: *From:* Brian Barker [EMAIL PROTECTED] *To:* users@openoffice.org *Date:* Tue, 15 Apr 2008 22:55:54 +0100 At 15:26 14/04/2008 +0100, Niall Martin wrote: In Lotus I am used to creating a table and then using copy and paste to batch paste direct to the cells in the table, but in OO I seem to have to paste special into the document as text, and then turn what I have pasted into a table. I find this rather long winded and awkward. Have I missed something? Possibly. I think that, in Writer, this is even easier than you hope. Don't create any table first. Instead, copy the cells from your spreadsheet and then use Edit | Paste Special... (or Ctrl+Shift+V), selecting DDE link from the options. This creates a table with your imported values, which you can then format as you require. Note that this technique actually creates a link to the source spreadsheet instead of a copy - so the spreadsheet file must continue to be available and any subsequent change to it will be reflected in your Writer document. If this is not what you need, after you have pasted the link, go to Edit | Links..., select the relevant link in the list, and press Break Link. You will now have an independent text document. I trust this helps. Brian Barker I did experiment briefly with the DDE option, but abandoned it at once, since it did not seem to be doing what I wanted. Your second paragraph I regard as a workaround which I will try some time, but still regard as rather clumsy. Thanks for your comment. Niall Martin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Spreadsheet to word processor table
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (R N D Martin) wrote: *From:* [EMAIL PROTECTED] (R N D Martin) *To:* users@openoffice.org *Date:* Tue, 15 Apr 2008 18:02 +0100 (BST) In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Ahromi Irawan) wrote: *From:* Ahromi Irawan [EMAIL PROTECTED] *To:* users@openoffice.org *Date:* Tue, 15 Apr 2008 10:00:11 +0700 Pada Tanggal 04/14/2008 09:26 PM, R N D Martin Menulis: In Lotus I am used to creating a table and then using cop and paste to batch paste direct to the cells in the table, but in OO I seem to have to paste special into the document as text, and then turn what I have pasted into a table. I find this rather long winded and awkward. Have I missed something? Niall Martin Edit | Paste Special | Formatted Text HTH -- Ahromi Irawan Cirebon Thanks. I'll try that again, but my memory is that it pasted an image of the bit of the spreadsheet rather than distributing the items over the fields. Niall Martin I repeated the operation, and found it pasted everything in column 1 of the table I created, definitely not what I wanted. Niall Martin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Spreadsheet to word processor table
On Wed, 16 Apr 2008 14:11 +0100 (BST) R N D Martin wrote: In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Brian Barker) wrote: *From:* Brian Barker [EMAIL PROTECTED] *To:* users@openoffice.org *Date:* Tue, 15 Apr 2008 22:55:54 +0100 At 15:26 14/04/2008 +0100, Niall Martin wrote: In Lotus I am used to creating a table and then using copy and paste to batch paste direct to the cells in the table, but in OO I seem to have to paste special into the document as text, and then turn what I have pasted into a table. I find this rather long winded and awkward. Have I missed something? Possibly. I think that, in Writer, this is even easier than you hope. Don't create any table first. Instead, copy the cells from your spreadsheet and then use Edit | Paste Special... (or Ctrl+Shift+V), selecting DDE link from the options. This creates a table with your imported values, which you can then format as you require. Note that this technique actually creates a link to the source spreadsheet instead of a copy - so the spreadsheet file must continue to be available and any subsequent change to it will be reflected in your Writer document. If this is not what you need, after you have pasted the link, go to Edit | Links..., select the relevant link in the list, and press Break Link. You will now have an independent text document. I trust this helps. Brian Barker I did experiment briefly with the DDE option, but abandoned it at once, since it did not seem to be doing what I wanted. Your second paragraph I regard as a workaround which I will try some time, but still regard as rather clumsy. Thanks for your comment. I am a bit confused as to your technique. I thought calc data pasted as a table without the need for creating the table first. -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Spreadsheet to word processor table
R N D Martin wrote: In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Brian Barker) wrote: *From:* Brian Barker [EMAIL PROTECTED] *To:* users@openoffice.org *Date:* Tue, 15 Apr 2008 22:55:54 +0100 At 15:26 14/04/2008 +0100, Niall Martin wrote: In Lotus I am used to creating a table and then using copy and paste to batch paste direct to the cells in the table, but in OO I seem to have to paste special into the document as text, and then turn what I have pasted into a table. I find this rather long winded and awkward. Have I missed something? Possibly. I think that, in Writer, this is even easier than you hope. Don't create any table first. Instead, copy the cells from your spreadsheet and then use Edit | Paste Special... (or Ctrl+Shift+V), selecting DDE link from the options. This creates a table with your imported values, which you can then format as you require. Note that this technique actually creates a link to the source spreadsheet instead of a copy - so the spreadsheet file must continue to be available and any subsequent change to it will be reflected in your Writer document. If this is not what you need, after you have pasted the link, go to Edit | Links..., select the relevant link in the list, and press Break Link. You will now have an independent text document. I trust this helps. Brian Barker I did experiment briefly with the DDE option, but abandoned it at once, since it did not seem to be doing what I wanted. Your second paragraph I regard as a workaround which I will try some time, but still regard as rather clumsy. Thanks for your comment. Niall Martin Niall, have you done the Paste Special as formatted test? That seems to preserve more of the formatting than the DDE link, whether later broken or not. You should end up with a table immediately after doing the Paste Special that comes pretty close to what you had in Calc. When you say turn what I have pasted into a table what kind of steps are you going through? Maybe we can help with that part. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Spreadsheet to word processor table
Thanks, Niall. Yes, it does, and I think we may be getting closer here. If you click *below* the table you're working with (I generally add an empty paragraph before my paste point), rather than inside the table, then do the Paste Special for formatted text, you should get an independent table that looks pretty much like what you had in Calc. If you want to append the data from that copy to your existing, nicely formatted table, just add an empty row at the bottom of the formatted one. Then click somewhere in the copied table, Table Select Table, and Ctrl-C. Now you have all your spreadsheet data in a good form for normal pasting. Click in the first cell (or whichever one is to be the top left of the appended data) of the empty new row of the formatted table, then Ctrl-V. Your data should populate the formatted table in the appropriate columns, adding all the rows it needs. Now you can delete the copied temporary table. That should do it, I hope, though you may have to do a little more to get the copied data to match the existing table's format. I do a very similar thing getting data from Base tables and queries into Writer tables. Unfortunately, the clipboard formats for Writer, Calc, and Base seem to be incompatible without the intermediate step. (By the way, let's keep all this on the list so others can help, too.) Niall Martin wrote: Thanks for your message.. Initially I created my table, then did paste special on to it. No go. I then explored the other options. DDE seemed to give the wrong answer. Paste special taking the formatted text option put everything in a single column of the table, instead of distributing the items in the appropriate columns. What succeeded was paste special, taking the unformatted text option, highlighting the pasted text, followed by table/convert to table. It does seem a roundabout way of doing things, particularly if having set up the table you then want to add more data to it. I hope this clarifies the process. On 16 Apr 2008 at 14:20, Barbara Duprey wrote: Date sent: Wed, 16 Apr 2008 14:20:01 -0500 From:Barbara Duprey [EMAIL PROTECTED] To: users@openoffice.org, [EMAIL PROTECTED] *Subject: * *Re: [users] Re: Spreadsheet to word processor table* R N D Martin wrote: In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Brian Barker) wrote: *From:* Brian Barker [EMAIL PROTECTED] *To:* users@openoffice.org *Date:* Tue, 15 Apr 2008 22:55:54 +0100 At 15:26 14/04/2008 +0100, Niall Martin wrote: In Lotus I am used to creating a table and then using copy and paste to batch paste direct to the cells in the table, but in OO I seem to have to paste special into the document as text, and then turn what I have pasted into a table. I find this rather long winded and awkward. Have I missed something? Possibly. I think that, in Writer, this is even easier than you hope. Don't create any table first. Instead, copy the cells from your spreadsheet and then use Edit | Paste Special... (or Ctrl+Shift+V), selecting DDE link from the options. This creates a table with your imported values, which you can then format as you require. Note that this technique actually creates a link to the source spreadsheet instead of a copy - so the spreadsheet file must continue to be available and any subsequent change to it will be reflected in your Writer document. If this is not what you need, after you have pasted the link, go to Edit | Links..., select the relevant link in the list, and press Break Link. You will now have an independent text document. I trust this helps. Brian Barker I did experiment briefly with the DDE option, but abandoned it at once, since it did not seem to be doing what I wanted. Your second paragraph I regard as a workaround which I will try some time, but still regard as rather clumsy. Thanks for your comment. Niall Martin Niall, have you done the Paste Special as formatted test? That seems to preserve more of the formatting than the DDE link, whether later broken or not. You should end up with a table immediately after doing the Paste Special that comes pretty close to what you had in Calc. When you say turn what I have pasted into a table what kind of steps are you going through? Maybe we can help with that part. Niall Martin Phone 0131 4678468 Please reply to: niallatrndmartin.cix.co.uk - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Spreadsheet to word processor table
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Ahromi Irawan) wrote: *From:* Ahromi Irawan [EMAIL PROTECTED] *To:* users@openoffice.org *Date:* Tue, 15 Apr 2008 10:00:11 +0700 Pada Tanggal 04/14/2008 09:26 PM, R N D Martin Menulis: In Lotus I am used to creating a table and then using cop and paste to batch paste direct to the cells in the table, but in OO I seem to have to paste special into the document as text, and then turn what I have pasted into a table. I find this rather long winded and awkward. Have I missed something? Niall Martin Edit | Paste Special | Formatted Text HTH -- Ahromi Irawan Cirebon Thanks. I'll try that again, but my memory is that it pasted an image of the bit of the spreadsheet rather than distributing the items over the fields. Niall Martin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
