title: How to set formula have table column field in Apache POI
body: <p>I created an XSSFTable with below example code:</p>
  
  <p><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateTable.java" rel="nofollow noreferrer">https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateTable.java</a></p>
  
  <p>One column in my XSSFTable is a formula that referencing to another column in this table.</p>
  
  <p>For example, in XSSFTable <code>TBL</code> column <code>ColumnA</code>, the formula is: <code>=[@[ColumnB]]</code>, I can set the formula on each cell in <code>ColumnA</code> via <code>cell.setCellFormula("TBL[[#This Row],[ColumnB]]")</code>, but it will have problem while opened in Excel and Excel has to remove the formula in order to display the worksheet correctly.</p>
  
  <p>This problem only happened in creating blank new XSSFWorkbook, if it is loaded from an existing .xlsx file created by Excel, it is able to modify the formula via cell.setCellFormula() and able to open in Excel correctly.</p>
  
  <p>If there are any sample code can work correctly in this situation?</p>