OpenOffice-OODoc - problem with leading characters

Posted on Wed Jul 4 00:22:00 2007 by petert
problem with leading characters
I'm trying to get data from multiple spreadsheets and combine them into one but whenever I read a number (such as 01/08/06) it get's turned into '2006-01-08 or (34 into '34). How do I keep this from happening? The ooCalc spreadsheets have default style/formatting settings. Here's a snippet of the code:
#get the date from little spread sheet and copy it into the big one while($date = $little_doc ->cellValue($little_sheet, $little_column . "1")){ $big_doc ->cellValue($big_sheet, $big_column . "1", $date); print "just wrote data: $date to big_spread\n"; $little_column++; $big_column++; }
Thanks in advance for any help, Pete.
Direct Responses: 5631 | Write a response