Displaying page
of
pages;
Items to
|
Title |
Test
Details
Excel A1 reference style
|
|
Expression |
^\$?(?(?=[0-9])[0-9]{1,5}:\$?[0-9]{1,5}|[A-Za-z]{1,2}(?(?=:):\$?[A-Za-z]{1,2}|(?(?!(\$?[0-9])):/$[A-Za-z]{1,2}|\$?[0-9]{1,5})(?(?=:):\$?[A-Za-z]{1,2}\$?[0-9]{1,5}|.)))
|
|
Description |
Matches Excel's A1 reference style. Single Cell, absolute, reletive, mixed, whole row, whole column. Validates it all.
|
|
Matches |
A10 | A10:A20 | $B$15:E15 | 5:5 | 5:10 | H:H | H:J | $A$10:$A$20
|
|
Non-Matches |
55 | C: | $HHH:555555 | $C:55
|
|
Author |
Rating:
Not yet rated.
Mike Sportsman
|
Displaying page
of
pages;
Items to
