xou/elixlsx

Office For Mac reports error when freezing only top row

Closed this issue · 0 comments

azhi commented

When setting Elixlsx.Sheet pane_freeze to {1, 0}, MS Office on Mac OS complains about corrupted file with

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <logFileName>freeze_bug.xlsx</logFileName>
  <summary>Errors were detected in file 'freeze_bug.xlsx'</summary>
  <removedFeatures summary="Following is a list of removed features:">
    <removedFeature>Removed Feature: View from /xl/worksheets/sheet1.xml part</removedFeature>
  </removedFeatures>
</recoveryLog>

Minimal reproduction:

require Elixlsx

alias Elixlsx.Sheet
alias Elixlsx.Workbook

sheet1 = Sheet.with_name("Freeze bug")
         |> Sheet.set_cell("A1", "Header")
         |> Sheet.set_cell("B1", "value")
         |> Sheet.set_pane_freeze(1, 0)
workbook = %Workbook{sheets: [sheet1]}

Elixlsx.write_to(workbook, "freeze_bug.xlsx")