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
Keywords: oooqa
Depends on:
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: ---

test-case document (13.50 KB, application/
2008-01-14 17:13 UTC, caolanm
no flags Details

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