FXLData Ribbon Bar - Revision history

Vmurrell at 14:59, 15 June 2026

2026-06-15T14:59:45Z

Vmurrell at 14:57, 15 June 2026

2026-06-15T14:57:52Z

Vmurrell at 14:56, 15 June 2026

2026-06-15T14:56:22Z

Vmurrell at 14:49, 15 June 2026

2026-06-15T14:49:55Z

Vmurrell at 14:44, 15 June 2026

2026-06-15T14:44:26Z

Vmurrell at 14:42, 15 June 2026

2026-06-15T14:42:23Z

Vmurrell: Created page with " Category:How to and other features in FXLData The FXLData has a ribbon bar which offers the following functions. {| class="wikitable" |- ! Option !! Usage |- | File:Wi..."

2026-06-15T14:40:49Z

Created page with " Category:How to and other features in FXLData The FXLData has a ribbon bar which offers the following functions. {| class="wikitable" |- ! Option !! Usage |- | File:Wi..."

New page

[[Category:How to and other features in FXLData]]
The FXLData has a ribbon bar which offers the following functions.

{| class="wikitable"
|-
! Option !! Usage
|-
| [[File:Wizard-button.png]] || Launch the function helper 'Wizard'
|-
| [[File:Login-button.png]] ||Launch the Login Function so sign into FXLData
|-
| [[File:Refresh-button.png]] || Refresh the FXLData function
|-
| [[File:Purge-button.png]] || Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source
|-
| [[File:Diag-button.png]] || Diagnostics - xxxxxxxxxxxxx
|-
| [[File:Logs-button.png]] || View Logs - xxxxxxxxxxxxx
|-
| [[File:Sys-info.png]] || System Info - xxxxxxxxxxxxx
|}

'''''Retired in R1.3''''' Automatic Calculation control whether changes to FXLData formulas automatically refresh the dataset in Legacy Mode - uncheck to speed up bulk changes to worksheets such as deleting large numbers of cells

'''''Retired in R1.3.03 ''''' 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","")

@@ Line 10: / Line 10: @@
 | [[File:Login-button.png]] ||Launch the Login Function so sign into FXLData. Click here [[Security_and_Authentication_in_FXLData#Extended_Authentication_Capabilities| to learn more about the Login options.]]
 |-
-| [[File:Refresh-button.png]] || Refresh the FXLData function. Click here [[Refresh_FXLData| to lean more about this option.]]
+| [[File:Refresh-button.png]] || Refresh the FXLData function. Click here [[FXLData_Refresh| to lean more about this option.]]
 |-
 | [[File:Purge-button.png]] || Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source. Click here [[FXLData_Purge|to learn more about this option.]]

@@ Line 12: / Line 12: @@
 | [[File:Refresh-button.png]] || Refresh the FXLData function. Click here [[Refresh_FXLData| to lean more about this option.]]
 |-
-| [[File:Purge-button.png]] || Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source. Click here [[/FXL_Data_Purge|to learn more about this option.]]
+| [[File:Purge-button.png]] || Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source. Click here [[FXLData_Purge|to learn more about this option.]]
 |-
 | [[File:Diag-button.png]] || Diagnostics. Click here [[FXLData_Diagnostics| to learn more about this feature.]]

@@ Line 14: / Line 14: @@
 | [[File:Purge-button.png]] || Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source. Click here [[/FXL_Data_Purge|to learn more about this option.]]
 |-
-| [[File:Diag-button.png]] || Diagnostics  - xxxxxxxxxxxxx
+| [[File:Diag-button.png]] || Diagnostics. Click here [[FXLData_Diagnostics| to learn more about this feature.]]
 |-
-| [[File:Logs-button.png]] || View Logs  - xxxxxxxxxxxxx
+| [[File:Logs-button.png]] || View Logs. Click here [[FXLData_Logs| to learn more about this feature.]]
 |-
-| [[File:Sys-info.png]] || System Info  - xxxxxxxxxxxxx
+| [[File:Sys-info.png]] || System Info. Click here [[FXLData_System_Info|to learn more about this feature.]]
 |}

@@ Line 8: / Line 8: @@
 | [[File:Wizard-button.png]] || Launch the function helper 'Wizard'. Click here [[FXLData_Wizard| to learn more about the Wizard.]]
 |-
-| [[File:Login-button.png]] ||Launch the Login Function so sign into FXLData
+| [[File:Login-button.png]] ||Launch the Login Function so sign into FXLData. Click here [[Security_and_Authentication_in_FXLData#Extended_Authentication_Capabilities| to learn more about the Login options.]]
 |-
 | [[File:Refresh-button.png]] || Refresh the FXLData function