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 2009/12/30 11:15:45 UTC
DO NOT REPLY [Bug 48462] New: Excel Name Box could not display the
range name corresponding to the singlecell after create/change the range name
using POI
https://issues.apache.org/bugzilla/show_bug.cgi?id=48462
Summary: Excel Name Box could not display the range name
corresponding to the singlecell after create/change
the range name using POI
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: liangyue_829@163.com
Created an attachment (id=24773)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24773)
a jpeg describes the usage of namebox for the relationship between single cell
and a range name
Excel Name Box could not display the range name corresponding to the singlecell
after create/change the range name using POI.
Below is the codes:
InputStream inp = new FileInputStream("testRF.xls");
HSSFWorkbook wb = new HSSFWorkbook(inp);
HSSFName name = wb.getNameAt(wb.getNameIndex("testCell"));
CellReference reference = new CellReference("Sheet1!A2");
name.setReference(reference.formatAsString());
File file = new File("output_testRF.xls");
if(file.exists())
file.delete();
FileOutputStream fileOut = new FileOutputStream("output_testRF.xls");
wb.write(fileOut);
fileOut.close();
--
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 48462] Excel Name Box could not display the range
name corresponding to the singlecell after create/change the range name using
POI
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48462
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |RESOLVED
Resolution| |FIXED
--- Comment #5 from Yegor Kozlov <ye...@dinom.ru> 2011-06-25 12:41:28 UTC ---
The problem is fixed in POI 3.5+ and I don't see why this ticket should stay
open.
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 48462] Excel Name Box could not display the range
name corresponding to the singlecell after create/change the range name using
POI
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48462
--- Comment #1 from Lion Liang <li...@163.com> 2009-12-30 02:17:23 UTC ---
Created an attachment (id=24774)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24774)
source excel file
--
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 48462] Excel Name Box could not display the range
name corresponding to the singlecell after create/change the range name using
POI
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48462
Lion Liang <li...@163.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|INVALID |
--- Comment #4 from Lion Liang <li...@163.com> 2010-01-03 22:20:19 UTC ---
Thanks Josh.
I just find using "Sheet1!$A$2" is working well on POI 3.5 for my requirement,
but still not work for POI 3.2 Final. this might be something like a POI bug
fix or enhancement after 3.2 final release.
However I am still using POI 3.2 for my work, I can't find the corresponding
bug or change list for this feature by searching in Bugzilla, could you please
attach it here if you could find it? Thanks!
BTW, I didn't have a chance to look at the way to use Retroweaver(you told me
this in Bug 46547) to convert the latest POI release to run
on a 1.4 JRE yet, but I'll definitely try it later. Thanks again for your
helps.
Sorry I have to put this bug to REOPENED to ensure it could be copied to you.
--
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 48462] Excel Name Box could not display the range
name corresponding to the singlecell after create/change the range name using
POI
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48462
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |INVALID
--- Comment #3 from Josh Micich <jo...@gildedtree.com> 2009-12-31 13:27:59 UTC ---
I can observe the funny behaviour you describe, but I think it is actually part
of normal Excel functionality. The anomaly seems to arise from using relative
coordinates in the cell reference (i.e. missing '$'). You can achieve the same
affect by setting the 'Refers To' property in the 'Name Manager' dialog to the
same value as you did in the java example. When 'navigating' to a defined name
by using the 'Name Box', different behaviour is observed depending on whether
the coordinates are absolute or relative.
The simple fix is to use absolute coordinates in your cell reference. For
example: "Sheet1!$A$2"
BTW - you should replace uses of the method HSSFName.setReference() to
HSSFName.setRefersToFormula(), as the old method will not be available in
future POI versions.
--
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 48462] Excel Name Box could not display the range
name corresponding to the singlecell after create/change the range name using
POI
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48462
--- Comment #2 from Lion Liang <li...@163.com> 2009-12-30 02:17:52 UTC ---
Created an attachment (id=24775)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24775)
POI output excel file
--
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