Cell and Text format in Exported excel file from qlik sense

[Anonymous]

Hi,

i'll just ask why is it some cell and text in exported excel file in qlik sense is bold and highlighted.

How does it happed?

What can i do to change it? Because i need the cell and text to be uniform.

Not bold and not highlighted.

*I got this excel file, in Export Data functionality of qlik sense.

Thank You in advance for your response.

[shraddha_g]

Can you share screenshot of this table from qliksense

[Anonymous]

Here's the screenshot in qlik, the columns are actually rambled.

in here, i've used Table to display the data from the database.

I didn't perform any calculation in all the columns.

[shraddha_g]

I couldn't find columns from excels you attached earlier In this qliksense Table

[shraddha_g]

Is it the same table you exported?

[Anonymous]

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.

[shraddha_g]

You are facing this issue in this particular app or in each app this is the same case?

[Anonymous]

In this app only. But I've tried to create new app with the same data, it's still the same.

[kristien]

Hi,

I think it has to do with the formula in the Column. I had the same on a column Year:

When I had 'Dual(Year([Documentdate]),YearStart([Documentdate]))'  in the formula, the column was bold and highlighted, but when is changed the formula in '=Year([Documentdate])', no special format was used.

[Anonymous]

This is happening to me as well and the Columns are not formulas.  Is this still happening to you?