On Mon, 10 Nov 2014, Vinay S V wrote:
I have an excel sheet which has a formula reference to another sheet of the
same workbook.
Currently, I'm on Sheet 1 and trying to set a formula for a cell using
*cell.setFormula(Sheet2[#All]).*
However, in the workbook, I have created the necessary sh
heet 2'. But still the code is not able to refer to that sheet.
Please let me know if there is a way to fix this issue or any workaround.
Thanks.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Apache-POI-excel-sheet-formula-reference-to-another-sheet-tp5717123.h