-1

in phpexcel problem with floating point, I'm from Russia, we decided to share bits of places, to do so would have been a comma or a point depending on the country 99,667 or 99.667

$sheet->setCellValueByColumnAndRow(
                        $i + 1,
                        $key + 5,
                        '=COUNTIF(' . PHPExcel_Cell::stringFromColumnIndex(
                            $i - $cntDate
                        ) . ($key + 5) . ':' . PHPExcel_Cell::stringFromColumnIndex($i - 1) . ($key + 5) . ',"<99.667")'
                    );
pnuts
  • 58,317
  • 11
  • 87
  • 139
Ivan Smorodin
  • 151
  • 3
  • 14

1 Answers1

0

Could you try wrapping the number in floatval() ?

Jubayer Arefin
  • 485
  • 7
  • 17
  • The problem in that at us in Russia are written to excel of number of float in formulas through a comma, and returns to floatval type number *. *** – Ivan Smorodin Jul 07 '14 at 10:30