GROUPBY missing form Excel Labs/AFE?

[0scarius]

Today was trying to refactor the multiple usage of a dynamic array formula using GROUPBY() into a dynamic function in the Excel Labs/AFE environment. However, the parser does not seem to recognize the GROUPBY statement. Is this not yet implemented in AFE?

[NWilson]

@0scarius Thank you for reporting this. These functions are not yet implemented in AFE, which has not had a release since the announcement of these functions.

We do not have any timeline for adding support for these functions to the AFE debugger; however we will provide correct syntax highlighting for these in a future release of AFE.

[0scarius]

Hi Nicholas,

Thanks for the reply. Addition to the debugger would not be my priority However, adding the functions to the AFE with correct syntax highlighting would be highly appreciated, as at this point, the syntax highlighter marks these functions as errors in my modules, meaning I can't save the code in that form. As a result, I have to build the code outside the AFE, which I find not desirable. Hoping for an expedient fix.

[NWilson]

@0scarius We will do a release shortly with this fix. However, I wouldn't expect that the (incorrect) red squiggly underline prevents saving correctly.

I have just typed in your formula from the screenshot above, into the Modules tab, using the current release version of AFE in the store. It saves correctly.

I did have to guess what the characters were under the "Unknown identifier" popup. It looks like you have a LET variable called "source" and a LAMBDA variable called "source", which looks suspicious.

[NWilson]

The fix has been released.

I would welcome further details though @0scarius if you do have a formula which is valid, but can't be saved by Excel Labs (even with red squigglies, which are purely visual and don't block saving).

[0scarius]

Hi Nicholas, Thanks for the heads up. I currently have v1.3, although I see that v1.4 is already available and I already ma on the bet-channel. I have tried to uninstall v1.3 and then re-install from the add-in store, but then 1.3 installs again. How can I get ahold of this new release? Kind regards, Oscar From: Nicholas Wilson ***@***.***> Sent: vrijdag 17 mei 2024 10:47 To: microsoft/Excel-Labs ***@***.***> Cc: oscarius ***@***.***>; Mention ***@***.***> Subject: Re: [microsoft/Excel-Labs] GROUPBY missing form Excel Labs/AFE? (Issue #28) @0scarius <https://github.com/0scarius> We will do a release shortly with this fix. However, I wouldn't expect that the (incorrect) red squiggly underline prevents saving correctly. I have just typed in your formula from the screenshot above, into the Modules tab, using the current release version of AFE in the store. It saves correctly. I did have to guess what the characters were under the "Unknown identifier" popup. It looks like you have a LET variable called "source" and a LAMBDA variable called "source", which looks suspicious. — Reply to this email directly, view it on GitHub <#28 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABXFFSAK24QGXBHMUV44HTLZCW7ZTAVCNFSM6AAAAABHMRRRY2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMJXGA2TSMBYHE> . You are receiving this because you were mentioned. <https://github.com/notifications/beacon/ABXFFSHGXUHSCM4ISZTTRLDZCW7ZTA5CNFSM6AAAAABHMRRRY2WGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTT6F7BBC.gif> Message ID: ***@***.*** ***@***.***> >

[0scarius]

When I have the new release installed, I will see if my problem persists and get back to you. KR. Oscar From: Nicholas Wilson ***@***.***> Sent: dinsdag 21 mei 2024 18:34 To: microsoft/Excel-Labs ***@***.***> Cc: oscarius ***@***.***>; Mention ***@***.***> Subject: Re: [microsoft/Excel-Labs] GROUPBY missing form Excel Labs/AFE? (Issue #28) The fix has been released. I would welcome further details though @0scarius <https://github.com/0scarius> if you do have a formula which is valid, but can't be saved by Excel Labs (even with red squigglies, which are purely visual and don't block saving). — Reply to this email directly, view it on GitHub <#28 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABXFFSCX3U4YI7SWUPQGQMLZDNZQ3AVCNFSM6AAAAABHMRRRY2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMRTGAYTKNBYG4> . You are receiving this because you were mentioned. <https://github.com/notifications/beacon/ABXFFSGLGANIG3YPFVDZ5NLZDNZQ3A5CNFSM6AAAAABHMRRRY2WGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTT6RKST6.gif> Message ID: ***@***.*** ***@***.***> >

[NWilson]

Thanks for the heads up. I currently have v1.3, although I see that v1.4 is already available and I already ma on the bet-channel. I have tried to uninstall v1.3 and then re-install from the add-in store, but then 1.3 installs again. How can I get ahold of this new release?

@0scarius That's an unusual problem, the latest update is normally available to everyone immediately, independent of Excel's own release channel.

I'm sorry this has been a problem for you.

Two thoughts:

• Test for version 1.4 in a fresh workbook
• Try clearing the web add-ins cache. This is bit complicated... File → Options → Trust Center (bottom left) → Trust Center Settings, then in the new dialog, Trusted Add-in catalogs → "Next time Office starts, clear all previously-started web add-ins cache". This is documented (a little bit) here

[0scarius]

Hi Nicholas, I went through the steps as you provided. However, unfortunately I still have/get v1.3 installed, also after following the steps from the link. Any other thoughts on getting the latest release? KR. Oscar From: Nicholas Wilson ***@***.***> Sent: dinsdag 21 mei 2024 20:06 To: microsoft/Excel-Labs ***@***.***> Cc: oscarius ***@***.***>; Mention ***@***.***> Subject: Re: [microsoft/Excel-Labs] GROUPBY missing form Excel Labs/AFE? (Issue #28) Thanks for the heads up. I currently have v1.3, although I see that v1.4 is already available and I already ma on the bet-channel. I have tried to uninstall v1.3 and then re-install from the add-in store, but then 1.3 installs again. How can I get ahold of this new release? @0scarius <https://github.com/0scarius> That's an unusual problem, the latest update is normally available to everyone immediately, independent of Excel's own release channel. I'm sorry this has been a problem for you. Two thoughts: * Test for version 1.4 in a fresh workbook * Try clearing the web add-ins cache. This is bit complicated... File → Options → Trust Center (bottom left) → Trust Center Settings, then in the new dialog, Trusted Add-in catalogs → "Next time Office starts, clear all previously-started web add-ins cache". This is documented (a little bit) here <https://learn.microsoft.com/en-us/office/dev/add-ins/testing/clear-cache> — Reply to this email directly, view it on GitHub <#28 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABXFFSBGEGKFHNYSY6KIC6LZDOEG7AVCNFSM6AAAAABHMRRRY2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMRTGE3DIMJUHE> . You are receiving this because you were mentioned. <https://github.com/notifications/beacon/ABXFFSBGF7WNEVE2M4WCIXDZDOEG7A5CNFSM6AAAAABHMRRRY2WGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTT6RTU7K.gif> Message ID: ***@***.*** ***@***.***> >

[NWilson]

@0scarius

Oh dear, I'm sorry it is still isn't working. I'm really guessing now, I don't have a strong idea.

You can remove and re-add an add-in using this Excel dialog:

---

Secondly, we can verify which version of the Store manifest your version of Excel is using.

If you right-click on the Excel Labs taskpane, you should be able to select the "Inspect" option

In the titlebar of the Inspect window, you'll see the URL that's being loaded:

The current add-in's URL is https://advancedformulaenvironment.officeapps.live.com/taskpane.03.html.

If we see the same URL in your version of Excel, then we have an issue with a stale cache for the taskpane resources. If we see a different URL in your version of Excel, then we have an issue with a stale cache (or older version) of the Office Store app manifest. This experiment could narrow down the cause of the issue.