{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,11]],"date-time":"2026-02-11T19:50:02Z","timestamp":1770839402099,"version":"3.50.1"},"reference-count":63,"publisher":"Institute of Electrical and Electronics Engineers (IEEE)","issue":"3","license":[{"start":{"date-parts":[[2017,3,1]],"date-time":"2017-03-01T00:00:00Z","timestamp":1488326400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/ieeexplore.ieee.org\/Xplorehelp\/downloads\/license-information\/IEEE.html"}],"funder":[{"DOI":"10.13039\/501100004826","name":"Beijing Natural Science Foundation","doi-asserted-by":"publisher","award":["4164104"],"award-info":[{"award-number":["4164104"]}],"id":[{"id":"10.13039\/501100004826","id-type":"DOI","asserted-by":"publisher"}]},{"name":"National Key Research and Development Plan","award":["2016YFB1000803"],"award-info":[{"award-number":["2016YFB1000803"]}]},{"DOI":"10.13039\/501100002920","name":"Research Grants Council","doi-asserted-by":"publisher","id":[{"id":"10.13039\/501100002920","id-type":"DOI","asserted-by":"publisher"}]},{"name":"General Research Fund","award":["611811"],"award-info":[{"award-number":["611811"]}]},{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation","doi-asserted-by":"publisher","award":["61472174"],"award-info":[{"award-number":["61472174"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation","doi-asserted-by":"publisher","award":["91318301"],"award-info":[{"award-number":["91318301"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation","doi-asserted-by":"publisher","award":["61321491"],"award-info":[{"award-number":["61321491"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]},{"name":"Collaborative Innovation Center of Novel Software Technology and Industrialization of China"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["IIEEE Trans. Software Eng."],"published-print":{"date-parts":[[2017,3,1]]},"DOI":"10.1109\/tse.2016.2584059","type":"journal-article","created":{"date-parts":[[2016,6,23]],"date-time":"2016-06-23T18:18:41Z","timestamp":1466705921000},"page":"226-251","source":"Crossref","is-referenced-by-count":27,"title":["CACheck: Detecting and Repairing Cell Arrays in Spreadsheets"],"prefix":"10.1109","volume":"43","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-3323-0449","authenticated-orcid":false,"given":"Wensheng","family":"Dou","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Chang","family":"Xu","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"S.C.","family":"Cheung","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jun","family":"Wei","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"263","reference":[{"key":"ref39","doi-asserted-by":"publisher","DOI":"10.1145\/2560012"},{"key":"ref38","article-title":"Introducing the Enron corpus","author":"klimt","year":"2004"},{"key":"ref33","first-page":"68","article-title":"On the empirical evaluation of fault localization techniques for spreadsheets","author":"hofer","year":"0","journal-title":"Proc 16th Int Conf Fundam Approaches Softw Eng"},{"key":"ref32","first-page":"1","article-title":"Copy-paste tracking: Fixing spreadsheets without breaking them","author":"hermans","year":"0","journal-title":"Proc 1st Int Conf Live Coding"},{"key":"ref31","doi-asserted-by":"publisher","DOI":"10.1109\/ICSE.2013.6606575"},{"key":"ref30","doi-asserted-by":"publisher","DOI":"10.1109\/ICSE.2012.6227171"},{"key":"ref37","doi-asserted-by":"publisher","DOI":"10.1145\/337180.337206"},{"key":"ref36","doi-asserted-by":"publisher","DOI":"10.1145\/1806799.1806833"},{"key":"ref35","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2014.03.058"},{"key":"ref34","doi-asserted-by":"publisher","DOI":"10.1007\/s10515-014-0141-7"},{"key":"ref60","article-title":"Spreadsheet detective","year":"0"},{"key":"ref62","article-title":"CACheck project","year":"0"},{"key":"ref61","article-title":"Spreadsheet auditor","year":"0"},{"key":"ref63","article-title":"Apache POI - the Java API for microsoft documents","year":"0"},{"key":"ref28","doi-asserted-by":"publisher","DOI":"10.1145\/1985793.1985855"},{"key":"ref27","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-14107-2_4"},{"key":"ref29","doi-asserted-by":"publisher","DOI":"10.1109\/ICSM.2012.6405300"},{"key":"ref2","doi-asserted-by":"publisher","DOI":"10.1145\/1134285.1134312"},{"key":"ref1","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2006.11"},{"key":"ref20","doi-asserted-by":"publisher","DOI":"10.1109\/ICSE.1998.671118"},{"key":"ref22","doi-asserted-by":"publisher","DOI":"10.1145\/1993498.1993506"},{"key":"ref21","doi-asserted-by":"publisher","DOI":"10.1145\/1926385.1926423"},{"key":"ref24","first-page":"56","article-title":"Improving spreadsheet test practices","author":"hermans","year":"0","journal-title":"Proc Conf Center Adv Stud Coll Res"},{"key":"ref23","doi-asserted-by":"publisher","DOI":"10.1145\/1993498.1993536"},{"key":"ref26","doi-asserted-by":"publisher","DOI":"10.1109\/ICSE.2015.129"},{"key":"ref25","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2015.7357210"},{"key":"ref50","first-page":"634","article-title":"Synthesizing number transformations from input-output examples","author":"singh","year":"0","journal-title":"Proc 24th Int Conf Comput Aided Verif"},{"key":"ref51","doi-asserted-by":"publisher","DOI":"10.1007\/s10664-013-9258-8"},{"key":"ref59","article-title":"PerfectXL","year":"0"},{"key":"ref58","article-title":"EXChecker","year":"0"},{"key":"ref57","article-title":"OAK operis analysis kit","year":"0"},{"key":"ref56","article-title":"Spreadsheet professional","year":"0"},{"key":"ref55","article-title":"How to use the auto fill options button in excel","year":"0"},{"key":"ref54","article-title":"European spreadsheet risks interest group","year":"0"},{"key":"ref53","article-title":"How effective can spreadsheet anomalies be detected: An empirical study","author":"zhang","year":"2016","journal-title":"J Syst Softw"},{"key":"ref52","volume":"13","author":"walkenbach","year":"2013","journal-title":"Excel 2013 Power Programming with VBA"},{"key":"ref10","doi-asserted-by":"publisher","DOI":"10.1145\/2884781.2884796"},{"key":"ref11","article-title":"A scalable approach to spreadsheet visualization","author":"clermont","year":"2003"},{"key":"ref40","doi-asserted-by":"publisher","DOI":"10.1145\/1294261.1294272"},{"key":"ref12","first-page":"87","article-title":"Auditing large spreadsheet programs","author":"clermont","year":"0","journal-title":"Proc Int Conf Inf Syst Implementation Model"},{"key":"ref13","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2010.22"},{"key":"ref14","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2012.6344535"},{"key":"ref15","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-31128-4_15"},{"key":"ref16","doi-asserted-by":"publisher","DOI":"10.1006\/ijhc.1996.0061"},{"key":"ref17","doi-asserted-by":"publisher","DOI":"10.1145\/2568225.2568316"},{"key":"ref18","first-page":"162","article-title":"VEnron: A versioned spreadsheet corpus and related evolution analysis","author":"dou","year":"0","journal-title":"Proc 38th Int Conf Softw Eng"},{"key":"ref19","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1145\/1082983.1083242","article-title":"The EUSES spreadsheet corpus: A shared resource for supporting experimentation with spreadsheet dependability mechanisms","volume":"30","author":"fisher","year":"2005","journal-title":"ACM SIGSOFT Softw Eng Notes"},{"key":"ref4","doi-asserted-by":"publisher","DOI":"10.1016\/j.jvlc.2006.06.001"},{"key":"ref3","doi-asserted-by":"publisher","DOI":"10.1109\/ICSE.2007.39"},{"key":"ref6","doi-asserted-by":"publisher","DOI":"10.1145\/2660193.2660207"},{"key":"ref5","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2008.73"},{"key":"ref8","doi-asserted-by":"publisher","DOI":"10.1016\/j.jvlc.2009.04.002"},{"key":"ref7","doi-asserted-by":"publisher","DOI":"10.1109\/HCC.2002.1046366"},{"key":"ref49","doi-asserted-by":"publisher","DOI":"10.1145\/1869459.1869474"},{"key":"ref9","doi-asserted-by":"publisher","DOI":"10.1016\/j.jvlc.2010.08.004"},{"key":"ref46","first-page":"23","article-title":"Classification of spreadsheet errors","author":"rajalingham","year":"2001","journal-title":"Proc European Spreadsheet Risks Interest Group"},{"key":"ref45","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2008.06.001"},{"key":"ref48","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2006.37"},{"key":"ref47","doi-asserted-by":"publisher","DOI":"10.1145\/331960.331968"},{"key":"ref42","first-page":"337","article-title":"Z3: An efficient SMT solver","author":"de moura","year":"0","journal-title":"Proc Theory Practice Softw 14th Int Conf Tools Algorithms Construction Anal Syst"},{"key":"ref41","doi-asserted-by":"publisher","DOI":"10.1109\/WCRE.2002.1173080"},{"key":"ref44","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2010.02.009"},{"key":"ref43","first-page":"8","article-title":"Facing the problem of spreadsheet errors","volume":"37","author":"panko","year":"2006","journal-title":"Decision Line"}],"container-title":["IEEE Transactions on Software Engineering"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx7\/32\/7876879\/07498607.pdf?arnumber=7498607","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,1,12]],"date-time":"2022-01-12T16:19:48Z","timestamp":1642004388000},"score":1,"resource":{"primary":{"URL":"http:\/\/ieeexplore.ieee.org\/document\/7498607\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017,3,1]]},"references-count":63,"journal-issue":{"issue":"3"},"URL":"https:\/\/doi.org\/10.1109\/tse.2016.2584059","relation":{},"ISSN":["0098-5589","1939-3520"],"issn-type":[{"value":"0098-5589","type":"print"},{"value":"1939-3520","type":"electronic"}],"subject":[],"published":{"date-parts":[[2017,3,1]]}}}