sheetDataVerification.js 20 KB

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