Bob, Thanks for this, it is strange and a bit frustrating as it seemed to work perfectly in the past. So I don't know if its a OOo thing or an R thing.
Graham On 05/11/2007, Bob Long <[EMAIL PROTECTED]> wrote: > > "Graham Smith" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > >I am copying a small table to the clipboard (as HTML from the statistics > > program R) and trying to paste the table into Writer and Calc. > > > > Pasting the clipboard into Excel produces a formatted table. Pasting > into > > Calc, just gives me the HTML code. I have tried using paste special, but > > HTML isn't an option > > > > With Writer, when I did this in the past, the HTML pasted as a formatted > > table (can't remember which version), but now it simply pastes the HTML > > code (as it does in Word). > > > > Again, I have tried paste special but as with Calc, it is considered an > > Unknown source and only unformatted text is offered as an option. > > > > This WINXPPro and OOo 2.3.0. > > > > Any suggestion how I get this to paste as a formatted table. > > I'm not familiar with the statistics program R, but I copied a table from > a > Web page (http://mpc.org.au/resources/resources07.html to be precise). In > Calc, a simple Edit|Paste worked - table cells ended up as individual Calc > cells. Also, Edit|Paste Special shows "HTML Format" as an option. > Strangely, > the drop down arrow on the "Paste" toolbar icon shows only "Unformatted > text" as an option, and then prompts for field delimiters. > > However, copying and pasting tables from other Web sites did not behave > the > same way. For example, for the language table at > http://projects.openoffice.org/native-lang.html, a simple Edit|Paste > resulted in the contents of each row appearing in each vertical cell, > without the columns being differentiated. But, Edit|Paste Special|HTML > format worked. Again, the drop down arrow on the "Paste" toolbar icon > shows > only "Unformatted text" as an option, and then prompts for field > delimiters. > > Strange! > > [XP Home, OOo 2.3] > > -- > Bob Long > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
