Posted on 2011-10-18
We have recently had a printing issue with certain excel files whereby when printed, the output would have rows of data to a point and then only formatting and then sometimes more data.
We have got round it by copying and pasting values into a blank sheet and then printing that. The font etc is only a basic font (Arial 10) so I don't believe its to do with the print drivers even though it is quite an old printer HP2050. Working in Excel 2003 with 2007 compatibility installed and the latest SP.
I thought I had discovered the reason, bizarre as it seems. A certain report would stop printing the data but would continue with formatting at a point where the contents of the cell were too big for the cell so would give the ### entry. We overcame this with the obvious answer of expanding the column and also then seem to overcome this with the latest SP but the problem now seems to have come back, the files in question haven't been used for some time so it might not have gone way altogether in the first place.
I think I have found the reason for the problem but want to confirm with the opinion of other Experts.
The reports affected have data exported from SAP. The Export is done by displaying the report in an Excel window within SAP, as opposed to the Inactive option. This is then highlighted, copied and pasted into an excel workbook. The report in excel usually has reasonable pastel coloured formatting but when pasted into Excel the formatting turns into garish shades of red and green. I normally just remove all fill formatting as it is usually only used for lookup purposes.
What sometimes happens though is that the paste retains the pastel colours as per the report within SAP and the colour palette within the workbook is changed so other formatting in the workbook also changes. In these cases if I reset the colour pallette the colours go garish again.
I think that has explained the scenario reasonably well up to today.
So, today I have a report that won't print properly and having thought about the colour pallette I reset the pallette in this particular workbook and the colours go garish. This sheet would then print properly (shades of grey anyway as its a b&w printer).
So the question is, am I right in thinking that it is the colour pallette that is causing the print problems? As its a new version of the SAP GUI(Release 8??) could the colour scheme be too complicated for the old printer?
If so, I will know to manage the exports accordingly to avoid the print problem.
Many thanks for your input!