nfTlWNl rn Ѻq$³*%yNk9S[H}$Λ@?7 ~ CѶͫ\]*uQlf Ȥ3 CˍLXlߙ-5E1WÎ\`Lٔ*ܝIc3ٿ ZmW6_|mB%:4X4΅_#1Iķխ}`^6[Չ1,_NgEֵ."4?8#z޾!o+loN33r%tۣu}sk. 07~P7XLgbM r0` peĒ }H}뫭j2-}|R~7׾y2w^%UQ}tүrF ҙ嬇//jV+>;KGj}3Maz5U7dMI-s_9gKXD׻aX8"5X X?pM\")@HM ޑZ= `Hls2bJUN%-;+oj=?`JL̡SW5þE9UVCWDZjL5V=j)Bs,%ڗg;BJ bͶϞo$;KW 5~a&IV+Qt9t5ߟS{vƝ Eୃ zn1i00&VxU|JJE5n[%gK{U &pN0Apݺ>)>\{rFvF% )&끻)1g`@3 % ZWVG@.b'Uᩘ̯j%!lvܢQwY3>Mq4֓Id]N"] "֮}$k{C[fY+ 8)cLuXD'98 G˳F4m˥ݩ: )(\zTŸC'#)F ɘz"m=q]j`iA6٫4q92Sz>Q.+ =OMJg$q weeCDɯf,qЮV5cs{g' UN2X[16еWRʗΊx=.Yo`Q6`X鍿"OHߦILV;@l2DQ՜Sp(/SqjK>QUH H f$8dB,ӡ裧{=EMd$ n]S*˲I#1Srr3jwj 5YN*'T3p=Zǯ#!] G01œͬ K\ڲziЏbä1G|c ˍ?Laрf^}O`9ƌa 8jTN/`m/ ,߿?9֪zqC@V[4$Ig Tޛ"IZD5YN*'T3'1Y0lb3#;ssP|(ZYGMָfCCieSkw3G˺Sy wv]XL4'nU#Gtq"3yA{~ d3_6xE\A RF7W%Pp@>@P,ʀMjfz^[:,r"gKF yesơEaSGj$LKx9>v8\X8sL{ 45Km_BɳEItX6]}|ZbÄџ$LKx9>v8@(? u#m_xmB<"O8o({xaz/4[6t,i/q"Z:NcT Jbч įy ƒ*uy5ƶ+%?E!QM2Kfc)6+l+LgʾSZ0Pʵץ~j*uh:E,N_cUCm~ K!I2qU5X~Ne$ony+"|ͼnrrAUx #U=A _LA;qp؉q9֪zqC@ٹHw5vL@k %42.>1*vޖ>dhL~d;OdZWEw9(=+G-霫0t||/A~:̨m%} +hv= 1-F\`Xo^/ ĢQ$3 ĢQ$31* qtJh T_@XE(w1ﾣSd8\h/sbɾ0h3am OShZgCzn=smW&2i8d'\Ofv#%95ū{WGֆs'~ \ !c|כ z޾!o+lo/(KD۔QK5'H<ţ@=/翥.?6?҉"zKv%/:@ؑ,0ةvHz4Lk+g {oay$!}i}E…m$ cG|c ˍ?LaрgetRow() : 1; } /** * ROW. * * Returns the row number of the given cell reference * If the cell reference is a range of cells, ROW returns the row numbers of each row in the reference * as a vertical array. * If cell reference is omitted, and the function is being called through the calculation engine, * then it is assumed to be the reference of the cell in which the ROW function appears; * otherwise this function returns 1. * * Excel Function: * =ROW([cellAddress]) * * @param null|array|string $cellAddress A reference to a range of cells for which you want the row numbers * * @return int|mixed[]|string */ public static function ROW($cellAddress = null, ?Cell $cell = null) { if (self::cellAddressNullOrWhitespace($cellAddress)) { return self::cellRow($cell); } if (is_array($cellAddress)) { foreach ($cellAddress as $rowKey => $rowValue) { foreach ($rowValue as $columnKey => $cellValue) { return (int) preg_replace('/\D/', '', $rowKey); } } return self::cellRow($cell); } $cellAddress = $cellAddress ?? ''; if ($cell !== null) { [,, $sheetName] = Helpers::extractWorksheet($cellAddress, $cell); [,, $cellAddress] = Helpers::extractCellAddresses($cellAddress, true, $cell->getWorksheet(), $sheetName); } [, $cellAddress] = Worksheet::extractSheetTitle($cellAddress, true); if (strpos($cellAddress, ':') !== false) { [$startAddress, $endAddress] = explode(':', $cellAddress); $startAddress = (string) preg_replace('/\D/', '', $startAddress); $endAddress = (string) preg_replace('/\D/', '', $endAddress); return array_map( function ($value) { return [$value]; }, range($startAddress, $endAddress) ); } [$cellAddress] = explode(':', $cellAddress); return (int) preg_replace('/\D/', '', $cellAddress); } /** * ROWS. * * Returns the number of rows in an array or reference. * * Excel Function: * =ROWS(cellAddress) * * @param null|array|string $cellAddress An array or array formula, or a reference to a range of cells * for which you want the number of rows * * @return int|string The number of rows in cellAddress, or a string if arguments are invalid */ public static function ROWS($cellAddress = null) { if (self::cellAddressNullOrWhitespace($cellAddress)) { return 1; } if (!is_array($cellAddress)) { return ExcelError::VALUE(); } reset($cellAddress); $isMatrix = (is_numeric(key($cellAddress))); [$columns, $rows] = Calculation::getMatrixDimensions($cellAddress); if ($isMatrix) { return $columns; } return $rows; } }