Skip to content

Features not supported in Web Form 2.0 compared to Excel add-ins

Spreading

Spreading does not support advanced syntax (e.g. "+10%").

Matrix Layout options

The column autofit function is supported 'by value' but not 'by template'. The 'from template' option is ignored in web forms, the 'from value' option is always used.

Drill Down

In Drill Down, only row/column drill down is supported.

The Cell Drill down is partly covered by the ad-hoc analysis.

Slicer

Slicers have not been implemented in Web Forms 2.0.

It is recommended to use the filter panel of web forms to change parameter values at runtime, and the Cell Field objects to display parameter values within the form.

Autofit rows

The row autofit function is supported for LBL forms. However, it is not supported in multidimensional forms.

Autofit Column

Autofit rules for columns 'from template' ('From Value' is supported)

Validation checks

Watch Expressions in matrices (both outside and inside the matrix) are supported but are implemented differently than in Excel add-ins.

The when saving and when closed flags do not work in Web Forms 2.0 as expressions are continuously evaluated and messages about violated expressions are displayed in a box in the top right-hand corner. Breach of the blocking expressions, shown in red in the box, prevents data from being saved.

Tagetik Hyperlinks are supported.

The reference to the Excel cell must only refer to cells in the current sheet.

When opening the form, transferring parameters via Excel cell is not supported.

Features not supported in Web Forms

Below is a list of functionalities that are not supported by Web Forms.

This is not to be intended as n exhaustive list. in general, Web forms are based on a completely different technology, architecture and codebase than Excel add-ins. For this reason, it is not guaranteed that forms executed as Web forms will support the same features and behave the same way as they do when executed using the Excel add-in.

  • Macros or VBA objects.

  • Work offline.

  • Report list.

  • Reporting Cell-based (TGKSend, TGKRet, ecc.).

  • Hidden comments.

  • Hidden sheets.

  • Save / Load formulas.

  • Show formulas used.

  • Reference to Spreadsheet Cell in Query Form (e.g. using the syntax ${A1} to refer to the spreadsheet cell A1 in the selection).

Excel formulas

List of Excel Formulas supported in Web forms 2.0: http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#FormulaFunctions.html

Cell Formats and Locale

The decimal and thousand separators for numeric formats depend on the nationality set in the Tagetik user configuration.

The date/time formats depend on the country set in the Tagetik user configuration. It cannot be guaranteed that the data and number format will always be the same as that applied by MS Excel. Here are some examples of such differences:

  • For Japan, the 'short date' format, unlike MS Excel, always uses two characters for the month (e.g. Excel '1976/8/30', but Web form 2.0 '1976/08/30');

  • For the U.K. and Italy, the format '30/8/76 16:28', unlike MS Excel, always uses two numbers for the year (e.g. Excel '30/8/1976 16:28', but Web form 2.0 '30/8/76 16:28');

  • For Poland, the 'long date' format may use alternative names for months and days of the week, different from those used by MS Excel;

  • For Turkey, the thousand separator is a space instead of a dot;

  • The 'short date' and 'long date' formats with '*' are not dependent on the user's locale.

  • Formats with a fixed locale set from Excel's Design area (such as 14-Mar-18) are adapted to the user's locale, except when the fixed locale is American (EN_US), Chinese (ZH_CN), or Japanese (JA_JP)

Validation Query

If elements generated by the query that can be selected in cells include numbers only (e.g. "01", "02", etc.), the cell formatting type must be "General" or "Text", otherwise, when the value is selected, the system could remove the zero and treat the selected value as a number. In contrast, the Excel client always treats the selected value as text. .

Excel table defined in the Query result area

If an Excel table is defined within the query result area, the Excel table will not be present in web forms.

Single Template and Multi-Template

The use of 'named ranges' in formulas or charts is not recommended when using sheet filters, as they may not be correctly evaluated in spreadsheets following the first one in each template (e.g. formulas with names generated by Tagetik using custom queries).

Charts may lose some of their formatting and colour palette (if the standard palette is not in use) in the sheets following the first one.

Managing Dictionary Items Outside the Matrix

Dictionary items have not been implemented, outside the Matrix, in web forms 2.0

Edit monthly ICs in Web Forms

The modification of monthly ICs for AIH matrices was not implemented in Web Forms 2.0.

Multidimensional forms - saving

Saving data in multidimensional forms when non-incremental saving is active (all dimensions are at the highest level of detail)

Download PDF

Web form can only be downloaded as .xlsx file; downloading PDFs has not been implemented in Web Forms 2.0.

Matrix Cell Properties for overridden contents

The Cell Properties functionality is not supported if the cell content is overridden.