Bug 101793 - Math function turns into date and cell is contaminated forever
Summary: Math function turns into date and cell is contaminated forever
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-08-30 12:38 UTC by g1689020
Modified: 2016-08-30 13:03 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 g1689020 2016-08-30 12:38:15 UTC 
User-Agent:       Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36
Build Identifier: e5f16313668ac592c1bfb310f4390624e3dbfb75

One cell in the sheet does not return mathematical operations even after formatted. Instead, after typing "=1+2" it returns "02/01/00". Tried formatting the sheet, but the same cell still does not calculate.

Reproducible: Always

Steps to Reproduce:
I'm not sure how I did it, but it happened to several cells in the sheet while I was calculating something basic like "=(20/5)*3"
Actual Results:  
11/01/00

Expected Results:  
12




Reset User Profile?No
Comment 1 Eike Rathke 2016-08-30 13:03:44 UTC 
Make sure you also have no style or conditional format applied that contains a date format.