Jeff swicegood
asked on
Method to call to change a spreadsheet cell type to "Date" in LibreOffice/OOo basic language
I am creating a self-filling spreadsheet in LibreOffice. I have searched but I can't find out what code to make an API call to change a spreadsheet cell type to "Date" in LibreOffice/OpenOffice.
REM ***** BASIC *****
sub Main
rem ----------------------------------------------------------------------
rem define variables
dim Doc as object
Dim Sheet As Object
Dim Cell As Object
Dim DatesStuffWasRecieved (20) as Date
Dim QuantitiesRecieved (20) as Integer
rem initialize everything
Doc = ThisComponent
Sheet = Doc.Sheets(0)
DatesStuffWasRecieved(1) = DateValue("12/02/2011")
Cell = Sheet.getCellByPosition(0, 6)
Cell.setValue(DatesStuffWasRecieved(1))
Rem Here is where I want to change the cell format to display the date rather than the cryptic number DateValue("12/02/2011")
end Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.