Log in

No account? Create an account
Why I hate Excel, part 435834689 of 875634863: I change the… - B. Henderson Asher's Moments of Mirth [entries|archive|friends|userinfo]
Listen in, listen Ian!

[ website | Flickr ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

[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.

[User Picture]From: oldbloke
2007-04-19 08:34 pm (UTC)
's prolly trying to expand it into a date or something, and that tips it over the 31 chars. Excel is full of oddities, there's no point stressing about it.

Does Quattro still exist? I used to like Quattro.

What's the spreadsheet in [Star|Open]Office really like?
(Reply) (Thread)
[User Picture]From: ruudboy
2007-04-19 08:46 pm (UTC)
What's the spreadsheet in [Star|Open]Office really like?

Um, it has cells in it you can type numbers in and stuff. Tbh I've only used it at home, and my spreadsheet needs there are far from anything which might be a useful test of if it's any good or not. The Google docs spreadsheet does everything I need it to.
(Reply) (Parent) (Thread)