Company Seal Stamping in Excel Invoices: Storage, Anchoring, and Coordinate Pitfalls
A developer built a feature to stamp company seals onto Excel-based invoices, quotes, and purchase orders, converted to PDF via LibreOffice. The seal image was moved out of a publicly readable storage bucket into a database column with no retrieval endpoint, and an append-only design preserved finalized documents. Positioning proved difficult because Apache POI's resize() method miscalculated column widths based on font metrics, so the developer computed the anchor corners manually. Further offsets arose from three separate coordinate transformations applied at different stages of PDF generation.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in