search

PHPOffice / PhpSpreadsheet

A pure PHP library for reading and writing spreadsheet files
https://phpspreadsheet.readthedocs.io
MIT License
13.37k stars 3.47k forks source link

[Bug]: Incorrect definition of date data type #4135

Closed Kladislav closed 3 months ago

Kladislav commented 3 months ago

https://github.com/SpartnerNL/Laravel-Excel/issues/4180

oleibman commented 3 months ago

What do you think is wrong? Dates are stored as floating point numbers in Excel. So, for example, the value stored in cell B3 is 45354. The formatted value of the cell is "3/3", because the number format of the cell is "d/m". If you are using getValue to determine the value of the cell, perhaps you should be using getFormattedValue instead.