Format XLS column to ‘text’ data type

  • Resolved sven31

    (@sven31)


    6 years, 9 months ago

    Values in a column start with something like ‘00003421’ in my custom field but when it is exported in XLS, it shows only ‘3421’ in the cell. It ignores the zero values. Moreover, I want them in text data type.

    How can I export the data in plain text format as it is (including zeroes)?

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Shambix

    (@shambix)

    6 years, 9 months ago

    Could you please share a link where I can download the xls file?
    Could you also provide the csv file for download?

    Thread Starter sven31

    (@sven31)

    6 years, 9 months ago

    Hi Shambix, please check https://bit.ly/2YoRIcc for XLS and https://bit.ly/2ZztWqb for CSV.

    Thanks!

    Plugin Author Shambix

    (@shambix)

    6 years, 9 months ago

    Hey @sven31, I’ve finally had some time to review this scenario.
    Technically it would be possible to tell the export what type of cell each one is, but the plugin would have to be extended, since the export currently treats all cells as generic. Also, since you have specific numbering, this might not work for everybody’s needs.

    Unfortunately, since it’s very easy/fast to set a cell type from Excel itself, once you open the file, it’s not a critical feature/bug… it would take too long to take care of this specific request in my free time.
    I could work on this mod for you, for a fee and therefore a short amount of time, if you want (feel free to contact me directly in case)!

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

The topic ‘Format XLS column to ‘text’ data type’ is closed to new replies.