print titles: print_title_rows does not work in LibreOffice

Issue #973 invalid
Christian
created an issue

Print titles created using

print_title_rows

or

print_title_cols

don't stick in LibreOffice 6.0 but work fine in MS Excel 2013. I haven't tested in previous LibreOffice versions.

If you create a new excel file in MS Excel and repeat a row, LibreOffice gets it..

Comments (8)

  1. Christian reporter

    Thanks for your quick response.
    You're right, I thought of that, but since LibreOffice opens MS Excel-generated files correctly, I suspected openpyxl to be guilty..
    Example file attached.

  2. CharlieC

    As far as I can tell this is a problem with LibreOffice not handling the cell references correctly. If you add the same rows in LO manually and look at the file you'll find that it essentially duplicates the print titles.

    LibreOffice still has a lot of OOXML related bugs so it's best to assume that the problem is with it and not openpyxl which follows the specification.

     <definedNames>
      <definedName function="false" hidden="false" localSheetId="0" name="_xlnm.Print_Titles" vbProcedure="false">
       Sheet!$1:$2
      </definedName>
      <definedName function="false" hidden="false" localSheetId="0" name="_xlnm.Print_Titles" vbProcedure="false" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
       Sheet!1:2
      </definedName>
    
  3. Log in to comment