Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations JAE on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to use Point from Expression in Excel ?

Status
Not open for further replies.

JA1410

Automotive
Joined
Mar 7, 2014
Messages
1
Location
US
I've played a little with modeling spreadsheet and point from Expression functionality.
First I have created point from expression named "MyPoint" with a value Point(10,20,30)
When expressions are extracted into Excel this one comes as:

Name displayed in cell A2: MyPoint
Value displayed in cell B2: Point(10,20,30)
Value in the cell in cell B2: =EXPVAL("MyName")

EXPVAL is not native Excel function. It must be one of the NX macros hidden in the password protected VBA modules.
You can over type the value cell (=EXPVAL...) with a plain text: Point(30,40,50) for example and Update NX will correctly update point to the new coordinates.
However if you type in the value cell Point(D2,E2,F2) where cells D2,E2,F2 have numeric coordinates 30,40,50 respectively this will cause error in update.
Trying to write =Point(D2,E2,F2) will cause #VALUE error in the cell B2.
I was also playing with string functions attempting to simulate text Point(30,40,50) where text 30,40,50 was build from values in the cells D2,E2 and F2 to no avail.
Update was still creating error.

But without this functionality there is not much advantage using Point from expression when planning to use modeling spreadsheet for advanced data manipulation.

Does anyone knows how to use Point(X,Y,Z) in modeling spreadsheet where X,Y,Z can be manipulated by other cells in the sheet ?
 
In Excel there is an EXP function
and there is a VAL function
so maybe you just need them to be separated.
just a thought
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top