FXLData Change Log

Excel Command

=FXLDataVersion("changelog")

H1.2.0.02_RFS_07.03.2025 (Released March 7, 2025)

RFS-279 - Enhancement - ability to view Dataflows in the Query builder by Name or ID.

H1.2.0.01_RFS_20.02.25 (Released February 20, 2025)

RFS-1359 - Bug Fix - Changing the Daily Format back to original state was not working as expected. Due to other changes in FXLData, this has now been rectified via the Refresh button. Support Ticket - 409849.

RFS-1324 - Bug Fix - The TimeSeriesFormat parameter was available to the FXLData and FXLDataV formulas but was absent in other variations such as: - FXLDataUrl - FXLDataUrlV - FXLDataUrlFact. The TimeSeriesFormat parameter was made available to all variations of the FXLData formula. Support Ticket - 397682.

RFS-902 - Tool Upgrade - A new section was added to the plugin ribbon. The user can enable /disable diagnostic, and decide on the level of verbosity (medium/high) For medium verbosity logs are limited to 40000 characters to prevent memory issues(around 15-20 request logs). For high verbosity logs are unlimited, hence it is advised not to use this option unless absolutely necessary and for brief periods. Please also be aware of any sensitive information that the logs will render before sharing. Click here from more information.

RFS-878 - Bug Fix - Unable to extract data using Excel 2016.- Issue fixed and compatibility is supported from Excel 2016 to 2020. Support Ticket - 378098.

RFS-772 - Improvement - Changed =FXLDataVersion("changelog") to show changlog starting from the newest changes instead of starting from the oldest.

RFS-382 - Bug Fix - Previously it was observed that in some scenarios registry returned a 404 rather than a 401 http response to fxl data when a user was unauthenticated. This caused fxl data to suppress the login dialog and offer no means for the user to remedy the situation. - Now, if FXL Data detects a 404 response it will display the login prompt on the first try thus providing the user an opportunity to enter valid credentials and continue with the successful processing of web service interactions with registry.

RFS-278 - Bug Fix - Previously, inconsistencies were observed between horizontal and vertical mode. - This has been resolved. Support Ticket - 333871.

RFS-109 - Change - Automatic Refresh could cause performance issues with large datasets - The automatic process has been removed and now, Refreshes must be performed manually. Support Ticket - 334024 & 397658.

R1.1.0.00_RFS_05.07.24

• RFS-262: Improved performance of the dataflow selection on the wizard form
• RFS-280: Introduced a feature that facilitates the conversion of the received TIME_FORMATs to daily

1.2.6 (24 February 2023)

• FXLData: Fixed bug returning the incorrect number of series for 'basket' queries (virtual dataflows)
• FXLData: Fixed bug incorrectly reporting the number of available / retrieved series in the resultset header

Version 1.2.5 (23 February 2023)

• FXLData: fixed bug in [user]@ syntax handler that mangled the URL if an @ symbol is used in the Dataflow ID for instance
• Legacy Mode: modified application event handling to make control over automatic calculation more robust
• Fusion Registry refreshable Excel workbooks: fixed bug preventing workbooks from being refreshed on open

Version 1.2.4 (18 November 2022)

• FXLData: show the REST data API url in the header
• FXLData: add 'nocc' client-side REST Argument to restrict the resultset time periods to only those with observation values when startPeriod and / or endPeriod are specified

Version 1.2.3 (14 November 2022)

• Legacy Mode: bug fix displaying N/A under certain circumstances

Version 1.2.2 (11 November 2022)

• Legacy Mode: bug fix preventing display of datasets with only a single row

Version 1.2.1 (08 November 2022)

• Legacy Mode: change automatic calculation option to 'off' by default to address general worksheet performance issues

Version 1.2.0 (05 July 2022)

• Legacy Mode: add Ribbon function to disable automatic calculation to speed bulk changes to worksheets such as deleting large numbers of cells

Version 1.1.2 (27 June 2022)

• Wizard: fix dataflow search

Version 1.1.1 (09 June 2022)

