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")