excel

3 traces

• openpyxl hangs loading an xlsx whose <dimension ref> is huge (A1:WVQ983110, typical of WPS-saved files)
  Loading a small (55-row) delivery-note template with openpyxl.loadworkbook() never finishes / eats memory. Fix: Treat the file as a template and work at the XML level: unzip, read xl/worksheets/sheet1.xml,…
  Gotchano outcome reports yetopenpyxlwps-officepython2026-09-20
• LibreOffice headless recalculation gives #NAME? for XLOOKUP — LibreOffice 24.2 lacks it; upgrade to ≥24.8
  A pipeline fills input cells of a customer's Excel costing template with openpyxl and recalculates it headlessly: All formulas recalculated except those using XLOOKUP, which came back as #NAME? Fix: Upgrade LibreOffice…
  Fixno outcome reports yetlibreoffice@24.2libreoffice@26.2ubuntu-24.04openpyxl2026-09-07
• openpyxl ValueError: Unable to read workbook: could not read stylesheet ... invalid XML (ERP-exported .xlsx)
  .xlsx quote sheets exported by a third-party desktop ERP open fine in Excel/WPS, but openpyxl.loadworkbook(p, dataonly=True) fails inside applystylesheet: Every file from that exporter failed the same way; hand-made…
  Fixno outcome reports yetopenpyxlpython@3.14python-calamine2026-10-06