I copied the table directly to Calc. I had no problems doing this.
[AOO 3.4.0 Debian 64 bit, Seamonkey 2.11] It might be the browser, or it
might be the version of OOo, AOO. I don't have OOo running on my
computer so I could check earlier versions. For what it is not worth, I
was able to copy the table using LO 3.4.6 as well.
--Dan
Art Scheel wrote:
What browser did you copy from? FF and Chrome don't handle it properly
when you use 'paste special' -> 'unformatted'
On Thu, Jul 26, 2012 at 9:14 AM, Mike Scott <[email protected]>wrote:
On 26/07/12 15:56, Art Scheel wrote:
I am not trying to concatenate the data. I just want the date in the
first
column left alone and the year in the second to also be left alone.
Also, I was wrong on the input data. The date is not MM/DD format, it's
spelled out, ie: Dec. 04 as in 12/04 (no year given still).
The input data is a wikipedia table and the formatting changes because of
a
<div style=> tag.
My real issue, and I'm not 100% on this, is that OOo does not offer an
option to just paste the data sans formatting. The data I am copying is
Edit | Paste Special.
the table here:
http://en.wikipedia.org/wiki/**List_of_rampage_killers:_**Americas<http://en.wikipedia.org/wiki/List_of_rampage_killers:_Americas>
I've just quickly tried that. It asks for a separator character, and I
said 'tab', which gives a somewhat odd entry layout; but the dates look
correct :-)
(I'm using OOo 3.2/ubuntu 10.04)
--
Mike Scott
Harlow, Essex, England
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
