https://bugs.freedesktop.org/show_bug.cgi?id=53858
Bug #: 53858
Summary: FORMATTING: Formating fraction entries, US locales
Classification: Unclassified
Product: LibreOffice
Version: 3.6.0.0.alpha1
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 65848
--> https://bugs.freedesktop.org/attachment.cgi?id=65848
Little Calc sheet, 1, Col formated as Fraction, 2.Col =VALUE(a?)
Problem description:
Entering a fraction (e.g 1/8) in cell which is formatted as FRACTION (# ??/??)
results in displaying 1/8 but value is date 1/8/2012.
Locales is US
Steps to reproduce:
1. Format cell as Number > Fraction, select # ??/??
2. enter "1/8" into cell, hit ENTER
3.
Current behavior:
Cell displays "1/8" left justified, VALUE(refCell)=40916 which is a date for
1/8/2012
Expected behavior:
Cell should display "1/8" right justified, VALUE(refCell)=0.125
Comment:
Excel does it right. If entered as "=1/8" or "+1/8" then correct display and
value. Enter "1 1/8" ok.
Enter Result Value
1/4 ¼ char
1/2 ½ char
13/16 Err. 502 invalid date entry
Platform (if different from the browser):
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20100101
Firefox/14.0.1
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
