{"id":2098,"date":"2025-08-27T20:16:53","date_gmt":"2025-08-27T12:16:53","guid":{"rendered":"https:\/\/www.tonghin.com.my\/blog\/?p=2098"},"modified":"2025-08-27T20:16:53","modified_gmt":"2025-08-27T12:16:53","slug":"building-excel-like-editable-ui","status":"publish","type":"post","link":"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/","title":{"rendered":"Building Excel-like Editable UI"},"content":{"rendered":"\n<p>Monday, August 11, 2025 \u2013 Last week, I was assigned a new feature by Mr. Peter. The goal was to design a UI similar to Excel, where users could freely edit cells, and moving to the next cell would automatically save changes. Additionally, certain fields needed to be auto-calculated based on the updates.<\/p>\n\n\n\n<p>To start, I created a simple get list UI, which was fairly straightforward. Afterward, I moved on to the UI portion, focusing on building a simple display list.<\/p>\n\n\n\n<p>Next, I worked on an update command so that users could update data line by line instead of saving the entire list at once. This approach would be faster, but at first, I skipped adding the full calculation logic and only tested the basic command. I then integrated the UI with the update command. Unfortunately, it didn\u2019t work as expected, the event wasn\u2019t being triggered.<\/p>\n\n\n\n<p>Towards the end of the week, Mr. Peter helped me identify the issue. It turned out there was a small mistake in the naming convention within the UI, which I had overlooked. Once corrected, the update event worked as intended.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Monday, August 11, 2025 \u2013 Last week, I was assigned a new feature by Mr. Peter. The goal was to design a UI similar to Excel, where users could freely edit cells, and moving to the next cell would automatically save changes. Additionally, certain fields needed to be auto-calculated based on the updates. To start, &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Building Excel-like Editable UI&#8221;<\/span><\/a><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Building Excel-like Editable UI | Tong Hin&#039;s Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Building Excel-like Editable UI | Tong Hin&#039;s Blog\" \/>\n<meta property=\"og:description\" content=\"Monday, August 11, 2025 \u2013 Last week, I was assigned a new feature by Mr. Peter. The goal was to design a UI similar to Excel, where users could freely edit cells, and moving to the next cell would automatically save changes. Additionally, certain fields needed to be auto-calculated based on the updates. To start, &hellip; Continue reading &quot;Building Excel-like Editable UI&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/\" \/>\n<meta property=\"og:site_name\" content=\"Tong Hin&#039;s Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-27T12:16:53+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data1\" content=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/#organization\",\"name\":\"TONG HIN MACHINERY\",\"url\":\"https:\/\/www.tonghin.com.my\/blog\/\",\"sameAs\":[\"https:\/\/www.youtube.com\/channel\/UC60EoxJMNbu8mV0LuEGfrBg\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.tonghin.com.my\/blog\/wp-content\/uploads\/2020\/10\/web_logo_180_180.jpg\",\"width\":180,\"height\":180,\"caption\":\"TONG HIN MACHINERY\"},\"image\":{\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/#website\",\"url\":\"https:\/\/www.tonghin.com.my\/blog\/\",\"name\":\"Tong Hin&#039;s Blog\",\"description\":\"Sharing About Technology\",\"publisher\":{\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.tonghin.com.my\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/#webpage\",\"url\":\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/\",\"name\":\"Building Excel-like Editable UI | Tong Hin&#039;s Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/#website\"},\"datePublished\":\"2025-08-27T12:16:53+00:00\",\"dateModified\":\"2025-08-27T12:16:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/\",\"url\":\"https:\/\/www.tonghin.com.my\/blog\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/\",\"url\":\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/\",\"name\":\"Building Excel-like Editable UI\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/#webpage\"},\"author\":{\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/#\/schema\/person\/81e2366362d8d14b15519395755cee6f\"},\"headline\":\"Building Excel-like Editable UI\",\"datePublished\":\"2025-08-27T12:16:53+00:00\",\"dateModified\":\"2025-08-27T12:16:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/2025\/08\/27\/building-excel-like-editable-ui\/#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/#organization\"},\"articleSection\":\"Experiential\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/#\/schema\/person\/81e2366362d8d14b15519395755cee6f\",\"name\":\"nurlailiyuzi\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.tonghin.com.my\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c0d4cc6f7fc881bd56d95bdbb0c4c14?s=96&d=mm&r=g\",\"caption\":\"nurlailiyuzi\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.tonghin.com.my\/blog\/wp-json\/wp\/v2\/posts\/2098"}],"collection":[{"href":"https:\/\/www.tonghin.com.my\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tonghin.com.my\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tonghin.com.my\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tonghin.com.my\/blog\/wp-json\/wp\/v2\/comments?post=2098"}],"version-history":[{"count":1,"href":"https:\/\/www.tonghin.com.my\/blog\/wp-json\/wp\/v2\/posts\/2098\/revisions"}],"predecessor-version":[{"id":2099,"href":"https:\/\/www.tonghin.com.my\/blog\/wp-json\/wp\/v2\/posts\/2098\/revisions\/2099"}],"wp:attachment":[{"href":"https:\/\/www.tonghin.com.my\/blog\/wp-json\/wp\/v2\/media?parent=2098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tonghin.com.my\/blog\/wp-json\/wp\/v2\/categories?post=2098"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tonghin.com.my\/blog\/wp-json\/wp\/v2\/tags?post=2098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}