TestExcel not working

[Gerard Lardner]

I am using CoolProp in Excel 2019. It works.

 

I have been using CoolProp for a number of years. I installed it on this new PC a few months ago; I never had any reason to run TestExcel as it just worked in my own spreadsheets.

 

I wanted to refer to TestExcel to see how isentropic_expansion_coefficient is called. To my surprise, CoolProp is not working in TestExcel.xlsx. I went back to my own worksheet; yes, CoolProp is working there. What could be happening?

 

Also, what are the input parameters for isentropic_expansion_coefficient?

[Ian Bell]

What does "is not working" mean?  

--
You received this message because you are subscribed to the Google Groups "coolprop-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to coolprop-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/coolprop-users/008e01d707f2%24d2bb9db0%247832d910%24%40gmail.com.

[Gerard Lardner]

Hello Ian,

 

In the TestExcel.xlsx spreadsheet, every cell calling any of the CoolProp functions displays “#NAME?”. The pop-up error in every cell I have examined message says “The formula contains unrecognized text” and the associated drop-down says “Invalid name error”. I tried reinstalling CoolProp to make sure the TestExcel spreadsheet hadn’t become corrupted.

 

But the weird thing is that my own Excel spreadsheets that make use of CoolProp work just fine.

 

Windows Professional 10 X64, MS Office 2019, CoolProp v6.4.1.0.

To view this discussion on the web visit https://groups.google.com/d/msgid/coolprop-users/CAJQnXJd2s5PZwh9P5b5%3DYfnfDDZTaShoqH85fcA5JOSwBdew%3Dg%40mail.gmail.com.

[Ian Bell]

Feels like maybe a file encoding error since I haven't heard of this before, and I know we have plenty of Excel users.

To view this discussion on the web visit https://groups.google.com/d/msgid/coolprop-users/009901d708a6%2482290a40%24867b1ec0%24%40gmail.com.

[Gerard Lardner]

Thanks, Ian. I have re-downloaded TestExcel.xlsx and got different behaviour; each cell will recalculate only if I open the cell to edit it and then hit Return. Plainly the issue is in some setting in my copy of Excel; my previous copy of TestExcel.xlsx might also have become corrupted.

 

I have recently been checking a large spreadsheet originally created by someone else, which is chock full of macros and VBA codes at least one of which changed some default settings, at least within that workbook; it might also have changed some settings in Excel itself.

To view this discussion on the web visit https://groups.google.com/d/msgid/coolprop-users/CAJQnXJe5rDj8uZ_s2_xRwG5zh5LMDgFnYd6mcsJpDpxqrMoAXA%40mail.gmail.com.

[Ian Bell]

Yeah, I personally wouldn't use Excel for something like this.  So hard to be sure that things are happening in the same way every time.

To view this discussion on the web visit https://groups.google.com/d/msgid/coolprop-users/008801d709e0%24de078cc0%249a16a640%24%40gmail.com.