poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 56123] ShiftRows, Bug in POI 3.10 Beta 2: "Could not find 'internal references' EXTERNALBOOK"
Date Mon, 10 Feb 2014 08:17:14 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=56123

--- Comment #2 from andreas@manticore-projects.com ---
(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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message