<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta http-equiv="X-UA-Compatible" content="IE=edge" />
				<meta name="viewport" content="width=device-width, initial-scale=1" />
		<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
		<meta name="format-detection" content="telephone=no" />
		<meta name="robots" content="noindex" />
			<title>ClarisWorks: Bad Range in Cell Formula After Undoing Insert Column</title><body class="ac-gn-current-support">
	<input type="hidden"  id="cdsHeaderObj" data-json='{"setPod": "true",
"resourceUrl": "https://support.apple.com",
"akamaiUrl": "https://km.support.apple.com",
"modelValue": "Support",
"aiSearchServiceURL": "support.apple.com",
"podLocaleValue": "en_US",
"omnitureLocale": "us_en",
"aiCrossDomainSearchServiceURL": "support-suggestions.apple.com",
"podValue": "us~en",
"searchCountry": "us",
"enableAppleInstant": "yes",
"pageName": "kb",
"amlSuggestionsUrl": "https://www.apple.com/search-services/suggestions/",
"title": "ClarisWorks: Bad Range in Cell Formula After Undoing Insert Column",
"channelName": "LEGACY"
}'>
	<input type="hidden"  id="httpDownloadURL" value="http://support.apple.com">
<!-- 	
 -->

	
<aside id="ac-gn-segmentbar" class="ac-gn-segmentbar" lang="en-US" dir="ltr" data-strings="{ 'exit': 'Exit', 'view': '{%STOREFRONT%} Store Home', 'segments': { 'smb': 'Business Store Home', 'eduInd': 'Education Store Home', 'other': 'Store Home' } }">
</aside>

<h1 id="main-title">ClarisWorks: Bad Range in Cell Formula After Undoing Insert Column</h1>
<div id="abstract">
 
<div id="intro-container"><div class="truncate"><div class="attr SYMPTOMS"><div class="attr TOPIC">This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.<BR></div></div> <!--  attr Symptom  --></div> <!--  truncate --></div> <!--  intro-container --><div class="clear"> </div>
 </div>   <!-- abstract end -->
<div id="articlecontent">
<div id="indicator-container">      
<div class="indicator archived"></div></div> <!-- Indicator-container -->
  <div class="attr SUMMARY">
This is fixed in ClarisWorks 1.0v3.<BR>
<BR>
Undoing an insert column in ClarisWorks 1.0v2 or earlier does not restore the proper range in formulas.<BR>
<BR>
1. Select a column which is referenced as a range in a cell formula in another column.<BR>
2.  Insert a column.<BR>
3.  Then choose Undo.<BR>
<BR>
Result:<BR>
The proper range is not restored in the formula. The result is &quot;#REF!&quot; and the word &quot;BADRANGE&quot; replaces the range in the formula.<BR></div>
</div>


<!-- Start SiteCatalyst code version: H.8. -->


<!-- End SiteCatalyst code version: H.8. -->


<div class="mod-date">Published Date: Feb 18, 2012</div>
  <div id="mimosa-tags">
  
  <input type ="hidden" id="mimosa-tags-heading" value="Related Topics" />
  <input type ="hidden" id="showNavTagFlag" value="true" />
  <input type ="hidden" id="tags-localised" value="Tag" />
        </div>

</div><!--/#content-->
</div><!--/#main-->

<!-- Helpful not helpful section -->
 <div style="display:none">
<div id="meta">
                </div> <!--/#meta-->
</div>          
        <!-- Related Section -->
<div class="border-div"></div>      <!-- Offer Section -->
<div class="border-div"></div>
<div id="promo" style="display:none;"> Still need help?</div>          
         
<div style="clear:both;"></div>

</div>
<input type="hidden"  id="cdsArticleObj" data-json='{"docId": "TA41939",
"cdsLocale": "en_US",
"imgSrc": "",
"akamaiUrl": "https://km.support.apple.com",
"strTitle": "ClarisWorks: Bad Range in Cell Formula After Undoing Insert Column",
"strLocale": "en_US",
"omniturePageName": "acs::kb::dl::ta41939::clarisworks: bad range in cell formula after undoing insert column",
"metaUrl": "",
"baseLink": "https://km.support.apple.com/kb/",
"reportLink": "https://support.apple.com",
"lcl": "en_US",
"localeParam": "en_US",
"viewLocale": "null",
"domainName": "0",
"archive": "true",
"enableAffectedProductPortlet": "false",
"configHeaderFooterLocale": "en_US",
"strCategoryListRefKeys": "",
"lastModifiedDate": "2012-02-18",
"creationDate": "1992-04-10",
"publishedDate": "Sat, 18 Feb 2012 06:21:46 GMT-00:00",
"publishedDateHeader": "Sat, 18 Feb 2012 06:21:46 GMT-00:00",
"oldInquiraID": "",
"articleNo": "TA41939",
"strChannel": "LEGACY",
"isOmnitureSupported": "true",
"referringPage": "unknown",
"messageResourcesArticleTempEmail": "Email Download Link",
"messageResourcesArticleTempDown": "Download",
"ACStaticText": "{\"more\": \"…more\", \"less\": \"less\" }"
}'>

<div class="footer-wrapper">

</div>


</html>