# Does Perspective Table support cell spanning?

**URL:** <https://forum.inductiveautomation.com/t/does-perspective-table-support-cell-spanning/39312>\
**Category:** Ignition\
**Created:** [October 2, 2020, 3:41pm UTC](https://forum.inductiveautomation.com/t/does-perspective-table-support-cell-spanning/39312 "2020-10-02T15:41:27Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasoncoope](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jasoncoope/32/18674_2.png) [@jasoncoope](https://forum.inductiveautomation.com/u/jasoncoope)\
**Post date:** [October 2, 2020, 3:41pm UTC](https://forum.inductiveautomation.com/t/does-perspective-table-support-cell-spanning/39312/1 "2020-10-02T15:41:27Z")

</div>

I have created a production scheduler using the power table in vision. The only way the client would switch from using excel was to give them something that resembled the schedule spreadsheet they were currently using. This could only be achieved because of the cell span feature in the power table.

 ![Power Table Scheduler](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/e/6e484e3d3e3e5d75e5cb7187d20271f8cdab40b4.png)

I’m now looking to do the same this time in Perspective. With a cursory glance I don’t see any exposed settings that would allow me to merge cells in the perspective table, as the cellSpanData allows for in the power table.

Has anyone figured out a way to achieve cell merging in the perspective table?

---

<div class="post-metadata">

**Author:** ![guanghui](https://avatars.discourse-cdn.com/v4/letter/g/43a26b/32.png) [@guanghui](https://forum.inductiveautomation.com/u/guanghui)\
**Post date:** [January 28, 2021, 6:56am UTC](https://forum.inductiveautomation.com/t/does-perspective-table-support-cell-spanning/39312/2 "2021-01-28T06:56:08Z")

</div>

Did you found the way?

---

<div class="post-metadata">

**Author:** ![jasoncoope](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jasoncoope/32/18674_2.png) [@jasoncoope](https://forum.inductiveautomation.com/u/jasoncoope)\
**Post date:** [January 28, 2021, 3:16pm UTC](https://forum.inductiveautomation.com/t/does-perspective-table-support-cell-spanning/39312/3 "2021-01-28T15:16:22Z")

</div>

I haven’t yet. I’ve held off implementing scheduling in perspective waiting for more components such as the the classic equipment schedule and calendar components to show up. I’ll have to call IA Support about cell spanning. I’ll update this post when I hear from them.

---

<div class="post-metadata">

**Author:** ![Chris\_Taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_taylor/32/3315_2.png) [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\
**Post date:** [January 28, 2021, 4:43pm UTC](https://forum.inductiveautomation.com/t/does-perspective-table-support-cell-spanning/39312/4 "2021-01-28T16:43:14Z")

</div>

Jason

We have a calendar module [https://modules.bijc.co.uk/](https://modules.bijc.co.uk/) for perspective available, It may not display as your tables do but it might be useful.  
Joe needs a longer vacation!

---

<div class="post-metadata">

**Author:** ![jasoncoope](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jasoncoope/32/18674_2.png) [@jasoncoope](https://forum.inductiveautomation.com/u/jasoncoope)\
**Post date:** [February 11, 2021, 2:53am UTC](https://forum.inductiveautomation.com/t/does-perspective-table-support-cell-spanning/39312/5 "2021-02-11T02:53:37Z")

</div>

Hi Chris,

Nice to hear from you! We’ll definitely take a look at your modules.

Cheers.

---

<div class="post-metadata">

**Author:** ![kgamble](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kgamble/32/8019_2.png) [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\
**Post date:** [February 18, 2022, 12:54am UTC](https://forum.inductiveautomation.com/t/does-perspective-table-support-cell-spanning/39312/6 "2022-02-18T00:54:10Z")

</div>

Looks like this is technically possible, just not super easy to do

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/2/8260f2a096abcceda2deb3f18d4b175a4a95d58f.png)

Essentially you just have to change the styling of the cells that you want to merge, to make the text invisible on the non-center cells, and remove any border on matching

A few notes:

- I would set the text on the non-center cells to transparent instead of removing it, so you can still get the data in a click event if needed
- This could probably be done algorithmically, to merge and tweak like cells, I just didnt do that to prove it out, I did it by hand
- It would be great if this was more first-party, however I don’t immediately know how they would set something like this up.

Here is the `data` property of this table to see the styling

```auto
[
  {
    "a": "-5",
    "b": "-3",
    "c": "2",
    "d": "0",
    "e": "C",
    "f": "",
    "equipment": {
      "value": "Lane 1",
      "style": {
        "borderBottom": null,
        "color": "transparent"
      }
    }
  },
  {
    "a": -2,
    "b": "-1",
    "c": "",
    "d": "",
    "e": "",
    "f": "",
    "equipment": {
      "value": "Lane 1",
      "style": {
        "borderBottom": null,
        "borderTop": null
      }
    }
  },
  {
    "a": "",
    "b": "",
    "c": "",
    "d": "",
    "e": "",
    "f": "",
    "equipment": {
      "value": "Lane 1",
      "style": {
        "borderTop": null,
        "color": "transparent"
      }
    }
  }
]

```

---

<div class="post-metadata">

**Author:** ![jasoncoope](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jasoncoope/32/18674_2.png) [@jasoncoope](https://forum.inductiveautomation.com/u/jasoncoope)\
**Post date:** [March 9, 2022, 3:58pm UTC](https://forum.inductiveautomation.com/t/does-perspective-table-support-cell-spanning/39312/7 "2022-03-09T15:58:20Z")

</div>

Thank you for this Keith. So it is somewhat possible.
