SPSS Statistics

 View Only
  • 1.  Table looks not compatible?

    Posted Fri January 21, 2022 09:21 AM
    After recently updating from SPSS Statistics 24 to version 28, I noticed that pivot table looks used in version 24 do not work in version 28 when I set them as the current standard look either in the Options dialog or using the 'Set TLook' syntax. SPSS 28 issues an error message in tne output window ('File xy.stt specified for SET TLook is not a valid SPSS Statistics file') and then applies the system default look.

    However, when I generate a pivot table using a look newly generated in SPSS 28 and then edit the table and apply a look generated in version 24, this works without problems.

    How can I make my table looks generated in SPSS 24 fully compatible with version 28?

    I also noticed that font sizes in the output viewer (pivot tables as well as plain text output) generally appear much smaller on the screen in version 28 than they used to appear in version 24 even though the specified point sizes are identical (this does, however, not affect printed output). Can this be changed?

    My OS is MS Windows 10.

    ------------------------------
    Frank Furter
    ------------------------------


  • 2.  RE: Table looks not compatible?

    Posted Fri January 21, 2022 03:38 PM
    Hi. I wonder if we could look at that file and see if we can figure out the exact problem. Could you please post it here or send it to me privately? Thank you.

    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------



  • 3.  RE: Table looks not compatible?

    Posted Fri January 21, 2022 04:01 PM
    Someone mentioned to me that the file might have a byte order mark (BOM) at the beginning, which could cause this. Make a copy of the STT file and on the copy try deleting that and seeing if that fixes it. For more information on how to do that in Windows for example, see this.

    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------



  • 4.  RE: Table looks not compatible?

    Posted Sat January 22, 2022 12:07 PM
    Dear Rick,

    thank you very much for your support. Please find one of the table looks that used to work well up until SPSS Statistics 24 but does not work in version 28 (I skipped the versions in-between) set set as the default look (using SET Tlook) below. I tried to attach the .stt file to this message but the forum software says that it can't upload the file because the file type is not supported :-\ As far as I can see, there is no BOM in that file.

    Best, Andreas

    <?xml version="1.0" encoding="UTF-8"?><tableProperties xmlns="http://www.ibm.com/software/analytics/spss/xml/table-looks" xmlns:vizml="http://www.ibm.com/software/analytics/spss/xml/visualization" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ibm.com/software/analytics/spss/xml/table-looks http://www.ibm.com/software/analytics/spss/xml/table-looks/table-looks-1.4.xsd">
    <generalProperties hideEmptyRows="false" maximumColumnWidth="1.9cm" maximumRowWidth="8cm" minimumColumnWidth="1.504cm" minimumRowWidth="1.2cm" rowDimensionLabels="inCorner"/>
    <footnoteProperties markerPosition="superscript" numberFormat="alphabetic"/>
    <cellFormatProperties>
    <caption>
    <vizml:style color="#000000" font-family="Arial" font-size="8pt" labelLocationVertical="positive" margin-bottom="1pt" margin-left="0.182cm" margin-right="0.182cm" margin-top="1pt" textAlignment="left"/>
    </caption>
    <footnotes>
    <vizml:style color="#000000" font-family="Arial" font-size="8pt" labelLocationVertical="positive" margin-bottom="0.041cm" margin-left="18pt" margin-right="18pt" margin-top="2pt" textAlignment="left"/>
    </footnotes>
    <rowLabels>
    <vizml:style color="#000000" font-family="Arial" font-size="9pt" labelLocationVertical="positive" margin-bottom="0.041cm" margin-left="0.182cm" margin-right="0.182cm" margin-top="1pt" textAlignment="left"/>
    </rowLabels>
    <columnLabels>
    <vizml:style color="#000000" font-family="Arial" font-size="9pt" labelLocationVertical="negative" margin-bottom="0.041cm" margin-left="0.182cm" margin-right="0.182cm" margin-top="1pt" textAlignment="center"/>
    </columnLabels>
    <data>
    <vizml:style color="#000000" font-family="Arial" font-size="9pt" labelLocationVertical="positive" margin-bottom="1pt" margin-left="0.1cm" margin-right="0.1cm" margin-top="1pt" textAlignment="mixed"/>
    </data>
    <layers>
    <vizml:style color="#000000" font-family="Arial" font-size="9pt" font-weight="bold" labelLocationVertical="negative" margin-bottom="0.041cm" margin-left="0.182cm" margin-right="0.182cm" margin-top="1pt" textAlignment="left"/>
    </layers>
    <title>
    <vizml:style color="#000000" font-family="Arial" font-size="10pt" font-weight="bold" labelLocationVertical="center" margin-bottom="6pt" margin-left="6pt" margin-right="8pt" margin-top="1pt" textAlignment="center"/>
    </title>
    <cornerLabels>
    <vizml:style color="#000000" font-family="Arial" font-size="9pt" labelLocationVertical="negative" margin-bottom="1pt" margin-left="0.182cm" margin-right="0.182cm" margin-top="1pt" textAlignment="left"/>
    </cornerLabels>
    </cellFormatProperties>
    <borderProperties>
    <topInnerFrame borderStyleType="thick" color="#000000"/>
    <rightInnerFrame borderStyleType="thick" color="#000000"/>
    <horizontalDimensionBorderColumns borderStyleType="solid" color="#000000"/>
    <horizontalDimensionBorderRows borderStyleType="solid" color="#000000"/>
    <horizontalCategoryBorderColumns borderStyleType="solid" color="#000000"/>
    <leftInnerFrame borderStyleType="thick" color="#000000"/>
    <verticalDimensionBorderRows borderStyleType="none" color="#000000"/>
    <titleLayerSeparator borderStyleType="none" color="#000000"/>
    <verticalCategoryBorderRows borderStyleType="none" color="#000000"/>
    <topOuterFrame borderStyleType="none" color="#000000"/>
    <bottomInnerFrame borderStyleType="thick" color="#000000"/>
    <leftOuterFrame borderStyleType="none" color="#000000"/>
    <dataAreaTop borderStyleType="thick" color="#000000"/>
    <verticalDimensionBorderColumns borderStyleType="solid" color="#000000"/>
    <dataAreaLeft borderStyleType="thick" color="#000000"/>
    <horizontalCategoryBorderRows borderStyleType="solid" color="#000000"/>
    <bottomOuterFrame borderStyleType="none" color="#000000"/>
    <rightOuterFrame borderStyleType="none" color="#000000"/>
    <verticalCategoryBorderColumns borderStyleType="solid" color="#000000"/>
    </borderProperties>
    <printingProperties continuationText="(cont.)" continuationTextAtBottom="true" continuationTextAtTop="false" printAllLayers="true" printEachLayerOnSeparatePage="false" rescaleLongTableToFitPage="false" rescaleWideTableToFitPage="true" windowOrphanLines="2"/>
    </tableProperties>

    ------------------------------
    Frank Furter
    ------------------------------



  • 5.  RE: Table looks not compatible?

    Posted Sat January 22, 2022 01:46 PM
    I tried this file, which definitely does not have a BOM in V28 and got the error message when this was set as the default.  However, if I created a table without it and then applied this look using the pivot table editor, it worked correctly.

    I see that the schema location in the look is invalid, but so is the location in other schema files that work.

    The other looks refer to schema versions 1.5 while this file refers to 1.4, but the differences between the two schemas seem innocuous and referencing 1.5 did not help.  This look does not have the name attribute, but adding that in did not help either.

    --





  • 6.  RE: Table looks not compatible?

    Posted Sat January 22, 2022 04:37 PM
    One more comment.  If I apply the incompatible look in the pivot table editor and then resave it, it then works correctly when set as the default look.  So that would provide a workaround.

    --





  • 7.  RE: Table looks not compatible?

    Posted Mon January 24, 2022 06:53 AM
      |   view attached
    Sure, applying the look in the pivot table editor and then re-saving it can be used as a workaround.

    I did this and then compared the XML code between the versions of the look saved in SPSS 24 and 28. The 'critical' difference is in the first lines; when I copy them from the Version 28 look to the Version 24 look, it works. I was, however, yet unable to determine what exactly makes the difference. I enclose a comparison between the two versions (the track changes show the changes in the Version 28 code as compared to the Version 24 code).

    ------------------------------
    Frank Furter
    ------------------------------

    Attachment(s)

    pdf
    Table Look XML.pdf   13 KB 1 version