Issue 113703

Summary: String to number conversion should also work for strings showing date, also if created by function
Product: Calc Reporter: wleionline <leiw>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Minor    
Priority: P3 CC: elish, issues, rainerbielefeld_ooo_qa
Version: OOO330m1Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
See Also: https://issues.apache.org/ooo/show_bug.cgi?id=5658
https://issues.apache.org/ooo/show_bug.cgi?id=109165
https://issues.apache.org/ooo/show_bug.cgi?id=109721
Issue Type: ENHANCEMENT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
excel doc
none
Pls see comments from rainerbielefeld Sat Aug 7 11:25:51
none
Calc vs. Calligra Sheets 2.6.4 none

Description wleionline 2010-08-06 09:24:55 UTC 
Open attach file formula_value_str.xls

You can find B5,B6,B7, B12,B13,B29 are all wrong

Another similar thing is get value from cell which return string that can be 
interpreted as number
An intereting thing is A21 is right, while B35 is wrong.

While open in Excel, they are all correct
Comment 1 wleionline 2010-08-06 09:26:47 UTC 
Created attachment 70984 [details]
excel doc
Comment 2 Rainer Bielefeld 2010-08-07 12:01:47 UTC 
Confirm effect with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]" and more or
less with  "Ooo-Dev 3.3.0 multilingual version English UI WIN XP: [DEV330m1
(Build 9514)]"

EXCEL viewer seems to do a String to Number conversion automatically, in OOo you
have to modify Formulas afer import, for example in 'B5' from "=MONAT(WERT(B9))"
to "=MONAT(WERT(B9))".

Issue
Comment 3 Rainer Bielefeld 2010-08-07 12:25:51 UTC 
Related to issue 5658, Issue 109165, Issue 109721?

I do not think that this is a particular open-import problem.

Currently I can't see any difference in behaviour between Strings and Strings
created by function "Concentrate", Pls. see my sample "mysample.ods"!

@wleionline:
Can you provide any example where you see different handling string and string
created by function concerning interpretation as number?
Comment 4 Rainer Bielefeld 2010-08-07 12:27:02 UTC 
Created attachment 70998 [details]
Pls see  comments from rainerbielefeld Sat Aug 7 11:25:51
Comment 5 Edwin Sharp 2013-12-17 12:57:22 UTC 
Confirmed with

AOO410m1(Build:9750)  -  Rev. 1551264
2013-12-17_04:10:52 - Rev. 1551455
Debian
Comment 6 Edwin Sharp 2013-12-17 12:58:38 UTC 
Created attachment 82120 [details]
Calc vs. Calligra Sheets 2.6.4
Comment 7 Rainer Bielefeld 2013-12-17 13:58:58 UTC 
Most important argument: LibreOffice Version: 4.1.3.2 does the job.

And also Softmaker FreeOffice finds out that these strings are is something like a date.

Somewhen between OOo 3.1.1 and OOo 3.3.0 we got a fix for the first conversion in Sample 2010-08-07 14:27 CEST, Rainer Bielefeld, what seems to limit the remaining problem to date strings.