https://bz.apache.org/bugzilla/show_bug.cgi?id=57844
--- Comment #3 from Javen O'Neal <[email protected]> --- Proposed resolution: Update the Java docs (https://poi.apache.org/apidocs/org/apache/poi/xssf/streaming/SXSSFSheet.html) and clearly state which functions are not implemented. (I'm guessing shiftRows isn't the only SXSSF* function that throws RuntimeException/UnsupportedOperationException("NotImplemented"). As Nick said, shiftRows could only work if the rows to be shifted are within current window, rows that haven't yet been written probably wouldn't be able to be shifted, and any reference (formula, named range, merged region, hyperlink, chart data, tables, pivot tables, conditional formatting rules) that refers to a shifted row would probably be broken. If someone can find a workable solution that addresses these issues, we'd be happy to implement it. Until then, the best we can do is advertise "Not Implemented" in the java docs. I think it'd be a step backwards to move shiftRows out of the Sheet interface so that SXSSFSheet isn't required to implement it. -- 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]
