Difference between revisions of "FXL Data changes in Hotfix February 2025"
(→Refresh) |
(→Diagnostic Tool) |
||
| (12 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
[[File:Appearance.png|800px]] | [[File:Appearance.png|800px]] | ||
| − | |||
=== [[Legacy Mode - FXLData |Legacy Mode]] === | === [[Legacy Mode - FXLData |Legacy Mode]] === | ||
| Line 18: | Line 17: | ||
As part of the change you will notice that the ampersand is inserted into the query shown in the formula bar. | As part of the change you will notice that the ampersand is inserted into the query shown in the formula bar. | ||
| − | '''Example:''' | + | '''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 === | === Refresh === | ||
| − | + | This article can now be found [[FXLData_Refresh|here]] | |
| − | + | === Diagnostic Tool === | |
| − | + | This article can now be found [[FXLData_Diagnostics|here]] | |
| − | === | + | === Other point to note === |
| − | + | ==== Functions ==== | |
| + | The TimeFormatFrequencyID parameter is now available when using the Functions: | ||
| + | * FXLDataURL | ||
| + | * FXLDataURLV | ||
| + | * FXLDataURLFact | ||
| + | |||
| + | [[File:TimeFormatFrequencyID.png|500px]] | ||
| + | |||
| + | ==== FXL DataRefreshable Worksheet ==== | ||
| + | The basic functionality as decsribed [[FXLData Refreshable Worksheet|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. | ||
Latest revision as of 08:35, 15 June 2026
Contents
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.
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
This article can now be found here
Diagnostic Tool
This article can now be found here
Other point to note
Functions
The TimeFormatFrequencyID parameter is now available when using the Functions:
- FXLDataURL
- FXLDataURLV
- FXLDataURLFact
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.
