exceljs icon indicating copy to clipboard operation
exceljs copied to clipboard

_xlnm._FilterDatabase has oversized JavaScript heap out of memory

Open zeromake opened this issue 2 years ago • 0 comments

I'm having a problem at work, I don't know how create _FilterDatabase but Area size is (8752-3) * (16364 - 1)

definedName = {
"name": "_xlnm._FilterDatabase",
"ranges": ["Sheet1!$A$3:$XEJ$8752"]
}
address = {
  top: 3,
  left: 1,
  bottom: 8752,
  right: 16364,
  sheetName: "Sheet1",
  tl: {
    address: "A3",
    col: 1,
    row: 3,
    $col$row: "$A$3",
    sheetName: "Sheet1",
  },
  br: {
    address: "XEJ8752",
    col: 16364,
    row: 8752,
    $col$row: "$XEJ$8752",
    sheetName: "Sheet1",
  },
  dimensions: "A3:XEJ8752",
}

error:

<--- Last few GCs --->

[2747:0x7fdbb8008000]    18040 ms: Mark-Compact (reduce) 4062.9 (4141.5) -> 4062.5 (4141.5) MB, 3109.8 / 0.0 ms  (+ 3.7 ms in 1 steps since start of marking, biggest step 3.7 ms, walltime since start of marking 3118 ms) (average mu = 0.215, current mu = 0[2747:0x7fdbb8008000]    20755 ms: Mark-Compact 4065.4 (4143.4) -> 4064.6 (4144.6) MB, 2712.8 / 0.0 ms  (average mu = 0.112, current mu = 0.001) allocation failure; scavenge might not succeed


<--- JS stacktrace --->

FATAL ERROR: Reached heap limit Allocation failed - JavaScript heap out of memory

How to skip _xlnm._FilterDatabase in defined-names.js?

zeromake avatar Dec 07 '23 02:12 zeromake