https://bz.apache.org/ooo/show_bug.cgi?id=126199
Issue ID: 126199 Issue Type: DEFECT Summary: Conditional Formatting causes color print to print in greyscale Product: Calc Version: 4.1.1 Hardware: PC OS: Windows 7 Status: UNCONFIRMED Severity: major Priority: P5 Component: printing Assignee: issues@openoffice.apache.org Reporter: mea...@meach.net Created attachment 84612 --> https://bz.apache.org/ooo/attachment.cgi?id=84612&action=edit Calc file with un-needed sheets deleted. Randomizing is used to assign people to two Bridge Sections that have Avery 5147 labels printed in different color Fonts (Section A is Black Font, Section B is Red Font). Each Label has data from 6 rows of the "NameTags" Sheet. The Conditional Formatting formula below is used to change Font Color for Section B to Red, using "SectionB" Cell Style. RIGHT(INDIRECT("NameTags.A"&TRUNC((ROW()+5)/6)*6-5);3)="(B)" Two Calc files are attached that differ only by random Section assignments performed by Macro assigned to Randomize button on Row 1 of "Pairs" Sheet. Macros must be Authorized. ___________________________________________________________ FIRST FILE: ConditionalFormattingBugFirstBlack.ods The first label is for Section A. Color printing is changed to greyscale if all pages are printed. If printing is started on page 2, all output is correct. Print preview is perfect in all cases. PDF print file is perfect in all cases. ___________________________________________________________ SECOND FILE: ConditionalFormattingBugFirstRed.ods (will submit later) The first label is for Section B. Result is correct for printing all pages, or any subset. ___________________________________________________________ All printing was in color mode with a Brother MFC9450CDN laser printer. Calc is the only application with greyscale substitution for requested color output. -- You are receiving this mail because: You are the assignee for the issue.