You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by jh...@apache.org on 2006/08/28 05:39:13 UTC
svn commit: r437519 -
/jakarta/poi/trunk/src/java/org/apache/poi/hssf/record/formula/Ref3DPtg.java
Author: jheight
Date: Sun Aug 27 20:39:13 2006
New Revision: 437519
URL: http://svn.apache.org/viewvc?rev=437519&view=rev
Log:
Bug36646: Ret3dPtg to include quotes when sheetname contains a space.
Modified:
jakarta/poi/trunk/src/java/org/apache/poi/hssf/record/formula/Ref3DPtg.java
Modified: jakarta/poi/trunk/src/java/org/apache/poi/hssf/record/formula/Ref3DPtg.java
URL: http://svn.apache.org/viewvc/jakarta/poi/trunk/src/java/org/apache/poi/hssf/record/formula/Ref3DPtg.java?rev=437519&r1=437518&r2=437519&view=diff
==============================================================================
--- jakarta/poi/trunk/src/java/org/apache/poi/hssf/record/formula/Ref3DPtg.java (original)
+++ jakarta/poi/trunk/src/java/org/apache/poi/hssf/record/formula/Ref3DPtg.java Sun Aug 27 20:39:13 2006
@@ -160,7 +160,13 @@
StringBuffer retval = new StringBuffer();
SheetReferences refs = book == null ? null : book.getSheetReferences();
if (refs != null) {
- retval.append(refs.getSheetName((int)this.field_1_index_extern_sheet));
+ String sheetName =refs.getSheetName((int)this.field_1_index_extern_sheet);
+ boolean appendQuotes = sheetName.contains(" ");
+ if (appendQuotes)
+ retval.append("'");
+ retval.append(sheetName);
+ if (appendQuotes)
+ retval.append("'");
retval.append('!');
}
retval.append((new CellReference(getRow(),getColumn(),!isRowRelative(),!isColRelative())).toString());
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/