Issue 2343 - .5 is not equal to 0.5.
Summary: .5 is not equal to 0.5.
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 641
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: tom
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2001-11-29 16:21 UTC by jpmcgee
Modified: 2013-08-07 15:13 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
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 jpmcgee 2001-11-29 16:21:19 UTC 
1)Create a new spreadsheet.
2) In cell A1, enter a zero followed by a decimal point followed by the 
digit '5'. Hit 'tab'. This moves to cell B1. Enter the formula “=A1*2”. Hit 
tab, and watch as the formula gets the (correct) value “1”.
3)In cell A2, enter a decimal point followed by the digit '5'.Hit 'tab' to move 
to B2. As the cursor moves to cell B2, watch the AutoCorrect change the “.5” to 
the 1/2 character. In cell B2, enter the formula “=A2*2”. Hit 'tab'. Watch as 
the formula gets the (incorrect) value “0”.
The only reason I found this was that I was typing in an Excel spreadsheet that 
I forgot to put on a floppy when I left home. I got a different answer on the 
two spreadsheets. That was for grades in a class. The affected student has 
brought up his average since then, but at the time, losing half credit on an 
assignment meant he got a B at midterm instead of the A he deserved
Comment 1 peter.junge 2001-11-29 16:32:23 UTC 
Hi,
I will check it. Priority 1 is too high anyway. Please use such
priority only for crashes and other real nasty stuff. If I can
reproduce it then we will flag the target to 'next build'.
Best regards, Peter
Comment 2 peter.junge 2001-12-03 15:59:26 UTC 
Hi,
it's not bug it's a feature. We will discuss if the current behaviour
really makes sense. Everybody feel free to add her/his comments.
My opinion, we should keep the feature but put the default in the
AutoCorrect dialog to 'off'.
Best regards, Peter
Comment 3 peter.junge 2001-12-04 10:29:36 UTC 
Hi Tom,
please remove this entry in the AutoCorrect dialog.
Regards, Peter
Comment 4 peter.junge 2001-12-04 16:51:34 UTC 
.
Comment 5 tom 2001-12-04 17:08:26 UTC 
fixed in src641t
Comment 6 peter.junge 2002-04-04 13:10:00 UTC 
Verified and closed.