harryC has asked for the wisdom of the Perl Monks concerning the following question:

Hi
I am trying OODOC but even the simple things do not seem to work
I create a ods spreadsheet with in Sheet1 position D1 a 1 in the cell.
I run the following code and nothing happens only the original spreadsheet gets saved in the new one.
test prints out empty and my cells in the new spreadsheet are empty except for D1.
I am using a dutch Openoffice under Windows XP version 2.1
And as you can see Sheet1 is Blad1 in my openoffice
Does that make a difference ?

sub makencalc { use OpenOffice::OODoc; my $doc = ooDocument(file => "$path_to_files\\verschillenstaatsjabloon +.ods"); my $testt = $doc->cellValue("Sheet1","D1"); print "test: $testt\n"; $testt = $doc->cellValue("Blad1","D1"); print "test: $testt\n"; $doc->cellValue("Sheet1", "A5", 'test text english '); $doc->cellValue("Blad1", "A6", "test text dutch"); $doc->save("$path_to_files\\verschillenstaat.ods"); }