export converts & to &

[ndarproj]

Livewire PowerGrid version

v6.1.11

Livewire version

3.5.0

Laravel version

11.28

Which PHP version are you using?

PHP 8.3

Which Theme are you using?

Tailwind

Have you published the resource files and customized them? (php artisan vendor:publish)

Yes

What is the problem?

so data that has & is being converted into &

now when i do export

Code snippets

<?php

namespace App\Livewire\Reporting\EngagementReport;

use App\Models\User;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Carbon;
use PowerComponents\LivewirePowerGrid\Button;
use PowerComponents\LivewirePowerGrid\Column;
use PowerComponents\LivewirePowerGrid\Components\SetUp\Exportable;
use PowerComponents\LivewirePowerGrid\Facades\Filter;
use PowerComponents\LivewirePowerGrid\Facades\Rule;
use PowerComponents\LivewirePowerGrid\Footer;
use PowerComponents\LivewirePowerGrid\Header;
use PowerComponents\LivewirePowerGrid\Facades\PowerGrid;
use PowerComponents\LivewirePowerGrid\PowerGridFields;
use PowerComponents\LivewirePowerGrid\PowerGridComponent;
use PowerComponents\LivewirePowerGrid\Traits\WithExport;

final class Table extends PowerGridComponent
{
    use WithExport;

    public string $tableName = "EngagementReportTable";
    public $reportData = [];

    public string $sortField = 'score';

    public string $sortDirection = 'desc';

    public function setUp(): array
    {
        return [
            PowerGrid::exportable('export')
                ->stripTags(true)
                ->striped()
                ->type(Exportable::TYPE_XLS, Exportable::TYPE_CSV),
            PowerGrid::header()->showSearchInput(),
            PowerGrid::footer()
                ->showPerPage()
                ->showRecordCount(),
        ];
    }

    public function datasource()
    {
        return collect($this->reportData);
    }

    public function fields(): PowerGridFields
    {
        return PowerGrid::fields()
            ->add('id')
            ->add('name')
            ->add('interval')
            ->add('engagement_level')
            ->add('score')
            ->add('badge_count')
            ->add('total_score')
            ->add('interactions')
            ->add('activities_completed')
            ->add('checkins_completed')
            ->add('email')
            ->add('team');
    }

    public function columns(): array
    {
        return [

            Column::make('Name', 'name')
                ->sortable()
                ->searchable(),

            Column::make('Email', 'email')
                ->searchable(),

            Column::make('Team', 'team')
                ->searchable(),

            Column::make('Interval', 'interval')
                ->searchable(),

            Column::make('Engagement Level', 'engagement_level')
                ->searchable(),

            Column::make('Score', 'score')
                ->searchable()
                ->sortable(),

            Column::make('Badge Count', 'badge_count')
                ->searchable()
                ->sortable(),

            Column::make('Total Score', 'total_score')
                ->searchable()
                ->sortable(),

            Column::make('Interactions', 'interactions')
                ->sortable()
                ->searchable(),

            Column::make('Check-ins Completed', 'checkins_completed')
                ->sortable()
                ->searchable(),

            Column::make('Activities Completed', 'activities_completed')
                ->sortable()
                ->searchable(),


        ];
    }

    public function filters(): array
    {
        return [
            Filter::inputText('name'),
            Filter::datepicker('created_at_formatted', 'created_at'),
        ];
    }


    /*
    public function actionRules(User $row): array
    {
       return [
            // Hide button edit for ID 1
            Rule::button('edit')
                ->when(fn($row) => $row->id === 1)
                ->hide(),
        ];
    }
    */
}

How do you expect it to work?

data returns as is..

Pfan%&nerstill, Schimmel and Pfeffer
and not
Pfan%&nerstill, Schimmel and Pfeffer

Please confirm (incomplete submissions will not be addressed)

• I have provided easy and step-by-step instructions to reproduce the bug.
• I have provided code samples as text and NOT images.
• I understand my bug report will be removed if I haven't met the criteria above.