Show column letters in grid

SheetJSDev · SheetJSDev · commit 0f23adf66666 · 2014-04-27T20:09:42.000-07:00
Originally the column labels were repeated in the top and in the first row; now it shows `A, B, C, ...` and the first row is properly frozen. h/t @Path2SharePoint (on Twitter) for noticing the issue.
diff --git a/assets/js/main.js b/assets/js/main.js
@@ -76,7 +76,7 @@ var _onsheet = function(json, cols, sheetnames, select_sheet_cb) {
     stretchH: 'all',
     rowHeaders: true,
     columns: cols.map(function(x) { return {data:x}; }),
-    colHeaders: cols,
+    colHeaders: cols.map(function(x,i) { return XLS.utils.encode_col(i); }),
     cells: function (r,c,p) {
       if(r === 0) this.renderer = boldRenderer;
     },
diff --git a/index.html b/index.html
@@ -33,7 +33,7 @@ <h3>
                     Need a file?  Why not the <a href="http://www.whitehouse.gov/sites/default/files/omb/budget/fy2014/assets/receipts.xls">OMB FY 2014 Federal Receipts?</a>
                 </h3>
                 <table id="tt">
-                  <tr><td colspan="6"><a href="osstatus.html">SheetJS Libraries</a> (for parsing) and <a href="http://handsontable.com">Handsontable</a> (grid component)</td></tr>
+                  <tr><td colspan="6"><a href="http://github.com/SheetJS/SheetJS.github.io">View Source</a>; <a href="osstatus.html">SheetJS Libraries</a> (for parsing) and <a href="http://handsontable.com">Handsontable</a> (grid component)</td></tr>
                   <tr>
                     <th>XLS/XML</th>
                     <td><a href="http://github.com/SheetJS/js-xls">Library Source</a></td>
diff --git a/tests/test.js b/tests/test.js
@@ -1213,7 +1213,7 @@ describe('should parse test files', function() {
 "rich_text_stress.xlsx",
 "roo_1900_base.xlsx",
 "roo_1904_base.xlsx",
-"roo_Bibelbund.xlsx.pending",
+"roo_Bibelbund.xlsx",
 "roo_Pfand_from_windows_phone.xlsx.pending",
 "roo_bbu.xlsx",
 "roo_boolean.xlsx",
@@ -1258,8 +1258,8 @@ describe('should parse test files', function() {
 "xlrd_test_comments_excel.xlsx",
 "xlrd_test_comments_gdocs.xlsx",
 "xlrd_text_bar.xlsx",
-"xlsx-stream-d-date-cell.xlsx"
-//"חישוב_נקודות_זיכוי.xlsx.pending",
+"xlsx-stream-d-date-cell.xlsx",
+"apachepoi_חישוב_נקודות_זיכוי.xlsx.pending"
 	].forEach(function(x) {
 		it(x, x.substr(-8) == ".pending" ? null : function(done) {
 			var oReq;
@@ -1277,7 +1277,7 @@ describe('should parse test files', function() {
 					var arraybuffer = oReq.response;
 					data = new Uint8Array(arraybuffer);
 					for(i = 0; i != data.length; ++i) arr[i] = data[i];
-					wb = (x.substr(-1) == "s" || x.substr(-4) == ".xml") ? XLS.read(arr, {type:'array'})
+					wb = (x.substr(-1) == "s" || x.substr(-1) == "l") ? XLS.read(arr, {type:'array'})
 						: XLSX.read(arr.map(function(x) { return String.fromCharCode(x); }).join(""), {type:'binary'});
 				} else {
 					var binary = oReq.responseBody;
@@ -1291,7 +1291,7 @@ describe('should parse test files', function() {
 					var lastChr = IEBinaryToArray_ByteStr_Last(binary);
 					data = rawBytes.replace(/[\s\S]/g, function( match ) { return byteMapping[match]; }) + lastChr;
 					for(i = 0; i != data.length; ++i) arr[i] = data.charCodeAt(i) & 0xff;
-					wb = (x.substr(-1) == "s" || x.substr(-4) == ".xml") ? XLS.read(arr, {type:'array'})
+					wb = (x.substr(-1) == "s" || x.substr(-1) == "l") ? XLS.read(arr, {type:'array'})
 						: XLSX.read(arr.map(function(x) { return String.fromCharCode(x); }).join(""), {type:'binary'});
 				}
 				parsetest(x, wb);
@@ -1314,7 +1314,7 @@ describe('should parse test files', function() {
 					var data = rawBytes.replace(/[\s\S]/g, function( match ) { return byteMapping[match]; }) + lastChr;
 					var arr = [];
 					for(i = 0; i != data.length; ++i) arr[i] = data.charCodeAt(i) & 0xff;
-					wb = (x.substr(-1) == "s" || x.substr(-4) == ".xml") ? XLS.read(arr, {type:'array'})
+					wb = (x.substr(-1) == "s" || x.substr(-1) == "l") ? XLS.read(arr, {type:'array'})
 						: XLSX.read(arr.map(function(x) { return String.fromCharCode(x); }).join(""), {type:'binary'});
 					parsetest(x, wb);
 					done();
