When I open a Excel file in MapInfo 2019, all the fields default to Character type

Occurrence

In MapInfo 2019, when I go to Open Table and select a Excel file, all the fields default to Character type. But in Excel they are formatted Number type.

Solution

This issue is fixed in MapInfo 2019.1 which can be downloaded with the latest Discover bundle here -

This is a regression defect introduced in MapInfo 2019. To workaround the issue, you can save the Excel file as a CSV. A CSV file can still be eited in Excel, and it will defualt to the appropriate fields types when opened in MapInfo.


Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Remove Highlighting Remove Highlighting

Edit this article

User Opinions (2 votes)

100% thumbs up 0% thumbs down

How would you rate this article?




Thank you for rating this article.

Related Articles

No related articles were found.

Attachments

No attachments were found.

Last Updated on: 1st of April, 2020