XLSX cell data type

  • Resolved FortJack

    (@jakobhemmers)


    8 years, 11 months ago

    We are using your plugin and have to say thanks for the great work!

    We have only one issue as we are using EAN codes as product numbers. When we export orders to a XLSX file, the product number will be interpreted as number and Excel will show that like “4,1234E+12” instead of “4123421610128”. Is it possible to fix the cell data type to string over the whole spreadsheet?

    Thanks in advance!

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

    (@algolplus)

    8 years, 11 months ago

    Hello

    For what fields must we force “string” format by default?
    Phone #, customer note, order notes, what else?

    You can temporary modify file /classes/formats/class-woe-formatter-xls.php
    replace
    $this->objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow( $pos, $this->last_row, $text );
    with
    $this->objPHPExcel->getActiveSheet()->setCellValueExplicitByColumnAndRow( $pos, $this->last_row, $text );

    But I suggest you create ticket . I’ll provide you modified version for tests.

    thanks, Alex

    • This reply was modified 8 years, 11 months ago by algol.plus.
    Thread Starter FortJack

    (@jakobhemmers)

    8 years, 11 months ago

    Thank you for the feedback. We have created a ticket.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘XLSX cell data type’ is closed to new replies.