Excel jasper reports hiding cell borders in opaque mode
Posted on September 25, 2017 at 6:32am
Not allowing conditional formatting in Excel after exporting reports into Excel (not highlighting, not allowing to "Fill")
Attempt to highlight a cell, doesnt work unless you double click.
using opaque mode to that column solves the prblm but cell borders also getting hidden
Joined: Jan 6 2016 - 1:18am
Last seen: 5 years 1 month ago
Posted on September 25, 2017 at 2:33pm
Just tested if borders with background color will show when exporting to xlsx - it seems to be working. I'm using Jaspersoft Studio 6.4.0.
How are you applying borders? Are you selecting a text element and setting borders from "Properties" (lower right hand side of Jaspersoft Studio" - "Borders" tab?
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 9 months ago
Posted on September 28, 2017 at 1:43am
hey if we are applying borders then those are visible, but they print on paper while printing.Normal excel cell borders are getting hidden in opaque mode so the excel report looking like white sheet with no borders betweens data
Joined: Jan 6 2016 - 1:18am
Last seen: 5 years 1 month ago
Posted on October 16, 2017 at 12:51am
hey hozawa, can you please tell me, if we are using opaque mode for an element and we export it to excel, the grid lines of that cell disappear, ho can we keel them as it is using opaque mode?
Joined: Jan 6 2016 - 1:18am
Last seen: 5 years 1 month ago
I dont want to apply borders, when we are applying conditional formatting in excel reports generated by jasper then background is not getting highlighted to those cell, but if we are applying opaque property to the cell then its is working fine but the cell borders are getting hidden with this opaque property.