perl OpenOffice::OOCBuilder插入公式的问题，着急！

feiying00917

向openoffice的sxc格式插入数据，OpenOffice::OOCBuilder这个模块很好用，但是我遇到一个问题，我要把两个单元格内容连接起来，我用了

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

结果在sxc中显示出来的是=E36&F36
而不是把两个单元格的内容连接之后的内容，这是怎么回事啊，程序就差这一步了，求帮助

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