XML-Reader: interpret zoom

[SlowFox71]

This is:

- [x ] a feature request

What is the expected behavior?

Interpreting <Zoom>50</Zoom> and <ShowPageBreakZoom/>

What is the current behavior?

These elements are ignored

What features do you think are causing the issue

• [x ] Reader

Does an issue affect all spreadsheet file formats? If not, which formats are affected?

XML only

Unfortunately, I do not have a link to an official documentation of the <WorksheetOptions>, but it accepts <Zoom>{$level}</Zoom> to set the zoom scale and <ShowPageBreakZoom> to show the page break preview. IMO this could easily be done with something like the following code in Xml.php:

if (isset($xmlX->WorksheetOptions->ShowPageBreakZoom)) {
    $spreadsheet->getActiveSheet()->getSheetView()->setView(SheetView::SHEETVIEW_PAGE_BREAK_PREVIEW);
}
if (isset($xmlX->WorksheetOptions->Zoom)) {
    $zoomScaleNormal = (int) $xmlX->WorksheetOptions->Zoom;
    if ($zoomScaleNormal <= 0) {
        // setZoomScaleNormal will throw an Exception if the scale is less than or equals 0
        // that is OK when manually creating documents, but we should be able to read all documents
        $zoomScaleNormal = 100;
    }

    $spreadsheet->getActiveSheet()->getSheetView()->setZoomScaleNormal($zoomScaleNormal);
}