YF to Excel formatting requirement

Ticout Support Team shared this idea 2 months ago
Not Planned

Hi YF,

We are looking to have the exporting formatting looked at for Excel...

As it stands when exporting to Excel we have an issue with the alignment of our text. Within YF we have a table built with Suppress Duplicates turned on. In YF this is aligned to be top. Exporting Aligns this to the bottom.

See the example below using the SKI Team.

3fcfd5ea745d83fa3b5deb653dfe6a63

To our understanding this appears to be a limitation with the exporting tool. We have a workaround by formatting the cells in Excel. This is good although we would like this implemented for YF as exporting hundreds of reports to Excel would take a long time to format each cell.

Regards,

Marc

Comments (8)

photo
1

Interesting, in my implementation of YF it's center aligned. I prefer top aligned for at least one of my reports.

https://community.yellowfinbi.com/topic/vertical-alignment-in-columns

Unfortunately, that's not the case:

0c41d8987e53bf8bae5a3771f749bbd8

photo
1

Hi Larry,

From your image attached, I can see you originally had this as centre aligned in YF and when you exported to Excel it kept the alignment? Is this correct?

Regards,

Mark

photo
1

Hi Mark,

I missed this reply. I have never tried to export this to Excel because this facesheet is exported as PDF in order to keep the HTML formatting. It doesn't seem that Excel vertical alignment is implicitly defined; when I export reports it is exported with Excel's default, bottom align. Lastly, my implementation is a third party license and I cannot get into the CSS because of the license limitations. It would be nice to have a section in the Admin Console that allows for CSS changes that carryover to Excel exporting.

photo
1

Hi Larry,

Thank you for the feedback, i'll add this to the notes.

Regards,

Mark

photo
photo
1

UPDATE

We have gone ahead and logged this Idea as an Enhancement. We will have this reviewed in the near future, all updates will be posted here.

Regards,

Mark

photo
1

Thanks for the update.

Regards,

CT

photo
1

No problem.

Regards,

Mark

photo
photo
1

UPDATE

Unfortunately as of yet we have no plans to implement this in YF. Our only work around would be to manually change the alignment within Excel.

Regards,

Mark