[Bug 71997] Html online import of numbers and dates is very inflexible, actual preference description is wrong

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=71997

j2006 <na...@yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Hardware|Mac                         |All
           Severity|trivial                     |normal

--- Comment #9 from j2006 <na...@yahoo.com> ---
So this bug is almost 6 years old now and "UNCONFIRMED" (are only people from
the USA using this software?). Maybe it is time to see what "the competition"
is doing better or worse.

The LibreOffice developers are, in my opinion, making matters better and worse
at the same time by introducing yet another global setting that, not only,
applies to manual input but to external links and csv-imports too:
   http://wiki.documentfoundation.org/ReleaseNotes/3.6#Localization
  "Date acceptance patterns"

So AOO is still at the pre-LO 3.6.2 level, meaning the "Use 'English (USA)' for
numbers" global preference under "HTML-compatibility" messes with dates:
https://bugs.freedesktop.org/show_bug.cgi?id=53177

At the same time combining this global setting with the manual choice for
selecting a locale on adding a link to external data is not doing anything, as
far as I can detect, in both AOO and LO:
https://bugs.freedesktop.org/show_bug.cgi?id=53103

So I hope AOO can learn from the choices made by the LO developers and do a
better job on the impact of global settings versus the choices you should have
and that should work on imported links/csv-files.

In both products this setting "Use 'English (USA)' for numbers"  needs some
rethinking e.g.:
- limit it to decimal-dot numbers (like it suggests)
- limit its scope to manual input, cut and paste ...
- introduce another setting for date-pattern recognition 
  - make that also limited to manual input, cut and paste ...
  - have an on import/linking setting that ignores the global settings
  - do not have the global settings overrule the on-import/linking settings

-- 
You are receiving this mail because:
You are on the CC list for the bug.