Who's On?

	Membership:
	Latest: Hitman
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5208

	People Online:
	Visitors: 261
	Members: 0
	Total: 261

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Preserve formatting upon LBI export

2 Replies

2 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

thummel1

Veteran Member

Posts: 121

7/2/2019 4:49 PM

We would like to be able to export existing LBI reports, (or set them to open directly as Excel (.xlsx)) so that the columns are sized according to the data in each column. The purpose of this is so that the end user does not have to spend the extra time re-sizing the columns to see all the data in each column of the Excel spreadsheet

Is there a way to do this if the report is coming from Crystal? I have tried changing some settings in the Export options within the Crystal report, which works great when exporting directly from Crystal, but when I republish this to LBI, the export options do not seem to get retained.

Any thoughts are appreciated!

Donna

Veteran Member

Posts: 110

7/2/2019 6:58 PM

We have had this issue since our upgrade to version 10. We can sometimes overcome it by reformatting the Crystal report but we often have to use the Excel data only export.

JonA

Veteran Member

Posts: 1163

7/10/2019 6:48 PM

Just a thought. Are they resizing each column individually? I can see where that may take time depending on the number of columns. But you can resize all columns at once by highlighting the entire worksheet and double-click the column separator.

Attachments

image_3.png