4 ms·
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 t
by counttheforks 4y ago
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.
- pbhjpbhj 4y agoI'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?
- HPsquared 4y agoMicrosoft 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.