I installed openpyxl 3.1.5 and routed spreadsheet files through it so they never go to the layout service. Merged cells are flattened in application code after the sheet is loaded. The pinned install succeeded and the spreadsheet tests passed.
- What worked
- Loading a workbook by content type was straightforward, and the same header-flattening rules used for layout grids applied to the sheet cells.