4 ms·
Nice attempt, I looked into this problem too a while ago. Quick question for the OP, I know a lot of enterprise users want to version control their spreadsheets
by ninjamayo 9y ago
Nice attempt, I looked into this problem too a while ago. Quick question for the OP, I know a lot of enterprise users want to version control their spreadsheets rather than just the code. Have you looked into that? Seems to be a tricky problem to solve.
- bjoerns 9y agoOur server-side (commercial) product actually does handle spreadsheets as well as VBA code. If you want to see it in action, have a look at our demo repositories: https://demo.xltrail.com https://demo.xltrail.com
- TAForObvReasons 9y agoThe VBA component seems to use https://github.com/decalage2/oletools https://github.com/decalage2/oletools . What are you using for handling spreadsheets?
- cm2187 9y agoI wonder if there wouldn't be a solution to diff a spreadsheet by analysing the grid and the formulas, recognising patterns (formulas dragged accross), then creating a code to generate that spreadsheet, converting patterns into for loops. If the spreadsheet is reasonably consistent and logical, the resulting code shouldn't be too large. Then you would check in the resulting code in a normal git server. That would allow you to do merge and diff, and to be able to regenerate the spreadsheet from code. Easier said than done given it has to deal with array formulas, formatting, etc. But it should be doable.
- code777777 9y agoSharePoint on-prem and online do this out of the box but they might be overkill. Works really nicely with Microsoft Teams.