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!
why just of all things 2004
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.
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.
My test shows that we have a bug.
Machine XP Pro/SP3
Details are here: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=82790
I can’t confirm that bug. Note that portable versions are not good for testing as they are packaged separately by third parties.
@oweng - I am aware of the limitation of the portable versions. I just have no alternative right now. My production version is 4.2.6.2. Nevertheless thanks for adding the comment for others. ----- Thanks for your testing. I saw the result at BugZilla.
@oweng - This is really interesting. I made a test in 4.2.6.2 ---- 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.
Mine is a installed version 4.3.0.4, not portable.
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 @ROSt53 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.