Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[QUESTION] 0 in cell shows up blank in export #2090

Closed
cvanderlinden opened this issue Mar 6, 2019 · 1 comment
Closed

[QUESTION] 0 in cell shows up blank in export #2090

cvanderlinden opened this issue Mar 6, 2019 · 1 comment

Comments

@cvanderlinden
Copy link

Versions

  • PHP version: 7.2
  • Laravel version: 5.5
  • Package version: 3.1

Description

I am creating my rows using an array and then returning return collect($rows);
When I set a cell value to 0 and export the .xls or .xlsx file, the cells where the zero was set are empty. This is causing an issue with my calculations

Some pseudo-code for how I am adding the rows
$rows[] = [ 'A1' => 0 'A2' => 0 ]; return collect($rows);

However, when I open the file, those values are blank instead of 0. Is there any way to include an actual zero instead of a blank cell?

Additional Information

Related Issues:
#1566 (2.1)
#135 (1.0)

@patrickbrouwers
Copy link
Member

https://docs.laravel-excel.com/3.1/exports/collection.html#strict-null-comparisons

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants