https://bugs.freedesktop.org/show_bug.cgi?id=56457
joaquin <narebeest...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #69146|0 |1
is obsolete| |
--- Comment #11 from joaquin <narebeest...@yahoo.com> ---
Created attachment 69445
--> https://bugs.freedesktop.org/attachment.cgi?id=69445&action=edit
External HTML sources with different "lang=" settings
This attachment contains links to 4 html sources that, at the moment, have the
following language setting and really used decimal separator vs date format:
- lang=nl, document has decimal separator ",", date: DD-MM-YYYY
- no HTML-lang setting (but document uses English, decimal dot, DD-month)
- lang=en but document uses US dates (in other text-strings) and decimal dot
So this is incorrect, the document should have used "lang=en-us"
- lang=en-us, document uses decimal dot and dates like "Fri, Nov 2, 2012"
(not shown when importing "HTML Tables")
I don't see any influence by the HTML setting on the import behaviour of
numbers. Also I would say that trusting the HTML source is useless since the
language setting is usually absent or wrong (also some sites don't use plain
HTML, take a look at Google Finance).
Like the original report stated, the following combination gives me all the
numbers:
- Non US locale (e.g. Dutch, German, ..)
- "Use English (USA) locale for numbers"
Result:
- numbers with a decimal "," are imported as text (use the VALUE function)
- decimal dot numbers are imported as numbers
See bug 53177 for the "date behaviour" and the related new additional global
language setting.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
