33726
2005-02-24 11:09:20 +0000
Strange Formulas not parsed
2008-07-10 16:05:40 +0000
1
1
1
Unclassified
POI
HSSF
2.5-FINAL
PC
Windows 2000
RESOLVED
WONTFIX
P2
enhancement
---
1
green_spam_fr
dev
4
oldest_to_newest
71455
0
green_spam_fr
2005-02-24 11:09:20 +0000
I have a formulas on my Excel sheet looking like this:
='C:\blp\api\dde\Blp.xla'!blp($B1;A$3:B$3;;;BLP|M!'EUSA1 Curncy,
[NAME,PX_BID]')
If you need an Excel sheet for your tests, just create a new one and paste the
formula. Excel will ask you to start BLP.EXE application, answer no, then Excel
will ask you where it can find BLP.XLA, just click cancal. That's all.
After parsing this Excel file the following code:
POIFSFileSystem fileSystem = new POIFSFileSystem(new FileInputStream
(fileInput));
HSSFWorkbook workbook = new HSSFWorkbook(fileSystem);
System.out.println(workbook.getSheetAt(0).getRow(0).getCell((short)
0).getCellFormula());
prints the following string:
NO IDEA - NAME($B1,A$3:B$3, , ,NO IDEA - NAME)
I'm not sure that it is possible (i.e. that Excel gives us this possibility), but we can
just choose to parse or not to parse the formulas. In my case I want just to read
the formula, change "EUSA1 Curncy" to "EUSA2 Curncy" and write it to Excel. No
need to really parse the formula.
73970
1
avik
2005-04-22 13:27:41 +0000
Unfortunately, we cannot give you access to the parts of a formula without
parsing it. And your formula is one the most complex types you can write :(
118522
2
apache
2008-07-10 16:05:40 +0000
At this time, we do not support excel formulas that utilise third party extensions, sorry