Login
You're viewing the functional.cafe public feed.

Replies

  • 💬 1🔄 0⭐ 2
  • Nov 19, 2026, 1:39 PM

    @steevmi1 @gumnos @mhoye I can reliably make Excel eval text in CSVs as expressions just by loading the CSV. CSV files are data not code unless you're working in Excel. I'm not sure if this is legacy Lotus-123 behavior but I expect CSV values surrounded by quotes to be treated as text strings and absolutely not as expressions to be evaluated.

    Excel is an attractive hazard and not fit for purpose.

    💬 3🔄 0⭐ 0
  • Nov 19, 2026, 1:53 PM

    @arclight

    Hah, just hit this working a case for $DAYJOB yesterday, in which the exported-from-Excel CSV file had values like

    ="long string of digits"

    to prevent long numbers (IMEI/SIM numbers) from getting converted to floating-point. Which is good, but mean that my CSV-handling importer had to strip off the wrapper that had been causing the value-extraction to give the wrong data. :sigh:

    💬 0🔄 0⭐ 1
  • Nov 19, 2026, 2:02 PM

    @arclight @steevmi1 @gumnos

    Unfortunately for a generation of scientists in institutions largely captured by the managerial class, Excel was the only tool immediately to hand that did not require a round trip through a procurement process with a constrained budget in one hand and a publication deadline in the other.

    💬 1🔄 0⭐ 3
  • 💬 0🔄 0⭐ 1
  • 💬 0🔄 0⭐ 1