CellMergeRangesInCollection.php 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. <?php
  2. return [
  3. [
  4. [
  5. 'A1:A3' => 'x',
  6. 'A4' => 'y',
  7. ],
  8. [
  9. 'A1' => 'x',
  10. 'A2' => 'x',
  11. 'A3' => 'x',
  12. 'A4' => 'y',
  13. ],
  14. ],
  15. [
  16. [
  17. 'A1:A4' => 'x',
  18. 'A6:A7' => 'x',
  19. 'A9' => 'x',
  20. ],
  21. [
  22. 'A7' => 'x',
  23. 'A1' => 'x',
  24. 'A4' => 'x',
  25. 'A6' => 'x',
  26. 'A2' => 'x',
  27. 'A9' => 'x',
  28. 'A3' => 'x',
  29. ],
  30. ],
  31. [
  32. [
  33. 'A1:A3' => 'x',
  34. 'B1:B3' => 'x',
  35. ],
  36. [
  37. 'A1' => 'x',
  38. 'B3' => 'x',
  39. 'A2' => 'x',
  40. 'B2' => 'x',
  41. 'A3' => 'x',
  42. 'B1' => 'x',
  43. ],
  44. ],
  45. [
  46. [
  47. 'A1' => 'x',
  48. 'A2' => 'y',
  49. 'A3' => 'z',
  50. ],
  51. [
  52. 'A1' => 'x',
  53. 'A2' => 'y',
  54. 'A3' => 'z',
  55. ],
  56. ],
  57. [
  58. [
  59. 'C1' => 'x',
  60. 'A1:A3' => 'x',
  61. 'A1:A3,C1:C3' => 'y',
  62. ],
  63. [
  64. 'C1' => 'x',
  65. 'A1:A3' => 'x',
  66. 'A1:A3,C1:C3' => 'y',
  67. ],
  68. ],
  69. ];