OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 15

changes.mady.by.user Alison Bird [softartisans]

Saved on

compared with

New Version Current

changes.mady.by.user Alison Bird [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Introducedin
8.5.1

...

8.5.1
Description

Excerpt

Sets or returns whether values should be preserved when importing into merged cells. The default value is true.

Signature
C#
C#
 public boolean PreserveDataOnMergedCells{ get; set; }
{signature}{signature:
}
Signature
vb.net
vb.net
Public Property PreserveDataOnMergedCells() As Boolean
{signature}
{example}{code:csharp|title=C#}
Example
Code Block
csharp
csharp
titleC#


          //--- Get PreserveDataOnMergedCells
          bool preserveData = importProps.PreserveDataOnMergedCells;

          //--- Set PreserveDataOnMergedCells
          importProps.PreserveDataOnMergedCells = false;
{code} {code:
 Code Block
vb.net
|title=
vb.net
titlevb.net
}


          '--- Get PreserveDataOnMergedCells
          Dim preserveData As Boolean = importProps.PreserveDataOnMergedCells

          '--- Set PreserveDataOnMergedCells
          importProps.PreserveDataOnMergedCells = False
        
{code}

{
 Web only
To see what this looks like, go to our online documentation:
To 
 
 see 
 
 what 
 
 this 
 
 looks 
 
 like, 
 
 go 
 
 to 
 
 our 
 
 online 
 
 documentation:
}


Given 
 
 the 
 
 following 
 
 data 
 
 set:

|
1
|
2
|
3
|
4
|
5
|
|
6
|
7
|
8
|
9
|
10
|
|
11
|
12
|
13
|
14
|
15
|


Is 
 
 being 
 
 imported 
 
 into 
 
 the 
 
 following 
 
 cells:


!EmptyCells.png|border=0!


If {{PreserveDataOnMergedCells}} is equal to {{true}}, each value will be assigned to a cell or group of merged cells. 

The result for the above example would be:


!PreserveDataTrue.png|border=0!

If {{PreserveDataOnMergedCells}} is equal to {{false}}, {{ImportData}} will treat all cells as though they are unmerged. Any additional values that are imported into merged areas will be lost. 

The result for the above example would be:


!PreserveDataFalse.png|border=0!


{web-only}

{example}

{remarks}When {{PreserveDataOnMergedCells}} is set to {{true}} it will also affect column names when {{UseColumnNames}} is also set to true.
{remarks}
Image Added
If PreserveDataOnMergedCells is equal to true, each value will be assigned to a cell or group of merged cells. 
The result for the above example would be:
Image Added
If PreserveDataOnMergedCells is equal to false, ImportData will treat all cells as though they are unmerged. Any additional values that are imported into merged areas will be lost. 
The result for the above example would be:
Image Added
 Web only
 Remarks
When PreserveDataOnMergedCells is set to true it will also affect column names when UseColumnNames is also set to true.