Business Analytics

Excel Formatting

  • 1.  Excel Formatting

    Posted Thu October 01, 2020 01:29 PM
    in CA 11.1.7 I have BIG text need to be display in excel , But i have fixed cell size and overflow  width 2 in -  white space -No Wrap / Default
    Spacing & breaking used all option (Break, Normal etc..) 

    Getting the output 


    But  need to display as below is any seething

    Pls advice any inputs . it used work in earlier version with these setting 
    enabled • RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL =TRUE and • RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL=TRUE as well 

    Thanks

    ------------------------------
    Chandra Medarametla
    ------------------------------