We have a web app where we display a report in the form of a Google Sheet in an IFrame.
When the user prints the document, we want the user to be able to define custom page breaks, exactly like you can in Excel. In Excel you can drag page breaks around to fit multiple sheets on a page, or even split a sheet onto multiple pages.
We know that a simple solution exists if the user just downloads the sheet as an Excel document, problem solved.
But we don't want to tie the user to Excel, after all, he paid for the app, so the app should be able to handle printing, as promised c",)
When printing in Google Sheets, you can define custom page breaks when you print the current sheet, not when you print the entire workbook.
We've looked at Excel for the web, in OneDrive, but it has the same problem as Google Sheets, it lacks Excel's powerful custom page break feature.
It's possible that there aren't anything out there. In which case we're playing with options like iTextSharp and HTML with a print stylesheet. But that would be quite a bit of effort, for something that I was hoping would just work out of the box in Google Sheets, I mean, if Excel can do it, why not Google Sheets? We'll have to build some sort of UI where the user can define page breaks. We'll lose the Google Sheets styling, because we'll be converting from Google Sheets to PDF, or HTML, and rendering the document from scratch. On the other hand it gives us the most control over page breaks.
So we're wondering, are there any solutions, like a web component, or something similar, open source or commercial, that provides the capability to define custom page breaks for the entire workbook?
Aucun commentaire:
Enregistrer un commentaire