Re: [office-formula] Portable documents language

[robert_weir@us.ibm.com]

Do implementations actually prohibit names that look like cell addresses, 
or only names that are actually cell addresses?

Particular example.  Excel before 2007 supported 256 columns.  So columns 
A through IV.  Excel 2007 increased the limit to 16K, so columns through 
XFD are allowed.

In Excel 2003 I get an error if I try to define a name called "A1".  But I 
do not get an error if I try to define a name called "XFD1".  Presumably 
the later would be an error in Excel 2007 or later.

So I'm wondering whether "looks like a cell address" even if we give a 
regex, will be entirely accurate.

But I suppose as  a portability note, this is good advice.

-Rob

Patrick Durusau <patrick@durusau.net> wrote on 02/05/2010 07:07:31 AM:

> 
> <snip>
> >> Willing to be surprised if you have a regex that will neatly solve 
this 
> >> issue!
> >> 
> >
> > ( [A-Za-z]+[0-9]+ )
> >
> > describes exactly the cell references. So I am not sure why you don't
> > like that.
> >
> > 
> Don't like it because your regex would prohibits all names that are 
> ASCII letters followed by digits.
> 
> Solves the problem, yes, but fails to recognize that users may already 
> have names that look like cell references.
> 
> Or do you mean to exclude all documents with such identifiers from being 

> "portable?"
> 
> The regex needs to be re-written anyway to correct the other error so I 
> would rather this be done once.
> 
> Hope you are looking forward to a great weekend!
> 
> Patrick
> 
> 
> -- 
> Patrick Durusau
> patrick@durusau.net
> Chair, V1 - US TAG to JTC 1/SC 34
> Convener, JTC 1/SC 34/WG 3 (Topic Maps)
> Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
> Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe from this mail list, you must leave the OASIS TC that
> generates this mail.  Follow this link to all your TCs in OASIS at:
> https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php 
>