Categories > OpenTBS with XLSX >

Re: mergeCells

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Sandeep
Date: 2013-06-06
Time: 15:07

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,
By: Skrol29
Date: 2013-06-08
Time: 01:26

Re: mergeCells

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)