Microsoft Excel Function Support
TDV supports the Microsoft Excel functions listed in the table below.
TDV Excel integration is through the Apache POI project. The following supported function list and limitations are based on the open source documentation for that project. Further details can be found on the Web.
Function or Operator | Notes |
Operators | Arithmetic and logical operators; some region operators. |
Built-in functions | More than 350 recognized. |
Add-in functions | Three from Analysis Toolpak recognized. |
Limitations
The following is a list of some of the known limitations of TDV’s implementation of Microsoft Excel functions:
• TDV cannot manipulate Excel array or table formulas of the form “{=...}” (rather than of the form “=...”).
• TDV cannot handle the region operators (UNION and INTERSECTION).
• TDV cannot parse add-in functions that have not previously been called.
• TDV cannot preserve white space in formulas.
• TDV cannot convert charts or macros to TDV objects.
• TDV does not support pivot tables.