Gridlines in Excel export

2 posts, 0 answers
  1. Kalli Kaldi
    Kalli Kaldi avatar
    30 posts
    Member since:
    Oct 2011

    Posted 04 Dec 2019 Link to this post

    Hi.

    I'm using the standalone designer to design my report.  When I export to Excel, the gridlines are not visible (see attachec file, Gridlines.PNG).  How can I make them visible during export ?

    Best regards,
    Kalli Kaldi

     

  2. Ivan Hristov
    Admin
    Ivan Hristov avatar
    220 posts

    Posted 09 Dec 2019 Link to this post

    Hello Kalli,

    The visibility of the grid lines in Excel is set to false by default, but can be changed through the device information settings. The name of the key is ShowGridlines. To make the grid lines visible during export from Standalone Report Designer, the following section needs to be added to its configuration file:

    	<Telerik.Reporting>
    		<extensions>
    			<render>
    				<extension name="XLSX">
    					<parameters>
    						<parameter name="ShowGridlines" value="true"/>
    					</parameters>
    				</extension>
    			</render>
    		</extensions>
    	</Telerik.Reporting>

    The reports produced with Standalone Report Designer will be probably rendered in an application. If you need to have the grid lines visible when exporting from this application to Excel, the same section needs to be added to the application configuration file as well.

    Regards,
    Ivan Hristov
    Progress Telerik

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top