Sneak Peek X16: Selecting Reference Cells for Table Formulas
One of the major features of the next version X16 is the integration of MS Excel compatible table formulas.
We already introduced MS Excel compatible formulas in a recent blog entry as a new major feature of the next TX Text Control version X16. Today, we would like to show the latest look and feel that has been already presented on conferences over the last weeks.
The following screenshot shows the table contextual ribbon tabs including the Formulas tab that can be used out-of-the-box in your applications without any additional lines of code:
The TX Text Control API returns a list of supported functions and supported number formats that are available in the ribbon UI:
Each cell can be adjusted to display text or numbers. If a formula cell text type is a number, a number format can be specified which is used to format the formula results automatically:
The following screen video shows how to select a table cell range for a SUM formula:
A demo application will be shipped with the setup that shows how to implement this interface on your own using the TX Text Control API. The next screenshot shows the C# Windows Forms sample with a traditional button bar UI interface:
Stay tuned for more features!
Jump to the other posts in this series:
- Sneak Peek X16: Excel Formulas and MailMerge
- Sneak Peek X16: MS Word Compatible Track Changes
- Sneak Peek X16: Filter and Sort MergeBlock Rows
- Sneak Peek X16: New Customizable Sidebar Controls
- Sneak Peek X16: Working with Formulas in Table Cells
- Sneak Peek X16: Selecting Reference Cells for Table Formulas
Related Posts
ReportingCloud: Backend Updated to TX Text Control X16
We just updated ReportingCloud to the latest version of TX Text Control X16 that comes with loads of new features that can be used in the reporting Web API now as well.
Automatically Format Numbers in Table Cells
The NumberFormat property can be used to automatically format numbers in table cells. This article shows how to use this feature.
Opening Microsoft Excel files with TX Text Control X16
Using TX Text Control X16, Excel spreadsheets can be imported into documents. This article shows several ways to work with Excel worksheets.
Sneak Peek X16: Excel Formulas and MailMerge
With the release of TX Text Control X16, Excel compatible formulas can be used in table cells. This article shows how to utilize them within MailMerge templates.
TX Text Control 33.0 SP3 is Now Available: What's New in the Latest Version
TX Text Control 33.0 Service Pack 3 is now available, offering important updates and bug fixes for all platforms. If you use TX Text Control in your document processing applications, this service…