JSFiddle - React, Tailwind, and code Playground

by pierian_design

JavaScript

/*
var aRanges = [

  [
    [51,67],
    [52,68],
    [53,69]
  ],
  
  [
  	[7,47],
    [7,47],
    [7,47]
  ],
  
  [
  	[7,47],
    [7,47],
    [7,47]
  ]

]
*/

var oActiveRangesInfo = {
	"aFirstColumns":[10,3,7],
  "aFirstRows":[11,10,9],
  "aLastColumns":[11,4,8],
  "aLastRows":[13,12,11],
  "aRows":[
  	{"indexRow":11,"startColumn":10,"endColumn":11,"includeRange":"J11:K13","offsetRow":2,"offsetColumn":7},
    {"indexRow":12,"startColumn":10,"endColumn":11,"includeRange":"J11:K13","offsetRow":3,"offsetColumn":7},
    {"indexRow":13,"startColumn":10,"endColumn":11,"includeRange":"J11:K13","offsetRow":4,"offsetColumn":7},
    {"indexRow":10,"startColumn":3,"endColumn":4,"includeRange":"C10:D12","offsetRow":1,"offsetColumn":0},
    {"indexRow":11,"startColumn":3,"endColumn":4,"includeRange":"C10:D12","offsetRow":2,"offsetColumn":0},
    {"indexRow":12,"startColumn":3,"endColumn":4,"includeRange":"C10:D12","offsetRow":3,"offsetColumn":0},
    {"indexRow":9,"startColumn":7,"endColumn":8,"includeRange":"G9:H11","offsetRow":0,"offsetColumn":4},
    {"indexRow":10,"startColumn":7,"endColumn":8,"includeRange":"G9:H11","offsetRow":1,"offsetColumn":4},
    {"indexRow":11,"startColumn":7,"endColumn":8,"includeRange":"G9:H11","offsetRow":2,"offsetColumn":4}
  ],
  "aColumns":[
  	{"indexColumn":10,"startRow":11,"endRow":13,"includeRange":"J11:K13","offsetColumn":7,"offsetRow":2},
    {"indexColumn":11,"startRow":11,"endRow":13,"includeRange":"J11:K13","offsetColumn":8,"offsetRow":2},
    {"indexColumn":3,"startRow":10,"endRow":12,"includeRange":"C10:D12","offsetColumn":0,"offsetRow":1},
    {"indexColumn":4,"startRow":10,"endRow":12,"includeRange":"C10:D12","offsetColumn":1,"offsetRow":1},
    {"indexColumn":7,"startRow":9,"endRow":11,"includeRange":"G9:H11","offsetColumn":4,"offsetRow":0},
    {"indexColumn":8,"startRow":9,"endRow":11,"includeRange":"G9:H11","offsetColumn":5,"offsetRow":0}
  ],
  "aRanges":[
  	{"a1Notation": "J11:K13", "offsetRow": 2, "offsetColumn":...