PhpSpreadsheet: How can I format a cell so that it accepts text values ​​without truncating the "+" sign in them?

Question

PHP

There is something like this code:

$sheet
  ->getStyleByColumnAndRow($column, $row)
  ->getNumberFormat()
  ->setFormatCode('@')
;
$sheet->setCellValueByColumnAndRow(
  $position,
  $row,
  $value
);

In theory, it should set the text format in the cell, and after that, if we set a value like "+5" in it, it should remain so. In practice, the plus sign is cut off. How to win it? I tried the General format, but with this format (General), the plus is cut off even if you check it manually in MS Excel itself. But the text format with such a check saves the plus, but not when we do it through the code.

Answer 1

Looks like we'll have to fiddle with the DefaultValueBinder heir and assign it to cells.
Look - on the 63rd line of this, the initial "+" is directly cut off, no matter how you deal with cell types.

Answer 2

Faced the same problem - the answer was in the
docs
, maybe it will be useful to someone given by code like this

// Set cell A8 with a numeric value, but tell PhpSpreadsheet it should be treated as a string
$spreadsheet->getActiveSheet()->setCellValueExplicit(
    'A8',  // координаты ячейки
    "01513789642",   // нужное значение строки
    \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING
);

Answer 3

As an option - to transfer values ​​prefixed with an apostrophe, i.e. instead "+5"of doing"'+5"