Bug 148598 - FORMATTING- A fraction is converted to date in cells designated as number
Summary: FORMATTING- A fraction is converted to date in cells designated as number
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-04-14 18:22 UTC by Walt
Modified: 2022-04-15 00:21 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Walt 2022-04-14 18:22:18 UTC 
In cells formatted for numbers, fractions are converted to dates. I feel this conversion should only be made in cells formatted for dates, not numbers in general.
Comment 1 Eike Rathke 2022-04-15 00:21:22 UTC 
Cells are not "formatted for numbers" or "formatted for dates" input. Cells may have a *display format* assigned that is not an input mask. If your locale happens to use the '/' slash date separator and you don't want a simple fraction  to be recognized as abbreviated date input then remove the D/M or M/D (depending on your locale) pattern from the Date Acceptance Patterns under Tools -> Options -> Languages Settings -> Languages. Or precede the fraction with a 0 to force a fraction input, like 0 1/2