Inconsistent Boolean Cell format in Output Spreadsheet
This issue is redirected from a downstream issue.
Minimal reproducible example
from openpyxl import Workbook
book = Workbook()
wks = book.create_sheet()
startrow, startcol = 0, 0
for cell in range(64):
xcell = wks.cell(
row=startrow + cell + 1, column=startcol + 1
)
xcell.value = True
book.save("test_direct.xlsx")
Issue Description
An Excel workbook test_direct.xlsx
with two sheets should be created. The column A of Sheet1
should contain 64 boolean values of TRUE()
. Cell values should also be 'boolean value'. However, the cell format after row 32 in 'Sheet1' is 'general number'.