News for hackers. Stuff that matters.

A comment on Dangers of CSV Injection. Parent comment

Re:Dangers of CSV Injection by jdelStrother on Tuesday October 10, 2017 @06:15AM (#15440649)
That's just a single regular apostrophe? At least on my machine, with Mac Excel 15.38, if I have a CSV containing:

1,foo,'=SUM(A1:A10),bar

and open it, then the single apostrophe is visible in the cell.

[ Parent | on HN ]
Re:Dangers of CSV Injection by elliottcarlson on Tuesday October 10, 2017 @11:58AM (#15442839)
You should actually append it to the trigger; i.e.

1,foo,='SUM(A1:A10),bar

[ Parent | on HN ]