converting a .xlsx file to .pdf not retain the specified print area

[joerg-jw]

Guidelines

• I understand that if I fail to adhere to contribution guidelines and/or fail to provide all required details, this issue may be closed without review.

Description of the bug

Why does converting a .xlsx file to .pdf not retain the specified print area and instead produces the entire page without selection?

mPDF version

8.2

PHP Version and environment (server type, cli provider etc., enclosing libraries and their respective versions)

8.2.12

Reproducible PHP+CSS+HTML snippet suffering by the error

`

//<?php
//https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#setting-printer-options-for-excel-files
require '../../vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Writer\Pdf\Mpdf;

// Lade die vorhandene Excel-Datei
$spreadsheet = IOFactory::createReader('Xlsx')->load('hello_world.xlsx');

// Arbeite mit der geladenen Excel-Datei
$sheet = $spreadsheet->getActiveSheet();

// Ändere eine Zelle
$sheet->setCellValue('B2', 'Updated Content');

// Beispiel: Setze den Druckbereich erneut (Beispiel: A1 bis D20)
$sheet->getPageSetup()->setPrintArea('A1:J10');
$spreadsheet->getActiveSheet()->getPageSetup()->setPrintArea('A1:E5');
$spreadsheet->getActiveSheet()->getPageSetup()->setHorizontalCentered(true);
$spreadsheet->getActiveSheet()->getPageSetup()->setVerticalCentered(true);
//$spreadsheet->getActiveSheet()->getPageSetup()->setScale(100);

// Speichere die Änderungen in derselben Datei
$excelWriter = IOFactory::createWriter($spreadsheet, 'Xlsx');
$excelWriter->save('hello_world_updated.xlsx');

// Lade die Excel-Datei
$spreadsheetUpdated = IOFactory::load('hello_world_updated.xlsx');

// Setze den Druckbereich (angenommen, der Druckbereich ist A1:B10)
$spreadsheetUpdated->getActiveSheet()->getPageSetup()->setPrintArea('A1:E5');
print_r($spreadsheetUpdated->getActiveSheet()->getPageSetup()->getPrintArea());

// Erstelle das PDF
$pdfWriter = new Mpdf($spreadsheetUpdated);
$pdfWriter->save('hello_world_updated.pdf');
?>`

[finwe]

This should be asked in phpspreadsheet repository, mPDF doesn't know anything about the internals of printed xls document.