search

xlladdins / xll

Excel add-in library
MIT License
104 stars 23 forks source link

Excel Functions - Parameters Info strings not showing #5

Closed GlennGitHubAcc closed 3 years ago

GlennGitHubAcc commented 3 years ago

Hi:

In the EXCEL function wizard the parameter info strings are not showing (see attached screenshots) even though they are setup in the XLL.

Any suggestions on what is wrong?

This is a Windows 10 x64 build.

Thanks. Glenn Excel XLL

keithalewis commented 3 years ago

Just like VBA! Kidding. Fixed in e553110363e08677aca23cf57ea4b2e5408dcc9b

GlennGitHubAcc commented 3 years ago

Thanks Kieth - should this update be available. When I do a GIT PULL I don't see any updates.

Also another point, when passing XLL_CSTRINGs they seem to get truncated after 23/24 characters. Is there anyway around this? Thanks

keithalewis commented 3 years ago

Please send me a https://en.wikipedia.org/wiki/Minimal_working_example.

GlennGitHubAcc commented 3 years ago

Sorry - checking further it was my mistake. Apologies.

Is e553110 checked in so I can update my files? Thanks again.

keithalewis commented 3 years ago

No worries. You helped me find a bug in my Args rewrite. If all is well now please close this issue. As a by-the-by, you can also write {XLL_TYPE, "name", "description"} without the Arg({...}).

GlennGitHubAcc commented 3 years ago

Sorry - the parameter string problem still doesn't seem to be fixed in my build. Is there something else I need to do?

keithalewis commented 3 years ago

Send me a MWE if you are still seeing problems.

GlennGitHubAcc commented 3 years ago

GNGStructuralLib.zip Hi Keith: I tried to create a MWE to illustrate the problem. I deleted the XLL template, reinstalled it and created a new project. I started off with just a few routines and it all seems to work ok including displaying the parameter labels correctly. However, when I add a few more routines, the XLL seems to fall apart and EXCEL won't load it. These routines have all loaded correctly before. I have attached the project - if you have any suggestions I would really appreciate it.

keithalewis commented 3 years ago

Hi @GlennGitHubAcc , I was able to build and run the 64-bit version in MSVC 2019 Preview. Spot checking shows the functions in the function wizard and the argument prompts look okay. Maybe you should try extracting your zip file and doing a fresh build like I just did. If loading fails you can Debug/Break All then look at the call stack to detect where it is hanging.

GlennGitHubAcc commented 3 years ago

Hi: Loaded the latest update and all seems to work now. Thanks.

keithalewis commented 3 years ago

I fixed a bug in OPER memory management. I was neglecting to use placement new on malloced memory. Thanks for pointing me in the right direction.