Reconciling assholes for nearly a decade.

Fun with Excel

Just realised that Excel does not strip out leading or trailing spaces in the names for different sheets.

I am going to have so much fun sending out documents with several sheets, all called sheet

"Sheet" != " Sheet" != "Sheet " != " Sheet "

The ensuing telephone conversations should be fun .....

"You want the sheet callled space sheet space ... no, not space sheet, you want space sheet space."

Gawd, I need to get out more!
Permalink Send private email Tapiwa 
July 9th, 2007 9:04am
How did the spaces get there in the first place?
Permalink AMerrickanGirl 
July 9th, 2007 9:22am
I put them there silly.

In most other MS products, leading and trailing spaces are truncated.

And, you normally  get namespace collisions if you try and have more than one sheet called the same thing. Using spaces is a workaround, and is not immediately obvious. Wonder how long it will take people to realise just how I managed to get several sheets called the same thing in one document.
Permalink Send private email Tapiwa 
July 9th, 2007 9:28am
Using the big bar at the front side of the keyboard
Permalink Send private email Locutus of Borg 
July 9th, 2007 9:28am
Yeah, there's a software engineering principle that basically says "Don't name things ALMOST EXACTLY the same, differing only by upper/lowercase, or by adding/subtracting underscores, because this becomes a maintenance nightmare."

There are exceptions to this rule -- in C++, conventions say a Class starts with an uppercase character, but instantiated objects of that Class (variables, in other words) should start with a lower-case letter.  Or is that Java?

Anyway, adding/removing spaces to make virtually identical, yet separate names, is not recommended either.  But I guess you're finding that out by experience.
Permalink SaveTheHubble 
July 9th, 2007 9:41am
Or, he knows it (isn't finding it out) and is doing it on purpose.

Duh.

Nice to see you posting again, Tapiwa.  How's your mom?
Permalink Send private email muppet 
July 9th, 2007 9:43am
"And, you normally  get namespace collisions if you try and have more than one sheet called the same thing. Using spaces is a workaround, and is not immediately obvious."

What's wrong with actually using unique, meaningful names?  Playing around with space-driven variations on $Sheet1 is just looking for trouble, no?
Permalink AMerrickanGirl 
July 9th, 2007 9:45am
i think you missed the point, dana. He IS looking for trouble.
Permalink heroin addicted ari$--tocrat 
July 9th, 2007 9:46am
JESUS CHRIST NO SHIT YOU GUYS ARE SO INFORMATIVE AND HELPFUL.

*Obviously* the whole point is to CAUSE TROUBLE.  Do you think he's doing it in the hopes that it will NOT cause confusion???!!
Permalink Send private email muppet 
July 9th, 2007 9:46am
bu ... but ... that's WRONG!
Permalink heroin addicted ari$--tocrat 
July 9th, 2007 9:55am
>How's your mom?
Last time I checked, she was still dead.

>bu ... but ... that's WRONG!
I know, but there are some morons I deal with that need that sort of joke played on them. Only for trivial stuff though.
<evil grin>
Permalink Send private email Tapiwa 
July 9th, 2007 9:58am
>> "Don't name things ALMOST EXACTLY the same, differing only by upper/lowercase, or by adding/subtracting underscores, because this becomes a maintenance nightmare." <<

Tell me about it.

Clearcase version control system: Case sensitive.
Windows file system: Not case sensitive.

Junior developer checks in directory with name differing only by case.  Consternation ensues for entire team.
Permalink xampl 
July 9th, 2007 10:27am
Case sensitivity is a bit moronic.

http://crazyontap.com/Topic.php?TopicId=20279&Posts=11
gives moron page

http://crazyontap.com/topic.php?TopicId=20279&Posts=11
works

Diff?? topic.php vs Topic.php

Moronic
Permalink Send private email Tapiwa 
July 9th, 2007 10:42am
>Case sensitivity is a bit moronic.

Blame apache.
Permalink Send private email Colm 
July 9th, 2007 2:47pm
Blame 'C'.  Pascal was never case sensitive.
Permalink SaveTheHubble 
July 9th, 2007 2:50pm
I had a better one. The users didn't like their leading zeros stripped when the .CSV file was double clicked, and they didn't want to format the columns. So, I concatenated the 0xA0 character to the beginning of the number and voila! the leading zeros remained, and everybody was happy.
Permalink LeftWingPharisee 
July 9th, 2007 10:41pm

This topic is archived. No further replies will be accepted.

Other topics: July, 2007 Other topics: July, 2007 Recent topics Recent topics