Ask Your Question

V4.3 does not recognize date format like 03SEP [closed]

asked 2014-08-18 19:27:01 +0200

Bonbonbillo gravatar image

updated 2016-03-02 12:48:52 +0200

Alex Kemp gravatar image

in libreoffice calc V4.1 , when copy and paste date like 03SEP, it can recognize as 03Sep2014(just as what I set in cell format), but now in V4.3, it says "#VALUE!". Help please and thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-02 12:49:26.022688


why just of all things 2004

karolus gravatar imagekarolus ( 2014-08-18 20:36:09 +0200 )edit

Please edit your question to indicate: (a) the data entered into the cell e.g., 2014-08-19; (b) the format code used to display the data e.g., DDMMM; (c) what is displayed in the cell e.g., 19Aug; (d) whatever actions you then take regarding this data e.g., copy/paste. Thanks.

oweng gravatar imageoweng ( 2014-08-19 02:46:20 +0200 )edit

OK. I answer as below: (a) the data entered into the cell:03SEP (input manully, or copy/paste here) (b) the format code used to display the data:DDMMM; (c) what is displayed in the cell:03SEP; (d) whatever actions you then take regarding this data:No more actions. the cell format is set as english format anything like 03Sep...etc.

Bonbonbillo gravatar imageBonbonbillo ( 2014-08-19 09:43:21 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2014-08-19 01:59:18 +0200

ROSt52 gravatar image

My test shows that we have a bug.
Machine XP Pro/SP3
Details are here:

edit flag offensive delete link more


I can't confirm that bug. Note that portable versions are not good for testing as they are packaged separately by third parties.

oweng gravatar imageoweng ( 2014-08-19 03:02:47 +0200 )edit

@oweng - I am aware of the limitation of the portable versions. I just have no alternative right now. My production version is Nevertheless thanks for adding the comment for others. ----- Thanks for your testing. I saw the result at BugZilla.

ROSt52 gravatar imageROSt52 ( 2014-08-19 04:20:55 +0200 )edit

@oweng - This is really interesting. I made a test in ---- 1) Unformatted cell > enter string 03Sep > string appears as text being aligned at the left side of the cell > reformatting to date is not possible ------ 2) formatted cell DDMMM > enter string 03Sep > string appears at the right side > reformatting cell to a different date format displays the date in the new format. As the input has no year, Calc assumes the current year. --- You are right, this is not the issue I report as a bug.

ROSt52 gravatar imageROSt52 ( 2014-08-20 03:35:05 +0200 )edit

answered 2014-08-19 12:45:18 +0200

oweng gravatar image

updated 2014-08-20 03:56:52 +0200

I can now see the problem in v4.3.0.4 and v4.4.0.0 (2014-08-10 daily build). This does not appear to be the same problem @ROSt52 has reported. Basically v4.3 and 4.4 treat the input of 03SEP as text, regardless of whether a cell has been previously formatted using the code DDMMM. Under v4.2.6.2 entering 03SEP results in either 03/09/14 (default cell format, en-AU locale) or 03Sep (cell format of DDMMM, en_AU locale), with both entered values treated as a date.

It has been reported as bug fdo#82222.

edit flag offensive delete link more

answered 2014-08-19 09:50:15 +0200

Bonbonbillo gravatar image

Mine is a installed version, not portable.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-08-18 19:27:01 +0200

Seen: 99 times

Last updated: Aug 20 '14