If the script contains 445 lines, you have 425 lines to delete. If the problem disappears while deleting some code, then you have likely found a location that is somehow related to reproducing the problem. Put the deleted part back in and delete other parts.

Most likely, the code around line 416 is related to reproducing the problem, so I would start by deleting lines 10 to 400 from the script and rewriting the rest so that it still reproduces the problem. We don't have your setup but it's highly unlikely that we can help you without reproducing your error.

Maybe you can also start by using the example program in Excel::Writer::XLSX and modifying it until it matches your code and still exhibits the problem.

A common case is that while reducing your program you find and correct the error.

In reply to Re^5: conditional_formatting problem by Corion
in thread conditional_formatting problem by musteata93

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.