Modeling Spreadsheet wrong behavior?

[Andersen07]

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(D17)[/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

 

[cowski]

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

 

[Andersen07]

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.

 

[cowski]

I used NX 2019 with Excel v2108 (office 365).

www.nxjournaling.com