Re: [office-formula] Portable documents language

["Andreas J. Guelzow" <andreas.guelzow@concordia.ab.ca>]

On Thu, 2010-02-04 at 18:10 -0700, Patrick Durusau wrote:
> Andreas,
> 
> Andreas J. Guelzow wrote:
> > On Thu, 2010-02-04 at 17:41 -0700, Patrick Durusau wrote:
> >   
> >> Greetings!
> >>
> >> Under Named Expressions - General, we say:
> >>
> >>     
> >>> Portable documents *should *limit the names of their identifiers to 
> >>> only ([UNICODE]) letters, underscores, and digits, not including 
> >>> patterns that look like cell references or the words True or False.
> >>>
> >>>       
> >> Eh?
> >>
> >> Is this meant to be a reference to XML letters, underscores and digits?
> >>
> >> Well for that matter, can someone speculate on what names are valid as 
> >> per the following syntax:
> >>
> >>     
> >>> PortableIdentifier ::= ( LetterXML
> >>>
> >>>         (LetterXML | DigitXML | '_' | CombiningCharXML)* )
> >>>       - ( [A-Za-z]+[0-9]+ )
> >>>       - ([Tt][Rr][Uu][Ee]) - ([Ff][Aa][Ll][Ss][Ee])
> >>>
> >>>       
> >> I suspect that something like:
> >>
> >> PortableIdentifier ::= ( LetterXML (LetterXML | DigitXML | '_' | CombiningCharXML)* )
> >> - ([Tt][Rr][Uu][Ee]) - ([Ff][Aa][Ll][Ss][Ee])
> >>
> >>
> >> was intended.
> >>     
> >
> > Surely not.
> >
> > Strings like "A1" should surely also be excluded.
> >
> >   
> Well, it says that in prose, "patterns that look like cell references" 
> but I am not sure there is a regex that would be generally applicable 
> enough to be worth including.
> 
> Would you make it any Letter + Digit? Recalling that ASCII + a Digit are 
> simply familiar to us and that other users may have other default field 
> headers.
> 
> Imperfect solution but I suspect an admonishment in the text is the best 
> we can do.
> 
> 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.

Andreas

This is a digitally signed message part