Home     Products      Support      Corporate     Sign In 

Support Knowledge Base, Article 235

Product
ExcelWriter
Version
2.03
Title
Error: Invalid cell name error when using Excel "A1", "B1" style cell references
Problem
When using ExcelWriter Desktop v2.03 on Windows 95, you may see the following error:
Invalid cell name. Cell name should look like [A]A[####]#, where A
is a letter for a column, and # is a one-based number for a row
This will occur if you reference cells using Excel-style addressing such as:
Cells("A1")
Cells("B2")
But, it will not occur if you reference cells using their ordinal numbers:
Cells(1,1)
Cells(2,2)
This error occurs only with ExcelWriter Desktop Edition. This error has not been observed on ExcelWriter Server editions.
Solution
This is a known issue in ExcelWriter Desktop v2.03 on Windows 95.

To prevent this error, reference cells using their ordinal numbers instead of Excel-style addressing.

Related Links
OfficeWriter Home Page
OfficeWriter Enterprise Edition
Latest OfficeWriter News

Created : 12/1/2002 12:00:00 AM (last modified : 3/26/2008 4:40:47 PM)

Rate this article!

 
Comments



Copyright 2006 © SoftArtisans, Inc. All Rights Reserved.

Site Map     |     Privacy Policy     |     Contact Us