https://issues.apache.org/bugzilla/show_bug.cgi?id=47543
--- Comment #10 from Yegor Kozlov <[email protected]> 2009-07-28 22:45:53 PST --- Guys, Creating a text .xls file manually is not a good idea - Excel creates a lot of garbage in this case. I created a simple VBA script that does a job similar to the attached Driver.java. The output is always readable by BiffViewer AND tolerant to changing font colors, no matter how large the grid is - 10x10, 100x100, etc. For all tests produced by the VBA script Excel allows changing the font color. I compared POI- and VBA- versions and didn't see anything suspicious about CONTINUE records - all looks sane. I won't be able to look into it more earlier than this weekend. If anyone wants to track this bug, I suggest the following strategy: - modify Driver.java and driver.vbs to produce equivalent output - for both POI- and VBA- code use a blank template XLS to minimize the differences. - start with a small grid, say 5x5. - start tweaking POI to produce output as much close to VBA as possible. For testing purposes you may need to temporary modify record classes. I won't be surprised if the culprit is a record absolutely irrelevant to SST - you never know it with Excel :) Regards, Yegor -- 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]
