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 ?
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 ?
