Issue 108713 - Switch off option requested for "Cell formatting remembers inputs with special formatting like date or currency"
Summary: Switch off option requested for "Cell formatting remembers inputs with specia...
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.1.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2010-01-27 13:37 UTC by ohallot
Modified: 2013-08-01 10:51 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description ohallot 2010-01-27 13:37:06 UTC
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.