1. Home
  2. Forum
  3. jQuery
  4. Spreadsheet will not print grid lines.

Spreadsheet will not print grid lines.

Sheet

Using this code:

var xlObj = $("#worksheet").data("ejSpreadsheet");  
xlObj.option({sheets: [{ "showGridlines": true, "printGridlines": true }]}); 
xlObj.XLPrint.printSheet();

Get this result:



Version: 16.2.0.50
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36





5 Replies
SK Shanmugaraja K Syncfusion Team September 26, 2018 11:55 AM UTC

Hi Eric, 
 
Thank you for using Syncfusion products. 
 
We have checked your reported query, by printing the worksheet by using the “printSheet” method in a button click event with provided details. The Spreadsheet print properly with gridlines and working fine from our side. For your convenience, we have prepared a JSPlayground sample & video to demonstrate this and the same can be downloaded from the below link, 
 
 
 
Note: The “printGridLines” is not an API. 
 
Could you please check the above sample and get back to us with more information to replicate this issue in our end, if possible please provide issue reproducible sample so that we can analyze based on that and provide you a better solution?  The information provided would be great help for us to resolve this issue. 
 
Regards, 
Shanmugaraja K 


ES Eric Solari September 26, 2018 04:35 PM UTC

Grid lines in your example print incorrectly when loading data from JSON.

https://gist.github.com/sliceofbytes/0d7382c08175a2a96d75304d2e81c75a

I'm using
ej.widgets.core.bootstrap.min.css
ej.theme.min.css
ej.widget.spreadsheet.min.js
jsrender.min.js


Which styles should I be looking at to determine why no grid lines appear?

As you can see in the following print page output it is not including any relevant styling for borders.

https://gist.github.com/sliceofbytes/dbcdedef212c65e3ffc9a01f58007ea3



SK Shanmugaraja K Syncfusion Team September 27, 2018 12:54 PM UTC

Hi Eric, 
 
Thank you for your update. 
 
We have checked your provided details by preparing the spreadsheet sample that refers the online CDN link for (ej.widgets.core.bootstrap.min.css & ej.theme.min.css) files and it is working fine from our side. We would suggest you to use (“ej.web.all.min.css”) file from CDN location. 
 
CDN LINKS: 
 
 
 
However, we would suspect that the cause of this issue may be CSS file name that you have referred in the sample may be mismatched, so we would suggest you to use the above CSS files with the names referred as like in the online CDN link. 
 
Could you please check with the above CDN links & sample and kindly get back to us, if you need any further assistance on this? 
 
Regards, 
Shanmugaraja K 


ES Eric Solari October 26, 2018 08:56 PM UTC

The example you provided does not print correctly.












SI Silambarasan I Syncfusion Team October 30, 2018 09:09 AM UTC

Hi Eric, 
 
Thank you for your update. 
 
We have checked your reported query with our previously provided sample and the Spreadsheet printing properly with gridlines & working fine in our end. For your convenience, we have prepared a video to demonstrate this and the same can be downloaded from the below link, 
 
 
 
However, we would to know the below details. 
 
1. Please share the details or code snippet if you did any CSS customization in Spreadsheet (sample level) since in the provided screenshot – Spreadsheet header is customized with blue background.  
 
2. Also, we suspect that it might be occurred due to CSS override in sample level. So, please provide the details about the stylesheet references that are loaded in your page. 
 
Could you please get back to us with the above information or share issue reproducible sample if possible, so that we can analyze based on that and provide a better solution? The information provided would be great help for us to proceed further. 
 
Regards, 
Silambarasan 


Loader.
Up arrow icon