3 ms·
I don't want this to sound snarky but I don't know how to phrase it better. How is the excel team going at fixing the calculation bugs nowadays after wilfully i
by harry8 4y ago
I don't want this to sound snarky but I don't know how to phrase it better. How is the excel team going at fixing the calculation bugs nowadays after wilfully ignoring them for deacdes? Do you have the management buy in to calculate correctly given that's kind of what excel is meant to do?
https://www.tandfonline.com/doi/abs/10.1198/tas.2011.09076 https://www.tandfonline.com/doi/abs/10.1198/tas.2011.09076
Sometime in the early to mid noughts I recall MS announcing they'd fixed rand() returning a random number between 0 and 1. Someone filled a page with =rand(), set a conditional format, it recalculate a few times and watched many cells turning red showing a negative number. I replicated this at the time. Still?
www.gnumeric.org is what I've used when needing a spreadsheet because of those issues and the refusal to fix them. Annoying ui changes happened instead...