[sc-dev] Date input (was: Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells)

2007-12-07 Thread Kohei Yoshida
On Thu, 2007-12-06 at 20:13 +0200, Leonard Mada wrote: > my vote for turning the Auto-Date OFF! (rant) > I always hated this Auto-Date bullshit. So, Leonard is mad. ;-) That makes me sad. (they rhyme!) But the funny thing is, Calc's date input seems to always infuriate users. They are not

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-06 Thread Cor Nouws
Niklas Nebel wrote (6-12-2007 17:24) Cor Nouws wrote: But, the question arose because of difficulties pasting numbers that become transferred to dates. E.g. pasting 14.60 (measured time in minutes and seconds) will result in 14-12-07 with the locale Dutch. Changing the locale to English VS mak

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-06 Thread Cor Nouws
Leonard Mada wrote (6-12-2007 19:13) my vote for turning the Auto-Date OFF! Well, our problem was solver by the punctual reply to my mail ... -- Cor Nouws Arnhem - Netherlands nl.OpenOffice.org - marketing contact - To uns

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-06 Thread Leonard Mada
Hi, my vote for turning the Auto-Date OFF! I hate this date thing. I use the english version of OOo, because I hate localised versions, and also their handling of number/date-formats (and other problems with localised versions). But I often write dates as non-standard dates. However, OOo insi

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-06 Thread Cor Nouws
Niklas Nebel wrote (6-12-2007 17:24) When pasting unformatted text, select "US English" as the column type in the "Text Import" dialog. For pasting HTML, set the option "Use 'English (USA)' locale for numbers" in Options - Load/Save - HTML Compatibility. The first we knew .. the second not.. S

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-06 Thread Niklas Nebel
Cor Nouws wrote: But, the question arose because of difficulties pasting numbers that become transferred to dates. E.g. pasting 14.60 (measured time in minutes and seconds) will result in 14-12-07 with the locale Dutch. Changing the locale to English VS makes that the number stays the same. And

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-06 Thread Cor Nouws
Hi Niklas, Eike, *, Niklas Nebel wrote (6-12-2007 11:49) Cor Nouws wrote: I can't find any spaces in the HTML. But pasting in a text editor or another spreadsheet appl. indeed gives the same result ... So probably something strange with the HTML-page? Or Firefox bug 303597 (https://bugzilla.

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-06 Thread Niklas Nebel
Cor Nouws wrote: I can't find any spaces in the HTML. But pasting in a text editor or another spreadsheet appl. indeed gives the same result ... So probably something strange with the HTML-page? Or Firefox bug 303597 (https://bugzilla.mozilla.org/show_bug.cgi?id=303597), assuming that you cop

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-06 Thread Eike Rathke
Hi Cor, On Tuesday, 2007-12-04 21:49:26 +0100, Cor Nouws wrote: > I can't find any spaces in the HTML. Not even in the raw HTML source? Note that there are several kinds of blanks, even non-spacing blanks that you won't see in a browser display but may get transformed into usual blanks when past

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-04 Thread Cor Nouws
Hi Niklas, Niklas Nebel wrote (4-12-2007 19:57) Cor Nouws wrote: From the Dutch users-list, a questions arose with pasting data, copied from a HTML page. When choosing Paste special->unformatted text (via the text import dialog), the content of every cell gets an extra space. Is this known

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-04 Thread Niklas Nebel
Cor Nouws wrote: From the Dutch users-list, a questions arose with pasting data, copied from a HTML page. When choosing Paste special->unformatted text (via the text import dialog), the content of every cell gets an extra space. Is this known? Can't find an existing issue. Are you sure the

[sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-04 Thread Cor Nouws
Hi *, From the Dutch users-list, a questions arose with pasting data, copied from a HTML page. When choosing Paste special->unformatted text (via the text import dialog), the content of every cell gets an extra space. Is this known? Can't find an existing issue. Thanks, Cor -- Cor Nouws Ar