'
. ''
. '',
$data
);
}
$data = file_get_contents($file2);
if ($data === false) {
self::fail('Unable to read file');
} else {
// cells B1, C1, D1 all nominally use quotePrefix s="1"
self::assertStringContainsString('', $data);
self::assertStringContainsString('', $data);
self::assertStringContainsString('', $data);
}
}
public function testFormulaDespiteQuotePrefix(): void
{
$reader = new Xlsx();
$spreadsheet = $reader->load(self::$testbook);
$sheet = $spreadsheet->getActiveSheet();
self::assertSame('=2+3', $sheet->getCell('B1')->getValue());
self::assertSame('=1+2', $sheet->getCell('C1')->getValue());
self::assertSame('3', $sheet->getCell('D1')->getValue());
self::assertSame(5, $sheet->getCell('B1')->getCalculatedValue());
self::assertSame('=1+2', $sheet->getCell('C1')->getCalculatedValue());
self::assertSame('3', $sheet->getCell('D1')->getCalculatedValue());
$spreadsheet->disconnectWorksheets();
}
}