Am 21.04.2015 um 22:44 schrieb Joel Madero: > On Tue, Apr 21, 2015 at 12:19 PM, Cor Nouws <oo...@nouenoff.nl> wrote: > >> bhaumikdave wrote on 13-04-15 08:58: >> >>> Done. Now Excel will recognize it as date and will allow you to format >> cells >>> any date format as you wish. >> >> No idea what Excel does or not or what proper date handling would be >> most ideal. >> You may try this one however ;) >> >> >> http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates >> > > I think we should make this an easy hack to get it into core. The question > comes up relatively frequently and many times people are just confused as > to why numbers/dates aren't showing up right. > > Cor - your thoughts since you developed the extension? > > > Best, > Joel > > >
You can't push dirty Basic hacks into the core. The extension may convert text into wrong values or nothing at all for the same reasons I've outlined. 13/5/2015 <--> 5/13/2015 <--> 13. Mai 2015 1.234 <--> 1,234 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted