News for hackers. Stuff that matters.

A comment on The first rule of Microsoft Excel: Don’t tell anyone you’re good at it. Parent comment

Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by counttheforks on Monday October 24, 2022 @12:00PM (#33318435)
I feel like Excel is almost there. If only you could save a sheet as a folder, where each formula was its own file and Excel would hot reload the changes made to those files. Then you might even be able to track the formulas in git.
[ Parent | on HN ]
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by HPsquared on Monday October 24, 2022 @12:27PM (#33318813)
Microsoft actually does offer a diff tool in some versions of Office, "Spreadsheet Compare", you can filter to look at e.g. formula changes (or any other area of differences between two Excel files).

Annoying it's not offered in most versions.

[ Parent | on HN ]
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by pbhjpbhj on Monday October 24, 2022 @12:10PM (#33318575)
I'd rather a "dual view" sheet, where each cell may shows the formula in the top half and the result in the bottom half. Save the CSV of the formulae & data view to your versioning system.

I guess you could have a third sub-cell for style?

[ Parent | on HN ]