Git really is awesome! Too bad we are only using SVN :-(
I like to have to text version of the workbook so I can query it using grep. We have multiple dozen of very similar workbooks (whoever set that up first was insane). Any change request involves updating all workbooks the exact same way.
After I update them I can run something like this:
grep "^A1" /*/sheet1.csv
Using this I get the value/formula and format of all workbooks for sheet1!A1. That way I am sure they have all been updated the same way. And this works with the VBA code as well.
Not the nicest system I have worked on, at least we don't have to touch it too often.
I have to handle quite a lot of Excel document at work, much to my despair. Unfortunately we are not using GIT, but SVN.
I ended up creating a small tool that extract the vba, named ranges plus the sheet in this format: "cell_adress,type,format,value"
I have to commit those files alongside the spreadsheet, which is not great but had helped me a lot.
Nice to hear others are working on the problem!
Sorry if I wasn't clear. Looking at the map, there are 6 dots over Vietnam. The 2 in the middle of Vietnam (around Hue and Danang I guess) are pink, for "te" as opposed to the other one which are blue, for "cha".
Any Vietnamese know why Vietnam has "tea" in the middle and "cha" in north or south on the map?
I spend 2 months in the north then lived for a few month in Saigon. I never came across people using anything other than "trà" (cha).
I like to have to text version of the workbook so I can query it using grep. We have multiple dozen of very similar workbooks (whoever set that up first was insane). Any change request involves updating all workbooks the exact same way. After I update them I can run something like this: grep "^A1" /*/sheet1.csv
Using this I get the value/formula and format of all workbooks for sheet1!A1. That way I am sure they have all been updated the same way. And this works with the VBA code as well.
Not the nicest system I have worked on, at least we don't have to touch it too often.