lundi 21 janvier 2019

How can I do "cross-Excel version" testing? My OpenPyXL generated .xlsx file looks different on Mac vs LibreOffice vs Google Sheets

I recently built a report for a Django webapp that outputs an xlsx file that includes some charts using the OpenPyXL library.

I tested the export on LibreOffice and Google Sheets and everything looked right. My client went to the site and opened the document in Excel for Mac version 16. He says that the chart looks off (specifically the bar charts aren't stacking correctly).

Is there a way I can do "cross-Excel testing" in the same way I'd do cross-browser testing? Does any service let me access all versions of Excel online? What do you do when you have to test something like this?

Aucun commentaire:

Enregistrer un commentaire