* Fires when source document has been loaded
* @param {Pman.Gnumerci} this
*/
- "load" : true
+ 'load' : true
});
Roo.util.Observable.call(this,cfg);
* @type {Object} rowInfo - list of row sizes
*/
rowInfo : false,
-
+ /**
+ * @type {Object} rowInfoDom - dom elements with sizes
+ */
+ rowInfoDom : false,
/**
* @type {Number} cmax - maximum number of columns
*/
this.sheet = false;
this.grid = false;
this.colInfo = false;
+ this.colInfoDom = false;
this.rowInfo = false;
+ this.rowInfoDom = false;
this.cmax = false;
this.rmax = false;
ci = this.sheet.getElementsByTagNameNS('*','RowInfo');
this.rowInfo = {};
+ this.rowInfoDom = {};
Roo.each(ci, function(c) {
var count = c.getAttribute('Count') || 1;
var s = c.getAttribute('No')*1;
for(var i =0; i < count; i++) {
+ _t.rowInfoDom[s+i] = c;
_t.rowInfo[s+i] = Math.floor(c.getAttribute('Unit')*1);
}
});
//Roo.log( cs.r+ ',' + cs.c + ' = '+ v);
// need to generate clell if it doe
if (typeof(this.grid[cs.r]) == 'undefined') {
- Roo.log('no row:' + cell);
+ //Roo.log('no row:' + cell);
this.grid[cs.r] = []; // create a row..
//return;
}
if (typeof(this.grid[cs.r][cs.c]) == 'undefined') {
- Roo.log('cell not defined:' + cell);
+ //Roo.log('cell not defined:' + cell);
this.createCell(cs.r,cs.c);
}
if (typeof(this.grid[cs.r][cs.c].dom) == 'undefined') {
- Roo.log('no default content for cell:' + cell);
+ ///Roo.log('no default content for cell:' + cell);
this.createCell(cs.r,cs.c);
//return;
}
{
// read the first row.
var tds = Roo.get(table).select('tr').item(0).select('td');
- var nc = 0;
- tds.each(function(td) {
- var cs = td.dom.getAttribute('colspan');
- cs = cs ? cs * 1 : 1;
- nc += cs;
+ var maxnc = 0;
+
+ Roo.get(table).select('tr').each(function(trs) {
+ var nc = 0;
+
+ trs.select('td').each(function(td) {
+ var cs = td.dom.getAttribute('colspan');
+ cs = cs ? cs * 1 : 1;
+ nc += cs;
+ });
+ maxnc = Math.max(nc, maxnc);
});
+
var tr = document.createElement('tr');
table.appendChild(tr);
- var ar = {}
- for (i =0; i < nc; i++) {
+ var ar = {};
+ for (i =0; i < maxnc; i++) {
ar[i] = document.createElement('td');
tr.appendChild(ar[i]);
}
// find the left.
- var ret = { cols : nc, pos : {} };
- for (i =0; i < nc; i++) {
+ var ret = { cols : maxnc, pos : {} };
+ for (i =0; i < maxnc; i++) {
ret.pos[ Roo.get(ar[i]).getLeft()] =i;
}
+ ret.near = function(p) {
+ // which one is nearest..
+
+ if (this.pos[p]) {
+ return this.pos[p];
+ }
+ var prox = 100000;
+ var match = 0;
+ for(var i in this.pos) {
+ var dis = Math.abs(p-i);
+ if (dis < prox) {
+ prox = dis;
+ match = this.pos[i];
+ }
+ }
+ return match;
+
+ }
table.removeChild(tr);
return ret;
},
var table_data = this.readTableData(datagrid);
+ // oroginally this cleaned line breaks, but we acutally need them..
var cleanHTML = function (str) {
- var ret = str;
- ret = ret.replace(/ /g,'.');
- ret = ret.replace(/\n/g,'.');
- ret = ret.replace(/\r/g,'.');
+ var ret = str;
+ ret = ret.replace(/ /g,' ');
+ // ret = ret.replace(/\n/g,'.');
+ // ret = ret.replace(/\r/g,'.');
var i;
- while (-1 != (i = ret.indexOf(unescape('%A0')))) {
- ret = ret.substring(0,i) + ' ' + ret.substring(i+1,str.length);
- }
+
return ret;
};
for(var row=0;row<rows.length;row++) {
- //var style = document.defaultView.getComputedStyle(rows[row], "");
- //if (rows[row].getAttribute('xls:height')) {
- // this.setRowHeight(row+y_offset, 0 + rows[row].getAttribute('xls:height'));
- //} else {
- // this.setRowHeight(row+y_offset, 0 + style.height.replace(/[^0-9.]+/g,''));
- // }
+ // let's see what affect this has..
+ // it might mess things up..
+
+ if (rows[row].getAttribute('xls:height')) {
+ this.setRowHeight(row + yoff +1, 1* rows[row].getAttribute('xls:height'));
+ } else {
+ this.setRowHeight( row + yoff +1, Roo.get(rows[row]).getHeight());
+ }
var cols = rows[row].getElementsByTagName('td');
var rowspan = cols[col].getAttribute('rowspan');
rowspan = rowspan ? rowspan * 1 : 1;
- var realcol = table_data.pos[ Roo.get(cols[col]).getLeft() ];
+ var realcol = table_data.near( Roo.get(cols[col]).getLeft() );
parseHtmlStyle : function(dom, row, col, colspan, rowspan) {
function toCol (rgb) {
- var ar = rgb.replace(/rgb\(/, '').replace(/\)/, '').replace(/ /, '').split(',');
+
+ var ar = rgb.replace(/rgb[a]?\(/, '').replace(/\)/, '').replace(/ /, '').split(',');
var rcs = [];
+ ar = ar.slice(0,3);
Roo.each(ar, function(c) {
-
- rcs.push((c*256).toString(16)) ;
+ rcs.push((c*c).toString(16)) ;
});
return rcs.join(':');
'color': function(ent,v) {
ent['Fore'] = toCol(v);
+ // this is a bit dumb.. we assume that if it's not black text, then it's shaded..
+ if (ent['Fore'] != '0:0:0') {
+ ent['Shade'] = 1;
+ }
+
},
'background-color' : function(ent,v) {
ent['Back'] = toCol(v);
-
+
}
}
}
map[k](ent,val);
}
+ // special flags..
+ if (el.dom.getAttribute('xls:wraptext')) {
+ ent.WrapText = 1;
+ }
+ if (el.dom.getAttribute('xls:valign')) {
+ ent.VAlign= 1;
+ }
+ if (el.dom.getAttribute('xls:halign')) {
+ ent.HAlign= 1;
+ }
// fonts..
var fmap = {
'font-size' : function(ent,v) {
- ent['FontUnit'] = v.replace(/px/, '');
+ ent['Unit'] = v.replace(/px/, '');
},
'font-weight' : function(ent,v) {
if (v != 'bold') return;
- ent['FontBold'] = 1;
+ ent['Bold'] = 1;
+ },
+ 'font-style' : function(ent,v) {
+ if (v != 'italic') return;
+ ent['Italic'] = 1;
}
- //FontItalic : function(ent,v) {
- // if (v*0 < 1) return;
- // //ent['font-weight'] = 'bold';
- //},
-
}
var fent = {
fmap[k](fent,val);
}
var font = el.getStyle('font-family') || 'Sans';
-
+ if (font.split(',').length > 1) {
+ font = font.split(',')[1].replace(/\s+/, '');
+ }
/// -- now create elements..
//<gnm:StyleRegion startCol="0" startRow="0" endCol="255" endRow="65535"
var sr = this.doc.createElementNS('http://www.gnumeric.org/v10.dtd', 'gnm:StyleRegion');
objs.appendChild(sr);
+ objs.appendChild(this.doc.createTextNode("\n"));// add a line break..
+
sr.setAttribute('startCol', col);
sr.setAttribute('endCol', col+ colspan-1);
sr.setAttribute('startRow', row);
- sr.setAttribute('endRow', row +rowspan -1);
+ sr.setAttribute('endRow', row + rowspan -1);
var st = this.doc.createElementNS('http://www.gnumeric.org/v10.dtd', 'gnm:Style');
sr.appendChild(st);
// do we need some defaults..
for(var k in ent) {
- Roo.log(k);
+ //Roo.log(k);
st.setAttribute(k, ent[k]);
}
st.appendChild(fo);
// do we need some defaults..
for(var k in fent) {
- fo.setAttribute(k, ent[k]);
+ fo.setAttribute(k, fent[k]);
}
fo.textContent = font;
// start adding them all together..
if (sb) {
- st.appendChild(sb)
+ st.appendChild(sb);
}
// step 1 - work out how many columns it will span..
// lets hope the spreadsheet is big enought..
var colwidth = 0;
- var endcol=col
+ var endcol=col;
for ( endcol=col;endcol <100; endcol++) {
if (!this.colInfo[endcol]) {
this.colInfo[endcol] = 100; // eak fudge
// return;
//}
- cell.textContent = this.RCtoCell(row1,col1) + ':' + this.RCtoCell(row2,col2)
+ cell.textContent = this.RCtoCell(row1,col1) + ':' + this.RCtoCell(row2,col2);
//var merges = this.gnumeric.getElementsByTagNameNS('*','MergedRegions');
var merges = this.sheet.getElementsByTagNameNS('*','MergedRegions');
this.sheet.insertBefore(merges,sl);
} else {
merges = merges[0];
- }
+ }
merges.appendChild(cell);
},
//<gmr:Rows DefaultSizePts="12.75">
// <gmr:RowInfo No="2" Unit="38.25" MarginA="0" MarginB="0" HardSize="1"/>
// < /gmr:Rows>
+
+ // this doesnt handle row ranges very well.. - with 'count in them..'
+
+ if (this.rowInfoDom[r]) {
+ this.rowInfoDom[r].setAttribute('Unit', height);
+ return;
+ }
+
var rows = this.sheet.getElementsByTagNameNS('*','Rows')[0]; // assume this exists..
var ri = this.doc.createElementNS('http://www.gnumeric.org/v10.dtd','gnm:RowInfo');
// assume we have no rows..
ri.setAttribute('MarginB', 0);
ri.setAttribute('HardSize', 1);
rows.appendChild(ri);
+ this.rowInfoDom[r] = ri;
},
/**
sheetnames = this.doc.getElementsByTagNameNS('*','Sheet');
sheetnames[0].parentNode.appendChild(sheetnames[sheetnames.length-1].cloneNode(true));
var sn = this.doc.getElementsByTagNameNS('*','Sheet')[sheet];
- var cls = sn.getElementsByTagNameNS('*','Cells')[0]
+ var cls = sn.getElementsByTagNameNS('*','Cells')[0];
while (cls.childNodes.length) {
cls.removeChild(cls.firstChild);
}
var ser = new XMLSerializer();
var x = new Pman.Download({
method: 'POST',
+ timeout : 120000, // quite a long wait.. 2 minutes.
params : {
xml : ser.serializeToString(this.doc),
format : 'xls', //xml
projects / Pman.Core / blobdiff