Why is the data displayed incorrectly through phpexcel?

Question

phpspreadsheet

There is an excel file, the data from which is not displayed correctly, and the incorrect display occurs on Linux, but under Windows everything is ok. The cells have their own format, and have values ​​like: 74.1, when the document is parsed on the local (windows), then everything is fine and the values ​​​​are written to the database as they should, however, on the test server, the values ​​take the following form: 74.09999999999999, when this happens not with all meanings. With which ones I can’t say, since all cells have the same format, and incorrect interpretation occurs only with some of them.

Answer 1

The problem is solved quite simply, but it was difficult to find a solution))
You need to change the php.ini
settings The precision parameter should be equal to 14. Also, the settings can be changed by phpexcell itself, so the following article https://stackoverflow.com
will be a good solution for someone
/questions/44023625/phpex...