Products > Dodgy Technology

Biologists rename our own biology to work around Excel "bug"

<< < (3/6) > >>

The Soulman:

--- Quote from: SiliconWizard on May 26, 2023, 08:55:09 pm --- It's just a right click away. :-DD

--- End quote ---

Have you tried?

Infraviolet:
"Intimately", I'll admit I dont know much about excel's interface any more, I forgot it all when I learnt to program, especially once I'd found R/RStudio could serve for most of my data handlng needs... But I do remember it was getting ever worse and more confusing every time M$ released a new version with a more graphically stylish (but ever less obvious) interface.

I don't understand why anyone, especially scientsists who surely already know some amount of programming, would put themselves through the torture of Excel for these sort of things.

Whales:
Without first using excel I would have never had what is needed to understand other languages like R or concepts like arrays.

Excel and spreadsheet software are a standard: they're full of warts, but the compromises mean everyone can play rather than just a select few.  There are many times I wanted to use something more advanced, but I couldn't because I knew the software would not be something my recipients and co-workers could get working. 

tszaboo:

--- Quote from: xrunner on May 25, 2023, 09:23:28 pm ---Simple to turn off in Open Office -

Click “Format Cells…” Click on the tab “Numbers” Under the category select box click “Text” Click “Ok”. Your text should no longer be interpreted as date/decimal/currency etc for the selected cells.

Just tried it, it leaves these types of inputs as they are:

OCT4
MARCH1

etc ...

--- End quote ---
Not even that much. Just put an ' in front of it. ' tells excel to leave it alone.

IanB:

--- Quote from: newbrain on May 26, 2023, 08:31:08 am ---
--- Quote from: xrunner on May 25, 2023, 09:23:28 pm ---Simple to turn off in Open Office -

--- End quote ---
Exactly as in MS Excel.
--- End quote ---

According to Microsoft, you cannot turn it off in Excel. This is what I would call a bug, and what Microsoft calls "do what we want, not what you want".


--- Quote ---Microsoft Excel is preprogrammed to make it easier to enter dates. For example, 12/2 changes to 2-Dec. This is very frustrating when you enter something that you don't want changed to a date. Unfortunately there is no way to turn this off. But there are ways to get around it.
--- End quote ---

https://support.microsoft.com/en-us/office/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-47d1-81e4-72cec11c4ed8

Navigation

[0] Message Index

[#] Next page

[*] Previous page