Ubuntu
openoffice.org package

date format showing in string

Asked by sasiatcyt

Inserted date in one of the cell in spread sheet , for example in A4 , 04-jan-2004 .

I have a PHP code , i want to retrieve the date from excel sheet , but it is showing 37987 for the above date.

But i need to show the date as 04-jan-2004.

i formatted cell in spread sheet , by selecting cell --> right click --> Format cells --> category (Date) --> Format(31 Dec 1999)

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Tony Pursell (ajpursell) said : 		#1

Hi

Do you mean that you have used PHP to write a program to extract data from an OpenOffice.org spreadsheet, in which case you may need to calculate and format the date yourself in code. By default, a date in OpenOffice.org spreadsheet is a number of days beginning with 30/12/1899 as day zero.

You may be able to get more help on the OpenOffice.org's forums (http://user.services.openoffice.org/en/forum/).

Tony

Can you help with this problem?

Provide an answer of your own, or ask sasiatcyt for more information if necessary.

To post a message you must log in.