|
I have a bit of software that uses the office interop (.net wrapper of COM classes) library to import data from spreadsheets. Some of today's imports failed, the issue turned out to be that the person who edited them put a double line border on the bottom of the last row of cells. Somehow that convinced Excel that it needed to return an extra row when I asked for the range of cells that were in use. The parser then barfed on the empty row because strings that look like "" can't be converted into numbers, etc.
Thankfully one of my eagle eyed coworkers spotted the difference. Otherwise I'd be ranting about excel being a buggy piece of crap and inexplicably returning an extra blank row in some files that I had to filter out.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
What do you get when you cross a joke with a rhetorical question?
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
Do questions with multiple question marks annoy you???
|
|
|
|
|
Ew. I use OleDb and the ACE engine to read and write Excel.
But today... I found out that when I set IMEX=1 -- the system says the file is read-only. 
|
|
|
|
|
You might want to look at EPPlus[^]. It is a lot saner than Office Interop.
What do you get when you cross a joke with a rhetorical question?
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
Do questions with multiple question marks annoy you???
|
|
|
|
|
If we ever do a major rework of the rest of the Office integration in the app swapping out the MS component might be worth it; at present, we'd still need to check for unsaved changes/etc.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
5Squared
=====
You are my everything but the kitchen sinko de Mayo Me gotta go pole the pirogue down the bayou country joe and the fishtales of brave ulysses s. grant you
|
|
|
|
|
Was Socratease a flirtatious philosopher?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Nah, 'e was an aristotle.
(hint: cockney)
|
|
|
|
|
I thought he was permanatly pissed[^]? 
(NSFW language)
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
modified 21-Sep-15 7:38am.
|
|
|
|
|
NSWF?
What do you get when you cross a joke with a rhetorical question?
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
Do questions with multiple question marks annoy you???
|
|
|
|
|
Mainly the joke about American beer being like making love in a canoe.
I know it doesn't quite reach MM's standards, but some people can be quite sensitive about that sort of language. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Don't even get me Sarted...
/ravi
|
|
|
|
|
You'll have your Plato full.
It was broke, so I fixed it.
|
|
|
|
|
Yes. You seem to have a Thoreau understanding of my condition.
/ravi
|
|
|
|
|
I Kant help you with your condition.
It was broke, so I fixed it.
|
|
|
|
|
|
what is with this chane of comments?
|
|
|
|
|
Here's[^] another one (of many).
/ravi
|
|
|
|
|
I think you ruined it by adding the "tease" to Socra. Just saying.
|
|
|
|
|
|
I posted about this problem[^] a month ago, and a few weeks before that.
I'm working at a company in San Diego as an employee of http://www.motionrecruitment.com/[^]
Right from the start their payroll website hasn't worked, so I have been tracking and submitting my hours to them with an Excel file.
Last Monday I got an email saying that they had made a mistake and that I would be getting mailed a check overnight, which I received the next day.
This week I submitted 44 hours for last week. Today I got paid - but only for 36 hours!!!
THIS COMPANY SUPPLIES PROGRAMMERS TO OTHER COMPANIES!!!! CAN THE NOT FIX THEIR OWNE PAYROLL SYSTEM!!!
AAAAHHHHHH!!!!!
Sorry, hadda vent.
If it's not broken, fix it until it is
|
|
|
|
|
Kevin Marois wrote: COMPANY SUPPLIES PROGRAMMERS TO OTHER COMPANIES!!!! CAN THE NOT FIX THEIR OWNE PAYROLL SYSTEM
The incongruity is hilarious. It's a serious pain when they mess up your pay.
|
|
|
|
|
Well, a classic case of The cobbler's children go barefoot...
I'd rather be phishing!
|
|
|
|
|
Well yeah, don't you know how expensive shoes are, and the elephanting spawnlings keep growing out of them every few days. 
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
They HAVE fixed it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
