Merged cells

[Jan-Walther-Blackbit]

Is there a way to support merged cells? In this case all columns within the merge range should return the same value. Currently only the first column in the merge range has the value, the other ones have "".

[aVadim483]

When you merge cells, Excel actually writes the value to only the first one. That's why you get this result

[Jan-Walther-Blackbit]

Ok, but is it possible to detect if a cell is merged with another one?

[aVadim483]

And you can use:

• Sheet::getMergedCells() -- Returns all merged ranges
• Sheet::isMerged(string $cellAddress) -- Checks if a cell is merged
• Sheet::mergedRange(string $cellAddress) -- Returns merge range of specified cell

[aVadim483]

For example

if ($sheet->isMerged('B3')) {
    $range = $sheet->mergedRange('B3');
}