Office 365 on the web Excel Add-in does not function correctly

[Tom-H2oThermo]

I’ve created an Excel Add-In that I have submitted to the MS Partner Center. Up to now I was really focused on Excel desktop application, but the Microsoft certification team seems to be mainly focused on Microsoft 365 web based applications. My add in works perfectly for the desktop, but not so well for the web based Excel.

Desktop:
As you enter the formula, you receive guidance:

Once you enter the formula, clicking on the fx to the left of the formula bar brings up a help window where you can enter values.

You can then click on Help on this function and it will open a web page with further details.

Office 365 on the web:

The web-based version doesn’t work this way:
The first step only shows the returned parameter, not the input parameter. Not the end of the world.

The second step where I click on the fx, it returns this

This is OK, not bad. But then when I click next I get this:

This is just wrong. It’s listing pressure twice, not pressure and enthalpy. Also, it lets me add arguments, which is also wrong. And it doesn’t list the optional parameters (units and metastable).
OK so I enter 20 for the pressure1 and 350 for pressure2, assuming that pressure2 is actually the enthalpy. And sure enough, it does return the correct value.
Also, there is no help link to the help pages.
My custom functions look like this in VS Code:
// Function OfficeDev/office-js-docs-pr#4
/**

• Enthalpy f(P,T): (0)kJ/kg, (1)BTU/lbm, (2)kJ/kg, (3)kJ/kg
• @customfunction
• @helpurl https://h2othermo.com/primary_functions/enthalpy-f_pt/
• @param {number} pressure (0)MPa, (1)psia, (2)bara, (3)kPa
• @param {number} temperature (0)K, (1)°F, (2)°C, (3)°C
• @param {number} [units=0] (0)SI, (1)US Customary, (2)Metric bara, (3) Metric kPa
• @param {number} [metastable] false=normal, true=metastable
• @returns (0)kJ/kg, (1)BTU/lbm, (2)kJ/kg, (3)kJ/kg
  */
  export function PTH(pressure, temperature, units, metastable) {
  return H2o.CallStmProp_fPT(pressure, temperature, units, Units.VectorParameters.Enthalpy, metastable);
  }

Any help would be greatly appreciated.

[AlexJerabek]

Hi @Tom-H2oThermo,

Could you please provide more context in a GitHub comment? I'm disinclined to open a .pdf file posted to a public forum like this.

[Tom-H2oThermo]

Ok, I’ll work on revising my post this evening. It will have the same content, just not in a PDF format. From: Alex Jerabek ***@***.***> Sent: Tuesday, May 7, 2024 11:35 AM To: OfficeDev/office-js-docs-pr ***@***.***> Cc: Thomas McAuliffe ***@***.***>; Mention ***@***.***> Subject: Re: [OfficeDev/office-js-docs-pr] Office 365 on the web Excel Add-in does not function correctly (Issue OfficeDev/office-js#4431) Hi @Tom-H2oThermo <https://github.com/Tom-H2oThermo> , Could you please provide more context in a GitHub comment? I'm disinclined to open a .pdf file posted to a public forum like this. — Reply to this email directly, view it on GitHub <#4431> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AGEBWKSI2KGMGD6H52JGH7TZBEGDZAVCNFSM6AAAAABHKBL35WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAOJYHE3DKOJQHA> . You are receiving this because you were mentioned. <https://github.com/notifications/beacon/AGEBWKUFZI3HQIJKAXRZ5FTZBEGDZA5CNFSM6AAAAABHKBL35WWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTT5DOWZI.gif> Message ID: ***@***.*** ***@***.***> >

[AlexJerabek]

Thank you. You should be able to directly paste images into a GitHub comment field.

[Tom-H2oThermo]

Alex, I deleted the PDF in my original post and replaced it with text and images. Your review of this issue would be greatly appreciated. Regards, Tom From: Alex Jerabek ***@***.***> Sent: Tuesday, May 7, 2024 12:03 PM To: OfficeDev/office-js-docs-pr ***@***.***> Cc: Thomas McAuliffe ***@***.***>; Mention ***@***.***> Subject: Re: [OfficeDev/office-js-docs-pr] Office 365 on the web Excel Add-in does not function correctly (Issue OfficeDev/office-js#4431) Thank you. You should be able to directly paste images into a GitHub comment field. — Reply to this email directly, view it on GitHub <#4431> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AGEBWKX44VER24ORWQ5HLI3ZBEJL7AVCNFSM6AAAAABHKBL35WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAOJZGAYDSOBRGQ> . You are receiving this because you were mentioned. <https://github.com/notifications/beacon/AGEBWKRYVLKFTUETMBJIKWLZBEJL7A5CNFSM6AAAAABHKBL35WWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTT5DRMRM.gif> Message ID: ***@***.*** ***@***.***> >

[AlexJerabek]

Thanks @Tom-H2oThermo. That difference in experience between desktop and web certainly seems like a bug. I'm going to transfer this to the office-js repo where a member of the custom functions feature crew can help you more.

[Tom-H2oThermo]

Thanks Alex. Yes it definitely seems like a bug to me. Hopefully it can be resolved soon. Thanks again.

Regards,
Tom

[ruijiaMS]

Hi @Tom-H2oThermo,
Sorry for the delay here! This is an known issue in office online Excel application and we had raised tasks 8668416 and 8668388 to track this issue. You could find the discussion from this link: #3228.
So, basically there will be a new feature for excel online including insert dialog, inline typing, arguments refactor and so on. Any update will post there! Thanks!

[Tom-H2oThermo]

Thank you Rui, But the #3328 issue is only a part of the problem. The bigger problem is when you click on the fx to the left of the formula bar. I don’t see where this was brought up in the #3328 issue. Excel Desktop version: Once you enter the formula, clicking on the fx to the left of the formula bar brings up a Function Arguments window where you can enter values. Excel Web Version: Instead of a Function Arguments window, it opens and Insert function window. Hopefully, the solution your team are working on will resolve this issue also. I greatly appreciate any help you can provide in this matter. Regards, Tom From: Rui Jia ***@***.***> Sent: Thursday, May 9, 2024 8:22 PM To: OfficeDev/office-js ***@***.***> Cc: Thomas McAuliffe ***@***.***>; Mention ***@***.***> Subject: Re: [OfficeDev/office-js] Office 365 on the web Excel Add-in does not function correctly (Issue #4431) Hi @Tom-H2oThermo <https://github.com/Tom-H2oThermo> , Sorry for the delay here! This is an known issue in office online Excel application and we had raised tasks 8668416 and 8668388 to track this issue. You could find the discussion from this link: #3228 <#3228> . So, basically there will be a new feature for excel online including insert dialog, inline typing, arguments refactor and so on. Any update will post there! Thanks! — Reply to this email directly, view it on GitHub <#4431 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AGEBWKXMVNCIQAHLD5GA4NDZBQVNFAVCNFSM6AAAAABHNVXYJSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMBTG4ZTGMJRGA> . You are receiving this because you were mentioned. <https://github.com/notifications/beacon/AGEBWKR6RNYCXYSKMD2LGLDZBQVNFA5CNFSM6AAAAABHNVXYJSWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTT5MRVXM.gif> Message ID: ***@***.*** ***@***.***> >