Different printers = different output

[Beyerconst]

Currently using Office 2016.

I regularly use a workbook which employs formulas/arrays. When printing the base sheets, the cells with formulae are currently "empty".

On the inkjet printer, the cells are output as blank, which is what is intended.

On our large copier, the cells are each populated with the same value, and then the sheet is printed. Said value is one of two possible array return values, however this problem is recent and did not affect the workbook in the past. Please see attachment for an example.

I wouldn't think a simple printer setting is to blame, so I'm currently at a loss on how to remedy the situation.

Excel.jpg

[JLGWhiz]

From what source does the 'CCS' derive? If it appears on one printer and not on the other, could it be because one printer is black and white print only and the other is color with the CCS being entered in white font? Wouldn't show on the color printer but would show on the black and white. If not that, must be something similar. Printers do not create text entries.

[Mabocat]

I have a similar problem with different printers
Just changed from Epson to Canon and now find spreadsheets that are more than one page, are reduced in size even though I have not altered spreadsheet margins. Is this normal when changing printer brands. I spent a lot of time getting the printed format to what I wanted but now !!!

Ron

[Mabocat]

Bit more - I found this only happens on landscape outputs and will not be centred horizontally even if set to do so. A quirk of Canon printers I guess?

[Mabocat]

as advised by Canon Australia

PIXMA MG2560 has a bottom non printable margin area of 16.7mm which is greater than the standard 5mm on higher priced printers. Please allow for this margin limitation when printing documents on the MG2560.


So I am stuck with this until printer fails.

Ron