[ excel ] compare and merge

Add the `Compare and Merge Workbooks` in `File > Option`

compare_and_merge_workbook

In order for the button not to be greyout. We need to share workbook first. Thanks to Gord Dibben. ( ref : https://groups.google.com/forum/#!topic/microsoft.public.excel/QA47xbOELGk )shareworkbook

NOTE : we can compare and merge only if the file is modified after share workbook

Advertisements

Arrays are objects in Java. And references to objects are passed by value.

private void demo() {
int[] array = new int[5];
System.out.println(Arrays.toString(array)); // 0, 0, 0, 0, 0
fillArray(array);
System.out.println(Arrays.toString(array)); // 0, 1, 2, 3, 4
}

private void fillArray(int[] array) {
for (int i = 0; i < array.length; i++) {
array[i] = i;
}
}

ref : http://stackoverflow.com/questions/14062118/pass-array-by-reference-in-java