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/05/08 20:27:16 UTC
DO NOT REPLY [Bug 44953] New: Datavalidation across sheets (list
mode)
https://issues.apache.org/bugzilla/show_bug.cgi?id=44953
Summary: Datavalidation across sheets (list mode)
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: graham@clippersoftware.co.uk
Created an attachment (id=21934)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=21934)
validation fault across sheets
Data validation list using another sheet fails
setting the data validation formula to:
String strFormula = "sheet1!$B$6:$B$9"
The program runs fine but on opening the xls file Excel says
File error: data may have been lost
If I change the formula to use defined range the the library throws an
exception
Validation of data list on the same sheet work
attached java test source formula used on line 118
Note: source write file to root of drive c on windows
poi library 3.1 - beta 1
--
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
DO NOT REPLY [Bug 44953] Datavalidation across sheets (list mode)
Posted by bu...@apache.org.
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
DO NOT REPLY [Bug 44953] Datavalidation across sheets (list mode)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44953
--- Comment #1 from Bernhard <be...@komaxgroup.com> 2008-06-19 01:14:49 PST ---
It is a limitation in Excel (I have version 2002).
--
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
DO NOT REPLY [Bug 44953] Datavalidation across sheets (list mode)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44953
E Simone <sc...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |scrollpane@yahoo.com
--- Comment #2 from E Simone <sc...@yahoo.com> 2008-07-21 16:06:52 PST ---
I have validated this bug. The other comment is incorrect. It is supported in
Excel. Any ideas about how this can be fixed?
--
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