|
@@ 570-578 (lines=9) @@
|
| 567 |
|
$type = DataType::TYPE_BOOL; |
| 568 |
|
$dataValue = ($allCellDataText == 'TRUE') ? true : false; |
| 569 |
|
break; |
| 570 |
|
case 'percentage': |
| 571 |
|
$type = DataType::TYPE_NUMERIC; |
| 572 |
|
$dataValue = (float) $cellData->getAttributeNS($officeNs, 'value'); |
| 573 |
|
|
| 574 |
|
if (floor($dataValue) == $dataValue) { |
| 575 |
|
$dataValue = (int) $dataValue; |
| 576 |
|
} |
| 577 |
|
$formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_00; |
| 578 |
|
break; |
| 579 |
|
case 'currency': |
| 580 |
|
$type = DataType::TYPE_NUMERIC; |
| 581 |
|
$dataValue = (float) $cellData->getAttributeNS($officeNs, 'value'); |
|
@@ 579-587 (lines=9) @@
|
| 576 |
|
} |
| 577 |
|
$formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_00; |
| 578 |
|
break; |
| 579 |
|
case 'currency': |
| 580 |
|
$type = DataType::TYPE_NUMERIC; |
| 581 |
|
$dataValue = (float) $cellData->getAttributeNS($officeNs, 'value'); |
| 582 |
|
|
| 583 |
|
if (floor($dataValue) == $dataValue) { |
| 584 |
|
$dataValue = (int) $dataValue; |
| 585 |
|
} |
| 586 |
|
$formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_CURRENCY_USD_SIMPLE; |
| 587 |
|
break; |
| 588 |
|
case 'float': |
| 589 |
|
$type = DataType::TYPE_NUMERIC; |
| 590 |
|
$dataValue = (float) $cellData->getAttributeNS($officeNs, 'value'); |
PHPOffice /
PhpSpreadsheet
