You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ce...@apache.org on 2017/09/18 18:55:07 UTC
svn commit: r1808763 -
/poi/trunk/src/java/org/apache/poi/ss/usermodel/Name.java
Author: centic
Date: Mon Sep 18 18:55:07 2017
New Revision: 1808763
URL: http://svn.apache.org/viewvc?rev=1808763&view=rev
Log:
Bug 61520: Add JavaDoc about name-references in Excel
Modified:
poi/trunk/src/java/org/apache/poi/ss/usermodel/Name.java
Modified: poi/trunk/src/java/org/apache/poi/ss/usermodel/Name.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/usermodel/Name.java?rev=1808763&r1=1808762&r2=1808763&view=diff
==============================================================================
--- poi/trunk/src/java/org/apache/poi/ss/usermodel/Name.java (original)
+++ poi/trunk/src/java/org/apache/poi/ss/usermodel/Name.java Mon Sep 18 18:55:07 2017
@@ -134,6 +134,11 @@ public interface Name {
* <li><code>-PMT(Interest_Rate/12,Number_of_Payments,Loan_Amount)</li>
* </ul>
*
+ * Note: Using relative values like 'A1:B1' can lead to unexpected moving of
+ * the cell that the name points to when working with the workbook in Microsoft Excel,
+ * usually using absolute references like '$A$1:$B$1' avoids this, see also
+ * https://superuser.com/a/1031047/126954
+ *
* @param formulaText the reference for this name
* @throws IllegalArgumentException if the specified formulaText is unparsable
*/
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org