{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,13]],"date-time":"2026-06-13T13:40:56Z","timestamp":1781358056575,"version":"3.54.1"},"reference-count":71,"publisher":"Association for Computing Machinery (ACM)","issue":"2","license":[{"start":{"date-parts":[[2024,1,29]],"date-time":"2024-01-29T00:00:00Z","timestamp":1706486400000},"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":["ACM Trans. Comput.-Hum. Interact."],"published-print":{"date-parts":[[2024,4,30]]},"abstract":"<jats:p>Spreadsheet programs for interactive surfaces have limited manipulations capabilities and are often frustrating to use. One key reason is that the spreadsheet grid creates a layer that intercepts most user input events, making it difficult to reach the cell values that lie underneath. We conduct an analysis of commercial spreadsheet programs and an elicitation study to understand what users can do and what they would like to do with spreadsheets on interactive surfaces. Informed by these, we design interaction techniques that leverage the precision of the pen to mitigate friction between the different layers. These enable more operations by direct manipulation on and through the grid, targeting not only cells and groups of cells, but values and substrings within and across cells as well. We prototype these interaction techniques and conduct a qualitative study with information workers who perform a variety of spreadsheet operations on their own data.<\/jats:p>","DOI":"10.1145\/3630097","type":"journal-article","created":{"date-parts":[[2023,10,25]],"date-time":"2023-10-25T21:37:44Z","timestamp":1698269864000},"page":"1-33","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":5,"title":["Spreadsheets on Interactive Surfaces: Breaking through the Grid with the Pen"],"prefix":"10.1145","volume":"31","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-6662-7362","authenticated-orcid":false,"given":"Vincent","family":"Cavez","sequence":"first","affiliation":[{"name":"Universit\u00e9 Paris-Saclay, CNRS, Inria, France"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-3050-9284","authenticated-orcid":false,"given":"Caroline","family":"Appert","sequence":"additional","affiliation":[{"name":"Universit\u00e9 Paris-Saclay, CNRS, Inria, France"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-9762-0462","authenticated-orcid":false,"given":"Emmanuel","family":"Pietriga","sequence":"additional","affiliation":[{"name":"Universit\u00e9 Paris-Saclay, CNRS, Inria, France"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2024,1,29]]},"reference":[{"key":"e_1_3_6_2_2","doi-asserted-by":"publisher","DOI":"10.1145\/1518701.1519052"},{"key":"e_1_3_6_3_2","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2021.3114830"},{"key":"e_1_3_6_4_2","volume-title":"The Encyclopedia of Human-Computer Interaction, 2nd edition","author":"Blandford Ann","year":"2013","unstructured":"Ann Blandford. 2013. Semi-structured qualitative studies. In The Encyclopedia of Human-Computer Interaction, 2nd edition, Mads Soegaard and Rikke Friis Dam (Eds.). Interaction Design Foundation."},{"key":"e_1_3_6_5_2","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2011.185"},{"key":"e_1_3_6_6_2","doi-asserted-by":"publisher","DOI":"10.1145\/1385569.1385595"},{"key":"e_1_3_6_7_2","article-title":"Pointer Events Level 2 - W3C Recommendation","author":"Brubeck Matt","year":"2019","unstructured":"Matt Brubeck, Rick Byers, Patrick H. Lauke, and Navid Zolghadr. 2019. Pointer Events Level 2 - W3C Recommendation. https:\/\/www.w3.org\/TR\/pointerevents2\/. (April2019).","journal-title":"https:\/\/www.w3.org\/TR\/pointerevents2\/"},{"key":"e_1_3_6_8_2","doi-asserted-by":"publisher","DOI":"10.1145\/3242587.3242652"},{"key":"e_1_3_6_9_2","doi-asserted-by":"publisher","DOI":"10.1145\/3491102.3501833"},{"key":"e_1_3_6_10_2","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2022.3209385"},{"key":"e_1_3_6_11_2","doi-asserted-by":"publisher","DOI":"10.1145\/1456650.1456652"},{"key":"e_1_3_6_12_2","doi-asserted-by":"publisher","DOI":"10.14778\/2824032.2824127"},{"key":"e_1_3_6_13_2","doi-asserted-by":"publisher","DOI":"10.7551\/mitpress\/10999.003.0005"},{"key":"e_1_3_6_14_2","doi-asserted-by":"publisher","DOI":"10.1145\/3472749.3474784"},{"key":"e_1_3_6_15_2","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-14600-8_18"},{"key":"e_1_3_6_16_2","doi-asserted-by":"publisher","DOI":"10.1145\/2076354.2076356"},{"key":"e_1_3_6_17_2","doi-asserted-by":"publisher","DOI":"10.1109\/ISMAR50242.2020.00063"},{"key":"e_1_3_6_18_2","doi-asserted-by":"publisher","DOI":"10.1080\/00222895.1987.10735426"},{"key":"e_1_3_6_19_2","doi-asserted-by":"publisher","DOI":"10.1145\/1926385.1926423"},{"key":"e_1_3_6_20_2","doi-asserted-by":"publisher","DOI":"10.1145\/2240236.2240260"},{"key":"e_1_3_6_21_2","doi-asserted-by":"publisher","DOI":"10.1145\/2047196.2047205"},{"key":"e_1_3_6_22_2","doi-asserted-by":"publisher","DOI":"10.1145\/2380116.2380156"},{"key":"e_1_3_6_23_2","doi-asserted-by":"publisher","DOI":"10.1145\/1993316.1993536"},{"key":"e_1_3_6_24_2","doi-asserted-by":"publisher","DOI":"10.1145\/2207676.2208327"},{"key":"e_1_3_6_25_2","doi-asserted-by":"publisher","DOI":"10.1145\/1866029.1866036"},{"key":"e_1_3_6_26_2","doi-asserted-by":"publisher","DOI":"10.1145\/3290605.3300523"},{"key":"e_1_3_6_27_2","doi-asserted-by":"publisher","DOI":"10.1109\/VL.1998.706154"},{"key":"e_1_3_6_28_2","unstructured":"Will Cukierski and Jessica Li. 2012. Titanic - Machine Learning from Disaster. (2012). https:\/\/kaggle.com\/competitions\/titanic. Accessed 11-17-2023."},{"key":"e_1_3_6_29_2","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3064034"},{"key":"e_1_3_6_30_2","doi-asserted-by":"publisher","DOI":"10.1145\/3025453.3025752"},{"key":"e_1_3_6_31_2","doi-asserted-by":"publisher","DOI":"10.1145\/1978942.1979444"},{"key":"e_1_3_6_32_2","doi-asserted-by":"publisher","DOI":"10.1145\/3411764.3445265"},{"key":"e_1_3_6_33_2","doi-asserted-by":"publisher","DOI":"10.1109\/PACIFICVIS.2015.7156378"},{"key":"e_1_3_6_34_2","doi-asserted-by":"publisher","DOI":"10.1561\/1100000081"},{"key":"e_1_3_6_35_2","doi-asserted-by":"publisher","DOI":"10.1145\/3526113.3545655"},{"key":"e_1_3_6_36_2","doi-asserted-by":"publisher","DOI":"10.1145\/3313831.3376147"},{"key":"e_1_3_6_37_2","doi-asserted-by":"publisher","DOI":"10.1145\/2254556.2254669"},{"key":"e_1_3_6_38_2","doi-asserted-by":"publisher","DOI":"10.1145\/2512349.2512802"},{"key":"e_1_3_6_39_2","doi-asserted-by":"publisher","DOI":"10.1145\/3132272.3134126"},{"key":"e_1_3_6_40_2","article-title":"Cross-platform handwriting recognition and interactive ink APIs","year":"2022","unstructured":"MyScript. 2022. Cross-platform handwriting recognition and interactive ink APIs. https:\/\/developer.myscript.com. (2022). Last accessed: 2023-09-28.","journal-title":"https:\/\/developer.myscript.com"},{"key":"e_1_3_6_41_2","doi-asserted-by":"publisher","DOI":"10.1145\/191666.191729"},{"key":"e_1_3_6_42_2","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-030-29390-1_24"},{"key":"e_1_3_6_43_2","doi-asserted-by":"publisher","DOI":"10.1145\/2807442.2807460"},{"key":"e_1_3_6_44_2","doi-asserted-by":"publisher","DOI":"10.1145\/2858036.2858201"},{"key":"e_1_3_6_45_2","doi-asserted-by":"publisher","DOI":"10.1145\/3025453.3025567"},{"key":"e_1_3_6_46_2","doi-asserted-by":"publisher","DOI":"10.1145\/948449.948460"},{"key":"e_1_3_6_47_2","doi-asserted-by":"publisher","DOI":"10.1145\/2468356.2468527"},{"key":"e_1_3_6_48_2","doi-asserted-by":"publisher","DOI":"10.1145\/191666.191776"},{"key":"e_1_3_6_49_2","doi-asserted-by":"publisher","DOI":"10.1145\/3025453.3025716"},{"key":"e_1_3_6_50_2","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2019.2950932"},{"key":"e_1_3_6_51_2","doi-asserted-by":"publisher","DOI":"10.1145\/3379337.3415861"},{"key":"e_1_3_6_52_2","doi-asserted-by":"publisher","DOI":"10.1145\/3290605.3300272"},{"key":"e_1_3_6_53_2","doi-asserted-by":"publisher","DOI":"10.1145\/3332165.3347934"},{"key":"e_1_3_6_54_2","doi-asserted-by":"publisher","DOI":"10.1145\/3173574.3173716"},{"key":"e_1_3_6_55_2","doi-asserted-by":"publisher","DOI":"10.1145\/2992154.2992157"},{"key":"e_1_3_6_56_2","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2018.8506584"},{"key":"e_1_3_6_57_2","doi-asserted-by":"publisher","DOI":"10.14778\/2212351.2212356"},{"key":"e_1_3_6_58_2","doi-asserted-by":"publisher","DOI":"10.1080\/10447318.2012.687676"},{"key":"e_1_3_6_59_2","doi-asserted-by":"publisher","DOI":"10.1145\/3313831.3376782"},{"key":"e_1_3_6_60_2","doi-asserted-by":"publisher","DOI":"10.1145\/3429360.3468193"},{"key":"e_1_3_6_61_2","doi-asserted-by":"publisher","DOI":"10.1145\/3279778.3279793"},{"key":"e_1_3_6_62_2","doi-asserted-by":"publisher","DOI":"10.1145\/3182168"},{"key":"e_1_3_6_63_2","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2007.70589"},{"key":"e_1_3_6_64_2","doi-asserted-by":"publisher","DOI":"10.1145\/1978942.1978963"},{"key":"e_1_3_6_65_2","doi-asserted-by":"publisher","DOI":"10.1145\/1518701.1518866"},{"key":"e_1_3_6_66_2","doi-asserted-by":"publisher","DOI":"10.1145\/3025453.3025664"},{"key":"e_1_3_6_67_2","doi-asserted-by":"publisher","DOI":"10.1145\/985921.986098"},{"key":"e_1_3_6_68_2","doi-asserted-by":"publisher","DOI":"10.1145\/2642918.2647390"},{"key":"e_1_3_6_69_2","doi-asserted-by":"publisher","DOI":"10.1145\/1866029.1866035"},{"key":"e_1_3_6_70_2","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2014.2346293"},{"key":"e_1_3_6_71_2","doi-asserted-by":"publisher","DOI":"10.1145\/2851581.2892326"},{"key":"e_1_3_6_72_2","doi-asserted-by":"publisher","DOI":"10.1145\/3290605.3300285"}],"container-title":["ACM Transactions on Computer-Human Interaction"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3630097","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3630097","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T22:50:56Z","timestamp":1750287056000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3630097"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,1,29]]},"references-count":71,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2024,4,30]]}},"alternative-id":["10.1145\/3630097"],"URL":"https:\/\/doi.org\/10.1145\/3630097","relation":{},"ISSN":["1073-0516","1557-7325"],"issn-type":[{"value":"1073-0516","type":"print"},{"value":"1557-7325","type":"electronic"}],"subject":[],"published":{"date-parts":[[2024,1,29]]},"assertion":[{"value":"2023-03-03","order":0,"name":"received","label":"Received","group":{"name":"publication_history","label":"Publication History"}},{"value":"2023-09-26","order":2,"name":"accepted","label":"Accepted","group":{"name":"publication_history","label":"Publication History"}},{"value":"2024-01-29","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}