Clear duplicate data in each cell when merging the same cells #3090

New Issue

heaxo · 2024-03-18T03:38:37Z

heaxo commented

2024-03-18 03:38:37 +00:00

I encountered a calculation error when using the SUM function to merge the same cells using workSheet ['! Merges']. The reason is that when I canceled the merged cells, each cell still retained its pre merged value

Figure 1 is what I expected

And Figure 2 is my current one. Canceling the merge of cells is incorrect, and the values before the merge are still retained

I encountered a calculation error when using the SUM function to merge the same cells using workSheet ['! Merges']. The reason is that when I canceled the merged cells, each cell still retained its pre merged value Figure 1 is what I expected And Figure 2 is my current one. Canceling the merge of cells is incorrect, and the values before the merge are still retained

1710732857180.jpg

15 KiB

1710733066058.jpg

12 KiB

sheetjs commented

2024-03-20 03:17:07 +00:00

Can you share the original file, before you cleared merge cells?

heaxo commented

2024-03-22 03:52:14 +00:00

Can you share the original file, before you cleared merge cells?

Of course I can

> Can you share the original file, before you cleared merge cells? Of course I can

DATA.xlsx

11 KiB

sheetjs commented

2024-03-22 18:39:37 +00:00

function fix_merges_in_workbook(wb) {
	wb.SheetNames.forEach(n => {
		var ws = wb.Sheets[n];
		ws?.["!merges"]?.forEach(m => {
			if(typeof m == "string") m = XLSX.utils.decode_range(m);
			for(var R = m.s.r; R <= m.e.r; ++R) for(var C = m.s.c; C <= m.e.c; ++C) {
				var cell = ws["!data"] ? ws["!data"][R]?.[C] : ws[XLSX.utils.encode_cell({r:R,c:C})];
				if(!cell || R == m.s.r && C == m.s.c) continue;
				delete cell.v; delete cell.w;
			}
		});	
	});
}

```js function fix_merges_in_workbook(wb) { wb.SheetNames.forEach(n => { var ws = wb.Sheets[n]; ws?.["!merges"]?.forEach(m => { if(typeof m == "string") m = XLSX.utils.decode_range(m); for(var R = m.s.r; R <= m.e.r; ++R) for(var C = m.s.c; C <= m.e.c; ++C) { var cell = ws["!data"] ? ws["!data"][R]?.[C] : ws[XLSX.utils.encode_cell({r:R,c:C})]; if(!cell || R == m.s.r && C == m.s.c) continue; delete cell.v; delete cell.w; } }); }); } ```

heaxo commented

2024-04-03 01:04:31 +00:00

Thank you for solving my problem, but I am curious why the xlsx.js library does not directly handle this situation when merging

Sign in to join this conversation.