https://bugs.documentfoundation.org/show_bug.cgi?id=87386
--- Comment #13 from [email protected] --- (In reply to GerardF from comment #11) > (In reply to klsu from comment #0) > > Cell C13 & D13 contain general number 24.09 and text 24.09.13, respectively > > (European dates dd.mm and dd.mm.yy in a .CSV opened on a US machine). > > Formula to convert the first dd.mm and the second year to a date would be > > =DATE(2000+VALUE(RIGHT(D13,2)),MOD(C13,1)*100,INT(C13)), however, for this > > particular date the formula returns 08/24/13 rather than 09/24/13. Note > > that: > > =DATE(2000+VALUE(RIGHT(D13,2)),0.09*100,INT(C13)) works > > =DATE(2000+VALUE(RIGHT(D13,2)),C13*100-INT(C13)*100,INT(C13)) works > > =DATE(2000+VALUE(RIGHT(D13,2)),(C13-INT(C13))*100,INT(C13)) does not > > =DATE(2000+VALUE(RIGHT(D13,2)),MOD(C13,1)*100,INT(C13)) does not > > A similar problem occurs with number 7.05 and text 07.05.13 and others, > > but not all. > > Instead of using DATE, VALUE, RIGHT, INT, MOD and other hundreds of > Functions, just open correctly the .csv file and you will have true dates > and don't need any functions. As I have said before, programs and computers are supposed to work for users, not vice versa. When programmers start to think they know more than their users about the things their programs are used for, it becomes a problem for users. I know how to open a .CSV; whereas you obviously haven't experienced that opening a .CSV created in a different language from the the machine it is being opened on doesn't always work as the programmers imagined it would. Someone who does nothing but programming doesn't typically know enough about how his program will be used to test it adequately. In addition, today's programmers are much less aware of the problem of unintended consequences because higher level languages make it easier to program without knowing what they're actually causing the computer do. This doesn't just caused bugs, but also severe security problems. I would have asked for a workaround if I had needed one (you can see by the things I tried above that I didn't need one). If you're a programmer, I suggest you read my response to Matthew Francis' last comment. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
