for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace PhpOffice\PhpSpreadsheet\Style\NumberFormat\Wizard;
abstract class DateTimeWizard implements Wizard
{
protected const NO_ESCAPING_NEEDED = "$+-/():!^&'~{}<>= ";
protected function padSeparatorArray(array $separators, int $count): array
$lastSeparator = array_pop($separators);
return $separators + array_fill(0, $count, $lastSeparator);
}
protected function escapeSingleCharacter(string $value): string
if (strpos(self::NO_ESCAPING_NEEDED, $value) !== false) {
return $value;
return "\\{$value}";
protected function wrapLiteral(string $value): string
if (mb_strlen($value, 'UTF-8') === 1) {
return $this->escapeSingleCharacter($value);
// Wrap any other string literals in quotes, so that they're clearly defined as string literals
return '"' . str_replace('"', '""', $value) . '"';
protected function intersperse(string $formatBlock, ?string $separator): string
return "{$formatBlock}{$separator}";
public function __toString(): string
return $this->format();
PHPOffice /
PhpSpreadsheet
