Difference between revisions of "FXLData what's new in R1.3.03"
| Line 7: | Line 7: | ||
Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]] | Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]] | ||
| + | |||
| + | == FXLData Tab == | ||
| + | On opening Excel and enabling the latest version of the FX Data add-in, you will several significant changes on the FXLData Tab within Excel. | ||
| + | |||
| + | [[File:Appearance.png|800px]] | ||
| + | |||
| + | === [[Legacy Mode - FXLData |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 described here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary. | ||
| + | |||
| + | The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|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. | ||
| + | |||
| + | [[File:Diagnostic tool.png|1000px]] | ||
Revision as of 05:09, 11 August 2025
Since the last main release of FXL Data in July 2024, a number of changes and enhancements have been introduced. The changes address 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 and incorporating a number of great new features.
Some of these changes were made available via an optional Hot fixes but the Release of R1.3 brings all the changes together and includes a useful new feature as well as various bug fixes.
A summary of all the changes can be viewed in the Change Log Change Log which shows which changes were made in which Hotfix and which are new in R1.3. This page summarises all the main changes as at Version 1.3.
Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found here.
FXLData Tab
On opening Excel and enabling the latest version of the FX Data add-in, you will several significant changes on the FXLData Tab within Excel.
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 described 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.
