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...
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:
Keywords: oooqa
Depends on:
Reported: 2010-08-06 09:24 UTC by wleionline
Modified: 2013-12-17 13:58 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

excel doc (9.50 KB, application/
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

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))".

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"!

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
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: 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.