On Mon, 15 Nov 2010, David Law wrote:
I'm not sure this ones too relevant, as I suspect the REAL Bloomberg
Add-In obtains realtime quotes from their online subscription-only
system, but maybe their API is documented & just needs to run on a
machine thats tunneled to them?...
Probably, but tha
h I'm a bit tied up with an Open-Source project of my own at present.
Best regards,
DaveLaw
- original message ----
Subject: Re: POI 3.7 can't get formula
Sent: Mon, 15 Nov 2010
From: Nick Burch
> On Sun, 14 Nov 2010, David Law wrote:
> > Here...
> > http://www.ap
On Sun, 14 Nov 2010, David Law wrote:
Here...
http://www.apconsult.de/projects/persella/TestRawDataPersella_v3.7.jar
...is a Jarfile I've put together.
Basically, I've created a new Function, BDP, for your Bloomberg Excel Add-In.
Would you be willing to contribute this to POI? If so, please cr
Andrey,
I have taken a look at your problem.
Here...
http://www.apconsult.de/projects/persella/TestRawDataPersella_v3.7.jar
...is a Jarfile I've put together.
Basically, I've created a new Function, BDP, for your Bloomberg Excel
Add-In.
To do that, I had to implement the function: Bdp.java, th
nk all the poi-developers & active forum
> participants for their time & hard work. It is a pleasure to
> be a member of this forum.
>
> Best regards,
> DaveLaw
>
> - original message
>
> Subject: Re: POI 3.7 can't get formula
> Sent: Fri, 0
uting "it doesn't work" - however loud - won't get anything fixed.
I would like to thank all the poi-developers & active forum
participants for their time & hard work. It is a pleasure to
be a member of this forum.
Best regards,
DaveLaw
----- original message ----
i think better way to use another payble framework, bcs u are not support,
just bla bla bla. for last 48 hours didn't propose any significant
decison! blablabla and nothing more. Just one thing: if u can't to help,
don't make believe that u ae very clever man! it's for u on the future =
-
> If poi is important to you, you have two options:
>
> 1) read the documentation, use google to search the mailing lists etc,
> and hopefully find your answer. If it looks like you really do have
> a bug in the bit of poi you're using, write a simple junit unit test
> that highlights the pro
On Thu, 4 Nov 2010, Trollchik wrote:
i understood, but at first, POI is very important for me!!! bcs my
project is based on poi, and now i met a lot of problems! AND NOTHING
WORK!
If poi is important to you, you have two options:
1) read the documentation, use google to search the mailing lis
i understood, but at first, POI is very important for me!!! bcs my project is
based on poi, and now i met a lot of problems! AND NOTHING WORK!
and the second, i tried to write personally, but i was said to write to
mailing list!
--
View this message in context:
http://apache-poi.1045710.n5.nabb
On Thu, 4 Nov 2010, Trollchik wrote:
my classpath is ok! 36 hours passed and noone response! or u have more
than 36 hours day in Atlanta ???!!!
POI is a volunteer project. No-one is obliged to respond to you, please
remember that when asking people to give up their time to answer your
questio
my classpath is ok! 36 hours passed and noone response! or u have more than
36 hours day in Atlanta ???!!!
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/POI-3-7-can-t-get-formula-tp3246256p3250109.html
Sent from the POI - User mailing list archive at Nabble.com.
-
(1) The developers of Apache POI contribute on a volunteer basis - POI is not
their main job. You are not paying us to wake up in the middle of the night.
(2) This week most of the active ones are in Atlanta for Apachecon NA 2010.
Thay are NOT in your time zone.
(3) I count 9 emails from you o
Guys,
cell.getCellFormula - not implemented
sheet.shiftRows - not implemented
sheet.removeRow - doesn't work properly
what was implemented at all?
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/POI-3-7-can-t-get-formula-tp3246256p3249769.html
Sent from the POI
WHERE ARE DEVELOPERS OF POI?? WHY U CAN'T HELP
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/POI-3-7-can-t-get-formula-tp3246256p3249750.html
Sent from the POI - User mailing list archive at Nabble.com.
-
ok, try do explain in detail. Exist file
http://apache-poi.1045710.n5.nabble.com/file/n3249624/RAW_DATA_persella.xlsm
RAW_DATA_persella.xlsm
for example look at the columns E AND F! u can see there a formulas!
but when i read file by POI, i see for column E:
http://schemas.openxmlformats.org/
it stiil doesn't work properly!
oldCell.getCTCell().getF().getStringValue()
some times write me that value=null, but actually there the same formulas as
in the previous cells!
why>
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/POI-3-7-can-t-get-formula-tp3246256p324
ok, i understood what u mean, may u mean to make like:
newCell.getCTCell().addNewF().setStringValue(oldCell.getCTCell().getF().getStringValue());
it look working for me.
can u look also to problem with deleting row
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/
but the cell.getCellFormula() is not implemented yet! how i can do it?
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/POI-3-7-can-t-get-formula-tp3246256p3248955.html
Sent from the POI - User mailing list archive at Nabble.com.
-
Can you create a simple file in Excel and set your formula with BDP to a cell.
Then create the same output using POI.
Unzip these two files and use diff to find what differs. This should give you
an idea what is missing.
As a quick solution, try just to set the formula string omitting all othe
i did as u recommended. This is my formulas:
http://schemas.openxmlformats.org/officeDocument/2006/relationships";>IF(ISNUMBER(BDP($B2,$Q$1)*$R2),BDP($B2,$Q$1)*$R2,
0)
http://schemas.openxmlformats.org/officeDocument/2006/relationships";>BDP($C2,T$1)
i make as:
newCell.getCTCell().setF(oldCell.
XSSFCell gives you access to the underlying xml bean. You can bypass the
call of setCellFormula and copy 'raw' xml as follows:
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellFormula
srcFormula = cell.getCTCell().getF();
newCell.getCTCell().setF(srcFormula);
Warning
yes, i did so :
newCell.setCellType(XSSFCell.CELL_TYPE_FORMULA);
newCell.setCellValue("=BDP($C270;E$1)");
but actually i have to do something like :
newCell.setCellValue(cell.getCellFormula());
bcs oldCell contains a macros!
--
View this message in context:
http://apache-poi.1045710.n5.n
i don't know about .xls, i.m working just with .xlsm!
So is any chance to make what i need or not?
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/POI-3-7-can-t-get-formula-tp3246256p3246946.html
Sent from the POI - User mailing list archive at Nabble.com.
--
i don't know about .xls, i.m working just with .xlsm!
So is any chance to make what i need or not?
-
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
yes, i did so :
newCell.setCellType(XSSFCell.CELL_TYPE_FORMULA);
newCell.setCellValue("=BDP($C270;E$1)");
but actually i have to do something like :
newCell.setCellValue(cell.getCellFormula());
bcs oldCell contains a macros!
--
hello!
"getCellFormula " this is not supported yet. But you can do this:
cell.setCellType(Cell.CELL_TYPE_FORMULA);
where you want to copy a formula.
I hope this can help you.
At 09:21 02/11/2010, you wrote:
actually i have to take 1 cell (which hold
macros) and create a new cell. Put
if i not mistaken, the formula like: "=BDP($C271;E$1)"
-
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
actually i have to take 1 cell (which hold macros) and create a new cell. Put
macros from old cell to new
one and write doc. But i call getCellFormula method and got: not supported.
-
To unsubscribe, e-mail: user-unsubscr...
What formula do you set? Can you post sample code?
Yegor
2010/11/2 andrey skrypnik :
> i tried to get cell formula from excel (attached), but get:
>
> java.lang.RuntimeException: Not implemented yet
> at
> org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getNameXPtg(XSSFEvaluationWorkbook
i tried to get cell formula from excel (attached), but get:
java.lang.RuntimeException: Not implemented yet
at
org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getNameXPtg(XSSFEvaluationWorkbook.java:105)
at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:916)
at
or
i tried to get cell formula from excel (attached), but get:
java.lang.RuntimeException: Not implemented yet
at
org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getNameXPtg(XSSFEvaluationWorkbook.java:105)
at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:916)
at org.apach
32 matches
Mail list logo
