Online PHP editor | rfc for 679Dp

@ 2023-12-21T05:09:26Z

<?php

function letterToColumnNumber(string $letters, int $indexStart = 0): int
{
    static $ordA = ord('A');
    $length = strlen($letters);
    $number = 0;
    $pow = 1;
    
    for ($i = $length - 1; $i >= 0; $i--) {
        // calculate the value of each letter and add to the total
        $number += (ord($letters[$i]) - $ordA + 1) * $pow;
        $pow *= 26;
    }

    return $number - (1 - $indexStart);
}

function rangeStringToRangeArray(string $range, int $indexStart = 0): array
{
    // Parse Excel range expression
    if (sscanf($range, '%[A-Z]%d:%[A-Z]%d', $startCol, $startRow, $endCol, $endRow) != 4) {
        throw new Exception('Invalid range expression');
    }

    return [
        [
            letterToColumnNumber($startCol, $indexStart),
            $startRow - (1 - $indexStart)
        ],
        [
            letterToColumnNumber($endCol, $indexStart),
            $endRow - (1 - $indexStart)
        ]
    ];
}

echo json_encode(rangeStringToRangeArray('A1:B2')); // returns [[0,0],[1,1]]
echo json_encode(rangeStringToRangeArray('A1:B2', 1)); // returns [[1,1],[2,2]]

Output for git.master_jit, git.master, rfc.property-hooks: [[0,0],[1,1]][[1,1],[2,2]]

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

2020-03-21 RFC: Is_Literal - declined
2020-12-04 Enumerations - included in PHP 8.1
2018-06-15 Typed Properties v2 - implemented in PHP 7.4
2016-08-12 Object typehint - included in PHP 7.2
2016-08-14 Arrow functions - withdrawn
2016-05-29 array_change_keys() - withdrawn
2016-04-19 Lexical scope support for anonymous classes - suspended
2016-04-17 Functional Interfaces - declined
2016-03-16 Typed Properties - superseded in favor of Typed Properties 2.0
2015-08-27 Callable Prototypes - declined
2015-05-01 Short Closures - declined / withdrawn in favor of Arrow Functions
2015-02-18 Scalar type hints v5 - included in PHP 7
2015-02-14 Union Types - declined
2013-09-22 Anonymous classes - included in PHP 7

preferences:dark modelive previewkey bindings