Am So, den 01.05.2005 schrieb Wolfgang Schaible um 10:42: > Hi, Hi Wolfgang,
> A field defined in HsqlDB as ISO-Date YY-MM-DD returns using > -getString() : a string e.g. 2005-05-01, > MsgBox with isDate(): True > (ok, isDate accepts numeric or string) > writing this with setString() to a Calc field: > '2005-05-01 > does -as a string- not use the format 'Date' of > the cell. ->Wrong way. > -getDate() : Xray says: --- IDL reference of the structure : > > > com.sun.star.util.Date (end of way for me...) > Day integer 1 > Month integer 5 > Year integer 2005 > MsgBox with isDate(): False ??? > -writing this with setString() to a Calc field: > =>BASIC runtime error. > Incorrect property value. > -writing this with setDate() to a Calc field: > =>BASIC runtime error. > Poperty or method not found (my inventation) > -writing this with setValue() to a Calc field: > =>BASIC runtime error. > Incorrect property value. > > How can I write this date to a Calc field, using the cell format? I don't know the answer, but maybe it'll help to go another way: Have you tried to look at the properties of a calc cell containing a properly formatted date value with XRay? I cannot talk about windows, but on unix-like machines a date is a longint containing the numer of seconds till somewhen 1970. Have a look at the properties Value, String, Formula and FormulaLocal of the cell. HTH, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
