/var/www/hkosl.com/imusiccircle/webadmin/libraies/phpoffice/phpexcel/Classes/PHPExcel/Cell/AdvancedValueBinder.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
<?php
/**
 * PHPExcel
 *
 * Copyright (c) 2006 - 2014 PHPExcel
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 *
 * @category   PHPExcel
 * @package    PHPExcel_Cell
 * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt    LGPL
 * @version    ##VERSION##, ##DATE##
 */


/** PHPExcel root directory */
if (!defined('PHPEXCEL_ROOT')) {
    
/**
     * @ignore
     */
    
define('PHPEXCEL_ROOT'dirname(__FILE__) . '/../../');
    require(
PHPEXCEL_ROOT 'PHPExcel/Autoloader.php');
}


/**
 * PHPExcel_Cell_AdvancedValueBinder
 *
 * @category   PHPExcel
 * @package    PHPExcel_Cell
 * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
 */
class PHPExcel_Cell_AdvancedValueBinder extends PHPExcel_Cell_DefaultValueBinder implements PHPExcel_Cell_IValueBinder
{
    
/**
     * Bind value to a cell
     *
     * @param  PHPExcel_Cell  $cell  Cell to bind value to
     * @param  mixed $value          Value to bind in cell
     * @return boolean
     */
    
public function bindValue(PHPExcel_Cell $cell$value null)
    {
        
// sanitize UTF-8 strings
        
if (is_string($value)) {
            
$value PHPExcel_Shared_String::SanitizeUTF8($value);
        }

        
// Find out data type
        
$dataType parent::dataTypeForValue($value);

        
// Style logic - strings
        
if ($dataType === PHPExcel_Cell_DataType::TYPE_STRING && !$value instanceof PHPExcel_RichText) {
            
//    Test for booleans using locale-setting
            
if ($value == PHPExcel_Calculation::getTRUE()) {
                
$cell->setValueExplicitTRUEPHPExcel_Cell_DataType::TYPE_BOOL);
                return 
true;
            } elseif(
$value == PHPExcel_Calculation::getFALSE()) {
                
$cell->setValueExplicitFALSEPHPExcel_Cell_DataType::TYPE_BOOL);
                return 
true;
            }

            
// Check for number in scientific format
            
if (preg_match('/^'.PHPExcel_Calculation::CALCULATION_REGEXP_NUMBER.'$/'$value)) {
                
$cell->setValueExplicit( (float) $valuePHPExcel_Cell_DataType::TYPE_NUMERIC);
                return 
true;
            }

            
// Check for fraction
            
if (preg_match('/^([+-]?)\s*([0-9]+)\s?\/\s*([0-9]+)$/'$value$matches)) {
                
// Convert value to number
                
$value $matches[2] / $matches[3];
                if (
$matches[1] == '-'$value $value;
                
$cell->setValueExplicit( (float) $valuePHPExcel_Cell_DataType::TYPE_NUMERIC);
                
// Set style
                
$cell->getWorksheet()->getStyle$cell->getCoordinate() )
                    ->
getNumberFormat()->setFormatCode'??/??' );
                return 
true;
            } elseif (
preg_match('/^([+-]?)([0-9]*) +([0-9]*)\s?\/\s*([0-9]*)$/'$value$matches)) {
                
// Convert value to number
                
$value $matches[2] + ($matches[3] / $matches[4]);
                if (
$matches[1] == '-'$value $value;
                
$cell->setValueExplicit( (float) $valuePHPExcel_Cell_DataType::TYPE_NUMERIC);
                
// Set style
                
$cell->getWorksheet()->getStyle$cell->getCoordinate() )
                    ->
getNumberFormat()->setFormatCode'# ??/??' );
                return 
true;
            }

            
// Check for percentage
            
if (preg_match('/^\-?[0-9]*\.?[0-9]*\s?\%$/'$value)) {
                
// Convert value to number
                
$value = (float) str_replace('%'''$value) / 100;
                
$cell->setValueExplicit$valuePHPExcel_Cell_DataType::TYPE_NUMERIC);
                
// Set style
                
$cell->getWorksheet()->getStyle$cell->getCoordinate() )
                    ->
getNumberFormat()->setFormatCodePHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00 );
                return 
true;
            }

            
// Check for currency
            
