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 sheet. The sheet name
is 'Sheet 2'.
And there's your problem! Just like in Excel, the name of the sheet given
in the formula string ("Sheet2" in your example above) *must* exactly
match the name of the sheet ("Sheet 2" in your case)
Make sure they match, and the format is the same format as you'd give in
excel (in terms of quoting, exclamation marks etc) and you'll be fine
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
