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: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
