Re: mergeCells

Hi,
Please help me on an issue with excel. Data is not showing in a row when I am getting in excel template. But this data is coming in data array. When I have used debug open then find out in output that is <mergeCells count="3">
  <mergeCell ref="B253:E253"/>
  <mergeCell ref="A252:E252"/>
  <mergeCell ref="A2:C2"/>
</mergeCells>
But MergeCells is not using in template. I have used in template for data as [data.current_year;ope=xlsxNum]. MergeCells is not using here.
So How to remove this?

Thanks,

Hi Sandeep,

Maybe your cells does not look merged, but they are.
Find them using your snippet.
Or manually delete the <mergeCells> element.
You can do this using $TBS->PlugIn(OPENTBS_DELETE_ELEMENTS, $Elements)