FXL Data changes in Hotfix February 2025

From Fusion Registry Wiki
Jump to navigation Jump to search

Background

In February 2025, a new version of FXLData was made available via an “on request” Hotfix.

This new version addresses several issues identified by users including, to stablise the product, removing the difference between using the Legacy Mode features (these catered for users who used Microsoft Excel 2010-2019) and those using subsequent versions i.e., MS Office 365.

When this version is incorporated into the next full release of the Fusion Regnology product suite, the wiki will be updated accordingly but, in the meantime, this is a summary of the key changes.

Appearance

On opening Excel and enabling the latest version of the FX Data add-in, you will notice two significant changes.

Appearance.png


Legacy Mode

The need for Legacy mode has been superseded by the removal of the Automatic Calculation facility. The Refresh button now works as expected and will perform an update on request.

As part of the change you will notice that the ampersand is inserted into the query shown in the formula bar.

Example: 

@FXLData("https://demo.metadatatechnology.com/FusionRegistry","WB,WDI_POVERTY,1.0",".SI_DST_02ND_20+SI_DST_03RD_20+SI_DST_04TH_20.",100,,,,"id","TRUE","FALSE","TRUE","FALSE","")

Refresh

FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here Refresh article a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed here.

Note that if the formula itself is deleted, you will also need to delete any returned data.

Diagnostic Tool

This feature has been introduced to help Regnology diagnose any issues encountered when using FXL Data. By default, the feature is switched off. When required, two options are available which supply different levels of detail. When the tool is enabled a log file will be created.

Diagnostic tool.png

Other point to note

Functions

The TimeFormatFrequencyID parameter is now available when using the Functions:

  • FXLDataURL
  • FXLDataURLV
  • FXLDataURLFact

TimeFormatFrequencyID.png


FXL DataRefreshable Worksheet

The basic functionality as decsribed here remains unchanged however please note that to retrieve the actual data, use the Refresh button to update.

Change Log

The function =FXLDataVersion("changelog") displays the change log which is now displayed in reverse chronological order.

Retrieved from "https://wiki.sdmxcloud.org/index.php?title=FXL_Data_changes_in_Hotfix_February_2025&oldid=7579"