DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=30978>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=30978 ------- Additional Comments From [EMAIL PROTECTED] 2008-02-14 07:03 ------- Unfortunately, to fix this bug, we're going to have to find a needle in a haystack (the record with the reference to the deleted sheet - since poi will open the spreadsheet with the removed sheet, it isn't a simple corruption issue) In order to find our needle, we'll initially need three files: * the original file with all the sheets in it * the file after removing the sheet in poi * the file after removing the sheet in excel Compare the latter two files, see the differences, and in theory you've found the record(s) we need to update. Alas it isn't quite that simple... Next, we have some fun with the fact that saving a file in excel and saving it in poi will give slightly different files. So, we need to open files 1 and 3 in poi, and save those again without changes. Now, find the difference between 1 and 1-from-poi, and 3 and 3-from-poi. Knowing those, you can see what differences there are from just the saving. Finally, find the differences between files 2 and 3, and ignore those differences that can be tracked back to excel save vs poi save. Hopefully that will leave you with only one or two differences, which are your needles. Once we know what those records are, we can work to fix. Anyone affected by this issue fancy spending an hour or two hunting down the needle? -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
