(Posted on behalf of Be Communities Member)
We use the XML reporting tool to generate our reports. We then save the report out, it saves out as html. We open the html file in excel. After making some column adjustments, we highlight the information and copy/paste into MicroStation. The lines forming the columns in the spreadsheet are not black by default. Is there something that I can change in the xsl sheet or a default setting in excel so we don’t have to change each file?
This change will likely be made in the XSL sheet. Can you please clarify what you mean by "The lines forming the columns in the spreadsheet are not black by default."? Do you mean that they are a different color than black or that they actually do not have lines at all? Also, can you please tell me the report that you are running and the style sheet that you are using?
"The lines forming the columns in the spreadsheet are not black by default."? - When I am in Excel and check the color of the lines that make the grid, they are a brownish color. (I will email you the screen shot - I don't see a way to post here.)
"Also, can you please tell me the report that you are running and the style sheet that you are using?" - It's a custom style sheet that Bentley did for us. (I will email that also.) The reports that we use are custom ones created by Bentley for us. This happens with all of our reports.
We noticed that not all of the lines would always print out on the hard copy/PDF. But they are there in the DGN. Someone happen to notice that the line color wasn't black in Excel. When they switch it to black, then it prints fine.
One user did make some change in a theme by editing the "theme.css" file. It fixed the issue with the black lines, but now his word/excel won't open. So we do not want to try that with anyone else yet.
The color of the grid lines can be changed in the CSS that is being called by the XSL
In the header of the XSL, you will most likely see a link to the CSS file being used to control the format of much of the content. In the example below, it is calling "theme.css" from the enigineer folder.
<html> <head> <link rel="stylesheet" type="text/css" href="{$xslRootDirectory}/_Themes/engineer/theme.css"/>
To change the color of the table grid lines, open this CSS (can be opened in any text editor, or xsl editor) and look for the sections for table, th, td, etc... that deal with the format of the table data, and change the various border color entries to 000000 for black.
Below is an example:
Before:
td
{
border-left-color: #FF00FF;
border-bottom-color: #FF00FF;
border-top-color: #FF00FF;
border-right-color: #FF00FF
}
After:
border-left-color: 000000;
border-bottom-color: 000000;
border-top-color: 000000;
border-right-color: 000000
Thanks - that worked!
Answer Verified By: Kevin McDonald