Support » Plugin: TablePress » Excel import doesn’t honour number format

  • Resolved colinsp

    (@colinsp)


    Importing an Excel spreadsheet where a column is a calculated column (by Excel) the Excel format is 2 decimal places but all decimal places are shown in the table.

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Unfortunately, the experimental Excel import can not always honor data formats. Please try saving the table to a CSV file in Excel and then import that CSV file into TablePress.

    Regards,
    Tobias

    OK thanks I will try that

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    sure, no problem! I hope this helps!

    Best wishes,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.