# Grouping rows on Simon Berridge's Excel

**URL:** <https://forum.xojo.com/t/grouping-rows-on-simon-berridges-excel/31346>\
**Category:** General\
**Created:** [May 10, 2016, 3:03pm UTC](https://forum.xojo.com/t/grouping-rows-on-simon-berridges-excel/31346 "2016-05-10T15:03:45Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gerardo\_Garca](https://forum.xojo.com/letter_avatar_proxy/v4/letter/g/e99b99/32.png) [@Gerardo\_Garca](https://forum.xojo.com/u/Gerardo_Garca)\
**Post date:** [May 10, 2016, 3:03pm UTC](https://forum.xojo.com/t/grouping-rows-on-simon-berridges-excel/31346/1 "2016-05-10T15:03:45Z")

</div>

Hi all!

Anyone knows if its possible to Group rows on Simon Berridge’s Excel?  
Thanks

😃

---

<div class="post-metadata">

**Author:** ![Simon\_Berridge](https://forum.xojo.com/letter_avatar_proxy/v4/letter/s/cc9497/32.png) [@Simon\_Berridge](https://forum.xojo.com/u/Simon_Berridge)\
**Post date:** [May 10, 2016, 4:41pm UTC](https://forum.xojo.com/t/grouping-rows-on-simon-berridges-excel/31346/2 "2016-05-10T16:41:43Z")

</div>

Gerardo

I am not sure what you mean with this question.

My gut reaction is No. I have not implemented all features, just a sub-set or ‘normal’ functions. There is conditional formatting available but I am not sure if this is what you mean.

Please advise exactly what you need.

Simon.

---

<div class="post-metadata">

**Author:** ![Gerardo\_Garca](https://forum.xojo.com/letter_avatar_proxy/v4/letter/g/e99b99/32.png) [@Gerardo\_Garca](https://forum.xojo.com/u/Gerardo_Garca)\
**Post date:** [May 10, 2016, 5:23pm UTC](https://forum.xojo.com/t/grouping-rows-on-simon-berridges-excel/31346/3 "2016-05-10T17:23:54Z")

</div>

[quote=265073:@Simon Berridge]Gerardo

I am not sure what you mean with this question.

My gut reaction is No. I have not implemented all features, just a sub-set or ‘normal’ functions. There is conditional formatting available but I am not sure if this is what you mean.

Please advise exactly what you need.

Simon.[/quote]  
Hi Simon.  
Thanks, That I try to do is add several rows after one row, and “hide” this rows “grouping it” like Excel does, when rows are grouped you can clic the “plus button” beside the row and it will expand and show the hidden rows.  
 ![](http://gilsmethod.wpengine.netdna-cdn.com/images/group-and-outline-rows-in-excel2.jpg)

---

<div class="post-metadata">

**Author:** ![Simon\_Berridge](https://forum.xojo.com/letter_avatar_proxy/v4/letter/s/cc9497/32.png) [@Simon\_Berridge](https://forum.xojo.com/u/Simon_Berridge)\
**Post date:** [May 11, 2016, 10:27am UTC](https://forum.xojo.com/t/grouping-rows-on-simon-berridges-excel/31346/4 "2016-05-11T10:27:00Z")

</div>

Gerardo

I am not an Excel expert and I have not seen this function before.

Let me check it out and see if I can add it to the class(es). At this point, though, I can tell you that it is not handled so is currently unavailable.

Simon.

---

<div class="post-metadata">

**Author:** ![Gerardo\_Garca](https://forum.xojo.com/letter_avatar_proxy/v4/letter/g/e99b99/32.png) [@Gerardo\_Garca](https://forum.xojo.com/u/Gerardo_Garca)\
**Post date:** [May 11, 2016, 1:37pm UTC](https://forum.xojo.com/t/grouping-rows-on-simon-berridges-excel/31346/5 "2016-05-11T13:37:09Z")

</div>

[quote=265256:@Simon Berridge]Gerardo

I am not an Excel expert and I have not seen this function before.

Let me check it out and see if I can add it to the class(es). At this point, though, I can tell you that it is not handled so is currently unavailable.

Simon.[/quote]  
Ok Simon, Thanks 😃 and Regards

---

<div class="post-metadata">

**Author:** ![Gerardo\_Garca](https://forum.xojo.com/letter_avatar_proxy/v4/letter/g/e99b99/32.png) [@Gerardo\_Garca](https://forum.xojo.com/u/Gerardo_Garca)\
**Post date:** [May 20, 2016, 6:20am UTC](https://forum.xojo.com/t/grouping-rows-on-simon-berridges-excel/31346/6 "2016-05-20T06:20:54Z")

</div>

[quote=265256:@Simon Berridge]Gerardo

I am not an Excel expert and I have not seen this function before.

Let me check it out and see if I can add it to the class(es). At this point, though, I can tell you that it is not handled so is currently unavailable.

Simon.[/quote]  
Hi Simon.

I write in this thread in order to not open new one.

I know that “SetCellFormula” works for doing Excel Formulas in a cell, like: Average, SUM, Date, Etc.

So I want to comment Text, you know when a String has an hyphen “-” it causes a table error and the worksheet can’t open.

So I made this Solution:

` Serial = "'"+ listbox.cell(i,7)
        xl.SetCellValue(4, Number, Serial)
        xl.SetCellStyleID(4,Number, "SBS000004")
`

As you can see I add an Apostrophe before the text, in order to Excel can detect it like a comment.

But when I do this, Ok It write the values with hyphens without problem.  
But the apostrophe is “Visible”, not invisible like when you write it on Excel.

So I investigate about “CONCATENATE” Function  
and you can add one ore more texts without problem on excel.

Thinking on this I do the follow:  
Dim Serial As String = “”""+lista.cell(i,6)+""""  
xl.SetCellFormula(5, i+7, “=CONCATENAR(”+ Serial +")")  
xl.SetCellStyleID(5,i+7, “SBS000004”)

And It doesn’t work.

Also I tried to change to:  
Serie = “”+lista.cell(i,6)+""

And when I do this, Writes on Excel: #NAME? =CONCATENATE(Example-example)

Is it possible to do this?  
Thanks

---

<div class="post-metadata">

**Author:** ![Gerardo\_Garca](https://forum.xojo.com/letter_avatar_proxy/v4/letter/g/e99b99/32.png) [@Gerardo\_Garca](https://forum.xojo.com/u/Gerardo_Garca)\
**Post date:** [October 7, 2016, 8:00pm UTC](https://forum.xojo.com/t/grouping-rows-on-simon-berridges-excel/31346/7 "2016-10-07T20:00:46Z")

</div>

I’ made an excel file with grouped rows and saved in Excel XML, and look the XML Code, and looks like this:

```auto
<Worksheet ss:Name="Hoja1">
  <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="8" x:FullColumns="1"
   x:FullRows="1" ss:DefaultRowHeight="16">
   <Row ss:StyleID="s62">
    <Cell><Data ss:Type="String">Hola</Data></Cell>
   </Row>
   <Row ss:Hidden="1">
    <Cell><Data ss:Type="String">conc 1</Data></Cell>
   </Row>
   <Row ss:Hidden="1">
    <Cell><Data ss:Type="String">conc2</Data></Cell>
   </Row>
   <Row ss:Hidden="1">
    <Cell><Data ss:Type="String">conc3</Data></Cell>
   </Row>
   <Row ss:StyleID="s62">
    <Cell><Data ss:Type="String">Yepo</Data></Cell>
   </Row>
   <Row ss:Hidden="1">
    <Cell><Data ss:Type="String">Conc1</Data></Cell>
   </Row>
   <Row ss:Hidden="1">
    <Cell><Data ss:Type="String">Conc2</Data></Cell>
   </Row>
  </Table>
```

So I need to think how to process this and Do this on Xojo with the Simon Berridge’s Excel process

---

<div class="post-metadata">

**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\
**Post date:** [October 29, 2020, 6:18pm UTC](https://forum.xojo.com/t/grouping-rows-on-simon-berridges-excel/31346/8 "2020-10-29T18:18:45Z")

</div>