formatjson={"root":"CategoryList001",
 "CategoryList001":
    {
	 "SheetId":"CategoryList001",
     "SheetName":"CategoryList001",
     "CategoryList.Category":
        {//"Category001":"General",
         "Category002":"Number",
         "Category003":"Currency",
         "Category004":"Accounting",
         "Category005":"Date",
         "Category006":"Time",
         "Category007":"Percentage",
		 "Category008":"Fraction",
		 "Category009":"Scientific",
         "Category010":"Text",
		 "Category011":"Boolean",
		// "Category012":"Custom",
		 //patch for backward compatibility
		 "String":"String",
		 "Number":"Number",
		 "Date":"Date",
		 "Boolean":"Boolean"}},
 //patch for backward compatibility
 "String":
    {"SheetId":"String",
     "SheetName":"String",
     "categoryName":"String",
	 "Description":"",
     "isDecimal":"0",
     "isCommaSeperator":"0",
	 "isVisible":"0",
     "isSymbol":"0"},
"Number":
    {"SheetId":"Number",
     "SheetName":"Number",
     "categoryName":"Number",
	 "Description":"",
     "isDecimal":"0",
     "isCommaSeperator":"0",
	 "isVisible":"0",
     "isSymbol":"0"},
"Date":
    {"SheetId":"Date",
     "SheetName":"Date",
     "categoryName":"Date",
	 "Description":"",
     "isDecimal":"0",
     "isCommaSeperator":"0",
	 "isVisible":"0",
     "isSymbol":"0"},
"Boolean":
    {"SheetId":"Boolean",
     "SheetName":"Boolean",
     "categoryName":"Boolean",
	 "Description":"",
     "isDecimal":"0",
     "isCommaSeperator":"0",
	 "isVisible":"0",
     "isSymbol":"0"},
//Block ends
 "Category001":
    {"SheetId":"Category001",
     "SheetName":"General",
     "categoryName":"General",
	 "Description":"General format cellshave no specific number format.",
     "isDecimal":"0",
     "isCommaSeperator":"0",
	 "isVisible":"1",
     "isSymbol":"0"},
 "Category002":
    {"SheetId":"Category002",
     "SheetName":"Number",
     "categoryName":"Number",
	 "Description":"Number is used for general display of numbers. Currency and Accounting specilized formatting for moneytary value.",
	 "isDecimal":"1",
     "isCommaSeperator":"1",
	 "isVisible":"1",
     "isSymbol":"0"},
 "Category003":
    {"SheetId":"Category003",
     "SheetName":"Currency",
     "categoryName":"Currency",
     "isDecimal":"1",
	 "Description":"Currency formats are used for general moneytary values. Use Accounting formats to allign decimal points in a column.",
     "isCommaSeperator":"1",
	 "isVisible":"1",
     "isSymbol":"1"},
 "Category004":
    {"SheetId":"Category004",
     "SheetName":"Accounting",
     "categoryName":"Accounting",
     "isDecimal":"1",
		"Description":"Accounting formats line up the currency symbols and decimal points in a column.",
     "isCommaSeperator":"0",
	 "isVisible":"1",
     "isSymbol":"1"},
 "Category005":
    {"SheetId":"Category005",
     "SheetName":"Date",
     "categoryName":"Date",
	 "Description":"Date formats display date and time serial numbers as date values.",
     "Category.Format":
        {
         "Format009":"Format009",
         "Format010":"Format010",
		 "Format014":"Format014",
		 "Format015":"Format015",
		 "Format019":"Format019",
		 "Format020":"Format020",
		 "Format021":"Format021",
		 "Format023":"Format023",
		 "Format024":"Format024",
		 "Format025":"Format025",
		 "Format026":"Format026",
		 "Format027":"Format027"
	 },
	 "isDecimal":"0",
     "isCommaSeperator":"0",
     "isSymbol":"0",
	 "isVisible":"1",
     "locale":"1"},
 "Category006":
    {"SheetId":"Category006",
     "SheetName":"Time",
     "categoryName":"Time",
	 "Description":"Date formats display date and time serial numbers as date values. ",
     "Category.Format":
        {
        "Format013":"Format013",
        "Format030":"Format030",
         "Format031":"Format031"
        },"isDecimal":"0",
     "isCommaSeperator":"0",
     "isSymbol":"0",
	 "isVisible":"1",
     "locale":"1"},
 "Category007":
    {"SheetId":"Category007",
     "SheetName":"Percentage",
     "categoryName":"Percentage",
	 "Description":"Percentage formats multiply the cell value by 100 and displays the result with a percent symbol. ",
    "isDecimal":"1",
     "isCommaSeperator":"0",
     "isSymbol":"0",
	 "isVisible":"0",
     "locale":"0"},
 "Category008":
    {"SheetId":"Category008",
     "SheetName":"Fraction",
     "categoryName":"Fraction",
	 "Description":"",
    "isDecimal":"0",
     "isCommaSeperator":"0",
     "isSymbol":"0",
	 "isVisible":"0",
     "locale":"0"},
 "Category009":
    {"SheetId":"Category009",
     "SheetName":"Scientific",
     "categoryName":"Scientific",
	 "Description":" ",
    "isDecimal":"1",
     "isCommaSeperator":"0",
     "isSymbol":"0",
	 "isVisible":"0",
     "locale":"0"},
 "Category010":
    {"SheetId":"Category010",
     "SheetName":"Text",
     "categoryName":"Text",
	 "Description":"Text format cells are treated as text even when a number is in the cell.The cell is displayed exactly as entered. ",
     "isDecimal":"0",
     "isCommaSeperator":"0",
     "isSymbol":"0",
	 "isVisible":"1",
     "locale":"0",
     "Category.Format":
     	{"Format032":"Format032"}
     },

"Category011":
    {"SheetId":"Category011",
     "SheetName":"Boolean",
     "categoryName":"Boolean",
	 "Description":"Boolean Value",
     "isDecimal":"0",
     "isCommaSeperator":"0",
     "isSymbol":"0",
	 "isVisible":"1",
     "locale":"0",
     "Category.Format":
        {"Format028":"Format028",
         "Format029":"Format029"}
     },

"Category012":
    {"SheetId":"Category012",
     "SheetName":"Custom",
     "categoryName":"Custom",
	 "Description":"Custom Format",
     "isDecimal":"0",
     "isCommaSeperator":"0",
     "isSymbol":"0",
	 "isVisible":"1",
     "locale":"0"},
 "Format001":
    {"SheetId":"Format001",
     "SheetName":"Format001",
     "DisplayText":"-1234",
	 "formatStr":"###0",
     "Category":
        {"Category002":"Number"}},
 "Format002":
    {"SheetId":"Format002",
     "SheetName":"Format002",
     "DisplayText":"1234",
	  "formatStr":"###0",
     "Category":
        {"Category002":"Number"}},
 "Format003":
    {"SheetId":"Format003",
     "SheetName":"Format003",
     "DisplayText":"1234",
	  "formatStr":"###0",
     "Category":
        {"Category002":"Number"},
     "Color":"red"},
 "Format004":
    {"SheetId":"Format004",
     "SheetName":"Format004",
     "DisplayText":"-1234",
	  "formatStr":"###0",
     "Category":
        {"Category002":"Number"},
     "Color":"red"},
 "Format005":
    {"SheetId":"Format005",
     "SheetName":"Format005",
     "DisplayText":"-1234",
	  "formatStr":"###0",
     "Category":
        {"Category003":"Currency"}},
 "Format006":
    {"SheetId":"Format006",
     "SheetName":"Format006",
     "DisplayText":"1234",
	  "formatStr":"###0",
     "Category":
        {"Category003":"Currency"}},
 "Format007":
    {"SheetId":"Format007",
     "SheetName":"Format007",
     "DisplayText":"1234",
	  "formatStr":"###0",
     "Category":
        {"Category003":"Currency"},
     "Color":"red"},
 "Format008":
    {"SheetId":"Format008",
     "SheetName":"Format008",
     "DisplayText":"-1234",
	  "formatStr":"###0",
     "Category":
        {"Category003":"Currency"},
     "Color":"red"},
"Format009":
    {"SheetId":"Format009",
     "SheetName":"Format009",
     "DisplayText":"01/24/2009",
	  "formatStr":"MM/dd/yyyy",
     "Category":
        {"Category005":"Date"}
      },
"Format010":
    {"SheetId":"Format010",
     "SheetName":"Format010",
     "DisplayText":"01/24/09",
	  "formatStr":"MM/dd/yy",
     "Category":
        {"Category005":"Date"}
      },
"Format011":
    {"SheetId":"Format011",
     "SheetName":"Format011",
     "DisplayText":"1/24/2009",
	  "formatStr":"M/d/yyyy",
     "Category":
        {"Category005":"Date"}
      },
"Format012":
    {"SheetId":"Format012",
     "SheetName":"Format012",
     "DisplayText":"1/24/09",
	  "formatStr":"M/d/yy",
     "Category":
        {"Category005":"Date"}
      },
"Format013":
    {"SheetId":"Format013",
     "SheetName":"Format013",
     "DisplayText":"1:30:55am",
	  "formatStr":"h:m:sa",
     "Category":
        {"Category006":"Time"}
      },
"Format014":
  {"SheetId":"Format014",
   "SheetName":"Format014",
   "DisplayText":"24/04/2009",
  "formatStr":"dd/MM/yyyy",
   "Category":
      {"Category005":"Date"}
},
"Format015":
  {"SheetId":"Format015",
   "SheetName":"Format015",
   "DisplayText":"24/04/09",
  "formatStr":"dd/MM/yy",
   "Category":
      {"Category005":"Date"}
},
"Format016":
  {"SheetId":"Format016",
   "SheetName":"Format016",
   "DisplayText":"4/4/2009",
  "formatStr":"d/M/yyyy",
   "Category":
      {"Category005":"Date"}
},
"Format017":
  {"SheetId":"Format017",
   "SheetName":"Format017",
   "DisplayText":"4/4/09",
  "formatStr":"d/M/yy",
   "Category":
      {"Category005":"Date"}
},
"Format019":
  {"SheetId":"Format019",
   "SheetName":"Format019",
   "DisplayText":"24-Apr-2009",
  "formatStr":"dd-MMM-yyyy",
   "Category":
      {"Category005":"Date"}
},
"Format020":
  {"SheetId":"Format020",
   "SheetName":"Format020",
   "DisplayText":"01-Jan-2010 14:35",
  "formatStr":"dd-MMM-yyyy HH:mm",
   "Category":
      {"Category005":"Date"}
},
"Format021":
  {"SheetId":"Format021",
   "SheetName":"Format021",
   "DisplayText":"23/01/2010 14:35",
  "formatStr":"dd/MM/yyyy HH:mm",
   "Category":
      {"Category005":"Date"}
},

"Format023":
  {"SheetId":"Format023",
   "SheetName":"Format023",
   "DisplayText":"23/01/2010 2:35PM",
  "formatStr":"dd/MM/yyyy hh:mma",
   "Category":
      {"Category005":"Date"}
},
"Format024":
  {"SheetId":"Format024",
   "SheetName":"Format024",
   "DisplayText":"01-Jan-2010 14:35",
  "formatStr":"dd-MMM-yyyy HH:mm",
   "Category":
      {"Category005":"Date"}
},
"Format025":
  {"SheetId":"Format025",
   "SheetName":"Format025",
   "DisplayText":"01-Jan-2010 2:35PM",
  "formatStr":"dd-MMM-yyyy hh:mma",
   "Category":
      {"Category005":"Date"}
},
"Format026":
  {"SheetId":"Format026",
   "SheetName":"Format026",
   "DisplayText":"01/23/2010 10:12AM",
  "formatStr":"MM/dd/yyyy hh:mma",
   "Category":
      {"Category005":"Date"}
},
"Format027":
  {"SheetId":"Format027",
   "SheetName":"Format027",
   "DisplayText":"01/23/2010 20:12",
  "formatStr":"MM/dd/yyyy HH:mm",
   "Category":
      {"Category005":"Date"}
},
"Format028":
  {"SheetId":"Format028",
   "SheetName":"Format028",
   "DisplayText":"Yes/No",
  "formatStr":"Yes/No",
   "Category":
      {"Category011":"Boolean"}
},
"Format029":
  {"SheetId":"Format029",
   "SheetName":"Format029",
   "DisplayText":"True/False",
  "formatStr":"True/False",
   "Category":
      {"Category011":"Boolean"}
},
"Format030":
  {"SheetId":"Format030",
   "SheetName":"Format030",
   "DisplayText":"13:30:55",
	"formatStr":"HH:m:ss",
    "Category":
        {"Category006":"Time"}
      },

"Format031":
  {"SheetId":"Format031",
   "SheetName":"Format031",
  "DisplayText":"01:30:55PM",
	  "formatStr":"hh:m:ssa",
     "Category":
        {"Category006":"Time"}
      },
"Format032":
	  {
		"SheetId":"Format032",
		"SheetName":"Format032",
		"DisplayText":"Password",
		"formatStr":"Password",
		"Category":
		{"Category010":"Text"}
	}
}