Sheet format questions -- Excel 2007
When you first open the workbook in Excel, Excel thinks the background colour
has been set for the cells. This will surpress the visiblity of the
gridlines.
--
Gary''s Student - gsnu200909
"TQuestar" wrote:
Two problems arise when I try to translate workbooks from Quattro Pro x4
format to Excel 2007.
In QPRO I save as a XLS file. and then open it in Excel. Generally this
works fine, however I find two problems:
1. The worksheets sometimes lack grid lines in Excel, though the Page Layout
Gridlines section of the ribbon has them checked. (Gridlines were showing in
QPro)
2. If I copy all of one of these sheets lacking gridlines into the
clipboard, open a new blank workbook, and paste, everything is black, because
the background is black. I must go to the Ctl-1 menu and select No Color for
the background. This results in proper appearance and gridlines showing.
Can anyone explain these behaviors? I suspect they are related.
|