FXLData Change Log

Changelog for FXLData

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