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

Reply via email to