Hello,
I use the module Spreadsheet::WriteExcel and have following effect by
generating formulas
...
# Formulas
my $formel = $worksheet -> store_formula('=IF(A2=A1,"X","-");');
for my $row (1..$anz_rows)
{
$worksheet -> repeat_formula($row, 8, $formel, $f_standard, 'A2',
'A'.($row + 1), 'A1', 'A'.$row );
}
...
The generate Excel (german) look like this:
=WENN(A9=A8;"X";"-")
=WENN(A90=A1;"X";"-") -> I would like A10
=WENN(A101=A1;"X";"-") -> I would like A11
...
=WENN(A20=A19;"X";"-")
also from A10 until A19 is not correct. Who can help me ?
Thank you.
Olivier
--
COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test
--------------------------------------------------
1. GMX TopMail - Platz 1 und Testsieger!
2. GMX ProMail - Platz 2 und Preis-Qualitätssieger!
3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. daybyday - 8. e-Post
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
