Reputation: 714 Enlightened
- Active Members
- Active Posts:
- 2,422 (1.1 per day)
- 13-September 08
- Profile Views:
- Last Active:
- 58 minutes ago
- Viewing Forum: Caffeine Lounge
- OS Preference:
- Favorite Browser:
- Favorite Processor:
- Favorite Gaming Platform:
- Your Car:
- Dream Kudos:
Posts I've Made
Posted 17 Sep 2014What he said.
In other news, I've agreed to teach my friends' son to program. I set up VS on their computer to teach him some basics to get started. Trying to decide the best point to start at in order to interest him and make sure he enjoys it.
Posted 17 Sep 2014one does not interfere with DIC's probing
Posted 17 Sep 2014Delicious junk data!
Have you asked her about just making a page for the form?
Posted 17 Sep 2014And this, ladies and gentlemen, is Tom's job in Office Space was. "I get the requirements from the customer and take it to the developers. I'M A PEOPLE PERSON! WHAT'S WRONG WITH YOU PEOPLE!?"No .NET.
It's a PHP web form. The submissions are to be sent to her. She wants it sent as a file attachment she can open in Excel. She wants to set the fonts and titling and italicizing so it appears consistent in Excel every time she opens one of these form submissions.
The form itself is actually an internal order form and I'm pulling pricing data and doing totals-per-product calculations from the database, so these totals are included in the .csv... but there are 4 products on the list that she has to call the supplier for current pricing. She wants to be able to "just type in the quote they give" and have it magically calculate the product totals and then total the whole order for her.
Right now, the form is writing to a .csv which she thinks is wonderful. She says, "This is great! Now, I just need it to do all the calculations and add my bold and stuff and it'll be perfect."
"I can't do that in a .csv file."
".csv file format doesn't work that way."
*Rolls eyes* "Ugh. I know you can do it. You just don't want to. You did it for that stupid unicorn thing."
"No, I generated a PDF file for UNICORN."
"So, do that. I'll just open the PDF file in Excel."
"It doesn't work that way."
"You always have an excuse, don't you? Why do you do things for other people, but not for me? What is your problem with me anyway? I know you don't like me. Just make it work the way I want it to."
I suddenly have a lot of sympathy for her husband.
I have found resources on how to create an xls file with PHP, what I can't find is how to add formulas...
I always got a laugh at that because that is actually a job that exists and needs to be done, and this is exactly why.
That said, and I don't mean to criticize - I've never said something can't be done. I just say, "I don't know how to do that yet." Only once have I said flat out no to a request and that was because the activex controls I was using didn't support the request (selective text coloring in a listbox) and it wasn't worth redoing all the controls just to add that small bit of functionality.
Posted 17 Sep 2014Trying to figure out how to explain to the secretary that I can't generate a .csv file to be opened in Excel that will keep formulas and font formatting because she is completely not understanding the concept.
if you're using .NET you can just generate an xlsx though...
- Member Title:
- 31 years old
- August 28, 1983
- Behind Seven Proxies!
- Music and Games
- Full Name:
- Joor Mudder
- Years Programming:
- Programming Languages: