SheetXL - v1.0.2
Guides
Demos
GitHub
Preparing search index...
@sheetxl/utils
CoordUtils
mergeRangeCoordValues
Function mergeRangeCoordValues
mergeRangeCoordValues
(
ranges
:
RangeCoordValue
<
any
>
[]
,
iterations
?:
number
,
getMerge
?:
(
from
:
[
a
:
RangeCoordValue
<
any
>
,
b
:
RangeCoordValue
<
any
>
]
,
destination
:
RangeCoordValue
,
axis
:
RangeAxis
,
)
=>
RangeCoordValue
<
any
>
|
null
|
undefined
,
axis
?:
RangeAxis
,
reuseArray
?:
[
RangeCoordValue
<
any
>
|
null
,
RangeCoordValue
<
any
>
|
null
]
,
)
:
RangeCoordValue
<
any
>
[]
Attempts to merge ranges that are guaranteed to not overlap.
Parameters
ranges
:
RangeCoordValue
<
any
>
[]
iterations
:
number
= 2
Optional
getMerge
:
(
from
:
[
a
:
RangeCoordValue
<
any
>
,
b
:
RangeCoordValue
<
any
>
]
,
destination
:
RangeCoordValue
,
axis
:
RangeAxis
,
)
=>
RangeCoordValue
<
any
>
|
null
|
undefined
axis
:
RangeAxis
= RangeAxis.Row
Optional
reuseArray
:
[
RangeCoordValue
<
any
>
|
null
,
RangeCoordValue
<
any
>
|
null
]
Returns
RangeCoordValue
<
any
>
[]
Default Value
'
2
'
.
Copy
Remarks
Setting to '0' will remove overlaps but not attempt to merge.
Setting to '1' will remove overlaps in the initial axis.
Setting to '2' will remove most overlaps but may miss overlaps that resulted from the previous iterations.
Setting to 'Number.MAX_SAFE_INTEGER' will run until no more ranges can be merged.
Settings
Member Visibility
Inherited
Theme
OS
Light
Dark
Guides
Demos
GitHub
SheetXL - v1.0.2
Loading...
Attempts to merge ranges that are guaranteed to not overlap.