Genes, Excel and Dates

Not related to a specific OLAP tool. (Includes forum policies and rules).
Post Reply
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Genes, Excel and Dates

Post by Steve Rowe »

Good to see we're not the only people that wrestle with this!

https://www.theregister.com/2020/08/06/ ... ene_names/
Technical Director
www.infocat.co.uk
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Genes, Excel and Dates

Post by gtonkin »

I saw that too and had a good chuckle.

Lies, damned lies and statistics!
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Genes, Excel and Dates

Post by Alan Kirk »

For everyone who hates this "feature"... go here: https://excel.uservoice.com/forums/3049 ... ate-format

Cast your vote. Raise your voice. Have your say.

Of course it's possible that the Office development team are arrogant enough to ignore it just as they did with the 1200+ people who voted to have the option of a multiple document interface reinstated in Excel after it was changed to "Single document interface, no option" in Excel 2013. Supposedly this was in response to "user requests" though strangely they never seemed to be able to produce a single one of these "users", nor explain how REMOVING MDI actually benefited users who wanted to use SDI when users who wanted to do that already had that option.

Still, OCCASIONALLY they listen. While they had to be dragged kicking and screaming to do it, they finally did restore the ability to pin folders in the File -> Open dialog, an option that was originally removed in Excel 2016. The User Voice thread for that has since been deleted, curiously. I'd suggest that it was to avoid publicly displaying how much MS screwed up by removing the feature in the first place, but there is no evidence of that. Still, one may speculate. Regardless, though, it means that voting on User Voice isn't ALWAYS a waste of time.

If you want this fixed... have at it, citizens.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply