This really grinds my gears

Question

This really grinds my gears

ZZartin

SSC-Dedicated

Points: 30920
More actions
June 12, 2018 at 9:20 am

#351843

People sending me excel documents zoomed to less than 100% yes thank you all your rows and columns now fit on one screen in an unreadable small size, bonus points when there's multiple tabs in the excel document.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 1

How about Excel files that have tons of embedded VBA scripts in them that do all sorts of magic data retrieval and manipulation written by a "power user" of the system, that then doesn't match reports written by IT so some other user complains about it and IT has to fix it.

ZZartin SSC-Dedicated Points: 30920 More actions · Answer 2

Or the evil of people who hide columns/rows :crazy:

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

ZZartin - Tuesday, June 12, 2018 10:38 AM
Or the evil of people who hide columns/rows :crazy:

And the ones who save the document with the cursor on a cell in column XFD - thanks so much, just what I wanted to see.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Luis Cazares SSC Guru Points: 183706 More actions · Answer 4

ZZartin - Tuesday, June 12, 2018 9:20 AM
People sending me excel documents zoomed to less than 100% yes thank you all your rows and columns now fit on one screen in an unreadable small size, bonus points when there's multiple tabs in the excel document.

Isn't that what data compression does?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 5

I "love" the ones that remind me of many of the posts on these very forums... you know the ones... they send you a spreadsheet with a note "This doesn't work. Please fix it for me". 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ManicStar SSCoach Points: 17992 More actions · Answer 6

Jeff Moden - Tuesday, June 12, 2018 12:45 PM
I "love" the ones that remind me of many of the posts on these very forums... you know the ones... they send you a spreadsheet with a note "This doesn't work. Please fix it for me". 😀

"Please fix it for me yesterday"

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 7

Or random sections of worksheets used for different things.

Or auto-calculate macros.

ManicStar SSCoach Points: 17992 More actions · Answer 8

Or my fav: The spreadsheet that has "no" manual intervention that I'm expected to load every day, that changes mysteriously every now and then because someone other than the usual person created it. Turns out that they didn't like the spelling of a column or something.

HappyGeek SSCoach Points: 18729 More actions · Answer 9

Nothing beats the ones that have data connections to the "my documents" folder of the loon that created that all important spreadsheet who was then sacked disgracefully and had their profile deleted!!

...