Mercurial > repos > mheinzl > variant_analyzer2

diff read2mut.py @ 58:04741369fc07 draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
planemo upload for repository https://github.com/Single-Molecule-Genetics/VariantAnalyzerGalaxy/tree/master/tools/variant_analyzer commit ee4a8e6cf290e6c8a4d55f9cd2839d60ab3b11c8
author mheinzl
date Fri, 12 Mar 2021 14:34:21 +0000
parents 706bf8b59eae
children 0b3df6ea1434
line wrap: on
line diff
--- a/read2mut.py	Fri Mar 12 14:29:17 2021 +0000
+++ b/read2mut.py	Fri Mar 12 14:34:21 2021 +0000
@@ -1109,21 +1109,21 @@
                 ws1.write_row(row_number + 1, 0, line2)
                 csv_writer.writerow(line2)
 
-                ws1.conditional_format('L{}:M{}'.format(row + 1, row + 2),
+                ws1.conditional_format('L{}:M{}'.format(row_number + 1, row_number + 2),
                                            {'type': 'formula',
-                                            'criteria': '=OR($B${}="1.1", $B${}="1.2")'.format(row + 1, row + 1),
+                                            'criteria': '=OR($B${}="1.1", $B${}="1.2")'.format(row_number + 1, row_number + 1),
                                             'format': format1,
-                                            'multi_range': 'L{}:M{} T{}:U{} B{}'.format(row + 1, row + 2, row + 1, row + 2, row + 1, row + 2)})
-                ws1.conditional_format('L{}:M{}'.format(row + 1, row + 2),
+                                            'multi_range': 'L{}:M{} T{}:U{} B{}'.format(row_number + 1, row_number + 2, row_number + 1, row_number + 2, row_number + 1, row_number + 2)})
+                ws1.conditional_format('L{}:M{}'.format(row_number + 1, row_number + 2),
                                            {'type': 'formula',
-                                            'criteria': '=OR($B${}="2.1", $B${}="2.2", $B${}="2.3", $B${}="2.4", $B${}="2.5")'.format(row + 1, row + 1, row + 1, row + 1, row + 1),
+                                            'criteria': '=OR($B${}="2.1", $B${}="2.2", $B${}="2.3", $B${}="2.4", $B${}="2.5")'.format(row_number + 1, row_number + 1, row_number + 1, row_number + 1, row_number + 1),
                                             'format': format3,
-                                            'multi_range': 'L{}:M{} T{}:U{} B{}'.format(row + 1, row + 2, row + 1, row + 2, row + 1, row + 2)})
-                ws1.conditional_format('L{}:M{}'.format(row + 1, row + 2),
+                                            'multi_range': 'L{}:M{} T{}:U{} B{}'.format(row_number + 1, row_number + 2, row_number + 1, row_number + 2, row_number + 1, row_number + 2)})
+                ws1.conditional_format('L{}:M{}'.format(row_number + 1, row_number + 2),
                                            {'type': 'formula',
-                                            'criteria': '=$B${}>="3"'.format(row + 1),
+                                            'criteria': '=$B${}>="3"'.format(row_number + 1),
                                             'format': format2,
-                                            'multi_range': 'L{}:M{} T{}:U{} B{}'.format(row + 1, row + 2, row + 1, row + 2, row + 1, row + 2)})                
+                                            'multi_range': 'L{}:M{} T{}:U{} B{}'.format(row_number + 1, row_number + 2, row_number + 1, row_number + 2, row_number + 1, row_number + 2)})                
 	
     # sheet 2
     if chimera_correction: