Write a DDE formula to Excel

[Sean Han <jh...@gmail.com>]

Hi, all:

I tried to write a DDE formula, in form of "IManager|001!1101`003", 
to an excel file with POI. But I always get the following error:

org.apache.poi.ss.formula.FormulaParseException: Specified named range 
'IManager' does not exist in the current workbook

Does anyone konw how to do it? 

Sean


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: Write a DDE formula to Excel

[Mark Beardsley <ma...@tiscali.co.uk>]

Have just looked at the format for DDE formulae though and I cannot promise
that this will work. It may well be that you are able to trick the parser
into accepting the 'name' part of the formula but I do not know if it will
reject the remaining syntax/structure. Only testing will tell I guess and it
may well be - just a guess at this stage - that you will have to customise
the formula parser to allow this type of thing through.

Yours

Mark B
-- 
View this message in context: http://apache-poi.1045710.n5.nabble.com/Write-a-DDE-formula-to-Excel-tp3345525p3345829.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: Write a DDE formula to Excel

[Mark Beardsley <ma...@tiscali.co.uk>]

Possibly highly illegitimate but I would fool the formula parser by simply
creating a named area somewhere on the sheet.

Yours

Mark B
-- 
View this message in context: http://apache-poi.1045710.n5.nabble.com/Write-a-DDE-formula-to-Excel-tp3345525p3345822.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org