• Refreshable worksheets: modified automatic refresh on open to improve reliability of refreshable worksheets

Version 1.1.0 (30 May 2022)

• FXLData: Support 'un' parameter to force login on refreshable worksheets

Version 1.0.1 (16 May 2022)

• FXLData: Fixed invalid availability query syntax when working with Fusion Registry 11 and SDMX 3.0
  

Version 1.0.0 (13 May 2022)

First Public Release 1.0.1 (16 May 2022)

• FXLData: Fixed invalid availability query syntax when working with Fusion Registry 11 and SDMX 3.0

---

Beta Versions

Beta 0.3.3

• Authentication issues fixed

Beta 0.3.4

• Modified parameterised variants to allow no dataflow and a dataflow/series key to be specified in the expression

Beta 0.3.5

• JSON / POST data query support for series baskets

Beta 0.3.6

• Vertical JSON / POST support

Beta 0.3.7

• Fixed bug in URL validator which rejected URLs where the host contains hyphens
• Fixed bug where URL's of the form crash the API call http://@hostname

Beta 0.3.8

• Add workaround for 'aggregate' queries where the availability query does not return the correct series_count
• =FXLDataV() now takes the same arguments as =FXLData() to ease switching between horizontal and vertical presentations - some arguments are ignored though

Beta 0.4.0

• Add ribbon bar Wizard

Beta 0.4.1

• Wizard: Removed redundant ribbon bar components
• Wizard: Added dataflow dropdown refresh

Beta 0.4.2

• Wizard: Added defence against JSON being supplied as a literal Expression value - Excel doesn't support that
• Wizard: Added tool tips
• Wizard: Corrected tab order

Beta 0.4.3

• Wizard: Improved handling of FXLData function execution errors when inserting the function into a sheet

Beta 0.4.4

• Wizard: Added checks to verify the correct version of Excel is being used (Microsoft 365 Excel Sept 2018 or later)

Beta 0.5.0

• FXLData / Wizard / Refresh: add support for pre-Excel 2018 'legacy mode' where the result array is iterated and inserting into the cells on ribbon button click

Beta 0.5.1

• FXLData: Added data query caching to improve performance particularly on legacy refresh where the same query may be executed multiple times

Beta 0.5.2

• Purge Cache: Added 'Purge Cache' function to the ribbon bar

Beta 0.5.3

• Legacy Mode: legacy functions now automatically refresh on change without using the Ribbon 'Refresh' emulating the behaviour of normal Excel functions to some extent
• Legacy Mode: added error handling for stack overflows on legacy 'evaulate' where the formula length exceeds the 255 character limit

Beta 0.5.4

• Ribbon: Added control over automatic refresh in legacy mode
• FXLData: Improved caching to avoid caching error results
• Legacy Mode: Modified application event handling to avoid triggering refresh events where not needed

Beta 0.5.5

• Wizard: check each Dataflow for access rights before adding to the dropdown to ensure the list only contains Dataflows for which the user has permissions

Beta 0.5.6

• FXLData: Fixed issues with FXLDaatV returning the incorrect number of series (removed paging which is not relevant for vertical and corrected series calcs when using calculated measures)
• FXLData: Removed API paging due to limited benefit
• FXLData: Fixed bug resulting in 'Query Error - 0 series retrieved of 0' due to paging errors
• Wizard: Query Builder - added clear selection button
• Wizard: Query Builder - show series count for entire dataflow on initialisation
• Wizard: Query Builder - removed irrelevant TIME_PERIOD tab
• Wizard: Added REST arguments syntax help
• Legacy Mode: Stopped screen updating during refresh to improve performance

Beta 0.5.7

• Wizard: Query Builder enhanced to grey-out invalid codes as selections are made
• Wizard: Improved query builder refresh performance
• Wizard: Improved 'unapplied changes' indicator
• Wizard: Improved REST API help popup

Beta 0.5.8

• FXLData: Trap and gracefully handled Registry data query errors that return no data, but result in HTTP 500 and 'Index:0, Size:0' responses
• Refresh: Added Refresh Sheet option
• Ribbon: Moved Refresh and Calculations to Ribbon menus

