[libreoffice-users] Unexpected behavior while writing Calc Functions

I wrote a simple function

Function mydate As Date
  mydate = CDate(100)
End Function

I then called this function from a Calc document

=myDate()

Finally, I directly accessed the cells with the dates from a macro 
similar to the following code:

Print ThisComponent.Sheets(0).getCellByPosition(0, 1).Value

The cell displayed the value as I expected, but the returned value was 
zero.

Turns out that dates are converted to strings when returned to Calc. 
Oops. The proper thing to do (if you want it to work as expected) is to 
return a numeric value.

Side note, this behavior is the same in the Apache and the Libre version 
of OO, so this has probably been there a long time.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php

--
For unsubscribe instructions e-mail to: users+help@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