# What's New in TX Text Control ActiveX 26.0 > TX Text Control ActiveX 26.0: tracked changes, loading SpreadsheetML (.xlsx), formulas in table cells in A1 or R1C1 notation and cell references in TXRulerBar. - **Product:** TX Text Control ActiveX - **Section:** Documentation - **Kind:** Topic - **Path:** TX Text Control ActiveX > What's New > Older Versions > What's New in TX Text Control ActiveX 26.0 - **2531 words** - **Web URL:** https://docs.textcontrol.com/tx-text-control-activex/whats-new/older-versions/2600/ - **LLMs URL:** https://docs.textcontrol.com/tx-text-control-activex/whats-new/older-versions/2600/llms.txt - **LLMs-Full URL:** https://docs.textcontrol.com/tx-text-control-activex/whats-new/older-versions/2600/llms-full.txt --- Developers who maintain a TX Text Control ActiveX 26.0 application, or upgrade one from version 25.0, find here what the version added: tracked changes, the SpreadsheetML format, formulas in table cells, cell references in the ruler bar and two new keyboard actions in tables. The new and extended properties, methods and events follow the features. ### New Features - **Tracked changes.** Track changes shows who has made text changes to a document. The new [IsTrackChangesEnabled](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/istrackchangesenabled-property/llms-full.txt) property turns it on or off. While it is on, `TXTextControl` marks up new text changes made to the document; when it is turned off, new changes are no longer marked up. Changes that were already tracked stay marked up in the document until they are removed. - **Enumerate changes.** [TrackedChangeNext](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangenext-method/llms-full.txt) enumerates all tracked changes of a document. [TrackedChangeStart](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangestart-property/llms-full.txt) and [TrackedChangeEnd](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangeend-property/llms-full.txt) return the position of a change in the text, and [TrackedChangeKind](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangekind-property/llms-full.txt) returns its kind: deleted or inserted text. - **Accept or reject.** The only way to remove tracked changes from a document is to accept or reject them with the [TrackedChangeDelete](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangedelete-method/llms-full.txt) method. - **Users and times.** Each tracked change has a change time ([TrackedChangeTime](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangetime-property/llms-full.txt) property) and is related to a user ([TrackedChangeUserName](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangeusername-property/llms-full.txt) property). A new tracked change is associated with the current user, the first in the list of users set with the [UserNames](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/usernames-property/llms-full.txt) property. When the list is empty, the name is set to an empty string, which stands for an unknown user. - **Events.** Events occur when a tracked change is created ([TrackedChangeCreated](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangecreated-event/llms-full.txt)), deleted ([TrackedChangeDeleted](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangedeleted-event/llms-full.txt)) or changed ([TrackedChangeChanged](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangechanged-event/llms-full.txt)). - **Highlighting.** A tracked change is highlighted on the screen in a color that depends on the user; the default color for the current user is red. Inserted text is shown as colored text, deleted text as colored, struck-through text. - **Changes that can't be tracked.** Some complex text operations, such as deleting a table column, can't be tracked. In these cases, the [CannotTrackChange](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/cannottrackchange-event/llms-full.txt) event occurs, and the end user decides whether the change is made. - **File formats.** Tracked changes are saved and reloaded with the TX Text Control format (.tx), the Rich Text Format (.rtf) and the Microsoft Word formats (.doc, .docx). - **SpreadsheetML format.** In addition to WordprocessingML, TX Text Control supports the **SpreadsheetML** part of the *Microsoft Office Open XML* format. SpreadsheetML is a ZIP-compressed XML format for spreadsheets and the standard format of Microsoft Excel. `TXTextControl` loads **.xlsx** files: the **Format** parameter of the [Load](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/load-method/llms-full.txt) method accepts a new value for this format. The import is limited to the content of the first worksheet of the document, and formulas with cell references into other worksheets or files are not supported. - **Formulas in tables.** TX Text Control calculates table cells with formulas. A formula is a property of a table cell. It is either loaded with a **SpreadsheetML** document or inserted with the [TableCellFormula](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/tablecellformula-property/llms-full.txt) and [TableCellNumberFormat](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/tablecellnumberformat-property/llms-full.txt) properties. - **Automatic updates.** A formula can reference other table cells, and the text of a formula cell is updated automatically when the content of an input cell changes. [IsFormulaCalculationEnabled](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/isformulacalculationenabled-property/llms-full.txt) switches automatic updating off. A formula cell can be the input cell of another formula cell. - **Cell references.** Cells are referenced in the A1 or the R1C1 notation, and [FormulaReferenceStyle](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/formulareferencestyle-property/llms-full.txt) switches between them. The A1 notation specifies a cell by a column letter and a row number: B3 is the cell in the third row and the second column. The R1C1 notation specifies a cell by a row number and a column number: R3C2 is the same cell. Square brackets express relative addresses, such as R\[-2\]C\[-3\]. The numbers inside the brackets say how many rows or columns the referenced cell is away from the cell itself. A negative row number means the referenced cell is above the cell that contains the formula; a negative column number means it is to the left of it. - **Dialog box.** The dialog box of [TableAttrDialog](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/tableattrdialog-method/llms-full.txt) has been extended with a third tab, which sets a formula and a number format for one or more table cells. - **Limitations.** Cell references to other tables or to document files are not supported. Number formats are restricted to positive number formats. - **More information.** [Using Formulas in Table Cells](https://docs.textcontrol.com/tx-text-control-activex/document-editor/tables/formulas/llms-full.txt) describes formulas, and [Number Formats](https://docs.textcontrol.com/tx-text-control-activex/document-editor/tables/number-formats/llms-full.txt) describes how to format their results. [Supported Formula Functions](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/llms-full.txt) lists all functions a formula can use. ![The Formulas tab of the built-in Table Properties dialog box of TX Text Control ActiveX 34.0, with the formula, the functions, the reference style and the number format.](https://docs.textcontrol.com/assets/img/tx-text-control-activex/table-properties-formulas.cecddac8.webp) - **Ruler bars.** The new [TXRulerBar.FormulaMode](https://docs.textcontrol.com/tx-text-control-activex/reference/txrulerbar/formulamode-property/llms-full.txt) property supports formulas in tables by showing cell references. Depending on the [TXTextControl.FormulaReferenceStyle](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/formulareferencestyle-property/llms-full.txt) property, table cells are addressed in the A1 or the R1C1 notation. Depending on the mode, cell references are shown for all cells or only for cells that contain a formula. - **Keyboard interface.** Pressing the TAB key in the last cell of a table now inserts a new table row at the end of the table. Pressing the ENTER key at the first input position of a document that begins with a table now inserts an empty line in front of the table. ### New Properties, Methods and Events Version 26.0 adds members to `TXTextControl` and one property to `TXRulerBar`. #### Properties | Member | Description | |---|---| | [TXRulerBar.FormulaMode](https://docs.textcontrol.com/tx-text-control-activex/reference/txrulerbar/formulamode-property/llms-full.txt) | Gets or sets a value specifying whether the ruler bar shows cell references when the current input position is in a table cell. | | [TXTextControl.FormulaReferenceStyle](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/formulareferencestyle-property/llms-full.txt) | Gets or sets a value determining how references to table cells in formulas are specified. | | [TXTextControl.IsFormulaCalculationEnabled](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/isformulacalculationenabled-property/llms-full.txt) | Gets or sets a value indicating whether formulas in tables are calculated automatically when the text of an input cell is changed. | | [TXTextControl.IsTrackChangesEnabled](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/istrackchangesenabled-property/llms-full.txt) | Gets or sets a value indicating whether track changes is active. | | [TXTextControl.TableCellFormula](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/tablecellformula-property/llms-full.txt) | Returns or sets the table cell's formula. | | [TXTextControl.TableCellNumberFormat](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/tablecellnumberformat-property/llms-full.txt) | Returns or sets a number format for the table cell. | | [TXTextControl.TableCellTextType](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/tablecelltexttype-property/llms-full.txt) | Returns or sets the text type of the table cell, which determines whether the cell's text is interpreted as a number or as text. | | [TXTextControl.TrackedChangeEnd](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangeend-property/llms-full.txt) | Returns the index (one-based) of the last character of the specified tracked change. | | [TXTextControl.TrackedChangeKind](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangekind-property/llms-full.txt) | Returns the kind of tracked change. | | [TXTextControl.TrackedChangeStart](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangestart-property/llms-full.txt) | Returns the index (one-based) of the first character of the specified tracked change. | | [TXTextControl.TrackedChangeTime](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangetime-property/llms-full.txt) | Returns the date and time when the change has been made. | | [TXTextControl.TrackedChangeUserName](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangeusername-property/llms-full.txt) | Returns the name of the user who has changed the document. | #### Methods | Member | Description | |---|---| | [TXTextControl.TrackedChangeDelete](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangedelete-method/llms-full.txt) | Removes a tracked change from the document. | | [TXTextControl.TrackedChangeNext](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangenext-method/llms-full.txt) | Returns the identifier of the tracked change that follows the specified tracked change in the current text of `TXTextControl`. | #### Events | Member | Description | |---|---| | [TXTextControl.CannotTrackChange](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/cannottrackchange-event/llms-full.txt) | Determines how to handle a change of the document that can't be added to the list of tracked changes. | | [TXTextControl.TrackedChangeChanged](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangechanged-event/llms-full.txt) | Occurs when the text of a tracked change has been altered. | | [TXTextControl.TrackedChangeCreated](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangecreated-event/llms-full.txt) | Occurs when a tracked change has been created. | | [TXTextControl.TrackedChangeDeleted](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/trackedchangedeleted-event/llms-full.txt) | Occurs when a tracked change has been deleted. | ### Extended Properties, Methods and Events | Member | Change | |---|---| | [Load](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/load-method/llms-full.txt) method | Accepts the new value **15 - SpreadsheetML** to load SpreadsheetML documents (\*.xlsx). | | [LoadSaveAttribute](https://docs.textcontrol.com/tx-text-control-activex/reference/txtextcontrol/loadsaveattribute-property/llms-full.txt) property | Extended with the **txLoadDocumentParts** attribute, which enables loading SpreadsheetML documents with several worksheets. | ### Related Pages - [Version 27.0](https://docs.textcontrol.com/tx-text-control-activex/whats-new/older-versions/2700/llms-full.txt): DPI awareness and highlighted text fields. - [Version 25.0](https://docs.textcontrol.com/tx-text-control-activex/whats-new/older-versions/2500/llms-full.txt): the features of the previous version. - [Tracking Document Changes](https://docs.textcontrol.com/tx-text-control-activex/reference/categories/track-changes/llms-full.txt): all members for tracked changes. - [Using Formulas in Table Cells](https://docs.textcontrol.com/tx-text-control-activex/document-editor/tables/formulas/llms-full.txt): formulas and cell references in detail. - [What's New](https://docs.textcontrol.com/tx-text-control-activex/whats-new/llms-full.txt): the changes of every TX Text Control ActiveX version. --- ## Nearby - **Previous:** [What's New in TX Text Control ActiveX 27.0](https://docs.textcontrol.com/tx-text-control-activex/whats-new/older-versions/2700/llms-full.txt) - **Next:** [What's New in TX Text Control ActiveX 25.0](https://docs.textcontrol.com/tx-text-control-activex/whats-new/older-versions/2500/llms-full.txt)