It seems that by default, when converting an Excel document with a print area set, only the print area is converted into the output document. Is there an option that can be passed to the conversion handler to convert the entire spreadsheet instead?
Thank you for your inquiry. In order to investigate the issue at our end, we are required following information from you:
- Version of the API that you are evaluating
- Problematic file
- Sample code
Your cooperation shall be appreciated in this regard.
Version: 17.3.0, eventually moving to 17.7(java)
printAreaTest.xlsx.zip (4.3 KB)
Sample code: https://gist.github.com/orrjosh/3e18233a032648594f041472b1b9fdf6
This is more of a general question though. Is there an existing method for accomplishing this?
Thanks for sharing the concerned files/details. We successfully reproduced this scenario at our end. Only print area gets converted not the entire spreadsheet. Hence, we’ve logged it in our internal issue tracking system with ID:CONVERSIONJAVA-455. As we get any work-around/suggestions from the concerned team about entire spreadsheet conversion process, we’ll notify you.