search

PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.19k forks source link

Named Range disappear #749

Open shenka opened 9 years ago

shenka commented 9 years ago

How to reproduce the issue:

  1. Create a new excel document.
  2. Name a range of values (e.g. list).
  3. Set the validation of a cell as "List" and enter "=list".
  4. Open the file with phpexcel and export, save or download.

The validation source pointing to the named range has disappear.

I mean, the arrow of the dropbox is there, but, no data appears.

What am I doing wrong?

for detail information refer to: https://github.com/Maatwebsite/Laravel-Excel/issues/438

Thanks in advance.

MarkBaker commented 9 years ago

Any particular Writers?

shenka commented 9 years ago

I've tried with xls and xlsx...

shenka commented 9 years ago

Sorry Mark,

My writer is "PHPExcel_Writer_Excel2007".

am I right? is this the name of the writer?

Thanks in advance.