hello :)
i know, this thread is very old, but i have exacty the same problems.
i'm using a HSSFSheet and after reading the solution, i tried it for hours
and navigated through the classes, which seems to influence the formulas,
but i dont understand much of it and my head is exploding right now :(
could anyone please tell me, how i could realise the following?
workbook.getSheet("Sheet1").getRow(0).getCell(0).setCellFormula("Sheet2.A1");
i would like to override the automatic evaluation of the formular and force
it to evaluate it when it is loaded via excel, but i have no idea, how it
works :'(
can anyone give me the neccessary source code for it? :D
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Apache-POI-not-able-to-evaluate-table-names-in-the-Excel-Sheet-tp5710583p5714476.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
