Chengbin asked 7 months ago
Hi:
After I upgraded to 2.8 from 2.22, several issue pop up ( which works fine in 2.22)
- When export to excel, there is extra role on the top: “Export to Excel” . Can we remove it?
- Any cell contacts “-” will be double quoted. For example, part number 752-34356 will show “752-34356”. In older version 2.22, it can show properly as 752-34356
- the top page navigator disappear even after I have put:
$opt[“toolbar”] = “both”;
$opt[“globalsearch”] = false;
$opt[“toppager”] = true;
Thanks in advance for your help!
3 Answers
Chengbin answered 7 months ago
Sorry, please ignore the first question. I found it can be controlled by \”heading\”=>False. But the heading does not work in 2.22.
Abu Ghufran Staff answered 5 months ago
Although it’s late, but just to log solution:
#2. You can use the previous export library. Just rename the lib/inc/excel/PHPExcel to _PHPExcel. It will shift back to the old library.
#3. Here is the demo code.
https://gist.github.com/gridphp/e2232c0052f2f34de3b785f1e21598c7
Line 28,29 and 51,52
Screenshot:
Your Answer
