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 dotancohen on Wednesday April 13, 2022 @01:49AM (#31011582)
Would it not be tedious to mark each cell as constant or input parameter? Perhaps it would be preferable to just ask the fine user when copying a cell with a formula?
[ Parent | on HN ]
Re:Human genes renamed to stop Microsoft Excel from misreadi... by magicalhippo on Wednesday April 13, 2022 @09:27AM (#31014395)
I almost always have <5 such cells in a sheet, typically just 2-3, so I don't think it would be that tedious given you only have to set that once.

In comparison, I often have formulas with over 20 cell references and/or multiple formulas referencing the "constants", so getting asked for each would indeed be tedious.

[ Parent | on HN ]