Worksheet!C295 -> Formula Error: Operator ':' has no operands

after a deep searching on google without finding any solution. I'm using Laravel Excel Maatwebsite package. I've already tried setting the calculate parameter on excel config file to false. I found a row on the database that contains this value "=_DateRDV:" but I need to need to keep it on the result excel

When I try to export a database query result to excel I get this error :

PhpOffice\PhpSpreadsheet\Calculation\Exception Worksheet!C295 -> Formula Error: Operator ':' has no operands

avb

6 years ago

Level 8

The = in "=_DateRDV:" is the problem here. The package reads this as a Formula. The Formula does not exist and gives an error.

Depending on if you want to export a string for this cell or format the whole column to text, you can take a different approach here. You can make use of export formatting goodies when exporting with Maatbesite Laravel Exel.

Either one of these approaches will help you out hopefully:

Custom formatting values and set the Datatype to DataType::TYPE_STRING
Formatting Columns for formatting the whole column to any of these options

Please or to participate in this conversation.