https://bz.apache.org/bugzilla/show_bug.cgi?id=61832
--- Comment #6 from Thamodharan <[email protected]> --- (In reply to Yegor Kozlov from comment #5) > Can you please do one more test: generate a 500K rows x 150 columns > spreadsheet containing only numbers and see if it opens? Due to its > streaming nature SXSSF stores strings differently than Excel does: Excel > puts strings in a shared cache while SXXSF stores strings inline. Number > cells should be fully compatible . Lets see. Hi Yegor Kozlov, I had tried as you suggested, it worked fine for 500K X 150 column while inserting numbers.The maximum int limit which we can give is 2147483647. cell.setCellValue(2147483647); Thus it worked fine. So, I extended the testing by increasing the row count and column count, i.e., 900K X 250 Column. Same cellValue 2147483647. The workbook is done successful. File size reached to 504 MB. But,The same content issue occurs while opening. Still as a mystery. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
