To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97903
------- Additional comments from brinz...@openoffice.org Sat Jan 10 10:22:27 +0000 2009 ------- imho this should work: Sub Main Dim oCell as Object Dim oLocale as New com.sun.star.lang.Locale Dim nFormat as Long oCell = ThisComponent.getSheets().getByIndex(0).getCellByPosition(0,0) nFormat = ThisComponent.getNumberFormats.getFormatIndex( com.sun.star.i18n.NumberFormatIndex.DATETIME_SYS_DDMMYYYY_HHMMSS , oLocale) oCell.NumberFormat = nFormat oCell.setValue(CDate("10.01.2009 12:30:00")) End Sub --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org