# Sneak Peek X16: Working with Formulas in Table Cells > TX Text Control X16 adds Microsoft Excel compatible formulas in table cells using the R1C1 reference style. Over 60 mathematical and trigonometric functions update dynamically when referenced cell values change, and integrate with MailMerge for data-driven calculated reports. - **Author:** Bjoern Meyer - **Published:** 2018-07-25 - **Modified:** 2026-03-05 - **Description:** TX Text Control X16 adds Microsoft Excel compatible formulas in table cells using the R1C1 reference style. Over 60 mathematical and trigonometric functions update dynamically when referenced cell values change, and integrate with MailMerge for data-driven calculated reports. - **2 min read** (381 words) - **Tags:** - ASP.NET - Release - Windows Forms - WPF - **Web URL:** https://www.textcontrol.com/blog/2018/07/25/sneak-peek-working-with-formulas-in-table-cells/ - **LLMs URL:** https://www.textcontrol.com/blog/2018/07/25/sneak-peek-working-with-formulas-in-table-cells/llms.txt - **LLMs-Full URL:** https://www.textcontrol.com/blog/2018/07/25/sneak-peek-working-with-formulas-in-table-cells/llms-full.txt --- We did not announce an official release date for version X16 (26.0), but we already published several articles explaining features we are working on. Today, we would like to present another feature that will be part of TX Text Control X16: Microsoft Excel compatible formulas in tables. Consider a value of a table cell that is calculated dynamically based on other table cell values. Typically, a SUM formula is inserted at the end of a table to create a total sum value. Or a tax value that is calculated based on a tax percentage value and the calculated total sum. Consider the following very basic table with a formula at the end that basically creates a sum of the above table rows. Cell references contained in formulas must use the relative *R1C1 reference style* (example: R\[-1\]C\[3\]). ![Table with formula](https://s1-www.textcontrol.com/assets/dist/blog/2018/07/25/a/assets/table_formula.webp "Table with formula") When the referenced cell values are changed, the cell with the formula is calculated dynamically: ![Table with formula](https://s1-www.textcontrol.com/assets/dist/blog/2018/07/25/a/assets/animation_formula.webp "Table with formula") TX Text Control will support 60+ formulas including most mathematical and trigonometric formulas compatible to Microsoft Excel. Additionally, in TX Text Control X16 it will be possible to load Excel XLSX files directly in order to import the spreadsheet into a table including formulas and table number formats. This feature is getting interesting in combination with TXTextControl.DocumentServer.MailMerge classwhere referenced cells are populated with data dynamically. Consider the following template showing a balance sheet: ![Table with formula](https://s1-www.textcontrol.com/assets/dist/blog/2018/07/25/a/assets/balancesheet.webp "Table with formula") The following sample data is used to merge the template: ``` 234 123 3424 223 8982 9000 ``` The merge fields are populated with data from the XML and the formula cells are updated automatically: ![Table with formula](https://s1-www.textcontrol.com/assets/dist/blog/2018/07/25/a/assets/animation_balancesheet.webp "Table with formula") Table cell formulas allow you to create views with calculated fields that are not part of your business object or pre-shaped data. Together with the new [filter and sorting](https://www.textcontrol.com/blog/2018/04/26/sneak-peek-x16-filter-and-sort-mergeblock-rows/llms-full.txt) options for repeating blocks, *MailMerge* is getting even more flexible. Stay tuned for more! --- ## About Bjoern Meyer As CEO, Bjoern is the visionary behind our strategic direction and business development, bridging the gap between our customers and engineering teams. His deep passion for coding and web technologies drives the creation of innovative products. If you're at a tech conference, be sure to stop by our booth - you'll most likely meet Bjoern in person. With an advanced graduate degree (Dipl. Inf.) in Computer Science, specializing in AI, from the University of Bremen, Bjoern brings significant expertise to his role. In his spare time, Bjoern enjoys running, paragliding, mountain biking, and playing the piano. - [LinkedIn](https://www.linkedin.com/in/bjoernmeyer/) - [X](https://x.com/txbjoern) - [GitHub](https://github.com/bjoerntx) --- ## Series - [Sneak Peek X16: Excel Formulas and MailMerge](https://www.textcontrol.com/blog/2018/10/30/sneak-peel-x16-excel-formulas-and-mailmerge/llms.txt) - [Sneak Peek X16: MS Word Compatible Track Changes](https://www.textcontrol.com/blog/2018/04/24/sneak-peek-x16-ms-word-compatible-track-changes/llms.txt) - [Sneak Peek X16: Filter and Sort MergeBlock Rows](https://www.textcontrol.com/blog/2018/04/26/sneak-peek-x16-filter-and-sort-mergeblock-rows/llms.txt) - [Sneak Peek X16: New Customizable Sidebar Controls](https://www.textcontrol.com/blog/2018/05/02/sneak-peek-x16-new-customizable-sidebar-controls/llms.txt) - **Sneak Peek X16: Working with Formulas in Table Cells** (this article) - [Sneak Peek X16: Selecting Reference Cells for Table Formulas](https://www.textcontrol.com/blog/2018/10/03/sneak-peek-x16-select-reference-cells-for-table-formulas/llms.txt) --- ## Related Posts - [TX Spell .NET 11.0 SP1 is Now Available: What's New in the Latest Version](https://www.textcontrol.com/blog/2026/04/08/tx-spell-net-11-0-sp1-is-now-available/llms.txt) - [TX Text Control 34.0 SP2 is Now Available: What's New in the Latest Version](https://www.textcontrol.com/blog/2026/02/18/tx-text-control-34-0-sp2-is-now-available/llms.txt) - [TX Text Control 34.0 SP1 is Now Available: What's New in the Latest Version](https://www.textcontrol.com/blog/2025/12/03/tx-text-control-34-0-sp1-is-now-available/llms.txt) - [Introducing TX Text Control 34.0: Your Next Leap in Document Processing](https://www.textcontrol.com/blog/2025/11/10/introducing-tx-text-control-34-0-your-next-leap-in-document-processing/llms.txt) - [Sneak Peek: TX Text Control 34.0 Coming November 2025](https://www.textcontrol.com/blog/2025/10/02/sneak-peek-tx-text-control-34-0-coming-november-2025/llms.txt) - [TX Text Control 33.0 SP3 is Now Available: What's New in the Latest Version](https://www.textcontrol.com/blog/2025/08/14/tx-text-control-33-0-sp3-is-now-available/llms.txt) - [TX Text Control 33.0 SP2 is Now Available: What's New in the Latest Version](https://www.textcontrol.com/blog/2025/06/18/tx-text-control-33-0-sp2-is-now-available/llms.txt) - [Service Pack Releases: What's New in TX Text Control 33.0 SP1 and 32.0 SP5](https://www.textcontrol.com/blog/2025/05/07/service-pack-releases-whats-new-in-tx-text-control-33-0-sp1-and-32-0-sp5/llms.txt) - [The Wait is Over: TX Text Control for Linux is Officially Here](https://www.textcontrol.com/blog/2025/03/12/the-wait-is-over-tx-text-control-for-linux-is-officially-here/llms.txt) - [Full .NET 9 Support in Text Control .NET Components for ASP.NET Core, Windows Forms, and WPF](https://www.textcontrol.com/blog/2024/11/11/full-net-9-support-in-text-control-net-components-for-asp-net-core-windows-forms-and-wpf/llms.txt) - [TX Text Control 32.0 Service Pack 4 Released](https://www.textcontrol.com/blog/2024/09/02/tx-text-control-32-0-service-pack-4-released/llms.txt) - [Service Pack 3: MailMerge Supports SVG Images](https://www.textcontrol.com/blog/2024/04/29/service-pack-3-mailmerge-supports-svg-images/llms.txt) - [TX Text Control 32.0 Service Pack 3 Released](https://www.textcontrol.com/blog/2024/04/29/tx-text-control-32-0-service-pack-3-released/llms.txt) - [32.0 Service Pack 2: Licensing, Unit Testing, and Azure DevOps](https://www.textcontrol.com/blog/2024/01/05/32-0-service-pack-2-licensing-unit-testing-and-azure-devops/llms.txt) - [Service Pack 1 for TX Text Control 32.0 Released](https://www.textcontrol.com/blog/2023/11/22/service-pack-1-for-tx-text-control-32-released/llms.txt) - [Service Pack 4 for TX Text Control 31.0 Released](https://www.textcontrol.com/blog/2023/09/19/service-pack-4-for-tx-text-control-31-released/llms.txt) - [TX Text Control 32.0 Has Been Released](https://www.textcontrol.com/blog/2023/09/13/tx-text-control-320-has-been-released/llms.txt) - [Sneak Peek 32.0: Modifying the Normal Stylesheet](https://www.textcontrol.com/blog/2023/07/04/sneak-peek-320-modifying-the-normal-stylesheet/llms.txt) - [Sneak Peek 32.0: Introducing Footnotes](https://www.textcontrol.com/blog/2023/06/23/sneak-peek-320-introducing-footnotes/llms.txt) - [Service Pack 3 for TX Text Control 31.0 Released](https://www.textcontrol.com/blog/2023/06/22/service-pack-3-for-tx-text-control-31-released/llms.txt) - [Service Pack 2 for TX Text Control 31.0 Released](https://www.textcontrol.com/blog/2023/02/22/service-pack-2-for-tx-text-control-31-released/llms.txt) - [Service Pack 1 for TX Text Control 31.0 Released](https://www.textcontrol.com/blog/2022/12/16/service-pack-1-for-tx-text-control-31-released/llms.txt) - [Service Pack 3 for TX Text Control 30.0 Released](https://www.textcontrol.com/blog/2022/09/20/service-pack-3-for-tx-text-control-30-released/llms.txt) - [TX Text Control 31.0 and TX Spell .NET 10.0 Have Been Released](https://www.textcontrol.com/blog/2022/09/07/tx-text-control-31-released/llms.txt) - [Visual Studio 2022 and .NET 5, 6 and 7 (Preview) Support and Strategy](https://www.textcontrol.com/blog/2022/08/11/visual-studio-2022-net-5-6-7-support-and-strategy/llms.txt)