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!
How did the spaces get there in the first place?
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.
Using the big bar at the front side of the keyboard
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.
July 9th, 2007 9:41am
Or, he knows it (isn't finding it out) and is doing it on purpose.
Nice to see you posting again, Tapiwa. How's your mom?
"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?
July 9th, 2007 9:45am
i think you missed the point, dana. He IS looking for trouble.
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???!!
bu ... but ... that's WRONG!
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.
>> "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.
July 9th, 2007 10:27am
July 9th, 2007 12:19pm
>Case sensitivity is a bit moronic.
July 9th, 2007 2:47pm
Blame 'C'. Pascal was never case sensitive.
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.
July 9th, 2007 10:41pm