[Issue 126199] New: Conditional Formatting causes color print to print in greyscale

[bu...@apache.org]

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: meachj@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.

[Issue 126199] Conditional Formatting causes color print to print in greyscale

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126199

oooforum <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oooforum@free.fr

--- Comment #2 from oooforum <oo...@free.fr> ---
I open your first ODS.
It contains macro and if I run a preview, I see 33 pages to print.
Thanks to save ink for my printer and provide a small document with a single
page and without macro inside.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126199] Conditional Formatting causes color print to print in greyscale

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126199

oooforum <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|major                       |normal
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #3 from oooforum <oo...@free.fr> ---
Your bug report is being closed as NOT_AN_ISSUE due to inactivity and a lack of
information which is needed in order to accurately reproduce and confirm the
problem. We encourage you to read my previous comment and provide any requested
information.

Once all of this is done, please set the bug back to UNCONFIRMED and we will
attempt to reproduce the issue.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126199] Conditional Formatting causes color print to print in greyscale

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126199

--- Comment #1 from Jerry.Meach <me...@meach.net> ---
Created attachment 84613
  --> https://bz.apache.org/ooo/attachment.cgi?id=84613&action=edit
Second case that prints correctly.

-- 
You are receiving this mail because:
You are the assignee for the issue.