DO NOT REPLY [Bug 45720] cloneSheet breaks autofilters

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=45720





--- Comment #1 from Josh Micich <jo...@gildedtree.com>  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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org