Issue 107665 - Number recognition of dates should be more logical
Summary: Number recognition of dates should be more logical
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.1.1
Hardware: PC Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 109240 (view as issue list)
Depends on:
Blocks:
 
Reported: 2009-12-14 13:43 UTC by giorg
Modified: 2017-05-20 11:22 UTC (History)
2 users (show)

See Also:
Issue Type: TASK
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
test file with table (8.29 KB, application/vnd.oasis.opendocument.text)
2009-12-14 13:46 UTC, giorg 		no flags Details
text file with dates (29 bytes, text/plain)
2009-12-14 13:46 UTC, giorg 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description giorg 2009-12-14 13:43:11 UTC 
- Open the attached odt
- Copy/paste the dates from the attached txt to the last column in the table
- Save the document
- Close and re-open the document
- Dates are wrong

The workaround is to format the cells as simple text.
Comment 1 giorg 2009-12-14 13:46:25 UTC 
Created attachment 66633 [details]
test file with table
Comment 2 giorg 2009-12-14 13:46:54 UTC 
Created attachment 66634 [details]
text file with dates
Comment 3 michael.ruess 2009-12-15 15:10:07 UTC 
You should disable "Number recognition" in the context menu of the table. Then
the number formats of the cells won't be reformatted automatically.
Comment 4 michael.ruess 2009-12-15 15:11:32 UTC 
Closed.
Comment 5 giorg 2009-12-15 15:57:30 UTC 
Alright, the workaround is fine, but I'd like to point this out: the default is
to have number recognition enabled, but if a user doesn't know about this, then
he could lose informations (as my customer did). In my opinion number
recognition should be disabled by default.

Thanks a lot.
Comment 6 eric.savary 2009-12-15 16:04:19 UTC 
duplicate

*** This issue has been marked as a duplicate of 100936 ***
Comment 7 eric.savary 2009-12-15 16:04:43 UTC 
Closed
Comment 8 davide 2009-12-17 11:06:14 UTC 
@es: in #100936 you asked to open a new detailed issue because "We don't fix
bugs by switching buggy functions off!"
giorg reported a detailed issue and it has been closed by suggesting to disable
"number recognition". Then you have closed it because it's a duplicate.

Or the function is buggy, therefore this issue must be kept open, or the
configuration is buggy so you have to keep open the #100936.
I think it's not acceptable that people lose their data after saving the
document because of a buggy function.
Comment 9 giorg 2009-12-17 11:12:58 UTC 
The test I made was on OOo 3.1.1 on Windows XP, everything in italian. If you
need more details, just tell me.
Comment 10 michael.ruess 2010-01-08 10:04:40 UTC 
MRU->OS: if valid date formats are copied to a table (as described above) these
should not be changed to a different (default) date format.
Comment 11 michael.ruess 2010-02-15 09:50:47 UTC 
*** Issue 109240 has been marked as a duplicate of this issue. ***
Comment 12 macias 2010-02-15 16:24:31 UTC 
Currently OOW has a loop, it formats data according to format, but if it 
it finds "better" match, it formats the format according to data (and then 
data according to that new format). This is plain wrong.

OOW can have initial "auto detection of data" turned on, but later when user 
selects any "fixed" format this format should be kept no matter what data are 
entered in the cells.
Comment 13 Marcus 2017-05-20 11:22:47 UTC 
Reset assigne to the default "issues@openoffice.apache.org".