perl OpenOffice::OOCBuilder插入公式的問題，著急！

feiying00917

向openoffice的sxc格式插入數(shù)據(jù)，OpenOffice::OOCBuilder這個模塊很好用，但是我遇到一個問題，我要把兩個單元格內(nèi)容連接起來，我用了

$sheet->set_data_xy ($column,$row,"=E$row&F$row",'formual');

結果在sxc中顯示出來的是=E36&F36
而不是把兩個單元格的內(nèi)容連接之后的內(nèi)容，這是怎么回事啊，程序就差這一步了，求幫助

feiying00917

太搞了啊，把formula這個單詞寫錯了啊回復 1# feiying00917


   

jason680

回復 2# feiying00917

1. check the package OpenOffice::OOCBuilder source code
http://cpansearch.perl.org/src/MAYGILL/OpenOffice-OOBuilder-0.09/OOCBuilder.pm

it check the type, but didn't have any warnings when you gave the wrong type
  # - check type
  my ($ok);
  if ($type) {
    $type=lc($type);
    foreach (@TYPES) {
       if ($type eq $_) {
         $ok=1;
         last;
      }
    }
  }
  $type=$TYPES[0] if (! $ok);  # take $TYPES[0] as default type


2. you can use constant function to check type by yourself

use strict;
use warnings;
use constant formula => 'formula';

print formula;
#print formual;

   

feiying00917

多謝，領教了回復 3# jason680