|
Hi
thanks for the reply on my first message it helped me a lot
i am trying to make a table with oodoc
i have suceeded for some part
i created a template document with a emty tabel with 3 rows and 8 columns,
a header with text in it and two empty rows.
i open the template and insert data and rows .
and save the document as a new odt file.
That works fine.
Now i want to have in the last collumn the a calculation column4 - column5.
If i put in my template in the last collumn =E<2>-F<2> then with insert rows it stays
=E2-F2 and does not change in =E3-F3
i tried to code it with:
$rijenteller =1 ;
foreach $basisstnr (sort keys %verschiltabel) {
my $cell = $document->getCell("$table",$rijenteller, 0);
$document->cellValue($cell,$basisstnr );
$document->cellValue("$table",$rijenteller,7,"=<E$rijenteller>-<F$rijenteller>");
$document->insertRow("$table",$rijenteller,position => 'after');
$rijenteller += 1;:<br>
}
but that does not work either
It only puts text in the column not a formula
How should I proceed ?
thks
Harry
|
(4)
]
