I had the same problem and escalated to Micro Focus.
Their R&D engineer explained the root of the issue, here are the details: ''This is a limitation of the feature ''#SKIP#''. It can only take effect on the columns of which the contents are of 'text' type. Otherwise all texts will be treated as invalid values. This part of logic depends on Microsoft Excel APIs. According to the current connection parameters, the type of a column is determined by the top 8 cells (8 is the default value and it can be changed by the registry settings of the column, NOT including the header. Mixed-typed columns are considered as 'text' right away.''
The R&D engineer explained that the workaround is to make sure the type of the column is 'text', and there's two ways to change this:
1. Manually: In Excel, change the first row of values to ''Text'' or change the first item of the first column to ''Text''.
Change the number to a bigger number, for example 60000. Micro Focus has now documented this in [KM03137588]