Legacy Mode - FXLData - Revision history

Vmurrell at 12:01, 17 November 2025

2025-11-17T12:01:50Z

Vmurrell at 13:27, 11 August 2025

2025-08-11T13:27:44Z

Vmurrell: /* Forcing Microsoft 365 Excel to use Legacy Mode */

2024-08-05T11:59:26Z

‎Forcing Microsoft 365 Excel to use Legacy Mode

Vmurrell: Vmurrell moved page Legacy Mode - FXLData - Draft to Legacy Mode - FXLData

2024-07-25T10:56:28Z

Vmurrell moved page Legacy Mode - FXLData - Draft to Legacy Mode - FXLData

Vmurrell: Created page with "Category:How to and other features in FXLData =Legacy Mode= Legacy Mode emulates the latest Microsoft 365 dynamic array behaviour in older Office Excel 20..."

2024-07-22T09:41:03Z

Created page with "Category:How to and other features in FXLData =Legacy Mode= <strong>Legacy Mode</strong> emulates the latest Microsoft 365 dynamic array behaviour in older Office Excel 20..."

New page

[[Category:How to and other features in FXLData]]
=Legacy Mode=
<strong>Legacy Mode</strong> emulates the latest Microsoft 365 dynamic array behaviour in older Office Excel 2010-2019 versions by populating the cells neighbouring that holding an FXLData formula with the data result set.

In versions of Microsoft 365 Excel that do support dynamic arrays, legacy mode can also be used to write the result set directly into the worksheet. That's useful in situations where discrete data points are needed rather than an Excel array which has certain limitations.

====Office Excel 2010-2019====
FXLData always works in legacy mode when using Office Excel 2010-2019.

When an FXLData function is executed, the first cell of the result set will appear as the formula result. If automatic calculation is enabled, FXLData's ''dynamic array emulation'' will immediately populate the neighbouring cells with the remainder of the result set. If automatic calculation is disabled, [[#Refresh|Refresh]] must be used.

====Forcing Microsoft 365 Excel to use Legacy Mode====
FXLData functions in Microsoft 365 Excel operate as dynamic array formulas by default where the result set appears in the worksheet as an Excel array.

Using the [https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34 Implicit intersection operator: @] however forces the FXLData function to operate in legacy mode causing the result set to be written directly into the worksheet.
=@FXLData("<nowiki>https://registry.domain.org/FusionRegistry</nowiki>","ECB,EXR,1.0","A..BGN+BEF..",100,"round=2","2010","2020","id",TRUE,FALSE,TRUE,FALSE)
In the above example the '''@''' preceeding the FXLData function name instructs Excel to return the ''implicit intersection'' of the result set array which is just the first cell. If legacy mode ''automatic calculation'' is enabled, the FXLData's dynamic array emulation will populate the neighbouring cells. If not, [[#Refresh|Refresh]] must be used.

← Older revision		Revision as of 12:01, 17 November 2025
Line 1:		Line 1:
		+	[[Category:RetiredFunctionality]]
	=Legacy Mode=		=Legacy Mode=

← Older revision		Revision as of 13:27, 11 August 2025
Line 1:		Line 1:
−	~~[[Category:How to and other features in FXLData]]~~
	=Legacy Mode=		=Legacy Mode=
		+
		+	'''''This mode was available in versions prior to February 2025 and is no longer applicable in R1.3.'''''
		+
	<strong>Legacy Mode</strong> emulates the latest Microsoft 365 dynamic array behaviour in older Office Excel 2010-2019 versions by populating the cells neighbouring that holding an FXLData formula with the data result set.		<strong>Legacy Mode</strong> emulates the latest Microsoft 365 dynamic array behaviour in older Office Excel 2010-2019 versions by populating the cells neighbouring that holding an FXLData formula with the data result set.

@@ Line 15: / Line 15: @@
 Using the [https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34 Implicit intersection operator: @] however forces the FXLData function to operate in legacy mode causing the result set to be written directly into the worksheet.
   =@FXLData("<nowiki>https://registry.domain.org/FusionRegistry</nowiki>","ECB,EXR,1.0","A..BGN+BEF..",100,"round=2","2010","2020","id",TRUE,FALSE,TRUE,FALSE)
-In the above example the '''@''' preceeding the FXLData function name instructs Excel to return the ''implicit intersection'' of the result set array which is just the first cell. If legacy mode ''automatic calculation'' is enabled, the FXLData's dynamic array emulation will populate the neighbouring cells. If not, [[#Refresh|Refresh]] must be used.
+In the above example the '''@''' preceeding the FXLData function name instructs Excel to return the ''implicit intersection'' of the result set array which is just the first cell. If legacy mode ''automatic calculation'' is enabled, the FXLData's dynamic array emulation will populate the neighbouring cells. If not, [[Refresh_-_FXLData | Refresh]] must be used.

← Older revision	Revision as of 10:56, 25 July 2024
(No difference)