Introduced in build 8.5.1
Description
Sets or returns whether values should be preserved when importing into merged cells.
C#
vb.net
Examples
C#
vb.net
Given the following data set:
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
When importing into the following cells:
When PreserveDataOnMergedCells
is equal to {{true}}the result would be:
When PreserveDataOnMergedCells
is equal to false
the result would be:
Remarks
WhenPreserveDataOnMergedCells
is set to true
it will also affect column names when UseColumnNames
is also set to true.