continue;
}
for (var c = s.c; c < s.c1;c++) {
- if (c > _t.cmax) continue;
+ if (c > _t.cmax) {
+ continue;
+ }
if (typeof(_t.grid[r][c]) == 'undefined') {
_t.createCell(r,c);
g.cls = [];
g.styles = [];
}
- if (g.cls.indexOf(s.name) > -1) continue;
+ if (g.cls.indexOf(s.name) > -1) {
+ continue;
+ }
g.cls.push(s.name);
g.styles.push(s.dom);
},
Fore : function(ent,v) {
var col=[];
- Roo.each(v.split(':'), function(c) { col.push(Math.round(parseInt(c,16)/256)); })
+ Roo.each(v.split(':'), function(c) { col.push(Math.round(parseInt(c,16)/256)); });
ent['color'] = 'rgb(' + col.join(',') + ')';
},
Back : function(ent,v) {
var col=[];
- Roo.each(v.split(':'), function(c) { col.push(Math.round(parseInt(c,16)/256)); })
+ Roo.each(v.split(':'), function(c) { col.push(Math.round(parseInt(c,16)/256)); });
ent['background-color'] = 'rgb(' + col.join(',') + ')';
},
FontUnit : function(ent,v) {
ent['font-size'] = v + 'px';
},
FontBold : function(ent,v) {
- if (v*1 < 1) return;
+ if (v*1 < 1) { return; }
ent['font-weight'] = 'bold';
},
FontItalic : function(ent,v) {
- if (v*0 < 1) return;
+ if (v*0 < 1) { return; }
//ent['font-weight'] = 'bold';
},
FontName : function(ent,v) {
BorderColor : function(ent,v) {
var vv = v.split('-');
var col=[];
- Roo.each(vv[1].split(':'), function(c) { col.push(Math.round(parseInt(c,16)/256)); })
+ Roo.each(vv[1].split(':'), function(c) { col.push(Math.round(parseInt(c,16)/256)); });
ent['border-'+vv[0]+'-color'] = 'rgb(' + col.join(',') + ')';
}
- }
+ };
function add(e, k, v) {
//Roo.log(k,v);
e.gstyle[k] = v;
data = data || this.data;
for (var r = 0; r < this.rmax;r++) {
- if (typeof(this.grid[r]) == 'undefined') continue;
+ if (typeof(this.grid[r]) == 'undefined') {
+ continue;
+ }
for (var c = 0; c < this.cmax;c++) {
if (typeof(this.grid[r][c]) == 'undefined') {
continue;
}
- }
+ };
var ent = {
HAlign:"1",
ent['Unit'] = v.replace(/px/, '');
},
'font-weight' : function(ent,v) {
- if (v != 'bold') return;
+ if (v != 'bold') {
+ return;
+ }
ent['Bold'] = 1;
},
'font-style' : function(ent,v) {
- if (v != 'italic') return;
+ if (v != 'italic') {
+ return;
+ }
ent['Italic'] = 1;
}
- }
+ };
var fent = {
Unit:"10",
*/
- writeImage : function (row, col, data, width, height)
+ writeImage : function (row, col, data, width, height, type)
{
+ if (!data) {
+ throw "write Image called with missing data";
+ }
// our default height width is 50/50 ?!
//console.log('w='+width+',height='+height);
// <gmr:Objects>
break;
}
}
-
soi.setAttribute('ObjectBound',
//gnumeric_colRowToName(row,col) + ':' + gnumeric_colRowToName(row+1,col+1));
soi.setAttribute('crop-left','0.000000');
soi.setAttribute('crop-right','0.000000');
// <Content image-type="jpeg" size-bytes="3900">...... < / Content>
+
+ var name = 'Image' + Math.random().toString(36).substring(2);
var content = this.doc.createElement('Content');
- content.setAttribute('image-type','jpeg');
- //alert(imgsrc);
-
- content.setAttribute('size-bytes',data.length);
- content.textContent = data;
+ content.setAttribute('image-type', type ? type : 'jpeg');
+ content.setAttribute('name', name);
soi.appendChild(content);
objs.appendChild(soi);
+
+ var godoc = this.doc.getElementsByTagNameNS('*','GODoc')[0];
+
+ var goimage = this.doc.createElement('GOImage');
+ goimage.setAttribute('image-type', type ? type : 'jpeg');
+ goimage.setAttribute('name', name);
+ goimage.setAttribute('type', 'GOPixbuf');
+ goimage.setAttribute('width', width);
+ goimage.setAttribute('height', height);
+ goimage.textContent = data;
+
+ godoc.appendChild(goimage);
+
return true;
//< /gnm:SheetObjectImage>
// < /gnm:Objects>
},
+
+ writeFixedImage : function (startCol, startRow, endCol, endRow, type, data, width, height)
+ {
+ if (!data) {
+ throw "write Image called with missing data";
+ }
+
+ startCol = startCol * 1;
+ startRow = startRow * 1;
+ endCol = endCol * 1;
+ endRow = endRow * 1;
+ width = width * 1;
+ height = height * 1;
+
+ var objs = this.sheet.getElementsByTagNameNS('*','Objects')[0];
+ var soi = this.doc.createElementNS('http://www.gnumeric.org/v10.dtd', 'gnm:SheetObjectImage');
+
+ soi.setAttribute('ObjectBound',this.RCtoCell(startRow, startCol) + ':' + this.RCtoCell(endRow, endCol));
+
+ soi.setAttribute('ObjectOffset', '0 0 0 0');
+ soi.setAttribute('ObjectAnchorType','16 16 16 16');
+ soi.setAttribute('Direction','17');
+ soi.setAttribute('crop-top','0.000000');
+ soi.setAttribute('crop-bottom','0.000000');
+ soi.setAttribute('crop-left','0.000000');
+ soi.setAttribute('crop-right','0.000000');
+
+ var name = 'Image' + Math.random().toString(36).substring(2);
+ var content = this.doc.createElement('Content');
+ content.setAttribute('image-type', type ? type : 'jpeg');
+ content.setAttribute('name', name);
+ soi.appendChild(content);
+ objs.appendChild(soi);
+
+ Roo.log(name);
+
+ var godoc = this.doc.getElementsByTagNameNS('*','GODoc')[0];
+
+ var goimage = this.doc.createElement('GOImage');
+ goimage.setAttribute('image-type', type ? type : 'jpeg');
+ goimage.setAttribute('name', name);
+ goimage.setAttribute('type', 'GOPixbuf');
+ goimage.setAttribute('width', width);
+ goimage.setAttribute('height', height);
+ goimage.textContent = data;
+
+ godoc.appendChild(goimage);
+
+ return true;
+ },
/**
* mergeRegion:
}
var g = grid[r][c];
- if (typeof(g.cls) =='undefined') g.cls = [];
+ if (typeof(g.cls) =='undefined') {
+ g.cls = [];
+ }
var w= calcWidth(c,g.colspan);
var value = g.value[0] == '=' ? 'CALCULATED' : g.value;
if(
g.styles[0].firstElementChild.getAttribute('Format') == "D\\-MMM\\-YYYY;@" &&
g.value[0] != '=' &&
- value.length &&
- !isNaN(value * 1)
+ !isNaN(value * 1) &&
+ value != 0
){
- Roo.log(value);
- value = new Date(value * 24 * 60 * 60 * 1000 + new Date('1900-01-01').getTime()).format('d-M-Y');
+ value = new Date(value * 24 * 60 * 60 * 1000 + new Date('1899-12-30').getTime()).format('d-M-Y');
}
} catch(e) {
}
-
-
out+=String.format('<td colspan="{0}" rowspan="{1}" class="{4}"><div style="{3}">{2}</div></td>',
g.colspan, g.rowspan, value,
'overflow:hidden;' +
{
name = name || "Missing_download_filename";
- if (this.downloadURL && this.downloadURL.charAt(this.downloadURL .length-1) != '/') {
+ if (this.downloadURL && this.downloadURL.charAt(this.downloadURL.length-1) != '/') {
this.downloadURL += '/';
}