Bug 63437 - Error data.valor 502
Summary: Error data.valor 502
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.2.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-04-11 16:56 UTC by Michel Kurz Zanuz
Modified: 2013-12-02 11:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Contains the formula (6.00 KB, application/vnd.ms-excel)
2013-04-11 16:56 UTC, Michel Kurz Zanuz 		Details
View All 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 Michel Kurz Zanuz 2013-04-11 16:56:50 UTC 
Created attachment 77825 [details]
Contains the formula

I'm using the formula: =DATA.VALOR(21/12/2012)
It returns error: 502
At version 3.3, it worked
Comment 1 m_a_riosv 2013-04-11 22:14:06 UTC 
Hi Michel,
I think it is not a bug, LibreOffice is now stricter with dates and number as text.
Take a look to this link:
http://erack.org/blog/archives/8-LibreOffice-date-acceptance-patterns.html

Also you can set a pattern in Menu/Tools/Options/Language settings/Language.
Change D/M with Y/M.

If you are agree, please change the status to RESOLVED NOTABUG
Comment 2 Olivier Hallot 2013-05-24 12:45:39 UTC 
re-qualifying as Spreadsheet issue.
Comment 3 retired 2013-11-21 08:07:58 UTC 
Closing this issue for now. Important information is missing.

Michel, do you still experience this problem, after following mariosv’s suggestion?


ALso please test against the latest stable LO version (currently 4.1.3.2)
http://libreoffice.org/download/

Should you still run into this problem, you can re-open this issue.
Comment 4 retired 2013-12-01 14:31:40 UTC 
Re-open. We need a spreadsheet expert to look into this. Sorry I somehow missed the example spreadsheet when I triaged this earlier.
Comment 5 m_a_riosv 2013-12-01 15:21:41 UTC 
Hi Foss, you can reopen if you like, but there is no bug.

LibreOffice help:
"
DATEVALUE
Returns the internal date number for text in quotes.
The internal date number is returned as a number. The number is determined by the date system that is used by LibreOffice to calculate dates.
If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion.
Syntax
DATEVALUE("Text")
Text is a **valid date expression and must be entered with quotation marks**.
Example
=DATEVALUE("1954-07-20") yields 19925.
"

Partial input dates are only accepted when entering dates by hand in a cell, with the patterns for the selected language.

If Michel want the day of today, if can modify the formula:
=DATEVALUE(E2&"/"&DAY(TODAY()))
Comment 6 retired 2013-12-02 11:51:24 UTC 
mariosv: thanks, that was the info I wanted.

Closing as NOTABUG then.