On Tue, 22 Jul 2008, Scrollpane wrote:
I am looking for work-arounds, but am also willing to pay developers to
build patches to support this functionality. If I am missing something,
and the following is supported, please let me know.
For both your issues, I'd suggest trying the following
* create a very simple file with poi, with simple data validation rules
that excel is happy about
* take a copy, open it in excel and save again, to let excel do any
coversions it might want to
* take a copy, open it in poi, change to the complex validation, and save
* take a copy, open it in excel, change to the complex validation, and save
Now, any differences between the last two files, which are not differences
in between the first two, should be the difference between how poi writes
out your complex validation and how excel does. In there will be the
answer as to what poi is doing wrong.
You'll almost certainly want to use org.apache.poi.hssf.dev.BiffViewer to
look into the files, and see what's different
Once you know what the differences are, you might be able to spot what poi
does wrong. If not, you'll hopefully have found out enough info for
someone else to help you... :) Upload the 4 files to a new entry in
bugzilla, and add a comment on the areas that differ to help people get
started.
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
