https://issues.apache.org/bugzilla/show_bug.cgi?id=56123
--- Comment #2 from [email protected] --- (In reply to Nick Burch from comment #1) > The comment for the code which calls checkExternSheet is: > > // Update any formulas on this sheet that point to > // rows which have been moved Yes, clear. But what is the exact purpose of the failing function? Please note, there is no reference to any other worksheet or workbook. All the formula refer to the single worksheet only. > At first glance, it looks like the table that maps between sheet names and > indexes for formulas has ended up confused, and/or that there's a bug in our > logic for handling that on some edge case. > A few things you could try: > * Step into LinkTable in a debugger, and see what it does know about, and > if the ids and names match what the normal names are Seems to be very likely. Unfortunately I am on travel an can not pull the full maven-repository at the moment. > * Try deleting a sheet in Excel, saving, and seeing if that fixes it > * Try adding a sheet in in Excel, saving, and seeing that fixes it I tried this with various combinations a thousand times in order to understand what is going on. I've created new workbooks from scratch, I copied existing worksheets over, I copied ranges, I inserted sheets etc etc. The only hint I can give: 1) one single sheet seems to work but (mostly), but simple reformatting can sometimes break it (e.g. change width of several columns at once) 2) as soon as you add another worksheet it breaks the new worksheet, but also the first (formerly working) one -- 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]
