SheetXL - v0.3.20
Preparing search index...
@sheetxl/utils
CoordUtils
mergeRangedValues
Function mergeRangedValues
mergeRangedValues
(
ranges
:
RangedValue
<
any
>
[]
,
iterations
?:
number
,
getMerge
?:
(
from
:
[
RangedValue
<
any
>
,
b
:
RangedValue
<
any
>
]
,
destination
:
RangedValue
,
orientation
:
RangeOrientation
,
)
=>
RangedValue
<
any
>
,
orientation
?:
RangeOrientation
,
reuseArray
?:
[
null
,
null
]
,
)
:
RangedValue
<
any
>
[]
Attempts to merge ranges that are guaranteed to not overlap.
Parameters
ranges
:
RangedValue
<
any
>
[]
iterations
:
number
= 2
Optional
getMerge
:
(
from
:
[
RangedValue
<
any
>
,
b
:
RangedValue
<
any
>
]
,
destination
:
RangedValue
,
orientation
:
RangeOrientation
,
)
=>
RangedValue
<
any
>
orientation
:
RangeOrientation
= RangeOrientation.Row
Optional
reuseArray
:
[
null
,
null
]
Returns
RangedValue
<
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 orientation.
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
SheetXL - v0.3.20
Loading...
Attempts to merge ranges that are guaranteed to not overlap.