LibreOffice Calc: cell is formatted for date.
If I input e.g. 3/5 for 3 May Calc displays 3 May 2014 (current year).
It works with all dates except for:
Input 1/4 (for 1 April 2014): Calc displays 1/4.
Input 3/4 (for 3 April 2014): Calc displays 3/4.
Input 1/2 (for 1 Feb 2014): Calc displays 1/2.
I haven't tested each and every date but the above are the most obvious ones.
I can confirm this with 220.127.116.11
You pointed out the three auto-correct replacements for fractions (accessible in Tools > AutoCorrect option > Replace tab).
It is indeed unintuitive in the case of cells already formatted for dates.
There are temporary workarounds if the fractions are not useful to you:
- In the AutoCorrect options, delete the three replacements that you pointed out;
- Or deactivate the replacement table in the Options tab.
To the developpers: is it possible to deactivate particular autocorrect rules for particular formatting cases?
Or better: let the formatting do its job before applying the replacement rules?
already known issue.
*** This bug has been marked as a duplicate of bug 33899 ***