Book a Demo

Author Topic: Import Excel BUG with MDG Office workaround  (Read 3039 times)

steen.jensen

  • EA User
  • **
  • Posts: 181
  • Karma: +8/-1
    • View Profile
Import Excel BUG with MDG Office workaround
« on: February 11, 2019, 10:32:41 am »
When importing Excel with many columns i.e two-letter columns AA, AB AC etc if you have many Tagged Values and not all object have all columns, the MDG Office can't handle two-letter columns, some values are shifted left to previews columns.

But if you fill all empty columns with i.e "0" (Zero) (Mark whole excel sheet, select Special, select Empty Cell, write a zero, press Enter) then all empty cells are filled with a "0" and  saved the excel and then the import with many columns is working as expected