https://bz.apache.org/bugzilla/show_bug.cgi?id=62834
--- Comment #3 from Greg Woolsey <[email protected]> --- And finally, the problem is a strangely formed XLSX file - it has, in its sheet1.xml, the following: <row r="3" spans="1:1" x14ac:dyDescent="0.25"> <c r="A3" s="1" t="str"> <f t="shared" ref="A3:A5" si="0">A2</f> <v>a value</v> </c> </row> <row r="4" spans="1:1" x14ac:dyDescent="0.25"> <c r="A4" s="1" t="s"> <v>1</v> </c> </row> <row r="5" spans="1:1" x14ac:dyDescent="0.25"> <c r="A5" s="1" t="str"> <f t="shared" si="0"/> <v>another value</v> </c> </row> Note how A3 defines itself as a shared formula covering A3:A5 with id=0. A5 references this properly, but A4 defines itself as a plain string cell, not a formula. Excel seems to handle this just fine, allowing cells to override a shared formula definition. Looks like POI needs to follow that behavior. I wonder where else this might cause trouble. -- 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]
