Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Button and list box getting hidden #2394

Closed
DeekshaPrabhub96 opened this issue Nov 11, 2021 · 1 comment
Closed

Button and list box getting hidden #2394

DeekshaPrabhub96 opened this issue Nov 11, 2021 · 1 comment

Comments

@DeekshaPrabhub96
Copy link

This is:
I have an excel with few buttons and list boxes added using Developer Menu. Using PHPSpreadsheet I am just opening and saving the file with different name.

What is the expected behavior?

The buttons and ListBoxes should be visible

What is the current behavior?

The Buttons and ListBoxes are in hidden state in the new excel. To make it visible, we have to go to Find and Select -> Selection Pane and Mark it as 'Show'.

What are the steps to reproduce?

Please check the attachments. I have attached sample input and output file.

<?php
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();

// add code that show the issue here...

$spreadsheet = $reader->load($file);

$writer = new Xlsx($spreadsheet);
$writer->save('TextColorOutput.xlsx');

Which versions of PhpSpreadsheet and PHP are affected?

1.19

ListandButtonInput.xlsx
ListandButtonOutpot.xlsx

@oleibman
Copy link
Collaborator

Closing. Testing against a recent version, the output file matches the input, almost certainly because of PR #3130, part of version 1.27.0 Jan. 24, 2023.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Development

No branches or pull requests

3 participants