"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]
