Issue 113703 - String to number conversion should also work for strings showing date, also if created by function
Summary: String to number conversion should also work for strings showing date, also i...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO330m1
Hardware: All All
: P3 Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2010-08-06 09:24 UTC by wleionline
Modified: 2013-12-17 13:58 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
excel doc (9.50 KB, application/vnd.ms-excel)
2010-08-06 09:26 UTC, wleionline 		no flags Details
Pls see comments from rainerbielefeld Sat Aug 7 11:25:51 (76.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-08-07 12:27 UTC, Rainer Bielefeld 		no flags Details
Calc vs. Calligra Sheets 2.6.4 (181.16 KB, application/zip)
2013-12-17 12:58 UTC, Edwin Sharp 		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 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.