Ref3DPtg.toFormulaString() has some code to detect the presense of a space char. Area3DPtg doesn't even have that. Some sample junit code to show the error: Ref3DPtg target = new Ref3DPtg("A1", (short)0); Workbook book = Workbook.createWorkbook(); book.checkExternSheet(0); book.setSheetName(0, "profit+loss"); assertEquals("'profit+loss'!A1", target.toFormulaString(book));
Created attachment 21457 [details] svn diff for several files + 5 new java files Some unrelated junit tests broke while doing the work. These were mostly related to printRanges. It was assumed that the correct behaviour for rendering 3d refs for print ranges was the same as that for rendering formulas (i.e. delimit and escape if any special characters are present). The junits were modified to reflect this.
Thanks for this, patch applied to trunk