DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17582>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17582 Formula Parser cannot parse formulas containing non-alphabetical characters ------- Additional Comments From [EMAIL PROTECTED] 2003-03-05 06:54 ------- Example String currencyCell = "F3"; HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(quote.getName()); HSSFRow row = sheet.createRow((short) 0); HSSFCell cell = row.createCell((short) 0); cell.setCellFormula("\"TOTAL[\" & " + currencyCell + " & \"]\""); In this case I had a request to create a spreadsheet, that in cell F3 would contain a currency (by the user typing it), and several other cells would use that value to display a heading e.g. typing USD in cell F3 would display "Total [USD]" in cell A1.(obviously the requirement of the square brackets could be relaxed). --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
