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 2010/09/08 13:39:27 UTC
DO NOT REPLY [Bug 49896] New: issue with getCellFormula() Excel
workbook name and path in vlookup functions
https://issues.apache.org/bugzilla/show_bug.cgi?id=49896
Summary: issue with getCellFormula() Excel workbook name and
path in vlookup functions
Product: POI
Version: 3.5-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
AssignedTo: dev@poi.apache.org
ReportedBy: rahuld14@yahoo.com
=> Create an excel file, say destn.xls with a column which has reference to
another excel file say source.xls (Give complete path to the source.xls -
something like - "=VLOOKUP(A1,'C:\[Source.XLS]Sheet1'!$A$2:$B$3,2,0)")
=> Execute the following code:
java.io.FileInputStream fs= new java.io.FileInputStream("C:/test/Destn.xls");
org.apache.poi.ss.usermodel.Workbook wb =
org.apache.poi.ss.usermodel.WorkbookFactory.create(fs);
org.apache.poi.ss.usermodel.Sheet sheet = wb.getSheetAt(0);
Row row = sheet.getRow(1);
org.apache.poi.ss.usermodel.Cell cell = row.getCell(1);//assuming this cell has
the vlookup formula in your excel file
if(cell != null && cell.getCellType()==Cell.CELL_TYPE_FORMULA)
{
System.out.println("Cell formula:"+cell.getCellFormula());
}
It gives result as VLOOKUP(A1,'[Source.XLS]Sheet1'!A:B,2,0)
The issue is because
org.apache.poi.hssf.record.SupBookRecord.decodeFileName(String) does not seem
to be implemented fully
--
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 49896] issue with getCellFormula() - Excel
workbook name and path in vlookup functions
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49896
--- Comment #1 from Rahul Kini <ra...@yahoo.com> 2010-09-08 23:49:54 EDT ---
Created an attachment (id=26005)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=26005)
File dst2.xls - contains a column2 with cell values linked to anohter workbook
src1.xls
--
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 49896] issue with getCellFormula() - Excel
workbook name and path in vlookup functions
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49896
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |45970
--
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 49896] issue with getCellFormula() - Excel
workbook name and path in vlookup functions
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49896
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #4 from Yegor Kozlov <ye...@dinom.ru> 2012-02-10 08:27:56 UTC ---
The problem should be fixed in r1242701
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 49896] issue with getCellFormula() - Excel
workbook name and path in vlookup functions
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49896
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Depends on|52576 |
--
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 49896] issue with getCellFormula() - Excel
workbook name and path in vlookup functions
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49896
Rahul Kini <ra...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|issue with getCellFormula() |issue with getCellFormula()
|Excel workbook name and |- Excel workbook name and
|path in vlookup functions |path in vlookup functions
--
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 49896] issue with getCellFormula() - Excel
workbook name and path in vlookup functions
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49896
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Depends on| |52576
--- Comment #3 from Yegor Kozlov <ye...@dinom.ru> 2012-02-03 08:51:23 UTC ---
The patch in Bug 52576 fully implements SupBookRecord.decodeFileName.
--
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 49896] issue with getCellFormula() - Excel
workbook name and path in vlookup functions
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49896
--- Comment #2 from Rahul Kini <ra...@yahoo.com> 2010-09-08 23:50:47 EDT ---
Created an attachment (id=26006)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=26006)
Src1.xls is referred to from dst2.xls
--
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