incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Scott <>
Subject Re: Copy/Pasting dates from HTML table to Calc formats wrong
Date Thu, 26 Jul 2012 15:14:29 GMT
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:

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:
For additional commands, e-mail:

View raw message