News for hackers. Stuff that matters.

A comment on Excel pivot table data leak leads to £120k fine for London council. Parent comment

Re:Excel pivot table data leak leads to £120k fine for Londo... by wereHamster on Monday April 23, 2018 @01:52PM (#16905729)
> It's a special option you have to select, but when done properly […]

So not really reliable, I wouldn't trust ordinary office users to use it correctly. Exporting to CSV is safer, because you can open the file in a plain-text editor and see what you're actually going to share. CSV won't hide anything from you, unlike the proprietary Excel file format (I know it's XML-in-ZIP but who can be bothered inspecting the contents).

[ Parent | on HN ]
Re:Excel pivot table data leak leads to £120k fine for Londo... by ksk on Monday April 23, 2018 @02:55PM (#16906340)
Why is it not reliable? The much famed "ordinary" user is often portrayed a bumbling incompetent user. For any heavy excel user, or rather any excel user thats ever used formulas, this is a common UI operation. Your CSV suggestion is good, but it can't carry the formatting and other extra info which is the reason people use excel to begin with!
[ Parent | on HN ]