wb.copy_worksheet does not copy background colors

Issue #1343 new
stdedos created an issue

The worksheet I am working on is xlsx 2007-365 format (created by LibreOffice)

Comments (4)

  1. stdedos reporter

    The issue is more intricate:

    Even though the original sheet is not modified, "almost all" color from every sheet is removed.

    Attaching before, and after version

    Code cannot get any simpler:

    def create_mock_wb():
        wb = load_workbook('Sanitized-2-Orig.xlsx')
    
        for i in range(1, 31):
            target = wb.copy_worksheet(wb['Pattern'])
            target.title = '%02d.09' % i
    
        wb.save('Sanitized-2-Modified.xlsx')
    
  2. Log in to comment