reginaldojunior /
winners
| @@ 1197-1212 (lines=16) @@ | ||
| 1194 | * @param mixed $arg,... Data values |
|
| 1195 | * @return int |
|
| 1196 | */ |
|
| 1197 | public static function COUNTA() { |
|
| 1198 | // Return value |
|
| 1199 | $returnValue = 0; |
|
| 1200 | ||
| 1201 | // Loop through arguments |
|
| 1202 | $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args()); |
|
| 1203 | foreach ($aArgs as $arg) { |
|
| 1204 | // Is it a numeric, boolean or string value? |
|
| 1205 | if ((is_numeric($arg)) || (is_bool($arg)) || ((is_string($arg) && ($arg != '')))) { |
|
| 1206 | ++$returnValue; |
|
| 1207 | } |
|
| 1208 | } |
|
| 1209 | ||
| 1210 | // Return |
|
| 1211 | return $returnValue; |
|
| 1212 | } // function COUNTA() |
|
| 1213 | ||
| 1214 | ||
| 1215 | /** |
|
| @@ 1228-1243 (lines=16) @@ | ||
| 1225 | * @param mixed $arg,... Data values |
|
| 1226 | * @return int |
|
| 1227 | */ |
|
| 1228 | public static function COUNTBLANK() { |
|
| 1229 | // Return value |
|
| 1230 | $returnValue = 0; |
|
| 1231 | ||
| 1232 | // Loop through arguments |
|
| 1233 | $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args()); |
|
| 1234 | foreach ($aArgs as $arg) { |
|
| 1235 | // Is it a blank cell? |
|
| 1236 | if ((is_null($arg)) || ((is_string($arg)) && ($arg == ''))) { |
|
| 1237 | ++$returnValue; |
|
| 1238 | } |
|
| 1239 | } |
|
| 1240 | ||
| 1241 | // Return |
|
| 1242 | return $returnValue; |
|
| 1243 | } // function COUNTBLANK() |
|
| 1244 | ||
| 1245 | ||
| 1246 | /** |
|
