Hyperlink appears in wrong cell

Issue #1143 resolved
Nick Pellegrino
created an issue

The file created by the following code is missing a hyperlink in cell B1, and instead has a hyperlink in cell A1.

from openpyxl import Workbook
from openpyxl.worksheet.write_only import WriteOnlyCell
workbook = Workbook(write_only=True)
sheet = workbook.create_sheet()
cells = [WriteOnlyCell(sheet, 'should not have hyperlink'), WriteOnlyCell(sheet, 'should have hyperlink')]
cells[1].hyperlink = 'http://bbc.co.uk'
sheet.append(cells)
workbook.save('hyperlink_in_wrong_cell.xlsx')

This is using version 2.6.0a1.

Comments (5)

  1. Log in to comment