Lines Matching refs:cell

55         row.forEach((cell, index) => {
57 value: cell?.value ?? "",
58 isEmpty: cell?.isEmpty ?? false,
59 isMerged: cell?.isMerged ?? false,
60 isMergedFirstColumn: cell?.isMergedFirstColumn ?? false,
62 isBold: cell?.isBold ?? false,
63 isItalic: cell?.isItalic ?? false,
64 isUnderline: cell?.isUnderline ?? false,
65 isStrike: cell?.isStrike ?? false,
66 alignmentHorizontal: cell?.alignmentHorizontal ?? "left",
68 … colorFont: (cell?.colorFont && cell.colorFont.length === 7) ? cell.colorFont : "#000000",
69 …colorBackground: (cell?.colorBackground && cell.colorBackground.length === 7) ? cell.colorBackgrou…
119 row.forEach(cell => {
120 if(cell["#item"] !== undefined) {
123 recursiveCellExportODS(cell["#item"], exportParsedRow);
126 … ((cell["-self-closing"] !== undefined) || (cell["-office:value-type"] !== undefined)) &&
127 ((Number(cell["-table:number-columns-repeated"]) || 1) < 10**3)
129 exportParsedRow.push(cell);
150 row.forEach((cell, columnIndex) => {
156 let mergedColumns = Number(cell["-table:number-columns-spanned"]) || 1;
157 let mergedRows = Number(cell["-table:number-rows-spanned"]) || 1;
162 value: cell["text:p"] ?? "",
163 isEmpty: !cell["text:p"],
167 ...(styleMap.get(cell["-table:style-name"]) ?? {})
179 value: (i+j === 0) ? (cell["text:p"] ?? "") : "",
180 isEmpty: (i+j === 0) ? !cell["text:p"] : true,
184 ...(styleMap.get(cell["-table:style-name"]) ?? {})
238 function getColorXLSX(cell, type) { argument
241 let fontStyle = cell.style.font?.color;
243 return "#" + (cell.style.font.color.argb.slice(2) || "000000");
252 let fgStyle = cell.style.fill?.fgColor;
254 return "#" + (cell.style.fill?.fgColor?.argb?.slice(2) || "FFFFFF");
270 row._cells.forEach(function(cell, colNumber) { argument
276 if(!cell.isMerged) {
279 value: cell.value ?? "",
280 isEmpty: !cell.value?.length,
284 isBold: cell.style.font?.bold || false,
285 isItalic: cell.style.font?.italic || false,
286 isUnderline: cell.style.font?.underline || false,
287 isStrike: cell.style.font?.strike || false,
288 alignmentHorizontal: cell.style?.alignment?.horizontal || "left",
290 colorFont: getColorXLSX(cell, "font"),
291 colorBackground: getColorXLSX(cell, "background")
293 } else if((cell?._mergeCount ?? 0) > 0) {
296 value: cell.value ?? "",
301 isBold: cell.style.font?.bold || false,
302 isItalic: cell.style.font?.italic || false,
303 isUnderline: cell.style.font?.underline || false,
304 isStrike: cell.style.font?.strike || false,
305 alignmentHorizontal: cell.style?.alignment?.horizontal || "left",
307 colorFont: getColorXLSX(cell, "font"),
308 colorBackground: getColorXLSX(cell, "background")
333 function setStyle(cell) { argument
334 let styledCell = cell.value;
336 if (cell.isBold) styledCell = `**${styledCell}**`;
337 if (cell.isItalic) styledCell = `\/\/${styledCell}\/\/`;
338 if (cell.isUnderline) styledCell = `__${styledCell}__`;
339 if (cell.isStrike) styledCell = `<del>${styledCell}</del>`;
341 if (cell.isMerged) {
342 if (cell.isMergedFirstColumn) {
343 if (!cell.isEmpty) return ' ' + styledCell + ' ';
350 if (!cell.value && !cell.isMerged) {
354 switch(cell.alignmentHorizontal) {
374 .map((cell) => setStyle(cell))