Open-source event management and ticket selling platform — perfect for concerts, conferences, and everything in between 🎟️ If you find this project helpful, please consider giving us a star ⭐️
PHP attendize-alternativedoor-managementevent-check-inevent-managementevent-registrationevent-ticketingeventbrite-alternativeeventslaravelopen-sourcephpreactself-hostedsell-ticketssell-tickets-onlineticket-sellingticketing-systemtickettailor-alternativetito-alternative
<?php
declare(strict_types=1);
namespace HiEvents\Services\Infrastructure\Export;
class SpreadsheetFormulaEscaper
{
private const FORMULA_TRIGGERS = ['=', '+', '-', '@', "\t", "\r"];
public function isFormulaTrigger(mixed $value): bool
{
if (! is_string($value) || $value === '' || is_numeric($value)) {
return false;
}
return in_array($value[0], self::FORMULA_TRIGGERS, true);
}
public function escape(mixed $value): mixed
{
return $this->isFormulaTrigger($value) ? "'".$value : $value;
}
/**
* @param array<int|string, mixed> $row
* @return array<int|string, mixed>
*/
public function escapeRow(array $row): array
{
return array_map(fn (mixed $value) => $this->escape($value), $row);
}
}