Posts

Showing posts with the label apache-poi

POI 3.17 creating Cell Comments in a cloned sheet creates inconsistent xlsx

Image
Clash Royale CLAN TAG #URR8PPP POI 3.17 creating Cell Comments in a cloned sheet creates inconsistent xlsx I used the cloneSheet method to copy a sheet within the same workbook which already contains comments. Afterwards new comments where added to this new sheet and the excel saved. cloneSheet When openening the file with Excel 365, it complained about /xl/comments1.xml and recovered the file. The newly created comments are available. The comments from the clone are removed during the recovery. Opening the zip file and looking at the /xl/comments1.xml , it shows a difference. Is this an issue with the cloneSheet method or is Microsoft using new ways? cloneSheet By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Why poi reading limitation huge file in excel?

Image
Clash Royale CLAN TAG #URR8PPP Why poi reading limitation huge file in excel? By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.