Excel Output: Filters Unwrapped

Tal Mickel shared this idea 2 years ago
Completed

Hey


When we export a report to excel, with the filters shown, the cell which holds the filters value is a single, very long string which exported unwrapped.

It causes a widening of the first column.

See screenshot below


YF version: 7.2 20170413


Thanks!

Dor & Tal


f01e14f7ace1d18bc9ccf571707fcd4f

Comments (8)

photo
2

Hi Dor and Tal,


Thanks for getting in touch about this. I've tested this on my end and can confirm that I see the same behavior. However, I don't believe that this is necessarily an example of Yellowfin or the XLSX exporter behaving improperly. Instead, this seems to be an example of the software behaving as designed, but producing results that aren't aesthetically pleasing. So, I'm going to convert this topic from a Problem to an Idea instead. This will then go before the product team for a decision on inclusion in a future Yellowfin build. Please keep an eye on this post for future updates from us :)


Thanks,

-Conner

photo
1

Thanks Conner!

photo
1

Hi Dor and Tal,


My apologies, I neglected to attach our internal tracking ID # for this Idea! It's good to keep this on hand in case you need to ask us about the case in the future. The tracking ID is YFN-6245.


Thanks!

-Conner

photo
1

Hey Conner !


Is there any update for this idea ?

photo
1

Hi Dor,


Unfortunately no. The task is still yet to be planned.

It does however display ok when exporting to PDF. Is there a reason you want to export to Excel? E.g further data manipulation? Just wondering if maybe the underlying problem here is having to manipulate data in excel ;)


Thanks,

David

photo
1

It is actually, for further processing, data manipulation, but we also have users that doesn't have Yellowfin, they're operative agents, which needs raw data for their work. :)

photo
1

Thanks for the extra info, sounds like we should send them a free-trial ;)

Another thing to think about is the data transformation in 7.4, you could do all manipulation there, and then send them the report they would have wanted to create .

Will keep you posted on any updates.


Thanks,

David

photo
photo
1

Hi guys, just an update on this item.


This idea was implemented in the latest 7.4.8. Change logs for the release can be found here.

Please let us know how it all goes post upgrade, or if there was anything else you were after.


Regards,

David