|
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.
|