Showing memos in image coding reports

[fantachiara]

Hi! I'm using QC to annotate some images containing handwritten text. I needed to code the images and annotate it with the transcription of the text, but annotation aren’t supported for images. So I put this transcriptions in memos, but then they didn't show up when exporting the coding to xlxs (while they were there in txt, html and odt format).
I slightly changed the report_codes.py and now they appear. Still, I played by ear so I'm posting to see if that's alright :)

# Column headings
        col_headings = ["File/case", "Coder", "Coded", "Id", "Codename", "Memo"]
        row = 1
        for col, code in enumerate(col_headings):
            ws.cell(column=col + 1, row=row, value=code)

        for row, data in enumerate(self.results):
            ws.cell(column=1, row=row + 2, value=data['file_or_casename'])
            ws.cell(column=2, row=row + 2, value=data['coder'])
            coding_id = ""
            if data['result_type'] == 'text':
                coding_id = "ctid:" + str(data['ctid'])
                ws.cell(column=3, row=row + 2, value=data['text'])
            if data['result_type'] == 'image':
                coding_id = "imid:" + str(data['imid'])
                ws.cell(column=3, row=row + 2, value="image")
            if data['result_type'] == 'av':
                coding_id = "avid:" + str(data['avid'])
                ws.cell(column=3, row=row + 2, value="a/v")
            ws.cell(column=4, row=row + 2, value=coding_id)
            ws.cell(column=5, row=row + 2, value=data['codename'])
            ws.cell(column=6, row=row + 2, value=data['coded_memo'])
            categories = self.categories_of_code(data['cid'])
            for i, category in enumerate(categories):
                ws.cell(column=7 + i, row=row + 2, value=category)
                ws.cell(column=7 + i, row=1, value='Category')  # Headings
        filepath, ok = QtWidgets.QFileDialog.getSaveFileName(self,
                                                            _("Save Excel File"), self.app.settings['directory'],
                                                            "XLSX Files(*.xlsx)")
        # options=QtWidgets.QFileDialog.Option.DontUseNativeDialog)
        if filepath is None or not ok:
            return
        if filepath[-4:] != ".xlsx":
            filepath += ".xlsx"
        wb.save(filepath)
        msg = _("Each row contains filename, coder, coded, codename and categories.") + "\n"
        msg += _('Report exported: ') + filepath
        Message(self.app, _('Report exported'), msg, "information").exec()
        self.parent_textEdit.append(msg)

This start at line 781. I added "Memo" in the headings, and the line ws.cell(column=6, row=row + 2, value=data['coded_memo']), then changed column=6 to column=7 in the two following lines.

[ccbogel]

Thank you. Thats a great idea.
I have added the code changes to the latest 3.6 code.
regards Colin