Cumbersome but working Apache POI save named cell reference

TestPOIWriteNamedCell.java

import static org.junit.Assert.*;

import java.awt.Desktop;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Name;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.CellReference;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.Test;

public class TestPOIWriteNamedCell {

	@Test
	public void testSingleCell() throws IOException {
		Workbook wb = new XSSFWorkbook();

		Sheet sheet = wb.createSheet();
		Row row = sheet.createRow(0);

		Name cellName = createCell(0, wb, sheet, row, 1, "_A_name");
		Name cellBName = createCell(1, wb, sheet, row, 2, "_B_name");

		String unittestName = "cellName";
		File tmpFile = File.createTempFile(unittestName, ".xlsx");

		wb.write(new FileOutputStream(tmpFile));
		Desktop.getDesktop().open(tmpFile);
	}

	private Name createCell(int colIdx, Workbook wb, Sheet sheet, Row row, Integer VALUE, String name) {
		Cell cell = row.createCell(colIdx);
		cell.setCellValue(VALUE);
		Name cellName = wb.createName();
		cellName.setNameName(name);    
		String formulaText = sheet.getSheetName() + "!" + "$" + CellReference.convertNumToColString(cell.getColumnIndex()) + "$" + (cell.getRowIndex() + 1);
//		String formulaText = sheet.getSheetName() + "!" + new CellReference(cell).formatAsString();
		cellName.setRefersToFormula(formulaText);
		return cellName;
	}

}