Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text format on excel export

I have and ID field that is formatted to look like a hyperlink (blue, underlined). I there an easy was to make this turn back to regular black text when exporting to excel? Right now it looks like a hyperlink in excel.

Thanks!

Labels (1)
3 Replies
Not applicable
Author

Guess i'm going to have to go the macro approach?

Not applicable
Author

anyone.... going once...

erichshiino
Partner - Master
Partner - Master

You could create another object without the formatting but I think you would still need a macro.

I created one for this case. I export the object data to excel (it goes with the formatting).

After this, I send commands to excel to format it as I want.

Please, check sample app attached.

Best Regards,

Erich