JSFiddle - React, Tailwind, and code Playground

by pierian_design

JavaScript

var oActiveRangesInfo = {
  "aRows":[
  	{"rowIndex":21,"startCol":3,"endCol":4,"includeRange":"C21:D23","offsetRow":0,"offsetCol":0},
    {"rowIndex":21,"startCol":6,"endCol":6,"includeRange":"F21:F23","offsetRow":0,"offsetCol":3},
    {"rowIndex":22,"startCol":3,"endCol":4,"includeRange":"C21:D23","offsetRow":1,"offsetCol":0},
    {"rowIndex":22,"startCol":6,"endCol":6,"includeRange":"F21:F23","offsetRow":1,"offsetCol":3},
    {"rowIndex":22,"startCol":7,"endCol":7,"includeRange":"G22:G25","offsetRow":1,"offsetCol":4},
    {"rowIndex":23,"startCol":3,"endCol":4,"includeRange":"C21:D23","offsetRow":2,"offsetCol":0},
    {"rowIndex":23,"startCol":6,"endCol":6,"includeRange":"F21:F23","offsetRow":2,"offsetCol":3},
    {"rowIndex":23,"startCol":7,"endCol":7,"includeRange":"G22:G25","offsetRow":2,"offsetCol":4},
    {"rowIndex":24,"startCol":7,"endCol":7,"includeRange":"G22:G25","offsetRow":3,"offsetCol":4},
    {"rowIndex":25,"startCol":7,"endCol":7,"includeRange":"G22:G25","offsetRow":4,"offsetCol":4},
    {"rowIndex":26,"startCol":4,"endCol":5,"includeRange":"D26:E26","offsetRow":5,"offsetCol":1}
	],
	"aColumns":[
		{"colIndex":3,"startRow":21,"endRow":23,"includeRange":"C21:D23","offsetCol":0,"offsetRow":0},
    {"colIndex":4,"startRow":21,"endRow":23,"includeRange":"C21:D23","offsetCol":1,"offsetRow":0},
    {"colIndex":6,"startRow":21,"endRow":23,"includeRange":"F21:F23","offsetCol":3,"offsetRow":0},
    {"colIndex":7,"startRow":22,"endRow":25,"includeRange":"G22:G25","offsetCol":4,"offsetRow":1},
    {"colIndex":4,"startRow":26,"endRow":26,"includeRange":"D26:E26","offsetCol":1,"offsetRow":5},
    {"colIndex":5,"startRow":26,"endRow":26,"includeRange":"D26:E26","offsetCol":2,"offsetRow":5}
  ],
  "aRanges":["C21:D23","F21:F23","G22:G25","D26:E26"],
	"aFirstColumns":[3,4,6,7],
  "aFirstRows":[21,22,26],
  "aLastColumns":[4,6,7,5],
  "aLastRows":[23,23,25,26]  
}


var aDataValues = [
  ["no skip", "skip", null, "6", null ],
  ["no skip", "skip", null, "6", ...