|
I'm trying to display the contents of a cell as type 'currency' (USD), but I'm having trouble getting it to work. Here is my code:
#get a handle for a table that contains one cell
my $table = $document->getTable(0, 1, 1);
#get a handle for the only cell in the table
my $cell = $document->getCell($table, 0,0);
$document->cellValueType($cell, 'currency');
$document->cellCurrency($cell, 'USD');
#print the value in the cell
$document->updateCell($cell, 95, '$95.00');
I've tried a number of variations for the arguments to updateCell, none of which work. I always either get a plain number or a zero. I have also unsuccessfully tried using a document template from my local copy of OOo (us-EN), as well as explicitly setting my language to us-EN.
Any help would be greatly appreciated. Thanks.
|
(4)
]
