Issue 63203 - Different value display of same spreadsheet file on Excel/OOo
Summary: Different value display of same spreadsheet file on Excel/OOo
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL: http://www.huweb.hu/maques/oo2-value.htm
Keywords:
Depends on:
Blocks:
 
Reported: 2006-03-15 10:44 UTC by maques
Modified: 2006-03-15 11:30 UTC (History)
1 user (show)

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

Attachments
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 maques 2006-03-15 10:44:49 UTC 
Different value display of same spreadsheet file on Excel (2000)/OOo (2.02)
    
Things to reproduce:
Enter "String1234xxx" to cell B1
Enter "=MID(B1;9;1)"  to cell B2
Enter "=B2+1"         to cell B3

B3 will display '1' on OpenOffice.org and '4' on Excel.
(Additional information: ="3"+1 in both application result '4')
Comment 1 frank 2006-03-15 11:30:30 UTC 
Hi,

IMHO not a bug from Calc but from Excel, they calculate with text values as the
MID function result is always a text, you get the difference.

Normally I should close this as invalid, but the expectations on the user site
have to be considered, so double to Issue 5658 .

Frank

*** This issue has been marked as a duplicate of 5658 ***
Comment 2 frank 2006-03-15 11:30:56 UTC 
closed double