Data Source Attachment Import "empty and ignored" Inconsistencies

[S A Martin]

We have an XLSX file with multiple tabs that needs to be imported and transformed, but I'm seeing some inconsistencies with how the different tabs are being loaded.

The tabs all use a similar format with columns populated by formulas being colored a light grey.  When we load the data sets, most of them show the empty rows as "empty and ignored" but one lists them all as "inserted".

I made a new version of the "oddity" tab with no formatting or formulas; It only processes and inserts the rows with data.  As soon as the background format is added to the column, it processes and inserts all 999 rows again.

Any insights as to what could be causing this behavior?

[Slava Savitsky]

Double check that the names of the columns do not consist of reserved words that may break the import process (such as "insert", "update", "query" and the like).

[S A Martin]

They do not use any reserved words.  If that were the issue, I would have expected it to continue when loading it into the new table or using a completely stripped version of the import spreadsheet.