g r o t t o 1 1

Peeve Farm
Breeding peeves for show, not just to keep as pets
  Blog \Blôg\, n. [Jrg, fr. Jrg. "Web-log".
     See {Blogger, BlogSpot, LiveJournal}.]
     A stream-of-consciousness Web journal, containing
     links, commentary, and pointless drivel.


On My Blog Menu:

InstaPundit
USS Clueless
James Lileks
Little Green Footballs
As the Apple Turns
Entropicana
Cold Fury
Capitalist Lion
Red Letter Day
Eric S. Raymond
Tal G in Jerusalem
Secular Islam
Aziz Poonawalla
Corsair the Rational Pirate
.clue

« ? Blogging Brians # »





Book Plug:

Buy it and I get
money. I think.
BSD Mall




 10/6/2003 -  10/8/2003
 9/29/2003 -  10/5/2003
 9/22/2003 -  9/28/2003
 9/15/2003 -  9/21/2003
  9/8/2003 -  9/14/2003
  9/1/2003 -   9/7/2003
 8/25/2003 -  8/31/2003
 8/18/2003 -  8/24/2003
 8/11/2003 -  8/17/2003
  8/4/2003 -  8/10/2003
 7/28/2003 -   8/3/2003
 7/21/2003 -  7/27/2003
 7/14/2003 -  7/20/2003
  7/7/2003 -  7/13/2003
 6/30/2003 -   7/6/2003
 6/23/2003 -  6/29/2003
 6/16/2003 -  6/22/2003
  6/9/2003 -  6/15/2003
  6/2/2003 -   6/8/2003
 5/26/2003 -   6/1/2003
 5/19/2003 -  5/25/2003
 5/12/2003 -  5/18/2003
  5/5/2003 -  5/11/2003
 4/28/2003 -   5/4/2003
 4/21/2003 -  4/27/2003
 4/14/2003 -  4/20/2003
  4/7/2003 -  4/13/2003
 3/31/2003 -   4/6/2003
 3/24/2003 -  3/30/2003
 3/17/2003 -  3/23/2003
 3/10/2003 -  3/16/2003
  3/3/2003 -   3/9/2003
 2/24/2003 -   3/2/2003
 2/17/2003 -  2/23/2003
 2/10/2003 -  2/16/2003
  2/3/2003 -   2/9/2003
 1/27/2003 -   2/2/2003
 1/20/2003 -  1/26/2003
 1/13/2003 -  1/19/2003
  1/6/2003 -  1/12/2003
12/30/2002 -   1/5/2003
12/23/2002 - 12/29/2002
12/16/2002 - 12/22/2002
 12/9/2002 - 12/15/2002
 12/2/2002 -  12/8/2002
11/25/2002 -  12/1/2002
11/18/2002 - 11/24/2002
11/11/2002 - 11/17/2002
 11/4/2002 - 11/10/2002
10/28/2002 -  11/3/2002
10/21/2002 - 10/27/2002
10/14/2002 - 10/20/2002
 10/7/2002 - 10/13/2002
 9/30/2002 -  10/6/2002
 9/23/2002 -  9/29/2002
 9/16/2002 -  9/22/2002
  9/9/2002 -  9/15/2002
  9/2/2002 -   9/8/2002
 8/26/2002 -   9/1/2002
 8/19/2002 -  8/25/2002
 8/12/2002 -  8/18/2002
  8/5/2002 -  8/11/2002
 7/29/2002 -   8/4/2002
 7/22/2002 -  7/28/2002
 7/15/2002 -  7/21/2002
  7/8/2002 -  7/14/2002
  7/1/2002 -   7/7/2002
 6/24/2002 -  6/30/2002
 6/17/2002 -  6/23/2002
 6/10/2002 -  6/16/2002
  6/3/2002 -   6/9/2002
 5/27/2002 -   6/2/2002
 5/20/2002 -  5/26/2002
 5/13/2002 -  5/19/2002
  5/6/2002 -  5/12/2002
 4/29/2002 -   5/5/2002
 4/22/2002 -  4/28/2002
 4/15/2002 -  4/21/2002
  4/8/2002 -  4/14/2002
  4/1/2002 -   4/7/2002
 3/25/2002 -  3/31/2002
 3/18/2002 -  3/24/2002
 3/11/2002 -  3/17/2002
  3/4/2002 -  3/10/2002
 2/25/2002 -   3/3/2002
 2/18/2002 -  2/24/2002
 2/11/2002 -  2/17/2002
  2/4/2002 -  2/10/2002
 1/28/2002 -   2/3/2002
 1/21/2002 -  1/27/2002
 1/14/2002 -  1/20/2002
  1/7/2002 -  1/13/2002
