xny/vendor/phpoffice/phpspreadsheet/tests/PhpSpreadsheetTests/Calculation/StringLengthTest.php

<?php

namespace PhpOffice\PhpSpreadsheetTests\Calculation;

use PhpOffice\PhpSpreadsheet\Cell\DataType;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PHPUnit\Framework\TestCase;

class StringLengthTest extends TestCase
{
    public function testStringLength(): void
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        // Note use Armenian character below to make sure chars, not bytes
        $longstring = str_repeat('Ԁ', DataType::MAX_STRING_LENGTH - 5);
        $sheet->getCell('C1')->setValue($longstring);
        self::assertSame($longstring, $sheet->getCell('C1')->getValue());
        $sheet->getCell('C2')->setValue($longstring . 'abcdef');
        self::assertSame($longstring . 'abcde', $sheet->getCell('C2')->getValue());
        $sheet->getCell('C3')->setValue('abcdef');
        $sheet->getCell('C4')->setValue('=C1 & C3');
        self::assertSame($longstring . 'abcde', $sheet->getCell('C4')->getCalculatedValue(), 'truncate cell concat with cell');
        $sheet->getCell('C5')->setValue('=C1 & "A"');
        self::assertSame($longstring . 'A', $sheet->getCell('C5')->getCalculatedValue(), 'okay cell concat with literal');
        $sheet->getCell('C6')->setValue('=C1 & "ABCDEF"');
        self::assertSame($longstring . 'ABCDE', $sheet->getCell('C6')->getCalculatedValue(), 'truncate cell concat with literal');
        $sheet->getCell('C7')->setValue('="ABCDEF" & C1');
        self::assertSame('ABCDEF' . str_repeat('Ԁ', DataType::MAX_STRING_LENGTH - 6), $sheet->getCell('C7')->getCalculatedValue(), 'truncate literal concat with cell');
        $sheet->getCell('C8')->setValue('="ABCDE" & C1');
        self::assertSame('ABCDE' . $longstring, $sheet->getCell('C8')->getCalculatedValue(), 'okay literal concat with cell');
        $spreadsheet->disconnectWorksheets();
    }
}