Zero (0) get removed

[Tejas20002]

I have try this method to don't remove the zero (0)

 public function columnFormats(): array {
        return [
            'A' => NumberFormat::FORMAT_NUMBER,
            'B' => NumberFormat::FORMAT_TEXT,
            'C' => NumberFormat::FORMAT_NUMBER,
        ];
    }

I have also try this:

 public function columnFormats(): array {
        return [
            'A' => NumberFormat::FORMAT_NUMBER,
            'B' => '0',
            'C' => NumberFormat::FORMAT_NUMBER,
        ];
    }

I have also try this:

 public function columnFormats(): array {
        return [
            'A' => NumberFormat::FORMAT_NUMBER,
            'B' => '@',
            'C' => NumberFormat::FORMAT_NUMBER,
        ];
    }

I have also try this:

 public function columnFormats(): array {
        return [
            'A' => NumberFormat::FORMAT_NUMBER,
            'B' => NumberFormats::FORMAT_GENERAL,
            'C' => NumberFormat::FORMAT_NUMBER,
        ];
    }

I have also try to convert int to string in the view of my Laravel then also zero(0) get removed, I have use function to convert int to string:

1. typecast

<table border="1">
    <thead>
    <tr>
        <th>#</th>
        <th>Single Open</th>
        <th>Amount</th>
    </tr>
    </thead>
    <tbody>
    {{ $i = 1 }}
    @foreach($opensingle as $jod)
        <tr>
            <td>{{ $i ?? '' ?? '1' }}</td>
            <td>{{ (string)$jod['open_digit'] }}</td>
            <td>{{ $jod['total_amount'] }}</td>
            {{ $i++ }}
        </tr>
    @endforeach
    </tbody>
</table>

2. String function strval() and settype():

<table border="1">
    <thead>
    <tr>
        <th>#</th>
        <th>Single Open</th>
        <th>Amount</th>
    </tr>
    </thead>
    <tbody>
    {{ $i = 1 }}
    @foreach($opensingle as $jod)
        <tr>
            <td>{{ $i ?? '' ?? '1' }}</td>
            <td>{{ strval($jod['open_digit']) }}</td> OR <td>{{ settype($jod['open_digit'], "string") }}</td> // answer of strval is empty and settype is 1
            <td>{{ $jod['total_amount'] }}</td>
            {{ $i++ }}
        </tr>
    @endforeach
    </tbody>
</table>

[patrickbrouwers]

Try the stringvaluebinder

[Tejas20002]

stringvaluebinder

not working

 public function columnFormats(): array {
        return [
            'A' => NumberFormat::FORMAT_NUMBER,
            'B' => NumberFormat::FORMAT_NUMBER,
            'C' => NumberFormat::FORMAT_NUMBER,
        ];
    }

    /**
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     */
    public function bindValue(Cell $cell, $value) {
        if (is_numeric($value)) {
            $cell->setValueExplicit($value, DataType::TYPE_STRING);
            return true;
        }
         return parent::bindValue($cell, $value);
    }

[Tejas20002]

@patrickbrouwers this issue has been fixed but not working in laravel here is fixed issue link checkout
PHPOffice/PhpSpreadsheet#2813

[patrickbrouwers]

You'll have to wait till PhpSpreadsheet releases that fix in a new version.

[af-cl]

@Tejas20002 for a simple display zero in a cell you can use a hack
<td>{!! $value == 0 ? '&#48;' : $value !!}</td>

[Tejas20002]

Yaaa! But it one type of makeshifter, it's not a proper way!!