||[Apr. 19th, 2007|12:26 pm]
Listen in, listen Ian!
Why I hate Excel, part 435834689 of 875634863: I change the description on|
a tag to E&T style YEP, no '02' or '03'. It doesn't like this,
and gives me three possible reasons why it's not allowed:
- The number of characters must not exceed 31.
- The characters :, /, \,
?, *, [ and ] are not
- The description must not be blank.
The text I have entered clearly isn't more than 31 characters. It's not
even possible to enter more than 31 characters anyway, it jsut doesn't let
you do that, so it won't ever be the case that you get the error message I
got having broken that particular validation rule.
I thought maybe in reality it was more than 31, so I deleted the last
character and it accepted the name. That looked messy then, with an
unmatched ' so I put it back and deleted the space after the
comma in the middle. It wasn't having that, so I can only assume it doesn't
like the description ending in '. I got it to work by changing
it to E&T YEP, no '02' or '03'.
This is so lazy. It knows exactly what the problem is, because it must have
hecked for it in order to stop me entering the invalid value. Why can't it
just tell me. It's a fault that I'd be ashamed to put software out with,
yet the world's biggest software company thinks it's fine. There's
something wrong there.