A1ConversionToR1C1Relative.php 949 B

12345678910111213141516171819202122232425262728293031323334
  1. <?php
  2. return [
  3. ['R[2]C[2]', 'O18', 16, 13],
  4. ['R18C15', '$O$18', 16, 13],
  5. ['R[-2]C[2]', 'O14', 16, 13],
  6. ['R[-2]C15', '$O14', 16, 13],
  7. ['R[2]C[-2]', 'K18', 16, 13],
  8. ['R18C[-2]', 'K$18', 16, 13],
  9. ['R[-2]C[-2]', 'K14', 16, 13],
  10. ['RC[3]', 'P16', 16, 13],
  11. ['R16C[3]', 'P$16', 16, 13],
  12. ['RC[-3]', 'J16', 16, 13],
  13. ['RC10', '$J16', 16, 13],
  14. ['R[4]C', 'M20', 16, 13],
  15. ['R[4]C13', '$M20', 16, 13],
  16. ['R[-4]C', 'M12', 16, 13],
  17. ['R12C', 'M$12', 16, 13],
  18. ['RC', 'E5', 5, 5],
  19. ['R5C5', '$E$5', 5, 5],
  20. ['R5C', 'E5', null, 5],
  21. ['R5C5', '$E5', null, 5],
  22. ['R5C', 'E$5', null, 5],
  23. ['RC5', 'E5', 5, null],
  24. ['RC5', '$E5', 5, null],
  25. ['R5C5', 'E$5', 5, null],
  26. ['R5C[2]', 'E5', null, 3],
  27. ['R5C5', '$E5', null, 3],
  28. ['R5C[2]', 'E$5', null, 3],
  29. ['R[2]C5', 'E5', 3, null],
  30. ['R5C5', '$E$5', 3, null],
  31. ['R5C[-2]', 'E5', null, 7],
  32. ['R[-2]C5', 'E5', 7, null],
  33. ];