Beta 0.6.0

• Legacy Mode: Modified legacy mode dynamic array emulation to improve performance to that comparable with actual dynamic arrays (legacyRefreshCell refactor - assign resultset arrary directly to range.value instead of iterating one cell at a time)
• Legacy Mode: Application events initialised in the FXLData Workbook Open event
• Legacy Mode: Automatic calculation defaulted on true in the FXLData Workbook Open event which improves reliability by avoiding reliance on ribbon initialisation to perform that task
• FXLData: Corrected duplication of double quotes where they appear in component labels

Beta 0.6.1

• Addin: Forces Excel to execute the FXLData formula in cell B2 on workbook open ensuring that refreshable workbooks generated by Fusion Registry refresh as expected on open

Beta 0.7.0

• FXLData: Fusion Registry 11 support
• FXLData: Authentication exception handling bug fixed in all four of the fxldata query execution functions - URL h and v, POST h and v
• FXLData: Added freshness timestamp to the resultset metrics
• Wizard: Do not show the wizard for FXLDataURL or FXLDataURLV functions as it is designed for use only with the parameterised function variants

Beta 0.7.2

• FXLData: SDMX 3.0 availability API support

Beta 0.7.3

• FXLData: Added FXLDataUrlFact() function

Beta 0.7.4

• FXLDataUrlFact: Added defence against errors caused where the availability query incorrectly indicates data is available, and the data query returns none
• FXLDataUrlFact: Added gzip accept encoding to XML dataset GET
• FXLData: Weakened the URL syntax check to avoid FXLDataURL refreshable sheet calls being rejected as bad URL because of spaces in the 'saveAs' parameter

Beta 0.7.5

• FXLData: Fixed issue preventing refreshable worksheets refreshing on open in legacy mode
• FXLData: Fixed FXLDataUrlFact bug where the wrong number of output columns was estimated under certain circumstances

Beta 0.7.6

• Wizard: Added 'Purge Cache on Apply' option
• Legacy Mode: Fixed bug in legacy mode refresh where resultsets in the same cell on different sheets are deleted on refresh

Beta 0.7.7

• Legacy Mode: Changed refresh to clear the contents of the range rather than clear all thus preserving user-applied formatting
• Legacy Mode: Fixed refresh bug which left redundant ranges where a FXLdata formula was moved, deleted or over written
• Legacy Mode: Changed refresh behaviour to not delete the range content when an FXLData formula is moved, deleted or over written

Beta 0.7.8

• Legacy Mode: Modified sub legacyRefreshCell() to exit immediately if the cell does not contain an FXLData function
• FXLData: FXLDATA-2 Vertical presentation fails with an 'subscript out of range' inline error when the resultset has one series

Beta 0.7.9

• Wizard: Added dataflow quick filter
• Legacy Mode: Removed the Ribbon Bar option to control automatic refresh on change because setting to 'manual' prevented workbook and sheet refresh because named ranges were not being created
• Legacy Mode: Fixed 'refreshselectedcell' bug whereby a named range was not being created if the function returns an error thus preventing subsequent workbook and sheet refresh operations

Beta 0.7.10

• Wizard: Date format syntax help added
• Wizard: Corrected date format validation bug that reported dates of the form '01/01/2010' as valid
• Wizard: Corrected bug that incorrectly evaluated date values in existing formulas on wizard startup

Beta 0.7.11

• Legacy Mode: Changed legacy mode to use 'worksheet' scoped named ranges rather the 'workbook' to avoid confusion when worksheets are duplicated
• Legacy Mode: Modified legacy refresh to use worksheet.evaluate rather than application.evaluation to ensure formulas run within the correct worksheet context - fixes unexpected workbook refresh results due to the formulas on other worksheets being evaluated in the current worksheet context

Beta 0.7.11

• FXLData: Bug fix to availability query to correctly set the format=sdmx-2.1 - resolves problem in Fusion Registry 11.0.0 where the query was being rejected with HTTP 406 due to invalid format specifier