|
@@ 559-567 (lines=9) @@
|
| 556 |
|
$type = DataType::TYPE_BOOL; |
| 557 |
|
$dataValue = ($allCellDataText == 'TRUE') ? true : false; |
| 558 |
|
break; |
| 559 |
|
case 'percentage': |
| 560 |
|
$type = DataType::TYPE_NUMERIC; |
| 561 |
|
$dataValue = (float) $cellData->getAttributeNS($officeNs, 'value'); |
| 562 |
|
|
| 563 |
|
if (floor($dataValue) == $dataValue) { |
| 564 |
|
$dataValue = (int) $dataValue; |
| 565 |
|
} |
| 566 |
|
$formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_00; |
| 567 |
|
break; |
| 568 |
|
case 'currency': |
| 569 |
|
$type = DataType::TYPE_NUMERIC; |
| 570 |
|
$dataValue = (float) $cellData->getAttributeNS($officeNs, 'value'); |
|
@@ 568-576 (lines=9) @@
|
| 565 |
|
} |
| 566 |
|
$formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_00; |
| 567 |
|
break; |
| 568 |
|
case 'currency': |
| 569 |
|
$type = DataType::TYPE_NUMERIC; |
| 570 |
|
$dataValue = (float) $cellData->getAttributeNS($officeNs, 'value'); |
| 571 |
|
|
| 572 |
|
if (floor($dataValue) == $dataValue) { |
| 573 |
|
$dataValue = (int) $dataValue; |
| 574 |
|
} |
| 575 |
|
$formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_CURRENCY_USD_SIMPLE; |
| 576 |
|
break; |
| 577 |
|
case 'float': |
| 578 |
|
$type = DataType::TYPE_NUMERIC; |
| 579 |
|
$dataValue = (float) $cellData->getAttributeNS($officeNs, 'value'); |
PHPOffice /
PhpSpreadsheet
