Post · bonfire.cafe

Post

Claudius Link

@realn2s@infosec.exchange · last week

How can one not love Excel /s

The worst is, that Excel looses the original content. Changing the cell format doesn't bring back the original ISBN 🤮

#UXFail #Excel

Screenshot of collumns P an Q in an Excel sheet.
The columns contain ISBNs, 10 and 13

The data is displayed in the scientific notation

isbn_10 isbn_13
1250209277 9,78125E+12
1250847680 9,78125E+12
... — Screenshot of collumns P an Q in an Excel sheet. The columns contain ISBNs, 10 and 13 The data is displayed in the scientific notation isbn_10 isbn_13 1250209277 9,78125E+12 1250847680 9,78125E+12 ...

ExcelAnalytics

@ExcelAnalytics@mastodon.world · last week

@realn2s have you tried using the 0 number format? Excel can handle up to 15 significant digits.

Claudius Link

@realn2s@infosec.exchange · last week

@ExcelAnalytics
Not sure what you mean. This is after a csv import. I had to redo the import and specify text format

ExcelAnalytics

@ExcelAnalytics@mastodon.world · 3 days ago

@realn2s in that case try changing the data type for that specific column.
https://sysmod.wordpress.com/2016/08/28/excel-gene-mutation-and-curation/

Patrick O'Beirne @ sysmod

Excel & Genes: mutation and curation

On 23 Aug a paper by three Australian authors gained much publicity about how Excel interprets data entry and how the users don’t check their data. Gene name errors are widespread in the scientific…

Claudius Link

@realn2s@infosec.exchange · 3 days ago

@ExcelAnalytics
That only works while importing. After the import Excel seems to use an internal number representation which isn't convertible to ISBN

bonfire.cafe

A space for Bonfire maintainers and contributors to communicate

bonfire.cafe: About · Code of conduct · Privacy · Users · Instances

Bonfire social · 1.0.2-alpha.34 no JS en

Automatic federation enabled