2021: Linux on the desktop, Free Software 9/11

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > YOSPOS > 2021: Linux on the desktop, Free Software 9/11

«‹›351 »

Phoenixan: Jan 16, 2010; Just Keep Cool-idge

Just-In-Timeberlake posted:

that's just an example, could be an invoice number, whatever.

i used to work with textbook publishing and had a sheet of 13 digit ISBN's + book titles and this poo poo drove me up the wall every day :suicide:

# ? Oct 18, 2017 22:46

Adbot: ADBOT LOVES YOU

# ? Jun 4, 2024 07:44

Just-In-Timeberlake: Aug 18, 2003

COACHS SPORT BAR posted:

I know that it can be frustrating entering values and having this happen. We are investigating what we can do to make this better.  You can help by Voting for this issue. For now, you can select a range and format as text prior to entering the bar codes / id numbers. -Eric [Microsoft]

COACHS SPORT BAR posted:

I know that it can be frustrating entering values and having this happen. We are investigating what we can do to make this better. 

COACHS SPORT BAR posted:

We are investigating what we can do to make this better. 

you can stop investigating, don't loving do it. full. stop.

# ? Oct 18, 2017 22:50

qirex: Feb 15, 2001

sometimes I wonder if microsoft even knows that most of the stuff people put in spreadsheets isn't numbers

Just-In-Timeberlake posted:

you can stop investigating, don't loving do it. full. stop.

it may be literally impossible to fix if the right vp or product manager has a strong opinion about it

# ? Oct 18, 2017 22:58

hobbesmaster: Jan 28, 2008

qirex posted:

sometimes I wonder if microsoft even knows that most of the stuff people put in spreadsheets isn't numbers

it may be literally impossible to fix if the right vp or product manager has a strong opinion about it

COACHS SPORT BAR posted:

get votin'
https://excel.uservoice.com/forums/...umbers-actually

e: currently the 3rd highest voted entry on that site

#1 is python as an alternative to vba lmao

# ? Oct 18, 2017 23:02

pram: Jun 10, 2001

microsoft bad

# ? Oct 18, 2017 23:02

Carthag Tuek: Oct 15, 2005; Tider skal komme,
tider skal henrulle,
sl�gt skal f�lge sl�gters gang

pram posted:

microsoft bad

# ? Oct 18, 2017 23:24

dont be mean to me: May 2, 2007; I'm interplanetary, bitch
Let's go to Mars

pram posted:

microsoft bad

So if Microsoft Bad fails, will that make Microsoft good?

# ? Oct 18, 2017 23:28

anthonypants: May 6, 2007; by Nyc_Tattoo; Dinosaur Gum

pram posted:

microsoft bad

no it's microsoft band

# ? Oct 18, 2017 23:29

Roosevelt: Jul 18, 2009; I'm looking for the man who shot my paw.

dont be mean to me posted:

So if Microsoft Bad fails, will that make Microsoft good?

Microsoft Worse 2019 collector's edition

# ? Oct 18, 2017 23:29

hobbesmaster: Jan 28, 2008

anthonypants posted:

#1 is python as an alternative to vba lmao

it qualifies as �literally anything else� so I guess I�m for it

# ? Oct 18, 2017 23:33

pram: Jun 10, 2001

remember when microsoft band was SOLD OUT everywhere and whoa mama, redmonds got a real sleeper hit here! and then they permanently ceased production like a year later. lol

# ? Oct 18, 2017 23:34

anthonypants: May 6, 2007; by Nyc_Tattoo; Dinosaur Gum

hobbesmaster posted:

it qualifies as �literally anything else� so I guess I�m for it

there's one for powershell too but it's nowhere near top 10

# ? Oct 18, 2017 23:40

BangersInMyKnickers: Nov 3, 2004; I have a thing for courageous dongles

ran in to this one IRL today

http://www.dell.com/support/article/us/en/19/sln306701/slow-performance-issues-in-excel-when-opening-saved-files?lang=en

You may see an issue when you try to open a saved (Hard Drive, USB Drive, Network Drive...) Excel spreadsheet and it may take 1-2 minutes before you will see the Excel splash screen when the file opens. This behavior should not happen if you open a new Excel spreadsheet and then open a saved Excel spreadsheet.

The best solution to resolve this behavior, is to disable the Waves MaxxAudio Service Application (Publisher Waves Audio Ltd.) service.

# ? Oct 19, 2017 01:24

ClassActionFursuit: Mar 15, 2006

Just-In-Timeberlake posted:

one of those questions had better be "why the gently caress does excel insist on displaying any large (cc number for example) as scientific notation and why the gently caress can i not turn that behavior off"

that was in there but unbelievably "has anyone ever in the history of this program existing ever pasted in data with formatting except by accident?" was not

# ? Oct 19, 2017 01:36

hobbesmaster: Jan 28, 2008

LastInLine posted:

that was in there but unbelievably "has anyone ever in the history of this program existing ever pasted in data with formatting except by accident?" was not

yes but only if it�s another excel document

# ? Oct 19, 2017 01:39

burning swine: May 26, 2004

BangersInMyKnickers posted:

The best solution to resolve this behavior, is to disable the Waves MaxxAudio Service Application (Publisher Waves Audio Ltd.) service.

lmao burn that poo poo to the ground

same terrible software that turbofucked the audio on my xps15 2 weeks ago

e: from the dell article

quote:

Note: All the audio should still work fine and the MaxxAudio application will load. However, there is no way to remove the service or application.

