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!

Modeling Spreadsheet wrong behavior?

Status
Not open for further replies.

Andersen07

Industrial
Joined
Dec 8, 2021
Messages
28
Location
BR
According to the docs, it seems that if I create a Spreadsheet (in [tt]NX > Tools > Spreadsheet[/tt]), formulas that I type in the spreadsheet should be two-way translated (from spreadsheet to NX expressions and from NX expressions to spreadsheet). So I tried:

[ol 1]
[li]In NX, created two parameters ([tt]Tools > Expressions[/tt]): [tt]width = 10[/tt] and [tt]height = if (width >= 10) then (5) else (20)[/tt].[/li]
[li]In NX, created a Spreadsheet ([tt]Tools > Spreadsheet[/tt]).[/li]
[li]In Excel, selected cell [tt]A1[/tt] and clicked [tt]Add-Ins > Extract Expr[/tt].[/li]
[/ol]

I expected [tt]width[/tt] to have formula "[tt]= 10[/tt]" and [tt]height[/tt] to have a translated formula "[tt]=IF(width >= 10; 5; 20)[/tt]", but instead I got [tt]height = @exprval("height")[/tt].


The other way around is even worse. If I:

[ol 1]
[li]In Excel, change [tt]height[/tt] expression to any Excel formula, like "[tt]=SUM(D1:D7)[/tt]" (which results in [tt]170[/tt])[/li]
[li]Save spreadsheet, click [tt]Add-Ins > Update NX[/tt] Part and close the spreadsheet[/li]
[/ol]

When I open the Expressions window ([tt]NX > Tools > Expressions[/tt]), I get [tt]height = 170[/tt], without any functions, just a bare value.
If I then reopen the Spreadsheet ([tt]NX > Tools > Spreadsheet[/tt]) and click [tt]Add-Ins > Refresh Expr[/tt], it refreshes [tt]height[/tt] to "[tt]= 170[/tt]", which makes me lose all the Spreadsheet logic whenever I refresh the expressions.

Protecting the desired cells to maintain their formula have no effect.

I'm using NX 2008 and Excel 2021
Is this the expected behavior?
Thanks
 
I ran a quick test and am seeing the same thing that you are. Either it is not working as intended, or there was a change and the help docs didn't get updated. Either way, I'd suggest contacting Siemens support and logging an incident report (IR).

www.nxjournaling.com
 
cowski,
which version of Excel are you using?
I'm thinking about downgrading it to 2019 version, since the Docs don't list 2021 as supported yet, to see if that's the problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top