sheetDataVerification.js 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580
  1. window.sheetDataVerification = {
  2. "name": "Data Verification",
  3. "index": "Sheet_pdolzzie5xwi_1600927444446",
  4. "celldata": [{"r":0,"c":0,"v":{"ct":{"fa":"General","t":"g"},"m":"Drop Down List","v":"Drop Down List","bl":1}},{"r":0,"c":1,"v":{"m":"Checkbox","ct":{"fa":"General","t":"g"},"v":"Checkbox","bl":1}},{"r":0,"c":2,"v":{"ct":{"fa":"General","t":"g"},"v":"Number between 1-10","bl":1,"m":"Number between 1-10"}},{"r":0,"c":3,"v":{"m":"Text content include Luckysheet","ct":{"fa":"General","t":"g"},"v":"Text content include Luckysheet","bl":1}},{"r":0,"c":4,"v":{"ct":{"fa":"General","t":"g"},"v":"Text length between 1-5","m":"Text length between 1-5","bl":1}},{"r":0,"c":5,"v":{"m":"Date","ct":{"fa":"General","t":"g"},"v":"Date","bl":1}},{"r":0,"c":6,"v":{"m":"Identification Number","ct":{"fa":"General","t":"g"},"v":"Identification Number","bl":1}},{"r":0,"c":7,"v":{"m":"Phone Number","ct":{"fa":"General","t":"g"},"v":"Phone Number","bl":1}},{"r":1,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"Fix","m":"Fix"}},{"r":1,"c":1,"v":{"m":"Fail","ct":{"fa":"General","t":"g"},"v":"Fail"}},{"r":1,"c":2,"v":{"v":1,"ct":{"fa":"General","t":"n"},"m":"1"}},{"r":1,"c":3,"v":{"m":"Luckysheet is good","ct":{"fa":"General","t":"g"},"v":"Luckysheet is good"}},{"r":1,"c":4,"v":{"m":"Welcome","ct":{"fa":"General","t":"g"},"v":"Welcome"}},{"r":1,"c":5,"v":{"m":"2020-09-24","ct":{"fa":"yyyy-MM-dd","t":"d"},"v":44098}},{"r":1,"c":6,"v":{"v":"311414199009138910","ct":{"fa":"@","t":"s"},"m":"311414199009138910"}},{"r":1,"c":7,"v":{"v":13678765439,"ct":{"fa":"General","t":"n"},"m":"13678765439"}},{"r":2,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"Done","m":"Done"}},{"r":2,"c":1,"v":{"m":"Pass","ct":{"fa":"General","t":"g"},"v":"Pass"}},{"r":2,"c":2,"v":{"v":2,"ct":{"fa":"General","t":"n"},"m":"2"}},{"r":2,"c":3,"v":{"m":"I am Luckysheet","ct":{"fa":"General","t":"g"},"v":"I am Luckysheet"}},{"r":2,"c":4,"v":{"m":"Good","ct":{"fa":"General","t":"g"},"v":"Good"}},{"r":2,"c":5,"v":{"ct":{"fa":"General","t":"g"},"v":"Time","m":"Time"}},{"r":2,"c":6,"v":{"v":"31141419900913891","ct":{"fa":"@","t":"s"},"m":"31141419900913891"}},{"r":2,"c":7,"v":{"v":1367876544,"ct":{"fa":"General","t":"n"},"m":"1367876544"}},{"r":3,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"Develop","m":"Develop"}},{"r":3,"c":1,"v":{"m":"Fail","ct":{"fa":"General","t":"g"},"v":"Fail"}},{"r":3,"c":2,"v":{"v":5,"ct":{"fa":"General","t":"n"},"m":"5"}},{"r":3,"c":3,"v":{"ct":{"fa":"General","t":"g"},"v":"I am luckyDemo","m":"I am luckyDemo"}},{"r":3,"c":4,"v":{"m":"Nice","ct":{"fa":"General","t":"g"},"v":"Nice"}},{"r":3,"c":5,"v":{"m":"2020-09-26","ct":{"fa":"yyyy-MM-dd","t":"d"},"v":44100}},{"r":3,"c":6,"v":{"v":"3114141990091389102","ct":{"fa":"@","t":"s"},"m":"3114141990091389102"}},{"r":3,"c":7,"v":{"v":136787654412,"ct":{"fa":"##0","t":"n"},"m":"136787654412"}},{"r":4,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"Doing","m":"Doing"}},{"r":4,"c":1,"v":{"m":"Fail","ct":{"fa":"General","t":"g"},"v":"Fail"}},{"r":4,"c":2,"v":{"v":11,"ct":{"fa":"General","t":"n"},"m":"11"}},{"r":4,"c":3,"v":{"ct":{"fa":"General","t":"g"},"v":"Luckysheet Documentation","m":"Luckysheet Documentation"}},{"r":4,"c":4,"v":{"ct":{"fa":"General","t":"g"},"v":"Morning","m":"Morning"}},{"r":4,"c":5,"v":{"m":"2020-09-27","ct":{"fa":"yyyy-MM-dd","t":"d"},"v":44101}},{"r":4,"c":6,"v":{"v":"31141419900913891X","ct":{"fa":"@","t":"s"},"m":"31141419900913891X"}},{"r":4,"c":7,"v":{"v":49865342456,"ct":{"fa":"General","t":"n"},"m":"49865342456"}},{"r":5,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"Develop","m":"Develop"}},{"r":5,"c":1,"v":{"m":"Fail","ct":{"fa":"General","t":"g"},"v":"Fail"}},{"r":5,"c":2,"v":{"v":3,"ct":{"fa":"General","t":"n"},"m":"3"}},{"r":5,"c":3,"v":{"m":"Luckyexcel","ct":{"fa":"General","t":"g"},"v":"Luckyexcel"}},{"r":5,"c":4,"v":{"ct":{"fa":"General","t":"g"},"v":"Tomorrow","m":"Tomorrow"}},{"r":5,"c":5,"v":{"ct":{"fa":"yyyy-MM-dd","t":"d"},"v":44071,"m":"2020-08-28"}},{"r":5,"c":6,"v":{"v":"Number","ct":{"fa":"@","t":"s"},"m":"Number"}},{"r":5,"c":7,"v":{"v":"Number","ct":{"fa":"General","t":"g"},"m":"Number"}},{"r":6,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"Done","m":"Done"}},{"r":6,"c":1,"v":{"m":"Pass","ct":{"fa":"General","t":"g"},"v":"Pass"}},{"r":6,"c":2,"v":{"v":0,"ct":{"fa":"General","t":"n"},"m":"0"}},{"r":6,"c":3,"v":{"m":"Luckysheet Online","ct":{"fa":"General","t":"g"},"v":"Luckysheet Online"}},{"r":6,"c":4,"v":{"m":"Three","ct":{"fa":"General","t":"g"},"v":"Three"}},{"r":6,"c":5,"v":{"m":"2020-09-29","ct":{"fa":"yyyy-MM-dd","t":"d"},"v":44103}},{"r":6,"c":6,"v":{"v":"311414199301118910","ct":{"fa":"@","t":"s"},"m":"311414199301118910"}},{"r":6,"c":7,"v":{"v":23309873564,"ct":{"fa":"General","t":"n"},"m":"23309873564"}},{"r":7,"c":8,"v":{"v":null,"ct":{"fa":"General","t":"g"},"bl":1}}],
  5. // "row": 84,
  6. "row": 100,
  7. "column": 60,
  8. "config": {
  9. "merge": {},
  10. "rowlen": {},
  11. "columnlen": {
  12. "0": 109,
  13. "2": 143,
  14. "3": 200,
  15. "4": 180,
  16. "6": 178,
  17. "7": 125
  18. },
  19. "customWidth": {
  20. "2": 1,
  21. "3": 1,
  22. "4": 1,
  23. "6": 1,
  24. "7": 1
  25. }
  26. },
  27. "luckysheet_select_save": [
  28. {
  29. "left": 963,
  30. "width": 125,
  31. "top": 240,
  32. "height": 19,
  33. "left_move": 963,
  34. "width_move": 125,
  35. "top_move": 240,
  36. "height_move": 19,
  37. "row": [
  38. 12,
  39. 12
  40. ],
  41. "column": [
  42. 7,
  43. 7
  44. ],
  45. "row_focus": 12,
  46. "column_focus": 7
  47. }
  48. ],
  49. "dataVerification": {
  50. "1_0": {
  51. "type": "dropdown",
  52. "type2": null,
  53. "value1": "Develop,Fix,Done",
  54. "value2": "",
  55. "checked": false,
  56. "remote": false,
  57. "prohibitInput": false,
  58. "hintShow": false,
  59. "hintText": ""
  60. },
  61. "2_0": {
  62. "type": "dropdown",
  63. "type2": null,
  64. "value1": "Develop,Fix,Done",
  65. "value2": "",
  66. "checked": false,
  67. "remote": false,
  68. "prohibitInput": false,
  69. "hintShow": false,
  70. "hintText": ""
  71. },
  72. "3_0": {
  73. "type": "dropdown",
  74. "type2": null,
  75. "value1": "Develop,Fix,Done",
  76. "value2": "",
  77. "checked": false,
  78. "remote": false,
  79. "prohibitInput": false,
  80. "hintShow": false,
  81. "hintText": ""
  82. },
  83. "4_0": {
  84. "type": "dropdown",
  85. "type2": null,
  86. "value1": "Develop,Fix,Done",
  87. "value2": "",
  88. "checked": false,
  89. "remote": false,
  90. "prohibitInput": false,
  91. "hintShow": false,
  92. "hintText": ""
  93. },
  94. "5_0": {
  95. "type": "dropdown",
  96. "type2": null,
  97. "value1": "Develop,Fix,Done",
  98. "value2": "",
  99. "checked": false,
  100. "remote": false,
  101. "prohibitInput": false,
  102. "hintShow": false,
  103. "hintText": ""
  104. },
  105. "6_0": {
  106. "type": "dropdown",
  107. "type2": null,
  108. "value1": "Develop,Fix,Done",
  109. "value2": "",
  110. "checked": false,
  111. "remote": false,
  112. "prohibitInput": false,
  113. "hintShow": false,
  114. "hintText": ""
  115. },
  116. "1_1": {
  117. "type": "checkbox",
  118. "type2": null,
  119. "value1": "Pass",
  120. "value2": "Fail",
  121. "checked": false,
  122. "remote": true,
  123. "prohibitInput": false,
  124. "hintShow": false,
  125. "hintText": ""
  126. },
  127. "2_1": {
  128. "type": "checkbox",
  129. "type2": null,
  130. "value1": "Pass",
  131. "value2": "Fail",
  132. "checked": true,
  133. "remote": true,
  134. "prohibitInput": false,
  135. "hintShow": false,
  136. "hintText": ""
  137. },
  138. "3_1": {
  139. "type": "checkbox",
  140. "type2": null,
  141. "value1": "Pass",
  142. "value2": "Fail",
  143. "checked": false,
  144. "remote": true,
  145. "prohibitInput": false,
  146. "hintShow": false,
  147. "hintText": ""
  148. },
  149. "4_1": {
  150. "type": "checkbox",
  151. "type2": null,
  152. "value1": "Pass",
  153. "value2": "Fail",
  154. "checked": false,
  155. "remote": true,
  156. "prohibitInput": false,
  157. "hintShow": false,
  158. "hintText": ""
  159. },
  160. "5_1": {
  161. "type": "checkbox",
  162. "type2": null,
  163. "value1": "Pass",
  164. "value2": "Fail",
  165. "checked": false,
  166. "remote": true,
  167. "prohibitInput": false,
  168. "hintShow": false,
  169. "hintText": ""
  170. },
  171. "6_1": {
  172. "type": "checkbox",
  173. "type2": null,
  174. "value1": "Pass",
  175. "value2": "Fail",
  176. "checked": true,
  177. "remote": true,
  178. "prohibitInput": false,
  179. "hintShow": false,
  180. "hintText": ""
  181. },
  182. "1_2": {
  183. "type": "number",
  184. "type2": "bw",
  185. "value1": "1",
  186. "value2": "10",
  187. "checked": false,
  188. "remote": false,
  189. "prohibitInput": true,
  190. "hintShow": false,
  191. "hintText": ""
  192. },
  193. "2_2": {
  194. "type": "number",
  195. "type2": "bw",
  196. "value1": "1",
  197. "value2": "10",
  198. "checked": false,
  199. "remote": false,
  200. "prohibitInput": true,
  201. "hintShow": false,
  202. "hintText": ""
  203. },
  204. "3_2": {
  205. "type": "number",
  206. "type2": "bw",
  207. "value1": "1",
  208. "value2": "10",
  209. "checked": false,
  210. "remote": false,
  211. "prohibitInput": true,
  212. "hintShow": false,
  213. "hintText": ""
  214. },
  215. "4_2": {
  216. "type": "number",
  217. "type2": "bw",
  218. "value1": "1",
  219. "value2": "10",
  220. "checked": false,
  221. "remote": false,
  222. "prohibitInput": true,
  223. "hintShow": false,
  224. "hintText": ""
  225. },
  226. "5_2": {
  227. "type": "number",
  228. "type2": "bw",
  229. "value1": "1",
  230. "value2": "10",
  231. "checked": false,
  232. "remote": false,
  233. "prohibitInput": true,
  234. "hintShow": false,
  235. "hintText": ""
  236. },
  237. "6_2": {
  238. "type": "number",
  239. "type2": "bw",
  240. "value1": "1",
  241. "value2": "10",
  242. "checked": false,
  243. "remote": false,
  244. "prohibitInput": true,
  245. "hintShow": false,
  246. "hintText": ""
  247. },
  248. "1_3": {
  249. "type": "text_content",
  250. "type2": "include",
  251. "value1": "Luckysheet",
  252. "value2": "",
  253. "checked": false,
  254. "remote": false,
  255. "prohibitInput": false,
  256. "hintShow": true,
  257. "hintText": "include Luckysheet"
  258. },
  259. "2_3": {
  260. "type": "text_content",
  261. "type2": "include",
  262. "value1": "Luckysheet",
  263. "value2": "",
  264. "checked": false,
  265. "remote": false,
  266. "prohibitInput": false,
  267. "hintShow": true,
  268. "hintText": "include Luckysheet"
  269. },
  270. "3_3": {
  271. "type": "text_content",
  272. "type2": "include",
  273. "value1": "Luckysheet",
  274. "value2": "",
  275. "checked": false,
  276. "remote": false,
  277. "prohibitInput": false,
  278. "hintShow": true,
  279. "hintText": "include Luckysheet"
  280. },
  281. "4_3": {
  282. "type": "text_content",
  283. "type2": "include",
  284. "value1": "Luckysheet",
  285. "value2": "",
  286. "checked": false,
  287. "remote": false,
  288. "prohibitInput": false,
  289. "hintShow": true,
  290. "hintText": "include Luckysheet"
  291. },
  292. "5_3": {
  293. "type": "text_content",
  294. "type2": "include",
  295. "value1": "Luckysheet",
  296. "value2": "",
  297. "checked": false,
  298. "remote": false,
  299. "prohibitInput": false,
  300. "hintShow": true,
  301. "hintText": "include Luckysheet"
  302. },
  303. "6_3": {
  304. "type": "text_content",
  305. "type2": "include",
  306. "value1": "Luckysheet",
  307. "value2": "",
  308. "checked": false,
  309. "remote": false,
  310. "prohibitInput": false,
  311. "hintShow": true,
  312. "hintText": "include Luckysheet"
  313. },
  314. "1_4": {
  315. "type": "text_length",
  316. "type2": "bw",
  317. "value1": "1",
  318. "value2": "5",
  319. "checked": false,
  320. "remote": false,
  321. "prohibitInput": true,
  322. "hintShow": false,
  323. "hintText": ""
  324. },
  325. "2_4": {
  326. "type": "text_length",
  327. "type2": "bw",
  328. "value1": "1",
  329. "value2": "5",
  330. "checked": false,
  331. "remote": false,
  332. "prohibitInput": true,
  333. "hintShow": false,
  334. "hintText": ""
  335. },
  336. "3_4": {
  337. "type": "text_length",
  338. "type2": "bw",
  339. "value1": "1",
  340. "value2": "5",
  341. "checked": false,
  342. "remote": false,
  343. "prohibitInput": true,
  344. "hintShow": false,
  345. "hintText": ""
  346. },
  347. "4_4": {
  348. "type": "text_length",
  349. "type2": "bw",
  350. "value1": "1",
  351. "value2": "5",
  352. "checked": false,
  353. "remote": false,
  354. "prohibitInput": true,
  355. "hintShow": false,
  356. "hintText": ""
  357. },
  358. "5_4": {
  359. "type": "text_length",
  360. "type2": "bw",
  361. "value1": "1",
  362. "value2": "5",
  363. "checked": false,
  364. "remote": false,
  365. "prohibitInput": true,
  366. "hintShow": false,
  367. "hintText": ""
  368. },
  369. "6_4": {
  370. "type": "text_length",
  371. "type2": "bw",
  372. "value1": "1",
  373. "value2": "5",
  374. "checked": false,
  375. "remote": false,
  376. "prohibitInput": true,
  377. "hintShow": false,
  378. "hintText": ""
  379. },
  380. "1_5": {
  381. "type": "date",
  382. "type2": "bw",
  383. "value1": "2020-09-23",
  384. "value2": "2020-10-10",
  385. "checked": false,
  386. "remote": false,
  387. "prohibitInput": false,
  388. "hintShow": false,
  389. "hintText": ""
  390. },
  391. "2_5": {
  392. "type": "date",
  393. "type2": "bw",
  394. "value1": "2020-09-23",
  395. "value2": "2020-10-10",
  396. "checked": false,
  397. "remote": false,
  398. "prohibitInput": false,
  399. "hintShow": false,
  400. "hintText": ""
  401. },
  402. "3_5": {
  403. "type": "date",
  404. "type2": "bw",
  405. "value1": "2020-09-23",
  406. "value2": "2020-10-10",
  407. "checked": false,
  408. "remote": false,
  409. "prohibitInput": false,
  410. "hintShow": false,
  411. "hintText": ""
  412. },
  413. "4_5": {
  414. "type": "date",
  415. "type2": "bw",
  416. "value1": "2020-09-23",
  417. "value2": "2020-10-10",
  418. "checked": false,
  419. "remote": false,
  420. "prohibitInput": false,
  421. "hintShow": false,
  422. "hintText": ""
  423. },
  424. "5_5": {
  425. "type": "date",
  426. "type2": "bw",
  427. "value1": "2020-09-23",
  428. "value2": "2020-10-10",
  429. "checked": false,
  430. "remote": false,
  431. "prohibitInput": false,
  432. "hintShow": false,
  433. "hintText": ""
  434. },
  435. "6_5": {
  436. "type": "date",
  437. "type2": "bw",
  438. "value1": "2020-09-23",
  439. "value2": "2020-10-10",
  440. "checked": false,
  441. "remote": false,
  442. "prohibitInput": false,
  443. "hintShow": false,
  444. "hintText": ""
  445. },
  446. "1_6": {
  447. "type": "validity",
  448. "type2": "card",
  449. "value1": "",
  450. "value2": "",
  451. "checked": false,
  452. "remote": false,
  453. "prohibitInput": false,
  454. "hintShow": false,
  455. "hintText": ""
  456. },
  457. "2_6": {
  458. "type": "validity",
  459. "type2": "card",
  460. "value1": "",
  461. "value2": "",
  462. "checked": false,
  463. "remote": false,
  464. "prohibitInput": false,
  465. "hintShow": false,
  466. "hintText": ""
  467. },
  468. "3_6": {
  469. "type": "validity",
  470. "type2": "card",
  471. "value1": "",
  472. "value2": "",
  473. "checked": false,
  474. "remote": false,
  475. "prohibitInput": false,
  476. "hintShow": false,
  477. "hintText": ""
  478. },
  479. "4_6": {
  480. "type": "validity",
  481. "type2": "card",
  482. "value1": "",
  483. "value2": "",
  484. "checked": false,
  485. "remote": false,
  486. "prohibitInput": false,
  487. "hintShow": false,
  488. "hintText": ""
  489. },
  490. "5_6": {
  491. "type": "validity",
  492. "type2": "card",
  493. "value1": "",
  494. "value2": "",
  495. "checked": false,
  496. "remote": false,
  497. "prohibitInput": false,
  498. "hintShow": false,
  499. "hintText": ""
  500. },
  501. "6_6": {
  502. "type": "validity",
  503. "type2": "card",
  504. "value1": "",
  505. "value2": "",
  506. "checked": false,
  507. "remote": false,
  508. "prohibitInput": false,
  509. "hintShow": false,
  510. "hintText": ""
  511. },
  512. "1_7": {
  513. "type": "validity",
  514. "type2": "phone",
  515. "value1": "",
  516. "value2": "",
  517. "checked": false,
  518. "remote": false,
  519. "prohibitInput": false,
  520. "hintShow": false,
  521. "hintText": ""
  522. },
  523. "2_7": {
  524. "type": "validity",
  525. "type2": "phone",
  526. "value1": "",
  527. "value2": "",
  528. "checked": false,
  529. "remote": false,
  530. "prohibitInput": false,
  531. "hintShow": false,
  532. "hintText": ""
  533. },
  534. "3_7": {
  535. "type": "validity",
  536. "type2": "phone",
  537. "value1": "",
  538. "value2": "",
  539. "checked": false,
  540. "remote": false,
  541. "prohibitInput": false,
  542. "hintShow": false,
  543. "hintText": ""
  544. },
  545. "4_7": {
  546. "type": "validity",
  547. "type2": "phone",
  548. "value1": "",
  549. "value2": "",
  550. "checked": false,
  551. "remote": false,
  552. "prohibitInput": false,
  553. "hintShow": false,
  554. "hintText": ""
  555. },
  556. "5_7": {
  557. "type": "validity",
  558. "type2": "phone",
  559. "value1": "",
  560. "value2": "",
  561. "checked": false,
  562. "remote": false,
  563. "prohibitInput": false,
  564. "hintShow": false,
  565. "hintText": ""
  566. },
  567. "6_7": {
  568. "type": "validity",
  569. "type2": "phone",
  570. "value1": "",
  571. "value2": "",
  572. "checked": false,
  573. "remote": false,
  574. "prohibitInput": false,
  575. "hintShow": false,
  576. "hintText": ""
  577. }
  578. }
  579. }
  580. // export default sheetDataVerification;