PHP 7.1: Numbers shown with scientific notation even if explicitely formatted as text · Issue #357 · PHPOffice/PhpSpreadsheet · GitHub

PHOTO EMBED

Mon Mar 27 2023 13:56:39 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

<?php
require 'vendor/autoload.php';
$data = array('foo' => '150000197301');
$spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
$sheet = $spreadsheet->getSheet(0);
$sheet->fromArray($data, null, 'A1');
$sheet->getStyle('A1:A1')
    ->getNumberFormat()
    ->setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT);
$writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
$filename = 'test_' . PHP_VERSION . '.xlsx';
$writer->save($filename);
content_copyCOPY

https://github.com/PHPOffice/PhpSpreadsheet/issues/357