Issue 13913 - Formula imported from Excel doesn't calculate correctly
Summary: Formula imported from Excel doesn't calculate correctly
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-04-28 21:59 UTC by Unknown
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
Excel spreadsheet calculates incorrectly in OOo Calc (10.50 KB, application/ms-excel)
2003-04-28 22:04 UTC, Unknown 		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 Unknown 2003-04-28 21:59:13 UTC 
The Excel spreadsheet uses "Mid" and "find" functions to parse a time string:
"0d 6h 3m 38s". The string is parsed into days, hours, minutes, and seconds and
then totalled in seconds. The formula to parse hours is
=MID(B2;FIND("h";B2;1)-2;2); minutes is =MID(B2;FIND("m";B2;1)-2;2); and seconds
is =MID(B2;FIND("s";B2;1)-2;2). (All days are 0 so there is no formula to parse
days.) These formulas calculate correctly when imported into Calc. The formula
for the total is =(C3*3600)+(D3*60)+E3. Calc calculates this last incorrectly as
0 (zero).
Comment 1 Unknown 2003-04-28 22:04:23 UTC 
Created attachment 5943 [details]
Excel spreadsheet calculates incorrectly in OOo Calc
Comment 2 frank 2003-04-29 07:39:08 UTC 
Hi Marsha,

this is not a bug ! Calc doesn't calculate with text values. The
result of the mid function has to be translated from text to number first.

Also the priorisation was much to high. Prio 1 means the whole
application is not running and this is not the case.

Best regards

Frank
Comment 3 frank 2003-04-29 07:39:27 UTC 
closed invalid