12/31/2001 -   1/6/2002
12/24/2001 - 12/30/2001
12/17/2001 - 12/23/2001
Friday, October 18, 2002
15:36 - Windows Moment of Zen

(top) link
Well, actually, "hour of rage" would be more accurate.

I spent the better part of an hour putting together a spreadsheet in Excel, using a template I'd constructed whose purpose was to allow our team to write test plans and then save them as comma-separated-value files, which they could then import into the web-based test-plan database using an integrated script.

After the spreadsheet was completely done, with all the text immaculately formatted and all the sort-ordering the way I wanted it, with the cell formatting all perfect, the section divisions aligned properly, and everything all ready to go... I went and clicked the "save" icon.



... 'Scuse me?

I click it again. "Document not saved."

I cannot believe my eyes, yet they are not in the habit of deceiving me. This application, this piece of software, is flatly refusing a command. "Please save the file." "NO." No explanation; no excuses. "I don't have to explain myself. I have better things to do than obey your pitiful commands, human."

Okay... maybe I'll "Save As", and export it as a CSV directly. "Save As", I click. it gives me a dialog about how this will cause the sheet to lose formatting. Fine, I know that. I click OK... and then, er... nothing. I check the Desktop. Nothing.

I try everywhere. I can't save on my remotely mounted Mac. I can't save on the central server. I can't save on my own local bloody Desktop.

Out of disk space, perhaps? C: 14.8 GB Free. Hokay, no, that's hardly likely. Excel files are REALLY HY))00GE LOOLOLOL!!!11`, but not that huge.

Interestingly, the filename as reported in the Excel window's title bar keeps changing to whatever I've tried to save it as, regardless of whether it's been successful or not. And each time I bring up the "Save As" dialog, the filename has a different extension and presentation. Sometimes it's got quotes around it. Sometimes it's got .xls at the end, sometimes it's got .csv. Either way, it seemingly has no bearing on the format of the file as I requested it to be saved. Not that there was any output file in the first place.

"Reboot the machine," suggest co-workers. Yuh-huh. After an hour's worth of work, I'm not going to simply reboot and have to type all this crap back in. But the options are looking fewer and fewer.

Finally I try opening up a completely new spreadsheet, copying the data from the first sheet, pasting it into the new one. This loses all the formatting, but at least most of the data gets transferred okay. And I try saving, and... lo and behold, it works.

A reboot and another half-hour's worth of reformatting work later, and finally it's ready to go. And it happily lets me save the file this time, without any indication of its earlier mood swing. "Oh, I'm innocent as the day is long! You wouldn't wanna hit lil' ol' me, now?"

Sometimes people in the company wonder why our team has been writing our own infrastructural tools for QA progress management, test-plan tracking, document archival, bug management, and so on. "Why don't you just use stuff like Excel and Project and Word?"

Because I like my software to work, thank you very much. We've written our own database software so we don't have to put up with this garbage. And when two or three guys in a company-- whose job descriptions don't even include toolsmithing-- can write more reliable software for a purpose like this than Microsoft has been peddling for twenty years, the fact that this answer isn't self-evident makes me weep for the future of humanity.


This crap doesn't even trap end-of-line characters when you save as CSV. Christ.


Back to Top


© Brian Tiemann