Issue 85242

Summary: xls: arithmetic with text formatted cells of one character "works" in excel
Product: Calc Reporter: caolanm
Component: open-importAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues, rb.henschel
Version: 680m242Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
test-case document none

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