News for hackers. Stuff that matters.

A comment on Human genes renamed to stop Microsoft Excel from misreading them as dates (2020). Parent comment

Re:Human genes renamed to stop Microsoft Excel from misreadi... by olau on Monday April 11, 2022 @07:38AM (#30987323)
UTF-8 CSV with a few HTML tags for formatting?

You could call it CHU.

Now you just need to make Excel accept it.

[ Parent | on HN ]
Re:Human genes renamed to stop Microsoft Excel from misreadi... by nicoburns on Monday April 11, 2022 @08:18AM (#30987677)
I'd like it to have support for things like "this is a <format> cell", where format is something like text, numeric, date, currency. I'm not sure how you'd specify that in HTML.
[ Parent | on HN ]
Re:Human genes renamed to stop Microsoft Excel from misreadi... by ElectricalUnion on Monday April 11, 2022 @09:29AM (#30988387)
> text, numeric, date

I think it's already defined?

<input type="text">, <input type="number">, <input type="date">

> currency

You probably need to use the microdata format https://schema.org/Offer

[ Parent | on HN ]