The service will re-enable after rebooting and will have to be disabled each time.

# ? Oct 19, 2017 02:33

pram: Jun 10, 2001

windows

# ? Oct 19, 2017 03:05

Cybernetic Vermin: Apr 18, 2005

Just-In-Timeberlake posted:

one of those questions had better be "why the gently caress does excel insist on displaying any large (cc number for example) as scientific notation and why the gently caress can i not turn that behavior off"

setting the number format of the cells to text not working? (and if this is what you always want, making a template where you preset all cells as such) :confused:

# ? Oct 19, 2017 08:41

Just-In-Timeberlake: Aug 18, 2003

Cybernetic Vermin posted:

setting the number format of the cells to text not working? (and if this is what you always want, making a template where you preset all cells as such)

hang on let me janitor my spreadsheet because microsoft assumes scientific notation is a thing that people want by default

# ? Oct 19, 2017 13:09

univbee: Jun 3, 2004

Just-In-Timeberlake posted:

hang on let me janitor my spreadsheet because microsoft assumes scientific notation is a thing that people want by default

i strongly suspect this is one of those things that will break some tenured professors' workflows so microsoft won't change it

would be nice if they at least made it a checkbox you could change somewhere though, drat

# ? Oct 19, 2017 13:11

champagne posting: Apr 5, 2006; YOU ARE A BRAIN
IN A BUNKER

it's a weird default to be sure, considering excel is almost only a business tool and not a scientific computing tool

i guess it could be the latter but i wouldn't want to be the poor sod who'd have to use it for that. again.

# ? Oct 19, 2017 13:21

Chris Knight: Jun 5, 2002; me @ ur posts; Fun Shoe

I hate the way excel just silently loses precision past a certain number size, but never throws a warning or anything at you. but will bitch about what it thinks are numbered values stored in a text formatted cell.

# ? Oct 19, 2017 13:58

akadajet: Sep 14, 2003

anthonypants posted:

#1 is python as an alternative to vba lmao

to be fair that would be pretty slick if done well

# ? Oct 19, 2017 14:02

cinci zoo sniper: Mar 15, 2013

akadajet posted:

to be fair that would be pretty slick if done well

# ? Oct 19, 2017 14:04

champagne posting: Apr 5, 2006; YOU ARE A BRAIN
IN A BUNKER

akadajet posted:

to be fair that would be pretty slick if done well

# ? Oct 19, 2017 14:05

Just-In-Timeberlake: Aug 18, 2003

Chris Knight posted:

I hate the way excel just silently loses precision past a certain number size, but never throws a warning or anything at you. but will bitch about what it thinks are numbered values stored in a text formatted cell.

here's a fun exercise:

paste in a large number that would cause excel to display it in SN

format the cell to be a text field

the cell still displays the SN but if you click the cell the value is displayed correctly

and another:

paste in a large number with more than two numbers to the right of the decimal point (9999999999999.123456)

excel converts it to SN and truncates it to 2 decimal places without warning and there is no getting it back, that precision is gone.

# ? Oct 19, 2017 14:09

Fatal Error: Feb 13, 2013; by sebmojo

my roommate's laptop just spontaneously rebooted without warning in order to install the update lmao

# ? Oct 19, 2017 14:16

Perplx: Jun 26, 2004; Best viewed on Orgasma Plasma; Lipstick Apathy

akadajet posted:

to be fair that would be pretty slick if done well

datanitro has been doing it well for like 5 years now

# ? Oct 19, 2017 14:18

univbee: Jun 3, 2004

Just-In-Timeberlake posted:

here's a fun exercise:

paste in a large number that would cause excel to display it in SN

format the cell to be a text field

the cell still displays the SN but if you click the cell the value is displayed correctly

and another:

paste in a large number with more than two numbers to the right of the decimal point (9999999999999.123456)

excel converts it to SN and truncates it to 2 decimal places without warning and there is no getting it back, that precision is gone.

this never would have happened with lotus 1-2-3

i have never used lotus 1-2-3 so it almost certainly would have also happened with lotus 1-2-3

# ? Oct 19, 2017 14:18

SupSuper: Apr 8, 2009; At the Heart of the city is an Alien horror, so vile and so powerful that not even death can claim it.

https://www.youtube.com/watch?v=4ck5RbTQj28

now with (1) usb-c port!

# ? Oct 19, 2017 14:20

champagne posting: Apr 5, 2006; YOU ARE A BRAIN
IN A BUNKER

Just-In-Timeberlake posted:

here's a fun exercise:

paste in a large number that would cause excel to display it in SN

format the cell to be a text field

the cell still displays the SN but if you click the cell the value is displayed correctly

and another:

paste in a large number with more than two numbers to the right of the decimal point (9999999999999.123456)

excel converts it to SN and truncates it to 2 decimal places without warning and there is no getting it back, that precision is gone.

a colleague of mine pointed out (when I explained this to him) that it's the limit of double precision for 64-bit floating points. You can have 15 numbers and a decimal point, no more no less. well I guess you could have less.

univbee posted:

this never would have happened with lotus 1-2-3

i have never used lotus 1-2-3 so it almost certainly would have also happened with lotus 1-2-3

the last version of 1-2-3 was in 32 bit so you could have even fewer numbers. I think. I am not a CS-person.

# ? Oct 19, 2017 14:23

Condiv: May 7, 2008; Sorry to undo the effort of paying a domestic abuser $10 to own this poster, but I am going to lose my dang mind if I keep seeing multiple posters who appear to be Baloogan.

With love,
a mod