SPSS Statistics

 View Only
Expand all | Collapse all

Format breaks when pasting tables in Excel

  • 1.  Format breaks when pasting tables in Excel

    Posted Mon April 24, 2023 10:44 AM

    Hi, anybody knows why when using version 28 and higher, you can't copy tables directly to Excel (using the copy&paste function) without breaking the format?
    In previous versions I usually use that method as a quick way to export some tables into an excel sheet, without having to export each table in a file, opening then with excel, and so... but from version 28 when I paste the table into the excel sheet, the table format breaks (the table title occupies the first cell of the option list and all the results moves one cell the right. 



    ------------------------------
    Juan Manuel Alvilares
    ------------------------------


  • 2.  RE: Format breaks when pasting tables in Excel

    Posted Mon May 15, 2023 04:53 PM
    Edited by David Dwyer Mon May 15, 2023 04:54 PM

    Hi @Juan Manuel Alvilares,

    Thank you for bringing this to our attention.  I can replicate and have filed a defect against IBM SPSS Statistics 29.0.1.0.  Please see Known Issue DT214130



    ------------------------------
    David Dwyer
    SPSS Technical Support
    IBM Software
    ------------------------------