Title with spaces & print title causes excel error

Issue #743 resolved
Michal created an issue

When I create xlsx file and set worksheet's title with spaces inside and then I am trying to add print title rows this way:

ws.print_title_rows = '1:1'

I get exception from MSExcel.

I look into xml and see this

<definedName localSheetId="3" name="_xlnm.Print_Titles">
   'title with spaces!1:1'

I suppose that closing quotation mark is in wrong place, I think it should be just before exclamation mark

'title with spaces'!$1:$1

I use Python 2.7 and openpyxl 2.4.1

Comments (2)

  1. Log in to comment