Simple Spreadsheet

// visible cols, optional
cols = 13;
// visible rows, optional
rows = 30;

// Usage: [#col,#row,"value","style"],
dbCells = [
  // column headers
  [1,-1,"Col1","","Col1 long name"], // B-ColTitle
  [2,-1,"Col2","color: blue; width:100px;","Col2 long name"], // C-ColTitle
  [3,-1,"Col3","width:100px;"], // D-ColTitle

// column group headers
  [0,-2,"Group1","color:red;colspan:2;"],
  [3,-2,"Group2","colspan:2;"],
  [5,-2,"Group3","colspan:3;"],
  [8,-2,"Group4","colspan:2;"],
  
  // row headers
  [-1,0,"Group#1","color:blue;","Group#1 long name"], // RowTitle 1
  [-1,1,"Row1",""], // RowTitle 2
  [-1,2,"Row2","height:50px;"], // RowTitle 3
  [-1,3,"Row3",""], // RowTitle 4
  [-1,4,"Group#2","color:blue;","Group#2 long name"], // RowTitle 5
  [-1,5,"Row1",""], // RowTitle 6
  [-1,6,"Row2",""], // RowTitle 7
  [-1,7,"Row3",""], // RowTitle 8

[1,-1,"Col1","","Col1 long name"], // B-ColTitle
  [2,-1,"Col2","color: blue; width:100px;","Col2 long name"], // C-ColTitle
  [3,-1,"Col3","width:100px;"], // D-ColTitle

// cells
  
  [0,0,"=C3","font-weight:bold;"], // A1
  [2,2,"test2","font-weight:bold;"], // C3
  [5,3,"html:This is a <b>html</b> text !<hr><ul><li>bullet 1</li><li>bullet 2</li><li>bullet 3</li></ul>",""], // F4
  [5,5,"This is a Multiline text !\\nline 2\\nline 3\\nend",""], // F6
  [1,2,"rowspan","font-size:150%; rowspan:2;"], // B3
  [1,5,"colspan","colspan:3;"], // B6

[1,4,"locked","readonly:true;height:50px;"], // B5
  [3,1,"10","format:dollar;"], // D2
  [2,1,"-2000000.999","width:100px; format:euro;"], // C2
  [1,1,"0.44321","format:percent;"], // B2
  
  [5,0,"=C3+'C\"3+C3'",""], // F1
  [5,1,"=C3+\"C'3-C3\"",""], // F2
  [5,2,"='C\"3-C3'+C3+\"C'3+C3\"",""], // F3
  [6,0,"=\"C'3+C3\"+C3+'C\"3-C3'",""], // G1
  [6,1,"='<t\"e\\'st'+100+\"te's\\\"t>\"","color:blue;"], // G2
  
  [4,0,"abc http://www.cnn.com test http://www.heise.de",""], // E1
  [4,1,"http://www.cnn.com","font-weight:bold;"], // E2
  [4,2,"firstname.lastname@invalid.local","font-weight:bold;"], // E3

[0,6,"02/26/2006","format:date;"], // A7
  [1,6,"03/27/2007 9:11:12","format:datetime;"], // B7
  [2,6,"14:11:12","format:time;"], // C7
  [3,6,"1.2.2004","format:date;"], // D7
  [4,6,"03/27/2007 9:11:12","format:datefulltime;"], // E7
  [5,6,"02/26/2006","format:datefull;"], // F7
  
  [2,3,"=customCalc(D4+D5)+customCalc2(D4+D5)","color:blue;"], // C4
  [2,4,"=D2*D3","font-weight:bold;"], // C5
  [3,2,"20",""], // D3
  [3,3,"=D2+D3","font-weight:bold; text-decoration:underline;"], // D4
  [3,4,"=sum(D2:D4)","color:blue;"], // D5
  [4,4,"=E5","color:red; font-style:italic;"], // E5

// Usage: graph(type,title,data,keys)
  [4,3,"=graph('bar',E11,F12:F15,E12:E15,'quarter','value')",""], // E4
  [4,5,"=graph('pie',F11,F12:F15,E12:E15)",""], // E6
  
  [4,16,"=graph('bar',E11,F12:F15,E12:E15,'quarter','value')",""], // E17
  [4,18,"=graph('line',G11,F12:F15,E12:E15,'quarter','value')",""], // E19
  
  [4,19,"=graph('linesteps','Linesteps graph',F12:F15,E12:E15,'quarter','value')",""], // E20
  [4,20,"=graph('scatter','Scatter graph',F12:F15,G12:G15)",""], // E21

[5,16,"=graph2('bar','Bar graph (2 bars)',F12:F15,G12:G15,E12:E15)","colspan:2;"], // F17
  [5,17,"=graph2('baraccumulate','Baraccumulate graph',F12:F15,G12:G15,E12:E15)","colspan:2;"], // F18
  [5,18,"=graph2('line','Line graph (2 lines)',F12:F15,G12:G15,E12:E15)","colspan:2;"], // F19
  [5,19,"=graph2('linesteps','Linesteps graph (2 lines)',F12:F15,G12:G15,E12:E15)","colspan:2;"], // F20

[4,10,"Bar graph",""], // F11
  [5,10,"Pie graph",""], // G11
  [6,10,"Line graph",""], // H11
  
  [4,11,"Q1",""], // E12
  [4,12,"Q2",""], // E13
  [4,13,"Q3",""], // E14
  [4,14,"Q4",""], // E15
  
  [5,11,"11",""], // F12
  [5,12,"2",""], // F13
  [5,13,"16",""], // F14
  [5,14,"22",""], // F15
  
  [6,11,"31",""], // G12
  [6,12,"37",""], // G13
  [6,13,"36",""], // G14
  [6,14,"43",""], // G15
  
  [1,7,"1",""], // B8
  [2,7,"2",""], // C8
  [3,7,"3",""], // D8
  [1,8,"6",""], // B9
  [2,8,"5",""], // C9
  [3,8,"5",""], // D9
  
  [1,10,"=\"sum(B8:D8)\"",""], // B11
  [2,10,"=sum(B8:D8)","readonly:true;"], // C11

[1,11,"=\"min(B8:D8)\"",""], // B12
  [2,11,"=min(B8:D8)",""], // C12

[1,12,"=\"max(B8:D8)\"",""], // B13
  [2,12,"=max(B8:D8)",""], // C13

[1,13,"=\"avg(B8:D8)\"",""], // B14
  [2,13,"=avg(B8:D8)",""], // C14

[1,14,"=\"count(B8:D8)\"",""], // B15
  [2,14,"=count(B8:D8)",""], // C15

[1,15,"=\"sum([B8,D8])\"",""], // B16
  [2,15,"=sum([B8,D8])",""] // C16
];
// define a custom function to be used in the formulas, optional
registerFuncs = ["customCalc","customCalc2"];

function customCalc(num) {
  return num*2.5;
}

function customCalc2(num) {
  return num*3.0*showCell(1,1); // num * 2.5 * B2
}

/*
dbCells = [
  [0,0,"1",""],
  [1,0,"2",""],
  [2,0,"31",""],
  [3,0,"4",""],

[0,1,"5",""],
  [1,1,"6",""],
  [2,1,"7",""],
  [3,1,"8",""],

[2,2,"a","",],

[2,3,"A","",],

[2,4,"b","",],

[2,5,"B","",],
];
*/

// forbid paging ? optional
// allowPaging = false;