Bug 78029

Summary:	Particular dates are replaced by fractions by the autocorrect rules even when cell format is set to date
Product:	LibreOffice	Reporter:	Uli <u_luhrs>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	barta, stephane.guillou
Priority:	medium
Version:	4.1.5.3 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Uli 2014-04-28 09:23:04 UTC

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.

Thanks,
Uli

Comment 1 Stéphane Guillou (stragu) 2014-04-29 12:59:35 UTC

I can confirm this with 4.1.5.3
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?

Cheers

Comment 2 tommy27 2014-05-02 10:40:05 UTC

already known issue.

*** This bug has been marked as a duplicate of bug 33899 ***