This content has been marked as final.
Show 3 replies
-
1. Re: Excel cell border disappears when converting to PDF (continued)
Ozzwoman9 Dec 23, 2008 8:59 AM (in response to CharlesBelov)I have never created a pdf from excel (only word), but I have run into the issue before where the word doc was setup outside the print area (this occurred even when the margins were set to zero). As I didn't do this often, my workaround was to move the contents on the document away from the edge more. Not sure if this is your problem, but thought it may help. -
2. Re: Excel cell border disappears when converting to PDF (continued)
CharlesBelov Dec 23, 2008 10:19 AM (in response to CharlesBelov)They are edge cells, C1 and D1, but I can't move them away from the edge. In order to produce an accessible PDF document, column headers must be entirely in the first row of a table. -
3. Re: Excel cell border disappears when converting to PDF (continued)
CharlesBelov Dec 23, 2008 12:36 PM (in response to CharlesBelov)I just tested inserting a blank row 1 in the spreadsheet, moving the problem cells to C2 and D2, but the borders still disappear from those cells.
Restoring back to C1 and D1, I note that if I copy the cell formats to other worksheets, the problem cells lose their borders on all worksheets.
I then tested what happened if I specified No Color for C1 and D1. The problem transferred to cells G1 and H1, which had then become the first adjacent cells with background color.
Restoring the background color to C1 and D1 transferred the problem back to C1 and D1, and removed the problem from G1 and H1.
Next, I gave cell A1 a background color of white. This removed the problem from cells C1 and D1, and gave it to A1.
Finally, I turned accessibility tagging off and that made the problem go away. However, I need tagging as we must post accessible documents.
So now I have a consistent way to describe the problem: cell borders disappear from the first set of contiguous cells with background colors if tagging is turned on. I'm going to file this as a bug.
Charles "Chas" Belov
SFMTA Webmaster
http://www.sfmta.com/webmaster

