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/06/09 06:04:12 UTC
DO NOT REPLY [Bug 45164] New: can'
t add data validation to excel writen by ms excel 2003
https://issues.apache.org/bugzilla/show_bug.cgi?id=45164
Summary: can't add data validation to excel writen by ms excel
2003
Product: POI
Version: 3.0
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: gaorongfu@gmail.com
CC: gaorongfu@gmail.com
If open a excel created by excel 2003 with poi, addDataValidation will effect
nothing.
--
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 45164] can't add data validation to excel writen
by ms excel 2003
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45164
--- Comment #7 from David Fisher <df...@jmlafferty.com> 2009-02-18 12:44:20 PST ---
Try the latest POI 3.5-beta5
--
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
[Bug 45164] can't add data validation to excel writen by ms excel
2003
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45164
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |WORKSFORME
--- Comment #8 from Dominik Stadler <do...@gmx.at> ---
no response in a long time => resolving for now, please reopen with more
information ifnthis is still an issue
--
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 45164] can'
t add data validation to excel writen by ms excel 2003
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45164
--- Comment #2 from Schelfhout Dries <sc...@hotmail.com> 2008-06-25 02:10:09 PST ---
Created an attachment (id=22171)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22171)
The main class
--
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 45164] can'
t add data validation to excel writen by ms excel 2003
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45164
Schelfhout Dries <sc...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #22174|One of the templates |Template one
description| |
--
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 45164] can'
t add data validation to excel writen by ms excel 2003
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45164
Schelfhout Dries <sc...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |schelfdr@hotmail.com
--- Comment #6 from Schelfhout Dries <sc...@hotmail.com> 2008-06-25 02:30:43 PST ---
I have the same problem as you discribe.
So I went and created the a small example code to show that I had this problem
also.
But when I created the simpel example(template four) and launched it, it
worked.
But when I did the same thing with an other excel(template one) it seemed to
give an error(see comment attachments).
I'm not getting this error if there's already a validation in the excell.
But when you open the file the validations I tried to add are not there and the
validation that was in the template is also gone.
The 'template one' that I uploaded here, is without a validation thus with the
error.
You can add a validation manuel to see what I just told here.
Why it works in 'template four' and not in 'template one' I don't know.
Maybe with my files you can find out what goes wrong.
--
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 45164] can'
t add data validation to excel writen by ms excel 2003
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45164
--- Comment #4 from Schelfhout Dries <sc...@hotmail.com> 2008-06-25 02:13:00 PST ---
Created an attachment (id=22173)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22173)
One of the templates
This template is just an empty excel with one sheet.
--
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 45164] can'
t add data validation to excel writen by ms excel 2003
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45164
--- Comment #5 from Schelfhout Dries <sc...@hotmail.com> 2008-06-25 02:15:33 PST ---
Created an attachment (id=22174)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22174)
One of the templates
The template has some other info in it.
This template gives the follow excel error log after running the code on it :
-----------------------------
Microsoft Excel File Repair Log
Errors were detected in file
'C:\javadev\tools\eclipse-3.3\workspace\ProcExcell\etc\output\procfour.xls'
The following is a list of repairs:
Damage to the file was so extensive that repairs were not possible. Excel
attempted to recover your formulas and values, but some data may have been lost
or corrupted.
--------------------------
Not mutch usefull info from microsoft :)
--
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 45164] can'
t add data validation to excel writen by ms excel 2003
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45164
Schelfhout Dries <sc...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #22173|One of the templates |Templates four
description| |
--
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 45164] can'
t add data validation to excel writen by ms excel 2003
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45164
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Josh Micich <jo...@gildedtree.com> 2008-06-20 01:19:04 PST ---
>From what I understand, you created a workbook in Excel 2003, and opened it in
POI, then added data validation (by calling
HSSFSheet.addValidationData(HSSFDataValidation) etc), and saved. Then when
re-opening in Excel, no changes were apparent.
Is this correct?
It's hard to tell what is going wrong so far, bug it might be worth trying out
a recent build, just in case this is a bug which has recently been fixed. If
not, please upload the offending (input) spreadsheet and some sample java code
to produce this bug.
--
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 45164] can'
t add data validation to excel writen by ms excel 2003
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45164
--- Comment #3 from Schelfhout Dries <sc...@hotmail.com> 2008-06-25 02:12:17 PST ---
Created an attachment (id=22172)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22172)
The class with the actual code
To swap between the two templates just change the name of the inputstream.
Also the directory where you place the templates needs to be changed.
--
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