How can I increase Row Height when exporting to xlsx format?

[former_member560462]

Crystal Report for Visual Studio 2010, service pack 4

I have a very simple report, with a few database fields in the detail section.  When I export to Excel xlsx the height of the rows is just slightly smaller than my detail text, such that the bottoms are clipped.  I have tried changing the size of the database field entries in the details section.  This makes the rows larger when I export to xls format, but not to xlsx.  Changing the font size does not affect the xlsx row height either.  How can I get my xlsx output to have a rowheight large enough to encompass my data?

-nld

[Former Member · Accepted solution]

Hello Leslie

When I export the attached report, to xlsx it works just fine. In this test, I used the export button on the viewer. (Unzip and rename the file extension to .rpt)

- Ludek

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

Formulas.txt.zip

[former_member560462 · Accepted solution]

Ludek, thank you for your help.  When I load your example in Crystal Reports 2011 Version 14.0.2.364 and export to xlsx, then open the output file in either Excel 2007 or Excel 2010, the row height looks exactly like my report does:  too small.  By too small I mean an underscore in a cell would not be visible, and the dangling letters q,y,p, etc have their feet truncated.  In your example, Bikes reads as Rikes, and Satisfactory is missing the bottoms of the S's.

So of course I copied the xlsx file to another machine, this one XP with Office 2010.  When I open it there, I see Bike and all missing feet.  Very curious, now, and obviously I cannot put the blame on Crystal.

-nld

[former_member560462 · Accepted solution]

To close this thread, I finally realized what the issue was.  Due to the aging process, I don't see as well as I used to, thus I had Control Panel/Display/General/DPI Settings set to Large Size (120DPI).   This in turn made my Arial 10 Normal font larger than it typically would be, and apparently Excel did not take that into account when formatting cell sizes.  Putting the DPI settings back to Normal now allows me to see all the pixels of all the characters in my xlsx report output.

-nld

[Former Member · Accepted solution]

Ahhh, You're in the same club I am , eyes, ears...

Funny thing, I was just about to ask about the DPI - more out of desperation as this usually does not pan out, but once in a blue moon...

Happy coding,

- Ludek