$currencyCode PHPExcel_Shared_String::getCurrencyCode();
            
$decimalSeparator PHPExcel_Shared_String::getDecimalSeparator();
            
$thousandsSeparator PHPExcel_Shared_String::getThousandsSeparator();
            if (
preg_match('/^'.preg_quote($currencyCode).' *(\d{1,3}('.preg_quote($thousandsSeparator).'\d{3})*|(\d+))('.preg_quote($decimalSeparator).'\d{2})?$/'$value)) {
                
// Convert value to number
                
$value = (float) trim(str_replace(array($currencyCode$thousandsSeparator$decimalSeparator), array('''''.'), $value));
                
$cell->setValueExplicit$valuePHPExcel_Cell_DataType::TYPE_NUMERIC);
                
// Set style
                
$cell->getWorksheet()->getStyle$cell->getCoordinate() )
                    ->
getNumberFormat()->setFormatCode(
                        
str_replace('$'$currencyCodePHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD_SIMPLE )
                    );
                return 
true;
            } elseif (
preg_match('/^\$ *(\d{1,3}(\,\d{3})*|(\d+))(\.\d{2})?$/'$value)) {
                
// Convert value to number
                
$value = (float) trim(str_replace(array('$',','), ''$value));
                
$cell->setValueExplicit$valuePHPExcel_Cell_DataType::TYPE_NUMERIC);
                
// Set style
                
$cell->getWorksheet()->getStyle$cell->getCoordinate() )
                    ->
getNumberFormat()->setFormatCodePHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD_SIMPLE );
                return 
true;
            }

            
// Check for time without seconds e.g. '9:45', '09:45'
            
if (preg_match('/^(\d|[0-1]\d|2[0-3]):[0-5]\d$/'$value)) {
                
// Convert value to number
                
list($h$m) = explode(':'$value);
                
$days $h 24 $m 1440;
                
$cell->setValueExplicit($daysPHPExcel_Cell_DataType::TYPE_NUMERIC);
                
// Set style
                
$cell->getWorksheet()->getStyle$cell->getCoordinate() )
                    ->
getNumberFormat()->setFormatCodePHPExcel_Style_NumberFormat::FORMAT_DATE_TIME3 );
                return 
true;
            }

            
// Check for time with seconds '9:45:59', '09:45:59'
            
if (preg_match('/^(\d|[0-1]\d|2[0-3]):[0-5]\d:[0-5]\d$/'$value)) {
                
// Convert value to number
                
list($h$m$s) = explode(':'$value);
                
$days $h 24 $m 1440 $s 86400;
                
// Convert value to number
                
$cell->setValueExplicit($daysPHPExcel_Cell_DataType::TYPE_NUMERIC);
                
// Set style
                
$cell->getWorksheet()->getStyle$cell->getCoordinate() )
                    ->
getNumberFormat()->setFormatCodePHPExcel_Style_NumberFormat::FORMAT_DATE_TIME4 );
                return 
true;
            }

            
// Check for datetime, e.g. '2008-12-31', '2008-12-31 15:59', '2008-12-31 15:59:10'
            
if (($d PHPExcel_Shared_Date::stringToExcel($value)) !== false) {
                
// Convert value to number
                
$cell->setValueExplicit($dPHPExcel_Cell_DataType::TYPE_NUMERIC);
                
// Determine style. Either there is a time part or not. Look for ':'
                
if (strpos($value':') !== false) {
                    
$formatCode 'yyyy-mm-dd h:mm';
                } else {
                    
$formatCode 'yyyy-mm-dd';
                }
                
$cell->getWorksheet()->getStyle$cell->getCoordinate() )
                    ->
getNumberFormat()->setFormatCode($formatCode);
                return 
true;
            }

            
// Check for newline character "\n"
            
if (strpos($value"\n") !== FALSE) {
                
$value PHPExcel_Shared_String::SanitizeUTF8($value);
                
$cell->setValueExplicit($valuePHPExcel_Cell_DataType::TYPE_STRING);
                
// Set style
                
$cell->getWorksheet()->getStyle$cell->getCoordinate() )
                    ->
getAlignment()->setWrapText(TRUE);
                return 
true;
            }
        }

        
// Not bound yet? Use parent...
        
return parent::bindValue($cell$value);
    }
}