{"id":"https://openalex.org/W2577742373","doi":"https://doi.org/10.4018/joeuc.2017040102","title":"Error Trapping and Metamorphic Testing for Spreadsheet Failure Detection","display_name":"Error Trapping and Metamorphic Testing for Spreadsheet Failure Detection","publication_year":2017,"publication_date":"2017-01-17","ids":{"openalex":"https://openalex.org/W2577742373","doi":"https://doi.org/10.4018/joeuc.2017040102","mag":"2577742373"},"language":"en","primary_location":{"id":"doi:10.4018/joeuc.2017040102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/joeuc.2017040102","pdf_url":null,"source":{"id":"https://openalex.org/S80285584","display_name":"Journal of Organizational and End User Computing","issn_l":"1546-2234","issn":["1546-2234","1546-5012"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Organizational and End User Computing","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://figshare.com/articles/journal_contribution/Error_trapping_and_metamorphic_testing_for_spreadsheet_failure_detection/13446059","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5051828363","display_name":"Pak\u2010Lok Poon","orcid":"https://orcid.org/0000-0003-2840-2418"},"institutions":[{"id":"https://openalex.org/I82951845","display_name":"RMIT University","ror":"https://ror.org/04ttjf776","country_code":"AU","type":"education","lineage":["https://openalex.org/I82951845"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Pak-Lok Poon","raw_affiliation_strings":["RMIT University, Melbourne, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"RMIT University, Melbourne, Australia","institution_ids":["https://openalex.org/I82951845"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033550181","display_name":"Huai Liu","orcid":"https://orcid.org/0000-0003-3125-4399"},"institutions":[{"id":"https://openalex.org/I82951845","display_name":"RMIT University","ror":"https://ror.org/04ttjf776","country_code":"AU","type":"education","lineage":["https://openalex.org/I82951845"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Huai Liu","raw_affiliation_strings":["RMIT University, Melbourne, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"RMIT University, Melbourne, Australia","institution_ids":["https://openalex.org/I82951845"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5035107113","display_name":"Tsong Yueh Chen","orcid":"https://orcid.org/0000-0003-3578-0994"},"institutions":[{"id":"https://openalex.org/I57093077","display_name":"Swinburne University of Technology","ror":"https://ror.org/031rekg67","country_code":"AU","type":"education","lineage":["https://openalex.org/I57093077"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Tsong Yueh Chen","raw_affiliation_strings":["Swinburne University of Technology, Melbourne, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Swinburne University of Technology, Melbourne, Australia","institution_ids":["https://openalex.org/I57093077"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.9941,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.78730261,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"29","issue":"2","first_page":"25","last_page":"42"},"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"}},{"id":"https://openalex.org/T12423","display_name":"Software Reliability and Analysis Research","score":0.9541000127792358,"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.7275170087814331},{"id":"https://openalex.org/keywords/error-detection-and-correction","display_name":"Error detection and correction","score":0.4438228905200958},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3573988676071167},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.17701297998428345}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7275170087814331},{"id":"https://openalex.org/C103088060","wikidata":"https://www.wikidata.org/wiki/Q1062839","display_name":"Error detection and correction","level":2,"score":0.4438228905200958},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3573988676071167},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.17701297998428345}],"mesh":[],"locations_count":7,"locations":[{"id":"doi:10.4018/joeuc.2017040102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/joeuc.2017040102","pdf_url":null,"source":{"id":"https://openalex.org/S80285584","display_name":"Journal of Organizational and End User Computing","issn_l":"1546-2234","issn":["1546-2234","1546-5012"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Organizational and End User Computing","raw_type":"journal-article"},{"id":"pmh:oai:acquire.cqu.edu.au:cqu:15566","is_oa":false,"landing_page_url":"http://hdl.cqu.edu.au/10018/1237102","pdf_url":null,"source":{"id":"https://openalex.org/S4306400635","display_name":"Acquire (CQUniversity)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I74899385","host_organization_name":"Central Queensland University","host_organization_lineage":["https://openalex.org/I74899385"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Poon, P-L, Liu, H, Chen, TY, (2017). Error trapping and metamorphic testing for spreadsheet failure detection. Journal of Organizational and End User Computing, Vol. 29, No. 2, p. 25-42 http://dx.doi.org/10.4018/JOEUC.2017040102","raw_type":"journal article"},{"id":"pmh:oai:eprints.vu.edu.au:34880","is_oa":false,"landing_page_url":"https://vuir.vu.edu.au/34880/","pdf_url":null,"source":{"id":"https://openalex.org/S4306400215","display_name":"Victoria University Research Repository (Victoria University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I41156924","host_organization_name":"Victoria University of Wellington","host_organization_lineage":["https://openalex.org/I41156924"],"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"},{"id":"pmh:oai:alma.61RMIT_INST:11247609290001341","is_oa":false,"landing_page_url":"https://doi.org/10.4018/JOEUC.2017040102","pdf_url":null,"source":{"id":"https://openalex.org/S4306402074","display_name":"RMIT Research Repository (RMIT University Library)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I82951845","host_organization_name":"RMIT University","host_organization_lineage":["https://openalex.org/I82951845"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"pmh:oai:figshare.com:article/13446059","is_oa":true,"landing_page_url":"https://figshare.com/articles/journal_contribution/Error_trapping_and_metamorphic_testing_for_spreadsheet_failure_detection/13446059","pdf_url":null,"source":{"id":"https://openalex.org/S4306402621","display_name":"INDIGO (University of Illinois at Chicago)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I39422238","host_organization_name":"University of Illinois Chicago","host_organization_lineage":["https://openalex.org/I39422238"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"},{"id":"pmh:oai:figshare.com:article/27498597","is_oa":true,"landing_page_url":"https://figshare.com/articles/journal_contribution/Error_trapping_and_metamorphic_testing_for_spreadsheet_failure_detection/27498597","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"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":"Text"},{"id":"pmh:oai:researchbank.swinburne.edu.au:456d2e07-3653-4ae4-954e-0af9fcedb5e6/1","is_oa":false,"landing_page_url":"http://hdl.handle.net/1959.3/434410","pdf_url":null,"source":{"id":"https://openalex.org/S4306401157","display_name":"Swinburne Research Bank (Swinburne University of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I57093077","host_organization_name":"Swinburne University of Technology","host_organization_lineage":["https://openalex.org/I57093077"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Journal of Organizational and End User Computing, Vol. 29, no. 2 (2017), pp. 25-42","raw_type":null}],"best_oa_location":{"id":"pmh:oai:figshare.com:article/13446059","is_oa":true,"landing_page_url":"https://figshare.com/articles/journal_contribution/Error_trapping_and_metamorphic_testing_for_spreadsheet_failure_detection/13446059","pdf_url":null,"source":{"id":"https://openalex.org/S4306402621","display_name":"INDIGO (University of Illinois at Chicago)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I39422238","host_organization_name":"University of Illinois Chicago","host_organization_lineage":["https://openalex.org/I39422238"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"},"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320334704","display_name":"Australian Research Council","ror":"https://ror.org/05mmh0f86"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":41,"referenced_works":["https://openalex.org/W93717786","https://openalex.org/W143959331","https://openalex.org/W186259066","https://openalex.org/W251141560","https://openalex.org/W1104960690","https://openalex.org/W1539402909","https://openalex.org/W1617678841","https://openalex.org/W1624692099","https://openalex.org/W1849216464","https://openalex.org/W1936022305","https://openalex.org/W1974365737","https://openalex.org/W1998189347","https://openalex.org/W1999078841","https://openalex.org/W2001027630","https://openalex.org/W2010329982","https://openalex.org/W2012984944","https://openalex.org/W2035349409","https://openalex.org/W2041650849","https://openalex.org/W2041713059","https://openalex.org/W2043998723","https://openalex.org/W2047183670","https://openalex.org/W2047914009","https://openalex.org/W2066240519","https://openalex.org/W2074863738","https://openalex.org/W2081280462","https://openalex.org/W2091093620","https://openalex.org/W2095955261","https://openalex.org/W2105110669","https://openalex.org/W2106514862","https://openalex.org/W2112338634","https://openalex.org/W2113234297","https://openalex.org/W2118577607","https://openalex.org/W2133335896","https://openalex.org/W2134413894","https://openalex.org/W2134600833","https://openalex.org/W2135473121","https://openalex.org/W2136255755","https://openalex.org/W2150704968","https://openalex.org/W2162036145","https://openalex.org/W3010856131","https://openalex.org/W3124066374"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W2382290278","https://openalex.org/W2478288626","https://openalex.org/W4391913857","https://openalex.org/W2350741829","https://openalex.org/W2530322880"],"abstract_inverted_index":{"This":[0,64],"study":[1],"deepens":[2],"the":[3,33,46,52,78,83,89],"research":[4],"on":[5],"error":[6],"trapping":[7],"(ET)":[8],"and":[9,24,30,57,76,102,106],"metamorphic":[10],"testing":[11,114],"(MT)":[12],"for":[13,62],"detecting":[14],"spreadsheet":[15,22,98,113],"failures.":[16],"It":[17],"is":[18,65,95],"observed":[19],"that":[20,92],"some":[21,42],"developers":[23],"testers":[25],"are":[26,36,104],"confused":[27],"between":[28],"ET":[29,56,101],"MT,":[31],"because":[32],"two":[34,84],"techniques":[35],"similar":[37],"to":[38,74],"each":[39],"other":[40],"in":[41,97,112],"aspects.":[43],"Inspired":[44],"by":[45,67],"observation,":[47],"this":[48],"paper":[49],"first":[50],"outlines":[51],"main":[53],"concepts":[54],"of":[55,82,88],"MT":[58,103],"using":[59],"several":[60],"examples":[61],"illustration.":[63],"followed":[66],"discussing":[68],"an":[69],"experiment":[70,90],"with":[71],"a":[72],"view":[73],"investigating":[75],"comparing":[77],"failure":[79],"detection":[80],"capabilities":[81],"techniques.":[85],"The":[86],"results":[87],"indicate":[91],"neither":[93],"technique":[94],"sufficient":[96],"testing.":[99],"Rather,":[100],"complementary":[105],"they":[107],"should":[108],"be":[109],"used":[110],"together":[111],"whenever":[115],"possible.":[116]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1}],"updated_date":"2026-07-19T07:52:34.831488","created_date":"2025-10-10T00:00:00"}