Merge cells based on length of the array in the next/previous row

[haydave]

merged cells.xlsx

It will be great to have something similar to the following: Templater allows you to merges cells vertically if you put a top level tag and a tag for a nested collection in one row.

[steevepay]

Hi @haydave,

First, thanks for your post! Can you explain the usage you want ? Do you want to add dynamic or static data into merges cells ?

[haydave]

Hi @steevepay,

Thanks for the response. My goal is to generate an Excel sheet of employee's attendances. Assume that row 2 (B2-AE2) contains numbers from 1 to 30. I would like to have merged cells in row 1 (B1-AE1) and include the name of the month in it. It should be dynamic in my case but it will be nice to have a possibility to put static data as well.

[steevepay]

Hi @haydave,

Your use case is an interesting usage, unfortunately carbone can't merge cells depending on iterations. We are keeping the idea and we will consider it for next releases. For now, we are fixing major bugs. Thanks again and we will come back to you.