You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2008/08/04 00:48:29 UTC

DO NOT REPLY [Bug 44953] Datavalidation across sheets (list mode)

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


Josh Micich <jo...@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #3 from Josh Micich <jo...@gildedtree.com>  2008-08-03 15:48:27 PST ---
Fixed in svn r682225/r682227.

This turned out to be way more work than expected.  There were several
bugs/deficiencies found in the original HSSFDataValidation API:
 - RVA settings for list formulas were NQR (probably the cause of this bug)
 - Lists with explicit values did not work
 - Formulas and simple values were not distinguished (Note that the Excel UI
handles expressions starting with '=' different to those without the equals
prefix).

There were also problems with the java object model in that too many things
were crammed into HSSFDataValidation. Extensive changes were made to resolve
these issues. 
A new class DVConstraint was created to hold just the validation type, operator
and value expressions.  CellRangeAddressList was renamed and raised in the API.
HSSFDataValidation was moved to org.apache.poi.hssf.usermodel (where classes
like HSSFWorkbook, HSSFConditionalFormatting, etc are found).


The attached test code (id=21934) is just an extract from the original
TestDataValidation.  TestDataValidation has been updated to cover the 'cross
sheet validation' case, as well as the fixed functionality mentioned above. 
You can tweak the 'isSame' boolean variable to output the new version of the
test spreadsheet.


-- 
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