spreadsheetRead/write functionality damages spreadsheet formatting| View in Tracker
Reporter/Name(from Bugbase): David R. / ()
Failure Type: Data Corruption
Found In Build/Fixed In Build: CF2018 Update 7 / docs
Priority/Frequency: Normal / Unknown
Locale/System: English / Windows 10
Vote Count: 0
Problem Description: spreadSheetRead followed by a spreadSheet write ruins the spreadsheet's formatting, in particular columns are set to what appears to be the size required to contain their text, even if they originally were set to some explicit width value; additionally, and probably related, images are resized. Steps to Reproduce: Load an XLSX spreadsheet with spreadsheetRead and immediately write it to an arbitrary new location with spreadsheetWrite. Actual Result: Newly written spreadsheet file has damaged column widths and image sizes. Expected Result: Newly written spreadsheet file has NO CHANGE from the original. Any Workarounds: Coincidentally this would be a great time to upgrade users to Apache POI 4, with support for Java 11.