Ghost stub title in mult response crosstabs

[John F Hall]

This is driving me crazy!

 

I'm writing an entry level tutorial on mult response and am trying to copy a table from spo to a Word file.  The final table on the spo is what I want, but however hard I try, when I copy it across to Word there's a ghost stub header creeping in on the Total column.  I've checked the sav file and there's nothing wrong with it. 

 

Where is the ghost header Male coming from?  There seems to be something between the table title and the table even in this mail as when I try to highlight the blank lines to delete them the cells in the table light up as well.

 

I could just edit the table and delete the unwanted header, but there may be a bug in SPSS (even 15)Am I stoopid or what?  Can someone please explain?

 

 

 

 

                                                         Q4*sex Crosstabulation

 

  

 

 

 

 

 

			Q5: Sex of respondent		Total
			Male	Female	Male
Previous experience and skills(a)	Typing	Count	26	80	106
	Word-   process	Count	39	91	130
	Social  stats	Count	15	46	61
	Survey  analysis	Count	10	18	28
	Other	Count	24	53	77
	None of these	Count	3	8	11
Total		Count	50	119	169

Percentages and totals are based on respondents.

a  Group

 

 

 

[Bruce Weaver]

Hi John.  It would not surprise me if this is a bug of some sort.  I remember having problems in some previous version (14 or 15 maybe?) where column heading in tables were messed up like that after exporting output to Word/RTF.  

Bruce

John F Hall-2 wrote

This is driving me crazy!



I'm writing an entry level tutorial on mult response and am trying to copy a table from spo to a Word file.  The final table on the spo is what I want, but however hard I try, when I copy it across to Word there's a ghost stub header creeping in on the Total column.  I've checked the sav file and there's nothing wrong with it.  



Where is the ghost header Male coming from?  There seems to be something between the table title and the table even in this mail as when I try to highlight the blank lines to delete them the cells in the table light up as well.



I could just edit the table and delete the unwanted header, but there may be a bug in SPSS (even 15)Am I stoopid or what?  Can someone please explain?





 

 

                                                         Q4*sex Crosstabulation

 

       
     
     Q5: Sex of respondent
     Total
     
        Male
      Female
     Male
     
      Previous experience and skills(a)
     Typing
     Count
     26
     80
     106
     
       Word-   process
      Count
     39
     91
     130
     
       Social  stats
      Count
     15
     46
     61
     
       Survey  analysis
      Count
     10
     18
     28
     
       Other
      Count
     24
     53
     77
     
       None of these
      Count
     3
     8
     11
     
      Total
     Count
     50
     119
     169
     


Percentages and totals are based on respondents.

a  Group

 

 

[Marta Garcia-Granero]

John F Hall wrote:

This is driving me crazy!

 

I'm writing an entry level tutorial on mult response and am trying to copy a table from spo to a Word file.  The final table on the spo is what I want, but however hard I try, when I copy it across to Word there's a ghost stub header creeping in on the Total column.  I've checked the sav file and there's nothing wrong with it. 

 

Where is the ghost header Male coming from?  There seems to be something between the table title and the table even in this mail as when I try to highlight the blank lines to delete them the cells in the table light up as well.

 

I could just edit the table and delete the unwanted header, but there may be a bug in SPSS (even 15)Am I stoopid or what?  Can someone please explain?

I've also had that experience too with SPSS 15 ("extra rows" I used to call them) when exporting to Word. The table looked until I did something to modify the column width, then strange rows appeared:

                                                                              Estadísticos

 

	N	Media	Desv. típ.	Mediana	Percentiles		Mínimo	Máximo
	25	25	75	25	75	25	75	25
J1	85	128,54	31,468	120,00	107,00	147,00	76	220
J2	85	127,29	31,539	118,00	107,00	144,00	74	220
J3	85	126,39	30,515	122,00	105,00	141,00	76	228
R1	85	128,26	31,257	118,00	106,00	146,00	76	220
R2	85	127,60	31,216	118,00	108,00	143,00	76	220
R3	85	126,11	30,201	120,00	106,00	139,00	76	226
S1	85	144,84	33,531	139,00	121,00	162,00	77	228
S2	85	142,74	32,818	132,00	118,50	160,00	88	228
S3	85	141,51	31,526	135,00	123,00	154,00	88	226

The swapping of the 75 and 25 values under Percentiles is particularly curious

I always found that SPSS 15 bug particularly annoying, and I was unable to find a solution (besides copying the pivot tables as images...)

My sympathy,
Marta GG
===================== 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

[MaxJasper]

If you edit this output table and click & drag to increase width of column Total, then you might see more beside "Male" like "Male+Female" or something like that which is completely rational because that column is indeed total of Male+Female columns. You can right click and hide heading for that column if you wish "Male+Female" Total does not show.

 

This is driving me crazy!

 

I'm writing an entry level tutorial on mult response and am trying to copy a table from spo to a Word file.  The final table on the spo is what I want, but however hard I try, when I copy it across to Word there's a ghost stub header creeping in on the Total column.  I've checked the sav file and there's nothing wrong with it. 

 

Where is the ghost header Male coming from?  There seems to be something between the table title and the table even in this mail as when I try to highlight the blank lines to delete them the cells in the table light up as well.

 

I could just edit the table and delete the unwanted header, but there may be a bug in SPSS (even 15)Am I stoopid or what?  Can someone please explain?

 

 

 

 

                                                         Q4*sex Crosstabulation

 

  

 

 

 

 

 

			Q5: Sex of respondent		Total
			Male	Female	Male
Previous experience and skills(a)	Typing	Count	26	80	106
	Word-   process	Count	39	91	130
	Social  stats	Count	15	46	61
	Survey  analysis	Count	10	18	28
	Other	Count	24	53	77
	None of these	Count	3	8	11
Total		Count	50	119	169

Percentages and totals are based on respondents.

a  Group

 

 

 

[MaxJasper]

John,

 

For me, ability to edit SPSS Tables is one of most useful features, otherwise I had to create my tables by other softwares.

 

Max.

 

Max

 

Thanks for this.  Bit late here, so I'll try it tomorrow.  My problem is that I'm writing for entry level users and need the default output to be right first time rather than have to be mucking about with all the fancy bells and whistles which SPSS seem to be fixated on.

 

John

----- Original Message -----

From: [hidden email]

To: [hidden email]

Sent: Monday, March 01, 2010 9:22 PM

Subject: RE: Ghost stub title in mult response crosstabs

If you edit this output table and click & drag to increase width of column Total, then you might see more beside "Male" like "Male+Female" or something like that which is completely rational because that column is indeed total of Male+Female columns. You can right click and hide heading for that column if you wish "Male+Female" Total does not show.