Issue 17990 - stock prices (numbers with fractions) not handled like Excel
Summary: stock prices (numbers with fractions) not handled like Excel
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 Beta2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-07 22:52 UTC by philmperry
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description philmperry 2003-08-07 22:52:04 UTC
As part of an online class teaching Excel, in OOo 1.1 Beta 2 I entered a column
of stock prices as "aa b/c" format (integer number of dollars with fractional
dollar). Most of the values apparently came through properly when I drew a stock
price chart (low/high/close), but the fractions 1/4, 1/2, and 3/4 were not
handled properly. When the stock price is entered, using those particular
fractions, two things happened: 1)the ISO single byte character for that
fraction was used instead of three characters (num-slash-denom), which is
inconsistent with other fractional values, and 2) those prices were apparently
treated as text strings rather than numbers (plot was all messed up). It looks
like someone got fancy with numeric formatting and decided on special treatment
for 1/4, 1/2, and 3/4, with the result that they aren't recognized as numbers.
Comment 1 frank 2003-08-08 08:43:17 UTC
Hi,

this is not a bug but a special option.

Use Tools - Autocorrect - Options - Replace 1/2 with... and untag this
checkbox.

So I close it as invalid.

frank
Comment 2 frank 2003-08-08 08:43:32 UTC
closed invalid