This forum is no longer open and is for reading/searching only.

Please use our new MachForm Community Forum instead.

MachForm Community Forums » MachForm 4

Zero Disappear on Export


  1. stuartwright
    Member

    Hi,
    I am trying to export lots of our form data but the telephone numbers keep coming out with the inital zero cut off.

    I found this post (http://www.appnitro.com/forums/topic/zero-start-value-disappears-in-excel#post-7826) with the same issue, but following the instructions don't seem to work anymore. Has this changed in v4?

    We store the telephone as a number field, rather than using the built in telephone if that effects things.

    Posted 9 years ago #
  2. yuniar

    It's the same case as the link you mentioned, but in version 4 you can edit the export_entries.php file around line 912:

    $worksheet->write($row_num, $col_num, $data);

    change it to become:

    $worksheet->writeString($row_num, $col_num, $data);

    MachForm Founder

    Posted 9 years ago #

RSS feed for this topic

Reply