Link to home
Start Free TrialLog in
Avatar of Jeff swicegood
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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Jeff swicegood
Jeff swicegood

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial