PHPOffice /
PhpSpreadsheet
| @@ 160-177 (lines=18) @@ | ||
| 157 | * |
|
| 158 | * @return int The number of columns in cellAddress |
|
| 159 | */ |
|
| 160 | public static function COLUMNS($cellAddress = null) |
|
| 161 | { |
|
| 162 | if (is_null($cellAddress) || $cellAddress === '') { |
|
| 163 | return 1; |
|
| 164 | } elseif (!is_array($cellAddress)) { |
|
| 165 | return Functions::VALUE(); |
|
| 166 | } |
|
| 167 | ||
| 168 | reset($cellAddress); |
|
| 169 | $isMatrix = (is_numeric(key($cellAddress))); |
|
| 170 | list($columns, $rows) = Calculation::_getMatrixDimensions($cellAddress); |
|
| 171 | ||
| 172 | if ($isMatrix) { |
|
| 173 | return $rows; |
|
| 174 | } |
|
| 175 | ||
| 176 | return $columns; |
|
| 177 | } |
|
| 178 | ||
| 179 | /** |
|
| 180 | * ROW. |
|
| @@ 241-258 (lines=18) @@ | ||
| 238 | * |
|
| 239 | * @return int The number of rows in cellAddress |
|
| 240 | */ |
|
| 241 | public static function ROWS($cellAddress = null) |
|
| 242 | { |
|
| 243 | if (is_null($cellAddress) || $cellAddress === '') { |
|
| 244 | return 1; |
|
| 245 | } elseif (!is_array($cellAddress)) { |
|
| 246 | return Functions::VALUE(); |
|
| 247 | } |
|
| 248 | ||
| 249 | reset($cellAddress); |
|
| 250 | $isMatrix = (is_numeric(key($cellAddress))); |
|
| 251 | list($columns, $rows) = Calculation::_getMatrixDimensions($cellAddress); |
|
| 252 | ||
| 253 | if ($isMatrix) { |
|
| 254 | return $columns; |
|
| 255 | } |
|
| 256 | ||
| 257 | return $rows; |
|
| 258 | } |
|
| 259 | ||
| 260 | /** |
|
| 261 | * HYPERLINK. |
|
