Bug 51025 - EDITING: Too aggressive Date Recognition/Conversion in OLE object data table
Summary: EDITING: Too aggressive Date Recognition/Conversion in OLE object data table
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: Chart-Data
  Show dependency treegraph
 
Reported: 2012-06-13 00:15 UTC by pupolesno
Modified: 2017-12-03 13:28 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Step 1- to 3 (84.22 KB, image/jpeg)
2012-06-18 01:23 UTC, pupolesno
Details

Note You need to log in before you can comment on or make changes to this bug.
Description pupolesno 2012-06-13 00:15:59 UTC
Problem description: 

Steps to reproduce:
1. paste chart to writer
2. edit date chart
3. add value "V/12"
4. system autocorrect recognized end change value to :"1.05.2012" - this is bug. 



Current behavior:

Expected behavior:

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (Windows NT 5.1; rv:13.0) Gecko/20100101 Firefox/13.0
Comment 1 Rainer Bielefeld Retired 2012-06-13 05:57:00 UTC
NOT Reproducible with "LibreOffice 3.5.4.2  German UI/Locale [Build-ID: 165a79a-7059095-e13bb37-fef39a4-9503d18] on German WIN7 Home Premium (64bit)

@Reporter:
@reporter:
Thank you for your report – unfortunately important information is missing.
May be hints on <http://wiki.documentfoundation.org/BugReport> will help you to find out what information will be useful to reproduce your problem? If you believe that that  is really sophisticated please as for Help on a user mailing list
Please:
- Write a meaningful Summary describing exactly what the problem is
- Attach a sample document (not only screenshot) or refer to an existing 
  sample document in an other Bug with a link.
- Attach screenshots with comments if you believe that that might explain the 
  problem better than a text comment. Best way is to insert your screenshots
  into a DRAW document and to add comments that explain what you want to show
- Contribute a document related step by step instruction containing every 
  key press and every mouse click how to reproduce your problem 
  (similar to example in Bug 43431)
- add information 
  -- concerning your OS (Version, Distribution, Language)
  -- concerning your LibO UI language, Locale setting
  –- Libo settings that might be related to your problems 
  -- how you launch LibO and how you opened the sample document
  -- everything else crossing your mind after you read linked texts

Even if you can not provide all demanded information, every little new information might bring the breakthrough.

May be you find on
<http://erack.org/blog/archives/18-Does-your-LibreOffice-locale-need-a-date-acceptance-pattern-for-incomplete-date-input.html>
That your problem will be solved with 3.6.0?
Comment 2 pupolesno 2012-06-18 01:23:02 UTC
Created attachment 63159 [details]
Step 1- to 3
Comment 3 pupolesno 2012-06-18 01:24:50 UTC
LibreOffice 3.5.4.2 PL
Build ID: 165a79a-7059095-e13bb37-fef39a4-9503d18
Win XP Prof PL.
1. open Writer
2. Wstaw(insert)->Obiekt(Object)->Wykres(chart)
3. Mouse double click on chart-> right key mouse->from menu choice Dane wykresu (Chart date).
4. in first column "A1" write value: V/12
5. System automatically change to "1.05.2012"
6. If write 'V/12, ' is visible on chart.
If you are don't understand me, i attach screen shoots.
Comment 4 Rainer Bielefeld Retired 2012-06-23 00:45:29 UTC
@pupolesno:
I still have absolutely not idea what your problem might be. You write down some observations, but so what? Is that good or bad what you see? And Why?  Without a clear description what you expect and reasoning why you expect so we can't find out what your problem is.
And what is so difficult to write a meaningful summary? "Is Wrong" is completely useless, all reports here are about "somehow wrong".

I am still waiting for your sample document.

Please feel free to reopen this Bug if you can contribute requested document and information.
Comment 5 pupolesno 2012-06-24 23:58:44 UTC
(In reply to comment #4)
> @pupolesno:
> I still have absolutely not idea what your problem might be. You write down
> some observations, but so what? Is that good or bad what you see? And Why? 
> Without a clear description what you expect and reasoning why you expect so we
> can't find out what your problem is.
> And what is so difficult to write a meaningful summary? "Is Wrong" is
> completely useless, all reports here are about "somehow wrong".
> 
> I am still waiting for your sample document.
> 
> Please feel free to reopen this Bug if you can contribute requested document
> and information.

As I wrote in the topic."Wrong Number recognition in WRITER"
Fault diagnosis is a bad format - conversion of value.
I can not enter values ​"V/12"​ in the graph .
Always value is turned on: 01/05/2012.
If you saw the attached screens, you know how to cause confusion.
Attach a file will not do anything because it happens every time.
Please read all the threads from the beginning.

p.s.
My English is terrible I know. Sorry.
Comment 6 Rainer Bielefeld Retired 2012-06-25 01:35:21 UTC
Sigh ....
This is a much more general problem with LibO's limited formatting and editing skills in Chart object data tables.

This has nothing to do with WRITER, same in DRAW 

And I agree, Date Recognition/Conversion is too aggressive. My first results are
- Some aspects worked more plausible in 3.3 (no number recognition for category)
- Date recognition inconsistent with new Spreadsheet standard
- It's not logic to have the axis formatted as currency and to have a Date
  Recognition active (for example), but that's the same in CALC)

@Eike:
Do you know whether there already something to improve this is in the pipeline?
Comment 7 Joel Madero 2014-11-06 20:53:37 UTC
Never confirmed by QA - moving to UNCONFIRMED for confirmation.
Comment 8 raal 2014-11-20 19:05:26 UTC
I can confirm with Version: 4.4.0.0.alpha2+
Build ID: 2f342c61616418c6ad7303d7f5efa27a28378681
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-11-16_00:33:40