+1 Thanks -- Divesh Dutta www.hotwaxsystems.com
On Tue, Sep 8, 2026 at 6:35 PM Mridul Pathak <[email protected]> wrote: > Hi all, > > I've opened two PRs adding a new screenxlsx view-handler type that produces > genuine binary .xlsx workbooks via Apache POI: > https://github.com/apache/ofbiz-framework/pull/1899 for the core > mechanism, > and https://github.com/apache/ofbiz-plugins/pull/395 wiring it into the > example plugin's demo screens alongside a couple of new UI entry points. > Both PRs are purely additive and don't touch any existing behavior, tracked > as OFBIZ-13567. > > The motivation is that the existing screenxls view-handler type doesn't > actually produce a real Excel file: its FreeMarker macros just emit a plain > HTML table, and it only opens in Excel because Excel is lenient about > mismatched file extensions and content types, while tools like LibreOffice > and Google Sheets are far less forgiving. The new screenxlsx handler builds > a real OOXML workbook directly from the same widget form/grid data, with > typed cells for currency and date fields, and has been verified end-to-end > against a running instance producing files that open cleanly everywhere. > > This makes screenxls obsolete. If there are no objections, I'll file a > follow-up ticket to remove it once OFBIZ-13567 lands. > > Reviews and feedback on the PRs are very welcome. > > Thanks, > Mridul Pathak >
