Yes that's the table that I've exported.
There are 100+ columns, some are invisible, the one that I've shared are the columns that are visible. Whenever i export data, all columns (100+ columns) are being exported.
These two columns are the one that was highlighted and bold whenever I export data.
*sorry for the confusion because in my updated file, i've changed the column name.
I beleive this issue is solved in newest release of Qlik Sense (nov or feb). In what Qlik Sense version do you have this problem?
Van: Kanya Kovalenko
Verzonden: dinsdag 27 maart 2018 19:54
Aan: Kristien REYNAERT <Kristien.REYNAERT@bewan.be>
Onderwerp: Re: - Cell and Text format in Exported excel file from qlik sense
I've seen the same issue and, as far as I can tell, it tends to affect only Dimensions (not Measures) where you have a mixture of numeric values and nulls. I've also seen it affect dates/timestamps.
You will notice that the format of the "bad" column in the resulting spreadsheet is Text, while for all other "good" columns it's General.
One workaround that I've used is to wrap the specifier of the offending Dimension in num(), date(), etc. or if possible, specify it as a Measure. I'm not sure if wrapping the dimension in a function forces it to become a measure, but it seems to work.