https://bugs.freedesktop.org/show_bug.cgi?id=47149
Bug #: 47149
Summary: EDITING Dutch postal codes containing AM or PM are
interpreted as time formats
Classification: Unclassified
Product: LibreOffice
Version: unspecified
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Dutch postal codes comprise of four digits followed by two characters.
In Libre Office these postal codes are routinely mistaken for time formats when
they end with AM or PM.
How to reproduce:
- Enter a dutch postal code ending with AM or PM (e.g. 5401 AM) in a cell.
Expected behaviour:
- The cell will display "5401 AM".
Actual behaviour:
- The cell will display "5401:00:00", some kind of time format.
Note that in the Netherlands 24-hour time formats are used, without AM or PM.
Note also, that any valid time entry using AM or PM will use a number <= 12,
and certainly not a number >= 1000 like in the Dutch postal codes.
This behaviour occurs was observed in several places in Libre Office, not just
in Calc:
1: Entering a postal code in a cell in Calc
See example above.
2: Entering a postal code in a table in Writer, when "Number Recognition" is
on.
The error is not immediately obvious here, but including these cells in ranges
e.g. for sums will produce unexpected results
3: Importing data from CSV files into Calc
Workarounds exist in this case, but most Dutch users will be unaware of the
problem and the workaround.
4: Importing data from CSV files for a mail merge into Writer
In the main menu, in the dialog under Insert | Fields | Other, CSV files can be
added as a database source in the tab "Database".
LO uses the first line / record to try and automatically determine the data
types of the fields in the CSV file. When that first line contains a postal
code including AM or PM, things go wrong in the merge.
There are workarounds for this, but most Dutch users will be unaware of this
problem buried deep inside LO.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
