News for hackers. Stuff that matters.
Re:Xltrail – An open-source Git command line extension for E... by ninjamayo on Monday February 19, 2018 @10:05AM (#16413262)
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.
Re:Xltrail – An open-source Git command line extension for E... by bjoerns on Monday February 19, 2018 @10:10AM (#16413297)
Our 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
Re:Xltrail – An open-source Git command line extension for E... by TAForObvReasons on Monday February 19, 2018 @11:37AM (#16413840)
The VBA component seems to use https://github.com/decalage2/oletools . What are you using for handling spreadsheets?
Re:Xltrail – An open-source Git command line extension for E... by cm2187 on Monday February 19, 2018 @10:54AM (#16413579)
I 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.

Re:Xltrail – An open-source Git command line extension for E... by code777777 on Monday February 19, 2018 @11:04AM (#16413634)
SharePoint on-prem and online do this out of the box but they might be overkill. Works really nicely with Microsoft Teams.