{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,20]],"date-time":"2026-01-20T04:25:32Z","timestamp":1768883132952,"version":"3.49.0"},"publisher-location":"New York, NY, USA","reference-count":49,"publisher":"ACM","license":[{"start":{"date-parts":[[2016,11,1]],"date-time":"2016-11-01T00:00:00Z","timestamp":1477958400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2016,11]]},"DOI":"10.1145\/2950290.2950359","type":"proceedings-article","created":{"date-parts":[[2016,11,1]],"date-time":"2016-11-01T13:46:03Z","timestamp":1478007963000},"page":"787-798","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":16,"title":["Detecting table clones and smells in spreadsheets"],"prefix":"10.1145","author":[{"given":"Wensheng","family":"Dou","sequence":"first","affiliation":[{"name":"Institute of Software at Chinese Academy of Sciences, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shing-Chi","family":"Cheung","sequence":"additional","affiliation":[{"name":"Hong Kong University of Science and Technology, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Chushu","family":"Gao","sequence":"additional","affiliation":[{"name":"Institute of Software at Chinese Academy of Sciences, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Chang","family":"Xu","sequence":"additional","affiliation":[{"name":"Nanjing University, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Liang","family":"Xu","sequence":"additional","affiliation":[{"name":"Institute of Software at Chinese Academy of Sciences, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jun","family":"Wei","sequence":"additional","affiliation":[{"name":"Institute of Software at Chinese Academy of Sciences, China"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2016,11]]},"reference":[{"key":"e_1_3_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2004.29"},{"key":"e_1_3_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2006.11"},{"key":"e_1_3_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1134285.1134312"},{"key":"e_1_3_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSE.2007.39"},{"key":"e_1_3_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jvlc.2006.06.001"},{"key":"e_1_3_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2008.73"},{"key":"e_1_3_2_1_7_1","first-page":"95","volume-title":"Proceedings of the Second Working Conference on Reverse Engineering (WCRE)","author":"Baker B.S.","unstructured":"B.S. Baker . On Finding Duplication and Near-duplication in Large Software Systems . In Proceedings of the Second Working Conference on Reverse Engineering (WCRE) , pages 86\u2013 95 . 1995. B.S. Baker. On Finding Duplication and Near-duplication in Large Software Systems. In Proceedings of the Second Working Conference on Reverse Engineering (WCRE), pages 86\u201395. 1995."},{"key":"e_1_3_2_1_8_1","first-page":"377","volume-title":"Proceedings of the International Conference on Software Maintenance (ICSM)","author":"Baxter I.D.","unstructured":"I.D. Baxter , A. Yahin , L. Moura , M. Sant\u2019Anna , and L. Bier . Clone Detection Using Abstract Syntax Trees . In Proceedings of the International Conference on Software Maintenance (ICSM) , pages 368\u2013 377 . 1998. I.D. Baxter, A. Yahin, L. Moura, M. Sant\u2019Anna, and L. Bier. Clone Detection Using Abstract Syntax Trees. In Proceedings of the International Conference on Software Maintenance (ICSM), pages 368\u2013377. 1998."},{"key":"e_1_3_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2007.70725"},{"key":"e_1_3_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2005.114"},{"key":"e_1_3_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/2593882.2593896"},{"key":"e_1_3_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.4018\/joeuc.2007070101"},{"key":"e_1_3_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jvlc.2009.04.002"},{"key":"e_1_3_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jvlc.2010.08.004"},{"key":"e_1_3_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2010.21"},{"key":"e_1_3_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/2884781.2884796"},{"key":"e_1_3_2_1_17_1","first-page":"97","volume-title":"Proceedings of the International Conference on Information Systems Implementation and Modeling","author":"Clermont M.","unstructured":"M. Clermont and R. Mittermeir . Auditing Large Spreadsheet Programs . In Proceedings of the International Conference on Information Systems Implementation and Modeling , pages 87\u2013 97 . 2003. M. Clermont and R. Mittermeir. Auditing Large Spreadsheet Programs. In Proceedings of the International Conference on Information Systems Implementation and Modeling, pages 87\u201397. 2003."},{"key":"e_1_3_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2010.22"},{"key":"e_1_3_2_1_19_1","first-page":"244","volume-title":"IEEE Symposium on Visual Languages and Human-Centric Computing (VL\/HCC)","author":"Cunha J.","unstructured":"J. Cunha , J.P. Fernandes , P. Martins , J. Mendes , and J. Saraiva . SmellSheet Detective: A tool for Detecting Bad Smells in Spreadsheets . In IEEE Symposium on Visual Languages and Human-Centric Computing (VL\/HCC) , pages 243\u2013 244 . 2012. J. Cunha, J.P. Fernandes, P. Martins, J. Mendes, and J. Saraiva. SmellSheet Detective: A tool for Detecting Bad Smells in Spreadsheets. In IEEE Symposium on Visual Languages and Human-Centric Computing (VL\/HCC), pages 243\u2013244. 2012."},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-31128-4_15"},{"key":"e_1_3_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/2568225.2568316"},{"key":"e_1_3_2_1_22_1","article-title":"CACheck: Detecting and Repairing Cell Arrays in Spreadsheets","volume":"2016","author":"Dou W.","unstructured":"W. Dou , C. Xu , S.C. Cheung , and J. Wei . CACheck: Detecting and Repairing Cell Arrays in Spreadsheets . IEEE Trans. Softw. Eng. , 2016 , preprint. W. Dou, C. Xu, S.C. Cheung, and J. Wei. CACheck: Detecting and Repairing Cell Arrays in Spreadsheets. IEEE Trans. Softw. Eng., 2016, preprint.","journal-title":"IEEE Trans. Softw. Eng."},{"key":"e_1_3_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/2889160.2889238"},{"key":"e_1_3_2_1_24_1","first-page":"118","volume-title":"Proceedings of the IEEE International Conference on Software Maintenance (ICSM)","author":"Ducasse S.","unstructured":"S. Ducasse , M. Rieger , and S. Demeyer . A Language Independent Approach for Detecting Duplicated Code . In Proceedings of the IEEE International Conference on Software Maintenance (ICSM) , pages 109\u2013 118 . 1999. S. Ducasse, M. Rieger, and S. Demeyer. A Language Independent Approach for Detecting Duplicated Code. In Proceedings of the IEEE International Conference on Software Maintenance (ICSM), pages 109\u2013118. 1999."},{"key":"e_1_3_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/1082983.1083242"},{"key":"e_1_3_2_1_26_1","first-page":"207","volume-title":"Proceedings of the International Conference on Software Engineering (ICSE)","author":"Rothermel G.","unstructured":"G. Rothermel , L. Li , C. Dupuis , and M. Burnett . What You See Is What You Test: A Methodology for Testing Formbased Visual Programs . In Proceedings of the International Conference on Software Engineering (ICSE) , pages 198\u2013 207 . 1998. G. Rothermel, L. Li, C. Dupuis, and M. Burnett. What You See Is What You Test: A Methodology for Testing Formbased Visual Programs. In Proceedings of the International Conference on Software Engineering (ICSE), pages 198\u2013 207. 1998."},{"key":"e_1_3_2_1_27_1","first-page":"75","volume-title":"Proceedings of the 24th European Conference on Object-Oriented Programming (ECOOP)","author":"Hermans F.","unstructured":"F. Hermans , M. Pinzger , and A. van Deursen . Automatically Extracting Class Diagrams from Spreadsheets . In Proceedings of the 24th European Conference on Object-Oriented Programming (ECOOP) , pages 52\u2013 75 . 2010. F. Hermans, M. Pinzger, and A. van Deursen. Automatically Extracting Class Diagrams from Spreadsheets. In Proceedings of the 24th European Conference on Object-Oriented Programming (ECOOP), pages 52\u201375. 2010."},{"key":"e_1_3_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/1985793.1985855"},{"key":"e_1_3_2_1_29_1","first-page":"451","volume-title":"Deursen. Detecting and Visualizing Inter-worksheet Smells in Spreadsheets. In Proceedings of the International Conference on Software Engineering (ICSE)","author":"Hermans F.","unstructured":"F. Hermans , M. Pinzger , and A. van Deursen. Detecting and Visualizing Inter-worksheet Smells in Spreadsheets. In Proceedings of the International Conference on Software Engineering (ICSE) , pages 441\u2013 451 . 2012. F. Hermans, M. Pinzger, and A. van Deursen. Detecting and Visualizing Inter-worksheet Smells in Spreadsheets. In Proceedings of the International Conference on Software Engineering (ICSE), pages 441\u2013451. 2012."},{"key":"e_1_3_2_1_30_1","first-page":"301","volume-title":"Deursen. Data Clone Detection and Visualization in Spreadsheets. In Proceedings of the International Conference on Software Engineering (ICSE)","author":"Hermans F.","unstructured":"F. Hermans , B. Sedee , M. Pinzger , and A. van Deursen. Data Clone Detection and Visualization in Spreadsheets. In Proceedings of the International Conference on Software Engineering (ICSE) , pages 292\u2013 301 . 2013. F. Hermans, B. Sedee, M. Pinzger, and A. van Deursen. Data Clone Detection and Visualization in Spreadsheets. In Proceedings of the International Conference on Software Engineering (ICSE), pages 292\u2013301. 2013."},{"key":"e_1_3_2_1_31_1","volume-title":"Proceedings of the 1st International Conference on Live Coding (ICLC).","author":"Hermans F.","year":"2015","unstructured":"F. Hermans and T. van der Storm. Copy-Paste Tracking: Fixing Spreadsheets Without Breaking Them . In Proceedings of the 1st International Conference on Live Coding (ICLC). 2015 . F. Hermans and T. van der Storm. Copy-Paste Tracking: Fixing Spreadsheets Without Breaking Them. In Proceedings of the 1st International Conference on Live Coding (ICLC). 2015."},{"key":"e_1_3_2_1_32_1","first-page":"183","volume-title":"Proceedings of the Conference of the Centre for Advanced Studies on Collaborative Research: Software Engineering -","volume":"1","author":"Johnson J.H.","unstructured":"J.H. Johnson . Identifying Redundancy in Source Code Using Fingerprints . In Proceedings of the Conference of the Centre for Advanced Studies on Collaborative Research: Software Engineering - Volume 1 , pages 171\u2013 183 . 1993. J.H. Johnson. Identifying Redundancy in Source Code Using Fingerprints. In Proceedings of the Conference of the Centre for Advanced Studies on Collaborative Research: Software Engineering - Volume 1, pages 171\u2013183. 1993."},{"key":"e_1_3_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2002.1019480"},{"key":"e_1_3_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1145\/1081706.1081737"},{"key":"e_1_3_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/337180.337206"},{"key":"e_1_3_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.1145\/1922649.1922658"},{"key":"e_1_3_2_1_37_1","first-page":"309","volume-title":"Proceedings of 8th Working Conference on Reverse Engineering (WCRE)","author":"Krinke J.","unstructured":"J. Krinke . Identifying Similar Code with Program Dependence Graphs . In Proceedings of 8th Working Conference on Reverse Engineering (WCRE) , pages 301\u2013 309 . 2001. J. Krinke. Identifying Similar Code with Program Dependence Graphs. In Proceedings of 8th Working Conference on Reverse Engineering (WCRE), pages 301\u2013309. 2001."},{"key":"e_1_3_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2006.28"},{"key":"e_1_3_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2011.90"},{"key":"e_1_3_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2010.02.009"},{"key":"e_1_3_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2008.06.001"},{"key":"e_1_3_2_1_42_1","first-page":"34","volume-title":"Classification of Spreadsheet Errors","author":"Rajalingham K.","unstructured":"K. Rajalingham , D.R. Chadwick , and B. Knight . Classification of Spreadsheet Errors . In European Spreadsheet Risks Interest Group (EuSpRIG) , pages 23\u2013 34 . 2001. K. Rajalingham, D.R. Chadwick, and B. Knight. Classification of Spreadsheet Errors. In European Spreadsheet Risks Interest Group (EuSpRIG), pages 23\u201334. 2001."},{"key":"e_1_3_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.1145\/331963.331968"},{"key":"e_1_3_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2005.34"},{"key":"e_1_3_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10664-009-9108-x"},{"key":"e_1_3_2_1_46_1","doi-asserted-by":"publisher","DOI":"10.5555\/2530505"},{"key":"e_1_3_2_1_47_1","unstructured":"How to use the Auto Fill Options button in Excel. http:\/\/support.microsoft.com\/kb\/291359.  How to use the Auto Fill Options button in Excel. http:\/\/support.microsoft.com\/kb\/291359."},{"key":"e_1_3_2_1_48_1","unstructured":"Apache POI - the Java API for Microsoft Documents. http:\/\/poi.apache.org\/.  Apache POI - the Java API for Microsoft Documents. http:\/\/poi.apache.org\/."},{"key":"e_1_3_2_1_49_1","unstructured":"TableCheck project (including experimental subjects and results). http:\/\/www.tcse.cn\/~wsdou\/project\/clone\/.  TableCheck project (including experimental subjects and results). http:\/\/www.tcse.cn\/~wsdou\/project\/clone\/."}],"event":{"name":"FSE'16: 24nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering","location":"Seattle WA USA","acronym":"FSE'16","sponsor":["SIGSOFT ACM Special Interest Group on Software Engineering"]},"container-title":["Proceedings of the 2016 24th ACM SIGSOFT International Symposium on Foundations of Software Engineering"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2950290.2950359","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/2950290.2950359","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T03:49:57Z","timestamp":1750218597000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2950290.2950359"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2016,11]]},"references-count":49,"alternative-id":["10.1145\/2950290.2950359","10.1145\/2950290"],"URL":"https:\/\/doi.org\/10.1145\/2950290.2950359","relation":{},"subject":[],"published":{"date-parts":[[2016,11]]},"assertion":[{"value":"2016-11-01","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}