Josh Micich <josh.micich <at> gmail.com> writes: > > Hello Gilles, > > I think you are on the right track. I suspected that Excel might do > exactly as you suggest. I.E. set firstSheet, lastSheet to -1 for the > deleted sheet, decrement all subsequent firstSheet,lastSheet indexes. > (all adjustment performed entirely within the externsheet record). > > It's theoretically possible to get rid of the '-1' entry in the > externsheet record, but this would be quite complex. It would involve > adjusting every externSheetIndex (all 3D refs in *every* formula). > > Can you write up some simple POI test code that reproduces this > problem as you describe? Is it important that an autofilter be > present? I suspect the problem will occur for any 3D references > pointing to subsequent remaining sheets after a deletion. > > -Josh
I'll try to see if the -1 hack really works, i think this is the same bug as https://issues.apache.org/bugzilla/show_bug.cgi?id=40829 and https://issues.apache.org/bugzilla/show_bug.cgi?id=17475 and https://issues.apache.org/bugzilla/show_bug.cgi?id=29619 indeed i think it doesnt have to be an autofilter, anything that has an extern sheet reference would cause the bug Gilles --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
