oleibman on master
Sync composer.lock/.json and Ph… (compare)
setValueExplicitbut the casting of your value to string it probably the normal one in PHP. Check this https://stackoverflow.com/questions/1471674/why-is-php-printing-my-number-in-scientific-notation-when-i-specified-it-as-00 you might find a few useful hints.
Yes, I know that that happens. The thing is that I lose precision in the number. For example,
"123456789012344992.000000" when I do an
sprintf('%f', $var). But it is not a number, it is a string, and I want it to be read as string in the beginning; if it is read as a string and not as a number, I think I will be able to solve the problem.
I will keep looking for a solution.
Thanks for your answer @frantzmiccoli !
Another thing is that the reader never calls my ValueBinder, so line
is never called.
Hello? Anyone in here?
I setup the page my excel file with Page Layout view and width.
The problem is that I start the excel with Microsoft 2007, Pagesetup width is not work.
When I click anything in menu of excel.
Pagesetup width is work.
Is it problem of Excel or Is there any code to solve that problem?
Is there a way to apply a border style for a range of cells other than the default method :
This method applies the border for the whole block and not each cell
@Med-Seif I think you may find this helpful: https://phpspreadsheet.readthedocs.io/en/develop/topics/recipes/#styles
You can use
$stlyes = [ 'borders' => [ 'allBorders' => [ 'borderStyle' => Style\Border::BORDER_THICK, ] ]
This will apply border to each cell in the range you have selected, rather than to just the outer cells.