{"id":"https://openalex.org/W2796264185","doi":"https://doi.org/10.1109/saner.2018.8330229","title":"Detecting faulty empty cells in spreadsheets","display_name":"Detecting faulty empty cells in spreadsheets","publication_year":2018,"publication_date":"2018-03-01","ids":{"openalex":"https://openalex.org/W2796264185","doi":"https://doi.org/10.1109/saner.2018.8330229","mag":"2796264185"},"language":"en","primary_location":{"id":"doi:10.1109/saner.2018.8330229","is_oa":false,"landing_page_url":"https://doi.org/10.1109/saner.2018.8330229","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 IEEE 25th International Conference on Software Analysis, Evolution and Reengineering (SANER)","raw_type":"proceedings-article"},"type":"conference-paper","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/A5064382429","display_name":"Liang Xu","orcid":"https://orcid.org/0000-0001-7400-3827"},"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":"Liang Xu","raw_affiliation_strings":["State Key Laboratory of Computer Science, Chinese Academy of Sciences, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"State Key Laboratory of Computer Science, Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I19820366"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037918959","display_name":"Shuo Wang","orcid":"https://orcid.org/0000-0003-2514-0045"},"institutions":[{"id":"https://openalex.org/I1456306","display_name":"North China University of Technology","ror":"https://ror.org/01nky7652","country_code":"CN","type":"education","lineage":["https://openalex.org/I1456306"]},{"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":"Shuo Wang","raw_affiliation_strings":["North China University of Technology","State Key Laboratory of Computer Science, Chinese Academy of Sciences, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"North China University of Technology","institution_ids":["https://openalex.org/I1456306"]},{"raw_affiliation_string":"State Key Laboratory of Computer Science, Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I19820366"]}]},{"author_position":"middle","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":false,"raw_author_name":"Wensheng Dou","raw_affiliation_strings":["State Key Laboratory of Computer Science, Chinese Academy of Sciences, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"State Key Laboratory of Computer Science, Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I19820366"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065763579","display_name":"Bo Yang","orcid":"https://orcid.org/0000-0003-1928-7526"},"institutions":[{"id":"https://openalex.org/I1456306","display_name":"North China University of Technology","ror":"https://ror.org/01nky7652","country_code":"CN","type":"education","lineage":["https://openalex.org/I1456306"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bo Yang","raw_affiliation_strings":["North China University of Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"North China University of Technology","institution_ids":["https://openalex.org/I1456306"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036073707","display_name":"Chushu Gao","orcid":"https://orcid.org/0000-0003-1397-4536"},"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":"Chushu Gao","raw_affiliation_strings":["State Key Laboratory of Computer Science, Chinese Academy of Sciences, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"State Key Laboratory of Computer Science, Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I19820366"]}]},{"author_position":"middle","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, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"State Key Laboratory of Computer Science, Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I19820366"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5087767046","display_name":"Tao Huang","orcid":"https://orcid.org/0000-0002-3545-1122"},"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":"Tao Huang","raw_affiliation_strings":["State Key Laboratory of Computer Science, Chinese Academy of Sciences, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"State Key Laboratory of Computer Science, Chinese Academy of Sciences, China","institution_ids":["https://openalex.org/I19820366"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.6106,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.8454367,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"423","last_page":"433"},"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.9998999834060669,"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.9998999834060669,"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.7580289840698242},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.6869845390319824},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.525187611579895},{"id":"https://openalex.org/keywords/value","display_name":"Value (mathematics)","score":0.44454193115234375},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.21241962909698486},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.09476688504219055},{"id":"https://openalex.org/keywords/biology","display_name":"Biology","score":0.07049959897994995}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7580289840698242},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.6869845390319824},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.525187611579895},{"id":"https://openalex.org/C2776291640","wikidata":"https://www.wikidata.org/wiki/Q2912517","display_name":"Value (mathematics)","level":2,"score":0.44454193115234375},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.21241962909698486},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.09476688504219055},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.07049959897994995},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/saner.2018.8330229","is_oa":false,"landing_page_url":"https://doi.org/10.1109/saner.2018.8330229","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 IEEE 25th International Conference on Software Analysis, Evolution and Reengineering (SANER)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W1531418056","https://openalex.org/W1579695396","https://openalex.org/W1808011207","https://openalex.org/W1824472593","https://openalex.org/W1880733898","https://openalex.org/W1933103375","https://openalex.org/W1966514306","https://openalex.org/W2006499508","https://openalex.org/W2010598806","https://openalex.org/W2038340833","https://openalex.org/W2044123923","https://openalex.org/W2068829166","https://openalex.org/W2083808198","https://openalex.org/W2093495548","https://openalex.org/W2095955261","https://openalex.org/W2097435116","https://openalex.org/W2129386590","https://openalex.org/W2135473121","https://openalex.org/W2136834093","https://openalex.org/W2144849164","https://openalex.org/W2153418968","https://openalex.org/W2154523049","https://openalex.org/W2156400118","https://openalex.org/W2171561334","https://openalex.org/W2362126069","https://openalex.org/W2406805043","https://openalex.org/W2408009809","https://openalex.org/W2464636023","https://openalex.org/W2548596251","https://openalex.org/W2610500547","https://openalex.org/W2744434042","https://openalex.org/W3135840814","https://openalex.org/W4213086105","https://openalex.org/W4249909277","https://openalex.org/W6638610261","https://openalex.org/W6714287094","https://openalex.org/W6791471414"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052","https://openalex.org/W4402327032","https://openalex.org/W2382290278"],"abstract_inverted_index":{"Spreadsheets":[0],"play":[1],"an":[2,67,127],"important":[3],"role":[4],"in":[5,90,120],"various":[6],"business":[7],"tasks,":[8],"such":[9],"as":[10],"financial":[11],"reports":[12],"and":[13,42,178],"data":[14],"analysis.":[15],"In":[16,109],"spreadsheets,":[17],"empty":[18,54,68,75,83,100,118,128,143,172,191],"cells":[19,93,119,173,192],"are":[20],"widely":[21],"used":[22],"for":[23],"different":[24,28],"purposes,":[25],"e.g.,":[26],"separating":[27],"tables,":[29],"or":[30],"default":[31],"value":[32],"\"0\".":[33],"However,":[34],"a":[35,39,44,52,59,87,137,152],"user":[36],"may":[37,50],"delete":[38],"formula":[40],"unintentionally,":[41],"leave":[43],"cell":[45,55,69,76,84,88,101,134,138,144],"empty.":[46],"Such":[47],"ad-hoc":[48],"modification":[49],"introduce":[51],"faulty":[53,117,146,171,190],"that":[56,63,167,193],"should":[57],"have":[58,102],"formula.":[60,153],"We":[61,154],"observe":[62],"the":[64,74,82,95,99,124,133,142,188],"context":[65,125],"of":[66,126,187],"can":[70,169,183],"help":[71],"determine":[72],"whether":[73,132],"is":[77,81,145],"faulty.":[78],"For":[79],"example,":[80],"next":[85],"to":[86,105,115,136],"array":[89],"which":[91],"all":[92],"share":[94],"same":[96],"semantics?":[97],"Does":[98],"headers":[103],"similar":[104],"other":[106],"non-empty":[107],"cells'?":[108],"this":[110],"paper,":[111],"we":[112],"propose":[113],"EmptyCheck,":[114],"detect":[116,170,184],"spreadsheets.":[121,162],"By":[122],"analyzing":[123],"cell,":[129],"EmptyCheck":[130,156,168,194],"validates":[131],"belong":[135],"array.":[139],"If":[140],"yes,":[141],"since":[147],"it":[148],"does":[149],"not":[150],"contain":[151],"evaluate":[155],"on":[157],"100":[158],"randomly":[159],"sampled":[160],"EUSES":[161],"The":[163],"experimental":[164],"result":[165],"shows":[166],"with":[174],"high":[175],"precision":[176],"(75.00%)":[177],"recall":[179],"(87.04%).":[180],"Existing":[181],"techniques":[182],"only":[185],"4.26%":[186],"true":[189],"detects.":[195]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}