Display one value while 'binding' another

Topics: Developer Forum
Jul 1, 2015 at 12:28 PM
Hi
I've been using PhpExcel for a while now , so thanks for that!

I wish to display 5 t/m 9 in a cell but for it's value (for sorting purposes) to be 5.

Can I manually add something like

$this->setCellContent($objPHPExcel, $column . $row, ' 5 t/m 9 ');
$this->bindRealValue($objPHPExcel, $column. $row, '5 ');

or is there an alternative option?
Coordinator
Jul 1, 2015 at 1:03 PM
Set the cell value as 5, and set a numberformat mask for it.... exactly as you'd do it in MS Excel
Marked as answer by techbot on 7/2/2015 at 3:42 AM
Jul 2, 2015 at 11:42 AM
Thank you Mark.
In addition here is some of the format options.

http://peltiertech.com/Excel/NumberFormats.html