Difference between revisions of "FXLData Change Log"
Jump to navigation
Jump to search
(Created page with "=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 i...") |
(→Changelog for FXLData) |
||
Line 87: | Line 87: | ||
* Wizard: Added 'Purge Cache on Apply' option | * 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 | * 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 | ||
+ | 1.0.0 (13 May 2022) | ||
+ | * Production release |
Revision as of 07:46, 13 May 2022
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
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
1.0.0 (13 May 2022)
- Production release