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

Reply via email to