Skip to content

Macro Buttons and List boxes are removed #2388

@DeekshaPrabhub96

Description

@DeekshaPrabhub96

This is: I have an XLSM with buttons and list box (macros) when I am opening an XLSM file and updating a cell value with text and saving it as different file.

$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($filePath);
$spreadsheet->getCalculationEngine()->suppressFormulaErrors=true;
.
.
.
$writer = new Xlsx($spreadsheet);
$writer->save('output.xlsm');

In the new file buttons and list boxes are missing.

What is the expected behavior?

Button and List box should be present in the new file because we are saving the existing file with different name.

What is the current behavior?

Button and list box are removed.

Which versions of PhpSpreadsheet and PHP are affected?

1.19

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions