V17.0.2 hangs in pivot table edit

[Ian Martin-2]

I contacted support about this in V16 and it is still not fixed.  Mac
OS 10.4.6 and patched V17 spss.

I don't think it matters how the table is created, but this one was a
table of partial correlations, about 15 variables, controlling for
one other variable.

The table appears in the output window promptly enough, but I need to
edit the number of decimal places shown, so open it in pivot table
editor. Select all cells, choose format, number, and number of
decimal places. Click OK, and wait, and wait, and wait....

After 20 minutes(!) try to force quit and nothing happens.

Any suggestions, or explanation of why this is still not fixed in the
new version?

Ian

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Soley, Bonita (HQ-LF010)]

I have a related question/request on this.   I used to have an autoscript set up to reset all the decimal places in the pivot tables to 2 places, versus the default single place.   I noticed that in v16 the script no longer works, and I'm sure it won't work in v17 either - it hangs up and loops back in the same table over and over.   Although I've used SPSS a long time, I haven't gotten into scripting, so don't know what the problem is.  (definitely am planning to get into scripting!)

Does anyone have an autoscript that can do this?

Thx,

Bonita

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ian Martin
Sent: Wednesday, April 29, 2009 3:35 PM
To: [hidden email]
Subject: V17.0.2 hangs in pivot table edit

I contacted support about this in V16 and it is still not fixed.  Mac OS 10.4.6 and patched V17 spss.

I don't think it matters how the table is created, but this one was a table of partial correlations, about 15 variables, controlling for one other variable.

The table appears in the output window promptly enough, but I need to edit the number of decimal places shown, so open it in pivot table editor. Select all cells, choose format, number, and number of decimal places. Click OK, and wait, and wait, and wait....

After 20 minutes(!) try to force quit and nothing happens.

Any suggestions, or explanation of why this is still not fixed in the new version?

Ian

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies

=====================
To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Peck, Jon]

v16 and later require a small change to preexisting autoscripts - spelled out in the help.  In most cases it's one line of code.  And, unlike prior versions, you can have one base autoscript that applies to many or all tables.

However, you can use the SPSSINC MODIFY TABLES extension command to set the decimals without having to write a script.  The package, which requires the Python plugin, includes a custom function specifically for setting the number of decimals.  I can supply a specific example if you decide to go that way.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Soley, Bonita (HQ-LF010)
Sent: Wednesday, April 29, 2009 2:26 PM
To: [hidden email]
Subject: Re: [SPSSX-L] V17.0.2 hangs in pivot table edit

I have a related question/request on this.   I used to have an autoscript set up to reset all the decimal places in the pivot tables to 2 places, versus the default single place.   I noticed that in v16 the script no longer works, and I'm sure it won't work in v17 either - it hangs up and loops back in the same table over and over.   Although I've used SPSS a long time, I haven't gotten into scripting, so don't know what the problem is.  (definitely am planning to get into scripting!)

Does anyone have an autoscript that can do this?

Thx,

Bonita

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD