|
@@ 495-502 (lines=8) @@
|
| 492 |
|
$type = \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_BOOL; |
| 493 |
|
$dataValue = ($allCellDataText == 'TRUE') ? true : false; |
| 494 |
|
break; |
| 495 |
|
case 'percentage': |
| 496 |
|
$type = \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC; |
| 497 |
|
$dataValue = (float) $cellDataOfficeAttributes['value']; |
| 498 |
|
if (floor($dataValue) == $dataValue) { |
| 499 |
|
$dataValue = (integer) $dataValue; |
| 500 |
|
} |
| 501 |
|
$formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_00; |
| 502 |
|
break; |
| 503 |
|
case 'currency': |
| 504 |
|
$type = \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC; |
| 505 |
|
$dataValue = (float) $cellDataOfficeAttributes['value']; |
|
@@ 503-510 (lines=8) @@
|
| 500 |
|
} |
| 501 |
|
$formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_00; |
| 502 |
|
break; |
| 503 |
|
case 'currency': |
| 504 |
|
$type = \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC; |
| 505 |
|
$dataValue = (float) $cellDataOfficeAttributes['value']; |
| 506 |
|
if (floor($dataValue) == $dataValue) { |
| 507 |
|
$dataValue = (integer) $dataValue; |
| 508 |
|
} |
| 509 |
|
$formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_CURRENCY_USD_SIMPLE; |
| 510 |
|
break; |
| 511 |
|
case 'float': |
| 512 |
|
$type = \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC; |
| 513 |
|
$dataValue = (float) $cellDataOfficeAttributes['value']; |
PHPOffice /
PhpSpreadsheet
