4 ms·
> If you put a formula into any cell starting with an `=` character, the office suite will give you a terse warning about updates or something, and when you acc
by masklinn 6y ago
> If you put a formula into any cell starting with an `=` character, the office suite will give you a terse warning about updates or something, and when you accept, it will run every formula.
Also Excel use the prefix apostrophe (') as an escape character to force text interpretation of a cell.
It will save that escape character to CSV, and will interpret an apostrophe prefix as an escape character.
- undecisive 6y agoYep. There are a bunch of gotchas that don't necessarily present security issues, but can be annoying to debug. Another good example is we used to generate random strings and report on those, but sometimes we got weird numbers appear in the fields, or ###, or even 0. Turned out that the random string generator would sometime produce strings like '327e-733" which excel helpfully parses for us.