Issue 85242 - xls: arithmetic with text formatted cells of one character "works" in excel
Summary: xls: arithmetic with text formatted cells of one character "works" in excel
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 680m242
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2008-01-14 17:12 UTC by caolanm
Modified: 2009-08-01 17:22 UTC (History)
2 users (show)

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

Attachments
test-case document (13.50 KB, application/vnd.ms-excel)
2008-01-14 17:13 UTC, caolanm 		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 caolanm 2008-01-14 17:12:57 UTC 
So in the attachment I have 10 and 11 in row 1 and 5 and 6 in row 2, all
formatted as *text*, which is crazy I guess, but nevertheless this is extracted
from a real .xls. Arithmetic on them in excel "works" in that I get a difference
on 1 in each case, while on import into calc the second row result is 0 not 1.
Comment 1 caolanm 2008-01-14 17:13:43 UTC 
Created attachment 50860 [details]
test-case document
Comment 2 caolanm 2008-01-14 17:14:11 UTC 
Original document can be seen at:
https://bugzilla.redhat.com/show_bug.cgi?id=419181
Comment 3 Regina Henschel 2009-08-01 17:21:42 UTC 
This problem is already tracked in issue 5658.

*** This issue has been marked as a duplicate of 5658 ***
Comment 4 Regina Henschel 2009-08-01 17:22:21 UTC 
closing duplicate