Find this useful? Enter your email to receive occasional updates for securing PHP code.

Signing you up...

Thank you for signing up!

PHP Decode

<?php declare(strict_types=1); namespace PhpOffice\PhpSpreadsheetTests\Writer\Xls; use ..

Decoded Output download

<?php

declare(strict_types=1);

namespace PhpOffice\PhpSpreadsheetTests\Writer\Xls;

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheetTests\Functional\AbstractFunctional;

class BooleanLiteralTest extends AbstractFunctional
{
    public function testBooleanLiteral(): void
    {
        // Issue 3369 - Xls Writer Parser unable to handle
        //   TRUE (or FALSE) when specified as function arguments.
        $formula = '=AND(true,true(),fAlse,false())';
        $spreadsheet = new Spreadsheet();
        $spreadsheet->setActiveSheetIndex(0);
        $spreadsheet->getActiveSheet()->setCellValue('A1', $formula);

        $robj = $this->writeAndReload($spreadsheet, 'Xls');
        $spreadsheet->disconnectWorksheets();
        $sheet0 = $robj->setActiveSheetIndex(0);
        self::assertSame(strtoupper($formula), $sheet0->getCell('A1')->getValue());
        $robj->disconnectWorksheets();
    }
}
 ?>

Did this file decode correctly?

Original Code

<?php

declare(strict_types=1);

namespace PhpOffice\PhpSpreadsheetTests\Writer\Xls;

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheetTests\Functional\AbstractFunctional;

class BooleanLiteralTest extends AbstractFunctional
{
    public function testBooleanLiteral(): void
    {
        // Issue 3369 - Xls Writer Parser unable to handle
        //   TRUE (or FALSE) when specified as function arguments.
        $formula = '=AND(true,true(),fAlse,false())';
        $spreadsheet = new Spreadsheet();
        $spreadsheet->setActiveSheetIndex(0);
        $spreadsheet->getActiveSheet()->setCellValue('A1', $formula);

        $robj = $this->writeAndReload($spreadsheet, 'Xls');
        $spreadsheet->disconnectWorksheets();
        $sheet0 = $robj->setActiveSheetIndex(0);
        self::assertSame(strtoupper($formula), $sheet0->getCell('A1')->getValue());
        $robj->disconnectWorksheets();
    }
}

Function Calls

None

Variables

None

Stats

MD5 c36d7cb92d201c4cb3fb9a9bbc411dcf
Eval Count 0
Decode Time 95 ms