Excel::Writer::XLSX 在公式中添加了一个意想不到的@(第 2 部分)

Question

这个问题遵循第一个问题:
Excel::Writer::XLSX adds an unexpected @ in formula
我正在使用 Excel::Writer::XLSX 将公式写入 xlsx 文件
在我使用 _xlfn 时，当我尝试编写一个复杂的公式时，我没有预期的结果。这是显示问题的代码:

use Excel::Writer::XLSX;
my $workbook  = Excel::Writer::XLSX->new( "test.xlsx" );
my $worksheet = $workbook->add_worksheet();
$worksheet->write( 'B1', "5");
$worksheet->write( 'A1', "4");
$worksheet->write( 'A2', "5");
$worksheet->write( 'A3', "3");
$worksheet->write( 'A4', "4");
$worksheet->write( 'A5', "6");
$worksheet->write( 'A7', "=_xlfn.STDEV.P(IF((A1:A5<B1),A1:A5))");
$workbook ->close();

然后单元格 A7 包含: =STDEV.P(IF((@A1:A5<B1),A1:A5))并且因为 @ ，单元格显示 #NAME?而不是公式的结果。
有谁知道如何删除这个意外的 @ ?

Answer 1

感谢JvdV，解决方法确实是使用{}

use Excel::Writer::XLSX;
my $workbook  = Excel::Writer::XLSX->new( "test.xlsx" );
my $worksheet = $workbook->add_worksheet();
$worksheet->write( 'B1', "5");
$worksheet->write( 'A1', "4");
$worksheet->write( 'A2', "5");
$worksheet->write( 'A3', "3");
$worksheet->write( 'A4', "4");
$worksheet->write( 'A5', "6");
$worksheet->write( 'A7', "{=_xlfn.STDEV.P(IF((A1:A5<B1),A1:A5))}");
$workbook ->close();