the most obscure request yet?

Moderators: Palmtana, coyote303

  • Author
  • Message
Offline

MaxPower

  • Posts: 770
  • Joined: Sat Sep 24, 2016 2:12 am

the most obscure request yet?

PostWed May 11, 2022 10:53 pm

This one is about Strat's official spreadsheet that contains the ATG player set.

Strat, I am begging you, when listing a hitter's run rating, just list it as an integer. Like 14. Not 1-14. Excel cannot be convinced that 1-14 is not a date, because Excel is obsessed with turning everything into dates with no recourse for the user. Thanks in advance.
Last edited by MaxPower on Wed May 11, 2022 10:59 pm, edited 1 time in total.
Offline

MaxPower

  • Posts: 770
  • Joined: Sat Sep 24, 2016 2:12 am

Re: the most obscure request yet?

PostWed May 11, 2022 10:55 pm

I suppose it's obligatory to post this meme here: https://i.imgur.com/9BkYzme.png
Offline

coyote303

  • Posts: 1531
  • Joined: Thu Aug 23, 2012 5:01 pm
  • Location: Colorado

Re: the most obscure request yet?

PostThu May 12, 2022 2:42 pm

SOM is unlikely to respond to this request. However, you should be able to format the run-rating column to text. That should solve the problem.
Offline

MaxPower

  • Posts: 770
  • Joined: Sat Sep 24, 2016 2:12 am

Re: the most obscure request yet?

PostThu May 12, 2022 5:07 pm

coyote303 wrote:SOM is unlikely to respond to this request. However, you should be able to format the run-rating column to text. That should solve the problem.

One would think, but for some reason Excel takes that to mean that I want "1-15" to display as a 5-digit number in the 40,000s.
Offline

coyote303

  • Posts: 1531
  • Joined: Thu Aug 23, 2012 5:01 pm
  • Location: Colorado

Re: the most obscure request yet?

PostFri May 13, 2022 11:31 am

Weird. I thought I would try out my suggestion myself. But I didn't need to; it simply accepted 1-14 as is. However, I don't use Excel; instead, I use LibreOffice which is a free clone of MS Office. I'm not sure it would be worth it to download it since you already have Excel, but on the other hand, it might solve your issue!
Offline

MaxPower

  • Posts: 770
  • Joined: Sat Sep 24, 2016 2:12 am

Re: the most obscure request yet?

PostFri May 13, 2022 5:07 pm

Nice, I'm not surprised it handles dates better as it couldn't possibly handle them worse. I ultimately had to paste the cells into Notepad then paste them back into Excel.

Return to Wish List, Suggestions for SOM

Who is online

Users browsing this forum: No registered users and 5 guests