in reply to Re^2: conditional_formatting problem
in thread conditional_formatting problem

The next step for you is to reduce your failing program to a short progam (20 lines) that still exhibits the problem. Then post this program together with the exact error message as copied from your terminal. This allows us to replicate your problem and maybe suggest a solution or a workaround.

Replies are listed 'Best First'.
Re^4: conditional_formatting problem
by musteata93 (Initiate) on Apr 08, 2016 at 07:50 UTC
    The script contains 445 lines. It is a program that creates a XLSX file and puts some information. The program works well until i try to use conditional formatting. The XLSX is created, the information is written but formatting is not working. This is what appears in terminal: Can't locate object method "conditional_formatting" via package "Excel::Writer:: XLSX::Worksheet" at D:\DSUsers\UIDQ2935\compare_projects\extract_c_files.pl line 416.

      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.