Issue 108713

Summary:	Switch off option requested for "Cell formatting remembers inputs with special formatting like date or currency"
Product:	Calc	Reporter:	ohallot <olivier.hallot.ooo>
Component:	formatting	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	elish, issues, rainerbielefeld_ooo_qa
Version:	OOo 3.1.1	Keywords:	oooqa
Target Milestone:	---
Hardware:	Unknown
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description ohallot 2010-01-27 13:37:06 UTC

Hi. 
Here is a weird format situation, please follow these steps:

1) open an empty new spreadsheet.
2) in cell A1 place the formula =1/3. It should render 0,33. OK.
3) now enter in A1 1/3 (no equal sign). It should render 01/03/10. OpenOffice
assumes input as date.
4) now enter again =1/3 in cell A1. The format of cell A1 was maintained as Date
and the rendering shows 31/12/99.

This is source of great confusion.

Comment 1 Rainer Bielefeld 2010-01-28 07:10:48 UTC

Confirm with WIN XP 3.1.1, but I beleive it's a feature, not a bug. 

And indeed, that can cause strange effects:
1. Input "1 €" to 'A2' (pls. use your local currency)
   "1,00 €" will be the result
2. Type "1/3" to 'A2' 
   "40.238,00 €" will be the result

May be it would be useful to be able to switch off this function

Comment 2 ohallot 2010-01-28 11:53:03 UTC

If this is a "feature", it was (perhaps) cloned from Excel (I checked w/ Excel
2003, same behaviour...).

Comment 3 Edwin Sharp 2013-08-01 10:51:34 UTC

Confirmed on Rev. 1507307 Win 7.
The origin to this error IMHO is enabling input of numbers with equal sign. Equal sign should be used only with functions. Numbers should be entered as is.