https://issues.apache.org/bugzilla/show_bug.cgi?id=45720
--- Comment #1 from Josh Micich <[EMAIL PROTECTED]> 2008-09-03 12:58:00 PST --- I could reproduce this bug fairly easily. One slight difference however, was that my Excel(2007) completely crashes when I try to sort using the autofilter in the newly copied sheet. To help diagnose, I cloned the sheet in the input spreadsheet using Excel and ran BiffViewer on that file, and the POI generated file. The first problem I noticed was a missing NameRecord (of the 'built-in' kind). Another cosmetic problem was POI's choice of name for the new sheet. Excel adds a space before the bracket e.g. "Test Clone (2)", which upsets the file offsets and causes false deltas when comparing the BiffViewer files. If fixed both these problems in svn r691740. No junit for the built-in name record yet. After that fix the next difference I tried working on was within the MSODRAWING record (in the second, copied sheet). Unfortunately, POI does not interpret that record when reading from and existing file (BiffViewer does though), so I had to resort to hex-editing the POI generated XLS file. After changing a few bytes (to make the POI generated second MSODRAWING record the same as the Excel generated one), the file loaded OK in Excel, and the autofilters worked fine. I will attach the BiffViewer dump of the MSODRAWING records before and after manual hex editing. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- 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]
