poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Beardsley <markbrd...@tiscali.co.uk>
Subject Re: [Bug 53314] New: Invalid Formula Cell Reference for named ranges referring to whole columns
Date Tue, 29 May 2012 14:23:09 GMT
I could well be wrong but I do not think that you can do this in Excel. Just
now, I opened a workbook, navigated to a sheet, right clicked on a cell and
selected 'Name a Range' from the menu that opened up. If I tried to create
range by entering this - =Sheet1!$G - into the refers to box and then
selecting OK, Excel raises an error. I have not completed any research but
suspect that the error means you cannot do this and that you must specify
the bounds of the range. Suggest you go onto an Excel forum and ask there
how to create a range that applies to a complete column. If it is possible,
and once you have the correct syntax, then it might be possible to replicate
the operation using POI.

View this message in context: http://apache-poi.1045710.n5.nabble.com/Bug-53314-New-Invalid-Formula-Cell-Reference-for-named-ranges-referring-to-whole-columns-tp5709977p5709986.html
Sent from the POI - Dev mailing list archive at Nabble.com.

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

View raw message