Bug 59220

Summary: Error while inserting a formula in the table in the form of date.
Product: LibreOffice Reporter: SalcefiX <krzemien.andrzej>
Component: WriterAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 3.6.4.3 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Bug in table in wiriter

Description SalcefiX 2013-01-10 23:37:14 UTC
Created attachment 72817 [details]
Bug in table in wiriter

Error while inserting a formula in the table as a date such as 05/01/2013. The program shows the 30 December 1899.
Comment 1 m_a_riosv 2013-01-11 20:41:02 UTC
Hi SalcefiX, thanks for reporting.

Please report what is your operating system, and your locale language, can you detail how and what formula are you trying to enter.
Comment 2 SalcefiX 2013-01-12 00:44:50 UTC
Operating System: Windows XP
Language: Polish
Formula in table in writer
Number Format: Date
Formula: = 05/01/2013
The result: 30/12/1899
Comment 3 SalcefiX 2013-01-12 01:28:24 UTC
Video recording frim desktop http://ubuntuone.com/6oKlr2MwiAFIe8csY9tMZ0
Comment 4 m_a_riosv 2013-01-12 17:59:05 UTC
Hi SalcefiX,
you are trying to enter a date like a formula, and you get the of division operations not a date.
To enter a date, you must enter the date directly in the cell (not as formula) and format the cell with the date format you like. You can reference this cell with a formula. 

I thin it is not a bug, writer is not calc and have not the same capabilities.
You can see in the help, Calculating in text documents.

Please if you are agree, change the status to RESOLVED NOTABUG.
Comment 5 SalcefiX 2013-01-12 21:14:35 UTC
Sorry for the inconvenience. I'm so ashamed.