{"id":"https://openalex.org/W2464636023","doi":"https://doi.org/10.1109/tse.2016.2584059","title":"CACheck: Detecting and Repairing Cell Arrays in Spreadsheets","display_name":"CACheck: Detecting and Repairing Cell Arrays in Spreadsheets","publication_year":2016,"publication_date":"2016-06-23","ids":{"openalex":"https://openalex.org/W2464636023","doi":"https://doi.org/10.1109/tse.2016.2584059","mag":"2464636023"},"language":"en","primary_location":{"id":"doi:10.1109/tse.2016.2584059","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tse.2016.2584059","pdf_url":null,"source":{"id":"https://openalex.org/S8351582","display_name":"IEEE Transactions on Software Engineering","issn_l":"0098-5589","issn":["0098-5589","1939-3520","2326-3881"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Software Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5023724495","display_name":"Wensheng Dou","orcid":"https://orcid.org/0000-0002-3323-0449"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"government","lineage":["https://openalex.org/I19820366"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Wensheng Dou","raw_affiliation_strings":["State Key Laboratory of Computer Science, Chinese Academy of Sciences, Beijing, China"],"affiliations":[{"raw_affiliation_string":"State Key Laboratory of Computer Science, Chinese Academy of Sciences, Beijing, China","institution_ids":["https://openalex.org/I19820366"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052203980","display_name":"Chang Xu","orcid":"https://orcid.org/0000-0002-6299-4704"},"institutions":[{"id":"https://openalex.org/I881766915","display_name":"Nanjing University","ror":"https://ror.org/01rxvg760","country_code":"CN","type":"education","lineage":["https://openalex.org/I881766915"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chang Xu","raw_affiliation_strings":["State Key Laboratory for Novel Software Technology, Nanjing University, Nanjing, Jiangsu, China"],"affiliations":[{"raw_affiliation_string":"State Key Laboratory for Novel Software Technology, Nanjing University, Nanjing, Jiangsu, China","institution_ids":["https://openalex.org/I881766915"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034057959","display_name":"Shing-Chi Cheung","orcid":"https://orcid.org/0000-0002-3508-7172"},"institutions":[{"id":"https://openalex.org/I200769079","display_name":"Hong Kong University of Science and Technology","ror":"https://ror.org/00q4vv597","country_code":"HK","type":"education","lineage":["https://openalex.org/I200769079"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"S.C. Cheung","raw_affiliation_strings":["Department of Computer Science and Engineering, Hong Kong University of Science and Technology, Kowloon, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, Hong Kong University of Science and Technology, Kowloon, Hong Kong, China","institution_ids":["https://openalex.org/I200769079"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5037779332","display_name":"Jun Wei","orcid":"https://orcid.org/0000-0002-1028-8509"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"government","lineage":["https://openalex.org/I19820366"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jun Wei","raw_affiliation_strings":["State Key Laboratory of Computer Science, Chinese Academy of Sciences, Beijing, China"],"affiliations":[{"raw_affiliation_string":"State Key Laboratory of Computer Science, Chinese Academy of Sciences, Beijing, China","institution_ids":["https://openalex.org/I19820366"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5023724495"],"corresponding_institution_ids":["https://openalex.org/I19820366"],"apc_list":null,"apc_paid":null,"fwci":8.229,"has_fulltext":false,"cited_by_count":32,"citation_normalized_percentile":{"value":0.97966045,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"43","issue":"3","first_page":"226","last_page":"251"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8156839609146118},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.6623519062995911},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.6529324054718018},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3444324731826782},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.22769030928611755},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.20729824900627136}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8156839609146118},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.6623519062995911},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.6529324054718018},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3444324731826782},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.22769030928611755},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20729824900627136}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/tse.2016.2584059","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tse.2016.2584059","pdf_url":null,"source":{"id":"https://openalex.org/S8351582","display_name":"IEEE Transactions on Software Engineering","issn_l":"0098-5589","issn":["0098-5589","1939-3520","2326-3881"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Software Engineering","raw_type":"journal-article"},{"id":"pmh:oai:repository.hkust.edu.hk:1783.1-84930","is_oa":false,"landing_page_url":"http://www.scopus.com/record/display.url?eid=2-s2.0-84997314686&origin=inward","pdf_url":null,"source":{"id":"https://openalex.org/S4306401796","display_name":"Rare & Special e-Zone (The Hong Kong University of Science and Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I200769079","host_organization_name":"Hong Kong University of Science and Technology","host_organization_lineage":["https://openalex.org/I200769079"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G2910793562","display_name":null,"funder_award_id":"61472174","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4722731998","display_name":null,"funder_award_id":"91318301","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5591154491","display_name":null,"funder_award_id":"4164104","funder_id":"https://openalex.org/F4320322919","funder_display_name":"Natural Science Foundation of Beijing Municipality"},{"id":"https://openalex.org/G6667581590","display_name":null,"funder_award_id":"61321491","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320321592","display_name":"Research Grants Council, University Grants Committee","ror":"https://ror.org/00djwmt25"},{"id":"https://openalex.org/F4320322919","display_name":"Natural Science Foundation of Beijing Municipality","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":65,"referenced_works":["https://openalex.org/W155995321","https://openalex.org/W194998427","https://openalex.org/W1480909796","https://openalex.org/W1515921409","https://openalex.org/W1531418056","https://openalex.org/W1571097741","https://openalex.org/W1579695396","https://openalex.org/W1880733898","https://openalex.org/W1933103375","https://openalex.org/W1958332869","https://openalex.org/W1970665021","https://openalex.org/W1974365737","https://openalex.org/W2006499508","https://openalex.org/W2010598806","https://openalex.org/W2022114557","https://openalex.org/W2038340833","https://openalex.org/W2044123923","https://openalex.org/W2060404275","https://openalex.org/W2077022777","https://openalex.org/W2080982416","https://openalex.org/W2083808198","https://openalex.org/W2086674260","https://openalex.org/W2095955261","https://openalex.org/W2097435116","https://openalex.org/W2109156518","https://openalex.org/W2111469656","https://openalex.org/W2117032538","https://openalex.org/W2119896264","https://openalex.org/W2129386590","https://openalex.org/W2132525863","https://openalex.org/W2134734244","https://openalex.org/W2135473121","https://openalex.org/W2136834093","https://openalex.org/W2137125606","https://openalex.org/W2138546883","https://openalex.org/W2138555106","https://openalex.org/W2142126234","https://openalex.org/W2142504747","https://openalex.org/W2149557049","https://openalex.org/W2150704968","https://openalex.org/W2152376725","https://openalex.org/W2153723363","https://openalex.org/W2156400118","https://openalex.org/W2162960800","https://openalex.org/W2164611950","https://openalex.org/W2169917840","https://openalex.org/W2171561334","https://openalex.org/W2200894932","https://openalex.org/W2277934767","https://openalex.org/W2320036734","https://openalex.org/W2362126069","https://openalex.org/W2408009809","https://openalex.org/W2917077002","https://openalex.org/W4213086105","https://openalex.org/W4233189519","https://openalex.org/W4237412827","https://openalex.org/W4242364663","https://openalex.org/W4249909277","https://openalex.org/W6606406289","https://openalex.org/W6607942509","https://openalex.org/W6634346572","https://openalex.org/W6639327702","https://openalex.org/W6681302359","https://openalex.org/W6694901015","https://openalex.org/W6700190621"],"related_works":["https://openalex.org/W2380389143","https://openalex.org/W1526789715","https://openalex.org/W1572523360","https://openalex.org/W155014619","https://openalex.org/W2166890385","https://openalex.org/W1584911658","https://openalex.org/W1500335153","https://openalex.org/W2067026386","https://openalex.org/W2001280137","https://openalex.org/W3214915308"],"abstract_inverted_index":{"Spreadsheets":[0],"are":[1,23,66,108],"widely":[2],"used":[3],"by":[4,87,126],"end":[5],"users":[6],"for":[7,118],"numerical":[8],"computation":[9,16,71],"in":[10,26,41],"their":[11,89],"business.":[12],"Spreadsheet":[13],"cells":[14,40,59],"whose":[15],"is":[17,116],"subject":[18],"to":[19,48,68],"the":[20,39,61,97],"same":[21,62],"semantics":[22],"often":[24],"clustered":[25],"a":[27,32,36,42,76],"row":[28],"or":[29],"column":[30],"as":[31],"cell":[33,43,54,85,106,128,139],"array.":[34],"When":[35],"spreadsheet":[37,123],"evolves,":[38],"array":[44],"can":[45],"degenerate":[46],"due":[47],"ad":[49],"hoc":[50],"modifications.":[51],"Such":[52],"degenerated":[53],"arrays":[55,86,107,140],"no":[56],"longer":[57],"keep":[58],"prescribing":[60],"computational":[63,91],"semantics,":[64],"and":[65,82,99,120,144],"said":[67],"exhibit":[69],"ambiguous":[70],"smells.":[72],"We":[73],"propose":[74],"CACheck,":[75],"novel":[77],"technique":[78],"that":[79,103,114],"automatically":[80],"detects":[81,137],"repairs":[83],"smelly":[84,105,127,138],"recovering":[88],"intended":[90],"semantics.":[92],"Our":[93,110],"empirical":[94],"study":[95,111],"on":[96],"EUSES":[98],"Enron":[100],"corpora":[101],"finds":[102],"such":[104],"common.":[109],"also":[112],"suggests":[113],"CACheck":[115,136],"useful":[117],"detecting":[119],"repairing":[121],"real":[122],"problems":[124],"caused":[125],"arrays.":[129],"Compared":[130],"with":[131,141],"our":[132],"previous":[133],"work":[134],"AmCheck,":[135],"higher":[142],"precision":[143],"recall":[145],"rate.":[146]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":9},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":2}],"updated_date":"2026-04-15T08:11:43.952461","created_date":"2025-10-10T00:00:00"}