PHPOffice /
PhpSpreadsheet
| @@ 83-92 (lines=10) @@ | ||
| 80 | * |
|
| 81 | * @return int |
|
| 82 | */ |
|
| 83 | public static function cellSort($a, $b) |
|
| 84 | { |
|
| 85 | sscanf($a, '%[A-Z]%d', $ac, $ar); |
|
| 86 | sscanf($b, '%[A-Z]%d', $bc, $br); |
|
| 87 | ||
| 88 | if ($ar == $br) { |
|
| 89 | return strcasecmp(strlen($ac) . $ac, strlen($bc) . $bc); |
|
| 90 | } |
|
| 91 | ||
| 92 | return ($ar < $br) ? -1 : 1; |
|
| 93 | } |
|
| 94 | ||
| 95 | /** |
|
| @@ 104-113 (lines=10) @@ | ||
| 101 | * |
|
| 102 | * @return int |
|
| 103 | */ |
|
| 104 | public static function cellReverseSort($a, $b) |
|
| 105 | { |
|
| 106 | sscanf($a, '%[A-Z]%d', $ac, $ar); |
|
| 107 | sscanf($b, '%[A-Z]%d', $bc, $br); |
|
| 108 | ||
| 109 | if ($ar == $br) { |
|
| 110 | return 1 - strcasecmp(strlen($ac) . $ac, strlen($bc) . $bc); |
|
| 111 | } |
|
| 112 | ||
| 113 | return ($ar < $br) ? 1 : -1; |
|
| 114 | } |
|
| 115 | ||
| 116 | /** |
|
