remove text wrapping in export

  • db151

    (@moddingrepair)


    8 months, 1 week ago

    Hi, I wanted to understand if there was a way to prevent the export of the order in the notes field, a way to prevent it from being prevented in the export by inserting the entire note if the customer leaves a note with the text wrapped (by clicking enter from the keyboard). without going to the end. A thousand thanks

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author algol.plus

    (@algolplus)

    please open section “Misc Settings” ( at bottom of the page) and add this code

    add_action( 'woe_xls_print_header', function($objPHPExcel, $formater ) {
    $objPHPExcel->getDefaultStyle()->getAlignment()->setWrapText(true);
    },10,2);

    Thread Starter db151

    (@moddingrepair)

    Hi thanks so much for the code, but I noticed that it is for the xls file, could you get the file exported to the CSV? A thousand thanks

    Plugin Author algol.plus

    (@algolplus)

    please don’t click on CSV file.

    start Excel and use menu Data>From Text/CSV.

    So you can configure format for necessary column.

    Thread Starter db151

    (@moddingrepair)

    add_action( 'woe_xls_print_header', function($objPHPExcel, $formater ) {
    $objPHPExcel->getDefaultStyle()->getAlignment()->setWrapText(true);
    },10,2);

    Maybe I explained myself badly, I meant if the code is ok for exporting the csv file? . I only export with csv files

    Plugin Author algol.plus

    (@algolplus)

    hi

    You don’t need any code.

    CSV is plain text format.

    so you must format columns when you open file in Excel, via menu Data.

    Plugin Author algol.plus

    (@algolplus)

    if I still understand you incorrectly — please record the video

    Thread Starter db151

    (@moddingrepair)

    my export file is .csv file. Is the code you gave me good for .csv files or is it only good for .xls files?

    screen : https://prnt.sc/t4e4XvqEx00u

    Plugin Author algol.plus

    (@algolplus)

    1. I sent you code for XLS
    2. You don’t need code to format CSV

    please record the video of the problem

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘remove text wrapping in export’ is closed to new replies.