Named range support has been implemented using the usermodel class HSSFName.
However, currently when a named range is attempted to be created over a single
the behaviour is erroneous.

Two ways to create a named range over a single cel were attempted:

1. using the string "A1"
------------------------
Calling HSSFName.setReference("Sheet1!A1");
throws the following exception:

   Failed with exception:
java.lang.ArrayIndexOutOfBoundsException: 1
	at org.apache.poi.hssf.record.formula.Area3DPtg.setArea(Area3DPtg.java:247)
	at org.apache.poi.hssf.record.NameRecord.setAreaReference(NameRecord.java:713)
	at org.apache.poi.hssf.usermodel.HSSFName.setReference(HSSFName.java:125)
	at <someLineInUserCode/>


2. using the string "A1:A1"
---------------------------
This code does not throw RuntimeException, but it retrieves the cell A1 twice
when the following code is used to retrieve the cell references:
    int namedCellIdx = wb.getNameIndex(cellName);
    HSSFName aNamedCell = wb.getNameAt(namedCellIdx);
    AreaReference aref = new AreaReference(aNamedCell.getReference());
    CellReference[] crefs = aref.getCells();
    for (int i=0, iSize=crefs.length; i<iSize; i++) {
        CellReference cref = crefs[i];
        HSSFSheet s = wb.getSheet(cref.getSheetName());
        HSSFRow r = sheet.getRow(cref.getRow());
        HSSFCell c = r.getCell(cref.getCol());
        String contents = c.getStringCellValue();
    }



Expected resolution:
--------------------
There should be atleast one way to create a named range over a single cell :)