Sign in to follow this  
Followers 0
ray306

Problem with ExcelCom_UDF

5 posts in this topic

It would appear that there is a problem with the function _ExcelSheetUsedRangeGet in the ExcelCom_UDF.

The problem would appear to be the invoking of :

$aSendBack[3] = Number(StringRegExpReplace($aSendBack[0], "\a", ""))

this call is on line 2110 in the ExcelCom_UDF I have. This call is supposed to strip away the non numeric part of an Excel cell address. (ie. A51 becomes 51). It would appear that the syntax for StringRegExpReplace() may have changed in the newest version as I did not have a problem with this until I updated last evening.

The code should be:

$aSendBack[3] = Number(StringRegExpReplace($aSendBack[0], "[A-Z,a-z]", ""))

I tested the suggested replacement code and it appears to work properly.

BTW thanks to all the people that put ExcelCom_UDF together as well as all the Autoit developers, it has been very helpful.

Ray

Share this post


Link to post
Share on other sites



Please post these issues in the General Help forum since this is not a part of the standard distribution..

- moved -


Visit the SciTE4AutoIt3 Download page for the latest versions        Beta files                                                          Forum Rules
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Share this post


Link to post
Share on other sites

Thanks for the report, Ray.

StringRegExpReplace() has changed at least once in the last couple of months to the point where it breaks some of the functions in my collection. I haven't mentioned it before because I understood the regular expression functions were in flux. Perhaps it's time to pop the question.

This may be a bug; If someone could tell me why the following code would/should not strip away non-numeric characters from the string, I would appreciate it:

$sTemp = StringRegExpReplace("ABC123", "\a", "")

It used to work, and now on some recent builds it doesn't. It should work, shouldn't it? What's the status of the regular expression functions? I haven't been able to test this against every build myself, but I have been receiving regular complaints about it no longer working.

-S


(Yet Another) ExcelCOM UDF"A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly...[indent]...specialization is for insects." - R. A. Heinlein[/indent]

Share this post


Link to post
Share on other sites

Ah. Yep. That would constitute a code-breaking change. Thanks, Randall.

Ray, I'll have a full ExcelCOM_UDF update which addresses this change within a day or two.

-S


(Yet Another) ExcelCOM UDF"A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly...[indent]...specialization is for insects." - R. A. Heinlein[/indent]

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0