|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Formula imported from Excel doesn't calculate correctly | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | Unknown <non-migrated> | ||||
| Component: | code | Assignee: | oc | ||||
| Status: | CLOSED NOT_AN_OOO_ISSUE | QA Contact: | issues@sc <issues> | ||||
| Severity: | Trivial | ||||||
| Priority: | P3 | CC: | issues | ||||
| Version: | OOo 1.1 Beta | ||||||
| Target Milestone: | --- | ||||||
| Hardware: | PC | ||||||
| OS: | Windows 2000 | ||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
| Developer Difficulty: | --- | ||||||
| Attachments: |
|
||||||
Created attachment 5943 [details]
Excel spreadsheet calculates incorrectly in OOo Calc
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 closed invalid |
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).